Author Topic: Reset Order ID Back To 1  (Read 7136 times)

wivelden

  • Jr. Member
  • **
  • Posts: 67
Reset Order ID Back To 1
« on: January 31, 2009, 06:15:14 am »
I have deleted all the entries in the database for any test orders but it is still not starting from 1.
How can I reset the order ID back to 1?

RolandD

  • Full Member
  • ***
  • Posts: 780
    • Home of CSVI
Re: Reset Order ID Back To 1
« Reply #1 on: January 31, 2009, 07:18:20 am »
Go in to PhpMyAdmin -> Select your table -> Operations -> set auto increment value back to 1. Also do an optimize on your table.
Regards,

RolandD

CSVI
http://www.csvimproved.com/

wivelden

  • Jr. Member
  • **
  • Posts: 67
Re: Reset Order ID Back To 1
« Reply #2 on: January 31, 2009, 07:55:03 am »
That did it. Thanks. I am learning something new everyday!

nichie

  • Beginner
  • *
  • Posts: 2
Re: Reset Order ID Back To 1
« Reply #3 on: November 10, 2010, 13:38:51 pm »
Thanks - that's exactly what I needed as well!

Tirrawarra

  • Beginner
  • *
  • Posts: 36
Re: Reset Order ID Back To 1
« Reply #4 on: November 09, 2011, 00:06:06 am »
SOLVED # Reset Virtuemart Orders ID Back To 1

thanks - exactly what I needed.