Change Order ID
 

Is there a way to change the Order ID number so that my first customer doesn't get "Order ID #1"?

Thanks!
-Midori

Go to your MySQL control panel Select browse xcart_orders then edit order ID 1 to anything you want.

What if you have about 30 orders but want to change that? Can I just change the last entry to say 1322 for example without messing up my database?

I believe so. If I'm not mistaken the Order ID is auto indexed using the last entry. All entries before that should remain unchanged.

Let me ask this (as I get scared tinkering with my database), if it "doesn't" work, can it be easily corrected by changing the number back to 30 for example?

Here is the only way to do it

BACKUP YOUR DATABASE!

Then try it.... If it does not work....

RESTORE YOUR BACKUP DATABASE!

I guess I should of thought of that, lol. Thanks. :roll:

Also change the same value in xcart_order_details

I don't see a way to just change next value, but there may be a way.

Thanks for the help! I should've figured that out on my own. :oops:

-Midori

Wait a second...what do I do if I don't have a MySQL control panel???