Is there any way to change increment ID for new orders. For example if current last order ID is 1000. But for new orders, I want to start it from 1020


1 Answer 1


You can change it in database, check for the table sequence_order_1 and change the Autoincrement value as required.

  • Is it safe and proper way ? Mar 20, 2018 at 8:05
  • I haven't see any other option so far, just take care while handing DB(backup). Mar 20, 2018 at 8:09

Your Answer

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

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