Just another WordPress.com weblog

Archive for November, 2010

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

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

Thanks,
Bijal Bhavsar 🙂

Advertisements