Resetting Order Number

[macwizards]

Our ISP had a hardware failure that's requried us to restore our SQL files from backup. If we accept orders with the restored data new orders will come in with order numbers that have already been used (prior to the hardware failure).

 

Example, we were on order #7452 before the failure, after the restore we are on order #7301.

 

We would like to tell OSCommerce to "jump ahead" to a next order number that was never used prior to the failure. Example, we want the next order to be #7453 not #7302.

 

How do we do this?

 

Thanks!

[MSP]

create a test order for yourself, go to your database (phpmyadmin if you have it), go to the orders table, find your order, and change the order number to 7433, and the next order placed will be 7434

[Ninalune]

Here is a thread I started earlier. Didn't have a cjance to try it yet, but I hope this helps:

 

http://www.oscommerce.com/forums/index.php?showtopic=266126

[macwizards]

create a test order for yourself, go to your database (phpmyadmin if you have it), go to the orders table, find your order, and change the order number to 7433, and the next order placed will be 7434

 

Thank you! We've had some orders that came in before we realized the problem. We would like to renumber them also, but we are worried about breaking them. Can we change the order number of real orders in this way (without breaking the orders)?

 

Is the order number referenced only in the orders table, or is it also referenced in other tables?