Changing length of Increment ID for Orders, Invoices, Creditmemo and Shipments

Posted: November 11, 2010 in Magento, Version 1.3.*, Version 1.4.*

Hello Everyone,

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

Bijal Bhavsar 🙂


Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )


Connecting to %s