Increment order increment ids for all stores

The following query increments the last increment ids for all store by 100:

UPDATE eav_entity_store AS ees
  INNER JOIN eav_entity_type AS eet ON eet.entity_type_id = ees.entity_type_id
SET ees.increment_last_id = ees.increment_last_id + 100
WHERE eet.entity_type_code='order';

The actual values for each store can be queried as shown in Get stores last order increment ids.

One thought on “Increment order increment ids for all stores

Leave a Reply

Your email address will not be published. Required fields are marked *

 

This site uses Akismet to reduce spam. Learn how your comment data is processed.