Invoice number

[smartgrafik]

Hi there,

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

How can I do that?

Regards,

[Theis Corfixen]

Hi @smartgrafik 

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

eav_entity_store

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'
WHERE
	eav_entity_type.entity_type_code = 'invoice'
AND eav_entity_store.store_id = '1';

I hope this helps :-)

[f_r_a_n_k_1005]

Subject: invoice number

hello!

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"?

[Amasty]

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.