I want to change the sequence of next new order number ( post_id ) in woocommerce because of some number conflicts with our accounting software who is integrated with woocommerce.

Our latest order number is 51249 and i want the next and newer to start with 70000.

Is it safe to run following sql query?: ALTER TABLE wp_posts AUTO_INCREMENT = 70000;

CodePudding user response：

Your question has the solution.

Yes, it is safe to increase AUTO_INCREMENT as long as you are sure you can never go back. The opposite (reducing) is not as easy and safe as increasing it. I would recommend you check the AUTO_INCREMENT value just in case before running the query.

In conclusion, this is the correct answer to achieve what you asked. Remember making a backup before just in case.

ALTER TABLE wp_posts AUTO_INCREMENT = 70000;