Jump to content

Can't update invoice id


Recommended Posts



I want to change my invoice number to 14001 so it starts with the new year..

But in my BO it doesent work. I've manually changed the last invoice to 14001 but the next invoice goes back to 1413 again. Makes no sense right?

I've run the query: 

SELECT MAX( `invoice_number` ) AS `invoice_number` FROM ps_orders

 and as result 14001.


Any help would be more then welcome.
(using prestashop


Link to comment
Share on other sites

Search for name = PS_INVOICE_NUMBER in the ps_configuration table. What is there?

id_configuration  41



name                 PC_INVOICE_NUMBER

Value                1

date_add          0000-00-00 00:00:00

date_upd          0000-00-00 00:00:00

Edited by Bolinga (see edit history)
Link to comment
Share on other sites

That's the problem.. If I set the number manually it's oke. But the next one doesent work, it doesent continou from the last one I just manually changed. It's really strange, i've found multiple forum items about this and tried them all. ( even italian and french forums ) but nothing

Link to comment
Share on other sites

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 account

Sign in

Already have an account? Sign in here.

Sign In Now
  • Create New...