Can the initial Order ID be changed?

Post by lm555cn » Wed Aug 26, 2009 2:13 am

I am trying Opencart, which i find fantastic! and had made some dummy purchases and noticed that the Order ID's for them started from 0 (Zero) and then incremented accordingly. Is there any way to choose a different number for the Order ID to start from in order to match the physical receipts or bills and take it from there?

Sorry for the answer but I have already tried to search in the backoffice and have had no luck.

I am trying to put a small cart system for my brother which is not to computer saavy, I am not either, but I like to get dirty my hands just to learn something new, even if I commit mistakes.

Anyway, I was looking for a cart system which was free, fast, easy to manage, easy to create templates, etc. and robust, I was going for Prestashop, but had a tough time with the templates and smarty. I am not much into programming, but with some Google searches for HTML,CSS and PHP I have been able to make some changes fairly easy, though I have to learn a lot more!

Great job with this cart system.

Post by Qphoria » Wed Aug 26, 2009 3:40 am

Post by lm555cn » Wed Aug 26, 2009 8:42 pm

Thanks a lot Qphoria!
Don't know SQL but I think I can manage by doing some searches.

Post by Qphoria » Wed Aug 26, 2009 9:22 pm

ALTER TABLE `opc_order`  AUTO_INCREMENT =500;

Post by lm555cn » Thu Aug 27, 2009 5:26 am

Thanks once again Qphoria.
I was in fact having some trouble doing it, but didn't want to bother.
I REALLY appreciate all your help.
Regards.

Post by cadsifu » Thu Oct 08, 2009 12:17 pm

Post by HeidiD » Sat Jan 30, 2010 9:56 am

Post by justme54s » Fri Apr 30, 2010 10:46 pm

ALTER TABLE `order`  AUTO_INCREMENT =10000

Post by tophat » Thu Mar 01, 2012 10:43 pm

Post by stremblay » Sun Apr 01, 2012 5:44 am

Post by jty » Sun Apr 01, 2012 8:15 am

Post by stremblay » Sun Apr 01, 2012 11:44 pm

Thanks jty ! This is a really awesome idea

Post by tunnu » Thu May 17, 2012 3:25 am

Post by myocid » Fri Jun 22, 2012 9:22 am

O, Hello everyone!
What the matter? Can somebody post a screenshot guider?
Best Wishes for all you

Attachments

screenshot.22-06-2012 09.18.59.png (25.18 KiB) Viewed 17307 times

Post by strato » Fri Jun 07, 2013 2:34 pm

I did this and it worked perfectly.
Just go to the "order" table. Click on the SQL tab at the top.
In the SQL window, backspace out the SELECT * blah blah blah.. and put in this:

ALTER TABLE `order` AUTO_INCREMENT =10000

I use the new version of OpenCart (1.5.5.1) and the table's actually "oc_order", so I changed it to this:

ALTER TABLE `oc_order` AUTO_INCREMENT =672 <---- I thought this was much more realistic, since my business is only a year old!

Hit the "Go" button.. and that's it! It won't look like anything has changed, but your next order will start with 672.

Post by crispylettuce » Sat Oct 12, 2013 4:34 am