Showing results for 
Search instead for 
Did you mean: 

Invoice number

Invoice number

Hi there,


I would like to start with invoice number 001 and will also change manually a number. 

How can I do that?




Re: Invoice number

Hi @smartgrafik 


You can change all the increment numbers, like order, invoices etc from the table:




You can use the following SQL code, and change the store ID to fit your store:


UPDATE eav_entity_store
INNER JOIN eav_entity_type ON eav_entity_type.entity_type_id = eav_entity_store.entity_type_id
SET eav_entity_store.increment_last_id = '001'
	eav_entity_type.entity_type_code = 'invoice'
AND eav_entity_store.store_id = '1';


I hope this helps :-)

Re: Invoice number

Subject: invoice number



I read the answer to smartgrafik's question about invoice numbering, but I don't understand it.. I am a Magento user since very recently, and am a comlete novice to its in and outs.

How do I get to " eav_entity_store"?

Re: Invoice number

Hello @f_r_a_n_k_1005

This is usually done by logging to your MySQL database with a program like phpMyAdmin.

However, you should be careful with changing such files and tables in Magento if you are new to it.

Alternatively, you can look for ready-to-use solutions like this one.

Was my answer helpful? You can accept it as a solution.
200+ professional extensions for M1 & M2 with free lifetime updates!