Orders ID - can I reset?

Hi,

I have configured ZenCart v1.5. I have imported orders from version 1.3.9h, now I have orders from 1 to 47, but don't know why they jumped from 47 to 52, 53, 54, I need these 3 new orders continuing after 47... how can I fix that? Which tables I should touch to make it work.

Regards,

You may have to learn to live with this. The order id is interlaced throughout the database in many tables. Once an id has been assigned, it cannot be used again. The missing numbers could have been test orders that were deleted or any other cause. You can set the order number to a number higher than the current id and try going on from there, but it will happen again.

I would like to set a higher order number so it does not appear to the customer that they are the first hundred or so orders. How can we change the current order number?

Admin > Tools > Store Manager > Set next order number.

Perfect, and thank you.