Tuesday, August 9, 2011

How to setup unique prefix For Orders, Invoices, Shipments, Customers and Quotes in magento?

* Orders (set prefix to begin with “O″)
* Invoices (set prefix to begin with “I″)
* Shipments (set prefix to begin with “S″)
* Customers (set prefix to begin with “C″)
* quotes (set prefix to begin with “Q″)
//For Orders
update `eav_entity_store` set `increment_prefix`= 'O' where `entity_type_id`='4' and `store_id`='1';
update `eav_entity_store` set `increment_last_id`= '000000000' where `entity_type_id`='4' and `store_id`='1';
 
//For Invoice
update `eav_entity_store` set `increment_prefix`= 'I' where `entity_type_id`='18' and `store_id`='1';
update `eav_entity_store` set `increment_last_id`= '000000000' where `entity_type_id`='18' and `store_id`='1';
 
//For shipments
update `eav_entity_store` set `increment_prefix`= 'S' where `entity_type_id`='24' and `store_id`='1';
update `eav_entity_store` set `increment_last_id`= '000000000' where `entity_type_id`='24' and `store_id`='1';

//For Customers
update `eav_entity_store` set `increment_prefix`= 'C' where `entity_type_id`='1' and `store_id`='1';
update `eav_entity_store` set `increment_last_id`= '000000000' where `entity_type_id`='1' and `store_id`='1';

//For quotes
update `eav_entity_store` set `increment_prefix`= 'Q' where `entity_type_id`='11' and `store_id`='1';
update `eav_entity_store` set `increment_last_id`= '000000000' where `entity_type_id`='11' and `store_id`='1';

No comments:

Post a Comment