Help fixing order numbers

Hi,

One option is using WooCommerce Extensions, for example, one that is able to help you is the Sequential Order Numbers Pro, https://woocommerce.com/products/sequential-order-numbers-pro/

Via SQL command in the database you can do it as well, be sure to back up the site before making any relevant change, the Alter Table command might help, here there are some articles that explain how to use it:

• Change auto increment starting number?
• Change Woocommerce order number to specific number of digits

I hope this helps.

Super, thanks @ihereira I’ll give the SQL commands a try… I did look into the pro plugin you recommended already and decided it wasn’t worth the money for a one-time quick fix. Thank you!

Hello,

Glad to hear that.

This is optional, if you have a few minutes, we’d love it if you could share your experience with the community by leaving a review.

Kind regards.