I want to shorten order number (increment id) but I don't want to use any modules.


2 Answers 2


To reduce the number of digits, you'll want to modify the increment_pad_length in the eav_entity_type table (for the order row, of course).

You can change the prefix by modifying the increment_prefix value in the eav_entity_store table. (Use the entity_type_id from the other table to identify which row you'd change.) By default, Magento uses the store's id (1) as the prefix.

If you're interested in learning more about the increment IDs, check out the Mage_Eav_Model_Entity_Increment_Numeric and Mage_Eav_Model_Entity_Increment_Abstract classes which are responsible for generating the next available ID based on the database settings.

Edit: You could even create your own increment logic by extending the Abstract class I mentioned above.


I dont´t know a module for this, but you can "easily" tweak the table eav_entity_store. You can look up the entity_id in eav_entity_type


Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.