For magento if you need to set order id pointer to xxxxxxxx then use below simple sql will solve your problem.


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=’xxxxxxxx’, eav_entity_store.increment_prefix=’x’ WHERE eav_entity_type.entity_type_code=’order’;

increment_prefix : This number will just add before your order ID

Example
you set increment_last_id 1234567
And increment_prefix=’6

So your next order ID will be 61234568

Where as 6 is from increment_prefix and 1234568 +1 count of increment_last_id

Leave a Reply

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