Shortening Increment ID length for Orders, Invoices, Creditmemo and Shipments

November 8, 2010 11:52

By default, Magento use 8 digits for Orders, Invoices, Creditmemo and Shipments’ increment ID. However, sometime you would like to change the length to meet 3rd party’s system requirement. This can be easily accomplished by:

  • modify the field “increment_pad_length” in the “eav_entity_type” table for whatever entity you’re wanting to modify.
  • modify the field “increment_last_id” in “eav_entity_store” table with the same “entity_type_id” in table “eav_entity_type” which the document type’s increment ID you would like to change. Remember to change all existing records for this “entity_type_id”.

After you changed them, the coming new document will use the new increment ID.

Happy Magento’ing ~

Share

One Response to “Shortening Increment ID length for Orders, Invoices, Creditmemo and Shipments”

  1. The development does in an perfect way what it's assured plus I acquired an outstanding support for the set up. you need this development if you are using Magento for bookkeeping. in my scenario I have a shop advertising both on-line and off-line.