markjl Posted May 28, 2013 Share Posted May 28, 2013 Hello is it possible to set the start and format of customer invoice numbers. Say if I want them to start at FC1235 Thanks Link to comment Share on other sites More sharing options...
vekia Posted May 28, 2013 Share Posted May 28, 2013 by default the ivoice ID field in database has got definition: id_order INT(10) NOT NULL AUTO_INCREMENT which mean that: - INT mean that field can handle only numbers - AUTO_INCEMENT mean that field can handle only numbers (automatically increase value of ID when you create new order) All of this mean, that you can't put there non-integer chars. Link to comment Share on other sites More sharing options...
markjl Posted May 28, 2013 Author Share Posted May 28, 2013 Strange, because when I go print the invoices the first is INVOICE # IN000001 which includes 2 alpha characters Link to comment Share on other sites More sharing options...
vekia Posted May 28, 2013 Share Posted May 28, 2013 so you want to change invoice ID appearance on pdf, i just thought that you want to change id order at all (in databases and in core) Link to comment Share on other sites More sharing options...
markjl Posted May 28, 2013 Author Share Posted May 28, 2013 I want the invoice numbers to start at the next available number from invoices from my old system EBP If I got to say invoice number FC1234 on EBP, then I want the first invoice in Prestashop to be FC1235 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