There is a similar question here: Magento 2 - What is the correct way to change default Order Id? However that did not work for me.

The first order in my store has the ID 000000001. I want that number to start with 2. I also want to change the last digit, so the next order's ends in 399.

  • "I have the same question as X but the answers did not work for me" is not enough to justify a new question. Please update the question with the exact steps that you tried because probably there was a mistake somewhere. Aug 19, 2016 at 7:38

1 Answer 1


go to your database, enter below query for table sequence_order_1. sequence_order_1 is used for order id management.

ALTER TABLE sequence_order_1 AUTO_INCREMENT=200000399;

Next order id is start from 200000399.

  • In PHPMYADMIN INSERT INTO sequence_order_1 (sequence_value) VALUES ('1000'); 1000 will be the new start number Jan 11, 2018 at 23:12

Not the answer you're looking for? Browse other questions tagged or ask your own question.