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???

Look through the email tpl/s you can just add whatever you want infront of the productID part.

You need to change all the subject lines and places where it mentions the order ID.

Doing it in the tpl's means it doesn't affect the real numbers in the database.

You can also change this in the order history display templates too.

just run this patch in admin:


where 12345 is replaced by the number of your choice.

The next order id produced by the system will be 12346

Once you have had an order you can delete this entry by running the following patch:

Great! Thanks to you both for your help. I really appreciate it!

-Midori

I just went through PHPadmin, found the last order and changed the value. Since it is on auto appending, it goes to the next value after the last one.

30000 = 30001 next

sounds good. :)