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”.
Mayank Zalavadia 🙂