OpenCart Community

Hey there, simple question that I have searched for hours to get an answer with no luck... I have opencart 1.5.05 fresh install and i need my invoice id number to start with 1500, not 1. how can I accomplish this. I see you can modify the invoice prefix in admin but nothing about the id itself. Thanks anyone for a quick answer on this!

Would appreciate an answer to this too please

Thanks

Steve

Seem the invoice number is determined by whatever the last invoice number is/was

Therefore

1. create a dummy order
2. look in your database table 'xx_order' (replace xx_ with your prefix if you use one or omit it entirely)
3. edit the dummy order row and change the Invoice number. (i.e. 1499)

Now wait for the first real order to come in, afterwhich you can delete your dummy order

hi simon,

where to find the database locate to modify the prefix.
which file ? in mysql ? what is the name in mysql? please help

Create dummy order and generate invoice number for it, open PHPMyAdmin, go to 'orders' table and find your dummy order. Look for 'invoice_no' column.

AnonyMoose wrote:Create dummy order and generate invoice number for it, open PHPMyAdmin, go to 'orders' table and find your dummy order. Look for 'invoice_no' column.

after look for the invoice_no column > is it manualy edit? every time do to so? where can i insert prefix the invoice no?
'INV-2011-800' to be show invoice each time automatically ? please help