CODEWITHSUNDEEP
magentomagento-1.9
Nirav Joshi
Nirav Joshi

Reputation: 2950

How to change order increment id

I made research many things about change increment order id. i tried extension also but nothing helps me to achieve like this.

I want it like 10000001 to 10001.

The orders are already there might not affected but if i place new order than the increment id should be 10002

Any help will appreciated.

Upvotes: 0

Views: 1153

Answers (1)

Jitendra Patel
Jitendra Patel

Reputation: 373

//Try with below query. please first try with testing site.

//Replace the X‘s with your desired order number and run the query.

UPDATE eav_entity_store INNER JOIN eav_entity_type ON eav_entity_type.entity_type_id = eav_entity_store.entity_type_id SET eav_entity_store.increment_last_id='XXXXXXXXXX' WHERE eav_entity_type.entity_type_code='order';

More details refer this link : enter link description here

Upvotes: 1

Related Questions