OpenCart Community

We have two sites, so we have often same order number of orders, like we have order #57 from this site also have sooner or later another number 57 order from second site. Because opencart counts order starting from 1 automatically.

Is it possible to make order number from any number to start counting, so we could set second site to count order from 10001?

create a fake order in one of your shops where you want to change the order number.
take note of the order number in admin.
open database using phpmyadmin.
find table orders, and find last order, edit this and find field with ordernumer.
change to any number desired, save.
order in admin will reflect everything correct, but thats no problem.

create a new fake order and you will see its the set ordernumber + 1

depending on your payment gateway, i would set ordernumber of second shop to a fairly high number so you never have duplicate order numbers in both shops

Change the auto number value on your Orders table.


Sent from my iPad using Tapatalk

Thanks for victorj, it works.