How To Reset Woocommerce Order Number

For those utilizing WooCommerce for their online shop, it’s common knowledge that the platform automatically assigns and sequentially increases the order numbers for each new purchase. Nonetheless, there are instances when resetting the order number to zero or another chosen figure might be beneficial. This article aims to guide you through the process of doing precisely that.

Why Reset WooCommerce Order Number?

There are several reasons why you might want to reset your WooCommerce order number. For example, if you have recently migrated your store to a new server or changed the URL of your site, you may want to start fresh with a new order number sequence. Alternatively, if you have experienced technical issues that have caused duplicate order numbers, resetting the order number can help prevent confusion and ensure that each order has a unique identifier.

How to Reset WooCommerce Order Number

To reset your WooCommerce order number, you will need to access the database of your WordPress site. Here are the steps to follow:

  1. Log in to your WordPress dashboard and navigate to “Plugins” > “Installed Plugins”.
  2. Find the “WooCommerce” plugin and deactivate it.
  3. Navigate to “Tools” > “Export” and export your WooCommerce data as a CSV file. This will allow you to keep track of your orders even after resetting the order number.
  4. Connect to your WordPress database using a tool like phpMyAdmin or MySQL Workbench.
  5. Locate the “woocommerce_order_items” table and delete all rows from it. This will remove all existing order numbers from your site.
  6. Locate the “woocommerce_orders” table and update the “order_number” column to a new value of your choice. You can set this to any number you like, but it’s recommended to start at zero or one to avoid confusion with existing orders.
  7. Reactivate the WooCommerce plugin in your WordPress dashboard and test that the order numbers are now reset to your chosen value.


Resetting your WooCommerce order number can be a useful way to start fresh with a new sequence of unique identifiers for your orders. By following the steps outlined in this article, you can easily reset your order number and ensure that each order has a distinct identifier.