baumi's blog

baumi's personal blog … Linux, OS X, Windows, Random things, …

Magento: Adjusting next invoice number, next order number

Synchronizing invoice and order numbers: Same order invoice number Plugin:
This plugin will synchronize invoice numbers with order numbers:

By installing this plugin, you’re done.

For going back to separated invoice/order numbers, simply go to System -> Configuration -> Extended and disable the “Fooman_SameOrderInvoiceNumber” module.

Manually adjusting the next invoice/order number in mySQL:
Edit the entries inside Table: eav_entity_store.

Bildschirmfoto 2016-03-15 um 14.13.37

To learn about the meaning of entity_type_id, simply check table eav_entity_type. Typically:

1 = customer
2 = customer_address
3 = catalog_category
4 = catalog_product
5 = order
6 = invoice
7 = refund / creditmemo

8 = shipment

Therefore the first two entries are reflecting the next order numbers, and the next two lines are showing the next invoice numbers:

This example is running a Magento store with two different store ID’s (one for German, one for English). Therefore we’ve got two entries for each eav_entity_type.

Please note, when using Fooman’s “Same order invoice number” Plugin, the entities with type 6 are unused. Therefore, when moving back to separated invoice and order numbers, you will want to manually increase the values of eav_entity_type 6 (=invoice).

Comments are currently closed.