* 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