Page 1 of 1

Invoice Numbers in 1.5.05

Posted: Tue Jul 26, 2011 5:25 am
by kbswebs
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!

Re: Invoice Numbers in 1.5.05

Posted: Tue Sep 27, 2011 12:21 am
by strobes
Would appreciate an answer to this too please

Thanks

Steve

Re: Invoice Numbers in 1.5.05

Posted: Tue Sep 27, 2011 12:40 am
by uksitebuilder
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

Re: Invoice Numbers in 1.5.05

Posted: Sat Nov 19, 2011 1:37 am
by annelim
hi simon,

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

Re: Invoice Numbers in 1.5.05

Posted: Sat Nov 19, 2011 3:53 am
by AnonyMoose
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.

Re: Invoice Numbers in 1.5.05

Posted: Thu Nov 24, 2011 1:26 am
by annelim
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