I'm trying to change sales_order entity_id, but can't. In my client system having 65451 orders, they want to change order number like 95651 for some reason. We can change sales_order increment_id, but is there possibility to change sales_order entity_id?

please suggest us if we can?

  • Please check the link. It will have all possible solution which you want to change in order number. Thanks and Hope it will help you. – Mayur Sep 16 '19 at 10:50

Change table auto-increment number for sales(sales_order, sales_order_grid) table.


ALTER TABLE sales_order AUTO_INCREMENT= 65451;

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.