How To: Change order number sequence in Magento

1. Take a backup of your database as explained here.

2. Find out the entity_id value for orders and invoices by opening the table eav_entity_type:

eav1

3. Open the table eav_entity_store and change the value in the increment_last_id field to the number to want to use:

eav2

 

Michael Savin

My name is Michael Savin. I've been contributing to the Internet for over ten years and have been a London based Magento freelancer for the last six.

I build eCommerce websites for varied companies worldwide and enjoy a close relationship with many brands, freelancers and studios. Work aside I enjoy cycling, reading and long walks in sunny days.

Leave a Reply

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