Post by JimVer » Sun Aug 04, 2013 9:22 pm

Is there anyway to let my invoice nr start at for example 770 instead of 1?

Thank you very much!

New member

Posts

Joined
Sun Apr 11, 2010 4:48 pm

Post by sytra » Sun Aug 04, 2013 10:22 pm

Do yo mean invoice or order ID?

If order id, there is a few threads about and most suggest running the following SQL command in PHPAdmin:

Code: Select all

ALTER TABLE `order` AUTO_INCREMENT = 1000;
Making sure you do it to the correct table and prefix order with your DB (eg, ours is "oc_order") change 1000 to whatever you want your order number to start at.

Another way is with this extension http://www.opencart.com/index.php?route ... on_id=6567 just follow the instructions carefully and make sure to delete the file when you have finished with it. This ext doesn't mention version 1.5.5.1 but we used it successfully.

Running OC 1.5.5.1 with vqmods.
http://www.aislings.co.uk
http://www.lovers-paradise-toys.co.uk


Active Member

Posts

Joined
Sat Feb 04, 2012 6:27 am

Post by JimVer » Sun Aug 04, 2013 11:02 pm

It worked PERFECT! Thank you very much!

I've used the extention on 1.5.5.1 and can confirm it works perfectly.

New member

Posts

Joined
Sun Apr 11, 2010 4:48 pm
Who is online

Users browsing this forum: Bing [Bot] and 46 guests