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.
1 thoughts on “Increment order increment ids for all stores”