tonymusante Posted June 25, 2015 Share Posted June 25, 2015 Hi all, i need to fix a start invoice number in my case 206. I gone to BO-Orders-Invoices and set number in backoffice but it does not run, invoices number still follow their number 6-7-8-etc etc...... I tried 206 and #206 too but no way to make it run good. Version 1.6 seems to have a lot of problems (or i'm real unlucky). Anybody is so kind to help me fixing invoice number? Link to comment Share on other sites More sharing options...
tonymusante Posted June 26, 2015 Author Share Posted June 26, 2015 up Link to comment Share on other sites More sharing options...
musicmaster Posted June 26, 2015 Share Posted June 26, 2015 I am not sure what you want. You cannot change the order id number in Prestashop. The only way to change it is to go directly to the ps_orders table in the database, for example with phpmyadmin. The order id is an auto increase value so if you set it to 206 the next order will get number 207. Link to comment Share on other sites More sharing options...
tonymusante Posted June 26, 2015 Author Share Posted June 26, 2015 I don't want to change order number, i need to start invoice from a determinate number not start from 1 Before moving to prestashop i used another CMS for my shop and i need to continue with the same invoice numeration. In my case the next invoice should be 207 and not 1. I tried to fix it in backoffice but it does not run. Link to comment Share on other sites More sharing options...
tonymusante Posted June 29, 2015 Author Share Posted June 29, 2015 is any way to edit straight to database table? Link to comment Share on other sites More sharing options...
tonymusante Posted June 30, 2015 Author Share Posted June 30, 2015 up Link to comment Share on other sites More sharing options...
irrelevant Posted June 30, 2015 Share Posted June 30, 2015 (edited) Go to Orders > Invoices page in back office. Scroll right down to the bottom, You will see a field named "Invoice number" with the text underneath: "The next invoice will begin with this number, and then increase with each additional invoice. Set to 0 if you want to keep the current number (which is #nnnn)" Put 207 in there and hit save :-D It worked for me .... You could try editing directly the record in ps_confuguration where name = "PS_INVOICE_START_NUMBER" Edited June 30, 2015 by irrelevant (see edit history) Link to comment Share on other sites More sharing options...
tonymusante Posted July 2, 2015 Author Share Posted July 2, 2015 i tried to set invoice number in backoffice but it doesn't run so i tried to set propertly database table but it doesn't run too i didn't find "PS_INVOICE_START_NUMBER" so i set "PS_INVOICE_NUMBER" with value 209 where is the problem? Link to comment Share on other sites More sharing options...
tonymusante Posted August 27, 2015 Author Share Posted August 27, 2015 updating to 1.6.1.1 solved my issue Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now