Looking for a way to manually increment the WordPress post ID

Question

I recently created a staging site to redesign an eCommerce website. Before pushing staging live, I imported all of the customers and orders into the staging site then went live. The issue that I'm running into is that the client's CRM is using the post ID for order tracking. The redesigned site's post ID for newly created orders is about 5,000 behind where the old site's post ID counter was. This is resulting in duplicate content issues in the client's CRM.

Is there a way to manually increment the post ID counter to a higher value?

Answer 1

A fellow developer helped me with the following code:

ALTER TABLE wp_posts AUTO_INCREMENT = x

Run this in phpMyAdmin to change the counter number to whatever value you place in x. Just make sure that it's higher than your current highest post number or serious issues can arise.