Problems with increment_id We just migrated from magento 1 to 2, and when we did a purchase test, the new orders instead follow the continuation of the last id, started from the beginning.

Example last order in magento1 migrated to magento 2 300017136

I should continue in the 300017137

But he came out with 300000001

Can someone help me solve this please?

1 Answer 1


Please open sequence_order_1 table.

Changes the increment value to 300017138 using MySql query.

  • Dear @Amit Bera thanks for your answer, in a clean magento test it works but in this magento 2 that just migrates does not work, when I create a new order puts 300000002 and in BD in the table sequence_order_1 it appears the record 2 on top of which I put in 17137 Jan 24, 2018 at 21:52

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.

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