Change Order ID

midori · #1 10-10-2003, 01:58 PM

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

Thanks!
-Midori

DogByteMan · #2 10-10-2003, 02:49 PM

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

bluecat · #3 10-10-2003, 06:57 PM

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?

DogByteMan · #4 10-10-2003, 07:01 PM

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.

bluecat · #5 10-10-2003, 07:04 PM

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?

DogByteMan · #6 10-10-2003, 07:06 PM

Here is the only way to do it

BACKUP YOUR DATABASE!

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

RESTORE YOUR BACKUP DATABASE!

bluecat · #7 10-10-2003, 07:10 PM

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

DogByteMan · #8 10-10-2003, 07:15 PM

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.

midori · #9 10-13-2003, 10:31 AM

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

-Midori

midori · #10 10-15-2003, 10:50 AM

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