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


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 ? – Kishan Patadia Mar 20 '18 at 8:05
  • I haven't see any other option so far, just take care while handing DB(backup). – Sreejith Gopinath Mar 20 '18 at 8:09

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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