Change default length of Increment ID for orders, invoices, shipments, creditmemos

$entityType = Mage::getModel('eav/entity_type')->loadByCode('order'); //invoice, shipment, creditmemo

$entityType->setIncrementPadLength(12)->save(); //changing length to 12

UPDATE `eav_entity_type` SET `increment_pad_length`= 12 WHERE entity_type_code = 'order';

UPDATE `eav_entity_type` SET `increment_pad_length`= 12 WHERE entity_type_code = 'invoice';

UPDATE `eav_entity_type` SET `increment_pad_length`= 12 WHERE entity_type_code = 'shipment';

UPDATE `eav_entity_type` SET `increment_pad_length`= 12 WHERE entity_type_code = 'creditmemo';

2 Comments

• 
  Sethy August 8, 2013 at 3:41 pm

  To change default magento numbers I tried to use several ready-made solutions ( i’m not a developer) and amasty’s Custom Order Number is the best i see on the market. Try to use if needed.

  Reply
• 
  stefan October 30, 2016 at 9:36 am

  Thanks for useful post.
  There is still another way to tackle this issue.
  I suggest using an extension, which can set up the new invoice number and modify the number of the next order at ease, you can check it out at: https://goo.gl/457QUH for more features.

  Reply