Order numbers did not increase the morning after

Hi,

With a lot of great help (support ticket 108585) the order numbers were forwarded to the customer email, and they kept increasing with every new order.

Last night the last order number was 52. Today I placed another order, and the order number fell back to 33.

I had deleted a few rows from the order and orderdetails tables, but the order numbers did not seem to be affected yesterday.

Do I have to leave all order and orderdetails stored in the database for the order numbers to work properly? Or is there another reason for the number mix up.

It sounds like you may be using the id column from your orders table for this value. The best way to check on it's current status and how it is working is to view the db directly and the values in this id column to see if there is an issue. This value is one that should be controlled by the db directly. If the index got reset or is staring from the last value then deleting records could have an effect on this.

Hi Eric,

Thank you for your reply. I checked the database, and now I think I know, what the problem is. Embarrasssing. I am updating the database with new products daily. When I import the database on the remote server, all tables are dropped, including order details and orders, and they get replaced with the tables I have on my local server. I will do some more testing, but I am very sure, this is the problem.

Ok, that makes sense since dropping the existing table would reset the index on it and it will start with the last index of the newly imported data.

Yes, I tried it today, after I did not import the database yesterday, and the numbers are fine.

Glad to hear it, post back if you have any other problems or questions.