Post by oclvr » Tue Jul 22, 2014 7:35 am

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?
Last edited by oclvr on Thu Jul 31, 2014 2:50 am, edited 1 time in total.

New member

Posts

Joined
Mon Jul 18, 2011 5:59 am

Post by victorj » Tue Jul 22, 2014 2:54 pm

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

Koeltechnische deurrubbers eenvoudig online op maat bestellen.
Alle niet stekplichtige onderdelen zoals scharnieren, sloten, randverwarming en verlichting voor alle typen koelingen en vriezers.
https://koelcel-onderdelen.com


User avatar
Expert Member

Posts

Joined
Sat Jun 25, 2011 4:09 am
Location - Alkmaar Holland

Post by melbagnato » Wed Jul 23, 2014 12:49 am

Change the auto number value on your Orders table.


Sent from my iPad using Tapatalk

http://online.enterpriseconsulting.com.au

Site with OpenCart extensions & code downloads, many new extensions coming soon!
Follow us on twitter for more updates

Image


User avatar
Active Member

Posts

Joined
Wed Jan 13, 2010 1:39 pm
Location - Melbourne

Post by oclvr » Thu Jul 31, 2014 2:49 am

Thanks for victorj, it works.

New member

Posts

Joined
Mon Jul 18, 2011 5:59 am
Who is online

Users browsing this forum: No registered users and 38 guests