Resetting WooCommerce order numbers is essential for maintaining an organized and professional online store. By using plugins like Sequential Order Numbers for WooCommerce, store owners can create a clear, sequential numbering system that enhances order tracking and bookkeeping, addressing the gaps caused by WordPress's unique post ID assignment.
- WooCommerce order numbers are not sequential by default, leading to potential confusion in order management.
- The Sequential Order Numbers plugin allows users to reset order numbers into a structured sequence, improving clarity.
- Store owners can customize order number sequences with prefixes, suffixes, and starting numbers for better organization.
- The plugin enables resetting order numbers at specified intervals, such as daily, monthly, or yearly, for efficient tracking.
- Separate sequences for free orders can be established to differentiate them from regular purchases, simplifying management.
- Resetting order numbers can enhance professionalism and streamline bookkeeping, making it easier to track sales and audit records.
WooCommerce order numbers can sometimes appear inconsistent, with gaps between one order and the next. You may also want to start your order numbers from a specific value, add a prefix or suffix, or create a cleaner sequential numbering system.
WooCommerce does not provide built-in settings for customizing order numbers. To change the number format or create a custom sequence, you can use a dedicated plugin or custom code.
In this guide, we’ll explain how WooCommerce order numbers work, why they may not be sequential, and how to change WooCommerce order numbers using the WebToffee Sequential Order Numbers plugin.
How Do WooCommerce Order Numbers Work?
Every WooCommerce order has a unique internal ID. The way these IDs are stored depends on the order storage system used by your store.
Traditionally, WooCommerce stored orders as WordPress posts in the wp_posts table. This meant orders shared the WordPress ID sequence with other content such as posts, pages, products, and attachments.
WooCommerce now uses High-Performance Order Storage (HPOS) by default for new installations. With HPOS, order data is stored in dedicated WooCommerce order tables instead of the traditional WordPress posts table. WooCommerce made HPOS stable and enabled it by default for new stores starting with WooCommerce 8.2.
Regardless of the storage method, WooCommerce does not include native settings for creating your own customer-facing order number sequence, such as:
- 1001, 1002, 1003…
- ORD-1001, ORD-1002…
- 2026-001, 2026-002…
- INV-SEP-001…
For that, you need a sequential order number plugin or a custom development solution.
Why Are WooCommerce Order Numbers Not Sequential?
A common concern among store owners is seeing order numbers such as:
1001 → 1002 → 1005 → 1008
instead of:
1001 → 1002 → 1003 → 1004
On stores using WooCommerce’s legacy order storage, this is largely because orders use WordPress post IDs.
For example:
- An order is created with ID 1001
- Another order gets 1002
- You upload an image, which receives ID 1003
- You create a product with ID 1004
- The next order receives ID 1005
Your WooCommerce order list would therefore show:
1001 → 1002 → 1005
The missing numbers do not necessarily mean WooCommerce has lost or skipped customer orders. Those IDs may simply have been assigned elsewhere in WordPress.
What About WooCommerce HPOS?
With HPOS, WooCommerce stores orders in dedicated tables such as _wc_orders instead of storing them directly as shop_order posts.
WooCommerce can also create placeholder records in the WordPress posts table to keep order IDs synchronized where required. This helps maintain compatibility between WooCommerce’s newer order storage and extensions that still depend on the traditional post-based structure.
So, rather than relying on the underlying WooCommerce order ID to create a clean customer-facing sequence, stores that require predictable numbering can use a separate sequential order number system.
What Is a Sequential WooCommerce Order Number?
A sequential order number follows a continuous, predefined sequence.
For example:
1001 → 1002 → 1003 → 1004
You can also customize the sequence to include prefixes, dates, fixed number lengths, or other identifying information:
ORD-1001 → ORD-1002 → ORD-1003
or
2026-0001 → 2026-0002 → 2026-0003
Sequential numbering makes order references easier to follow without requiring you to change WooCommerce’s underlying order storage.
Yes. You can change the order number displayed for WooCommerce orders, but WooCommerce does not provide built-in settings for doing this.
There are generally two approaches.
1. Use a WooCommerce Order Number Plugin
A dedicated plugin is the simplest option if you want to:
- Create sequential order numbers
- Change the starting order number
- Add prefixes or suffixes
- Include dates in order numbers
- Set a custom increment value
- Apply custom numbers to existing orders
- Restart sequences automatically
This approach is suitable for most store owners because the numbering can be managed directly from WooCommerce settings.
2. Use Custom Code
Developers can customize the order number displayed by WooCommerce using hooks and custom code.
This may work for simple requirements, but more advanced numbering rules, recurring resets, existing-order renumbering, and compatibility with other WooCommerce extensions require additional development and testing.
It is also better to avoid directly changing WooCommerce database IDs. WooCommerce recommends using its order APIs rather than directly querying or modifying the underlying database because stores may use either HPOS or legacy order storage.
For most stores, a dedicated plugin provides the easier way to generate and manage custom WooCommerce order numbers.
The free Sequential Order Number for WooCommerce plugin lets you replace the default order number format with a custom sequential sequence.
For more advanced controls, such as recurring resets and separate sequences for free orders, you can use the premium Sequential Order Numbers for WooCommerce plugin.
Step 1: Create a New WooCommerce Order Number Sequence
Install and activate the free Sequential Order Numbers for WooCommerce plugin. Then go to:
WooCommerce > Settings > Sequential Order Number
Under Settings, configure the following:
- Under Order number format, choose how you want the sequential order numbers to appear. Depending on the selected format, additional fields will be displayed. For example, if you select [Prefix][Number][Suffix][Date], fields for adding a prefix, suffix, and date format will appear.
- In Order number length, enter the minimum number of digits you want the order number to contain. For example, setting the length to
4can display numbers such as 0001, 0002, and 0003. - In Start Number, enter the number from which you want the sequence to begin. For example, entering 1001 will create a sequence such as: 1001 → 1002 → 1003 → 1004

You can use the preview shown below the Start Number field to check how the order number will appear before saving the settings.
Step 2: Reset Order Numbers for Past Orders
- If you want to generate past WooCommerce order numbers in sequential order, enable the Apply for all orders checkbox.
- Then keep the Track orders and Search orders checkboxes enabled to search for and track orders using the new order numbers.

Once configured, save the changes to apply the new sequential numbering format to future WooCommerce orders.
All WooCommerce order numbers, including those from past orders, will be reset to the new sequential order.
3. Track Orders Using Shortcode
To keep track of the sequential order number, enable the track order option. Enter the shortcode provided below for tracking orders.

WooCommerce provides this shortcode to link orders based on the order ID. To track orders, add this shortcode in a custom post.
The screenshot below shows the order tracking page on a website using the shortcode.

You can view all the order details by entering the order ID and billing email associated with a particular order.
Note: Features such as a separate sequence for free orders, custom increment values, and automatic sequence resets are available in the Pro version.
The WooCommerce Sequential Order Pro plugin allows you to reset the order numbers for both old and new orders at specified time intervals.
For example, if you want the first order of each month to start with order number 1, with subsequent orders following sequentially, resetting order numbers monthly is the answer.
After installing the premium plugin, follow these steps:
- Go to WooCommerce > Settings > Sequential Order Number Pro.
- Scroll down to the General settings.
- Choose Increment counter as 1. This will create order numbers with the increment of 1.
- Select Monthly interval from the Reset sequential order number to auto-reset the order number sequence every month.
- Then, choose the starting number for the order numbers.
- Click on Save changes to save the settings.

If your WooCommerce store offers free orders through giveaway campaigns or coupon promotions, these orders will be included in the same order number sequence as your regular orders. This can make it difficult and time-consuming to distinguish free orders from paid ones.
To efficiently manage this issue, you can use the sequential order number plugin to create a separate order number sequence for free orders. This allows you to easily differentiate between free and regular orders.
To organize WooCommerce free orders by number sequentially:
- Go to WooCommerce > Settings > Sequential Order Number Pro.
- Enable the Separate sequence for free orders checkbox.
- Then, choose a start number for free orders.
- Enter the prefix for the free order numbers.
- Click on Save changes.

This will create a separate order number sequence for free orders in your store.
If at any point you want to revert your customized order numbers back to WooCommerce’s default post IDs, the Sequential Order Number plugin makes it easy to do so.
- Go to WooCommerce > Settings > Sequential Order Number Pro > Troubleshooting tools
- Next, scroll down to Reset order number to default option and click “Reset to default.” This step will restore WooCommerce default order numbers.

Why Use Sequential Order Numbers in WooCommerce?
- Quick tracking: Easily locate orders using simple, sequential numbers, ideal for high-volume stores.
- Accurate reporting: Instantly gauge total sales and maintain clean records.
- Audit-friendly: Essential for tax reporting and legal documentation in certain regions.
- Efficient support: Reference order numbers during customer inquiries to resolve issues faster.

The WooCommerce Sequential Order Number plugin helps you simplify bookkeeping and order management on your WooCommerce store. By organizing the non-sequential WooCommerce order numbers in sequential order, you can manage your WooCommerce orders efficiently and error-free.
This WebToffee plugin allows you to generate custom order number sequences with prefixes, suffixes, dates, and numbers. You can choose the length of the order number, your preferred starting number, and your incrementation value. This plugin will automatically reset the order numbers at specific intervals. You can also choose to maintain a separate order number sequence for free orders to not mix free orders with standard orders.
In simple words, this plugin can save you from the hassles of random order number sequences and simplify your bookkeeping process.
Key features:
- Able to generate custom sequence of order numbers
- Create custom order numbers for free WooCommerce orders
- Customize the prefix, starting number, and length of the order number
- Add a prefix to the order date
- Customize order numbers for all orders or only for new orders
- Auto-reset order numbers in sequential pattern
- Shortcode support for order tracking
- Restore WooCommerce default order numbers
- Update order numbers manually
- You can optionally enable admin order searches by custom order numbers
Frequently Asked Questions
No, the WooCommerce order numbers are not in sequential order because they are assigned from the WordPress post ID. If a new post or product is published on your website between two new orders, the order numbers won’t be in sequential order.
Gaps in WooCommerce order numbers do not necessarily mean that orders are missing.
On stores using legacy order storage, orders historically shared WordPress’s ID sequence with other content types. This means IDs between two orders could be assigned to posts, pages, products, attachments, or other database records.
Modern WooCommerce stores may use HPOS, where order data is stored in dedicated order tables.
WooCommerce doesn’t provide a built-in option to change order numbers — they’re automatically assigned based on WordPress post IDs. To change them, you’ll need a plugin like Sequential Order Numbers for WooCommerce by WebToffee.
Once installed, go to WooCommerce > Settings > Sequential Order Number, and you can set a custom starting number, add a prefix or suffix, and define the increment value. Changes apply to all new orders immediately, and you can optionally apply them to past orders as well.
It depends on your settings. The WebToffee Sequential Order Numbers plugin lets you reset only future orders or renumber all past orders.
Keep in mind: resetting past orders will change existing order numbers, potentially breaking references in emails, invoices, or accounting systems. It’s best to do this before going live or at the start of a new financial year and update any external records if needed.
By default, WooCommerce assigns order numbers based on WordPress post IDs, so your first order might be numbered 5, 23, or higher, depending on how much other content exists on your site. To start from 1 (or any number you choose), navigate to WooCommerce > Settings > Sequential Order Number, and set your preferred value in the Start number field. If you want existing past orders renumbered as well, enable the Apply for all orders option before saving.
Use the WebToffee Sequential Order Numbers plugin to create a custom sequence of order numbers in WooCommerce. After installing the free WebToffee sequential order numbers plugin, go to WooCommerce > Settings > Sequential Order Number. Then, choose the prefixes for your order numbers and click on Save Changes to save the settings.
WooCommerce has no native options for order number formatting. With the Sequential Order Numbers for WooCommerce plugin, you can build a custom format by combining a prefix, a date pattern, and a sequential number — for example, ORD-2024-0001. In the plugin settings under WooCommerce > Settings > Sequential Order Number, you can choose the date format to embed (year, month, or full date), set the number length with zero-padding, and define a prefix or suffix. The Pro version offers the most flexibility here, including auto-reset intervals so your numbering restarts cleanly each month or year.
Using the WebToffee Sequential Order Numbers for WooCommerce plugin, you can generate separate order numbers for your free orders.
After installing the plugin, go to WooCommerce > Settings > Sequential Order Number (Pro). Then, enable the Separate sequence for free orders checkbox. Choose the preferred number sequence for the free orders and click on Save changes.
To export orders from your WooCommerce store, you can use the free WooCommerce order import export plugin. With this plugin, you can easily export WooCommerce orders to a CSV file.
Refer to this article for more information: How to Export WooCommerce Orders and Products?
Keeping your WooCommerce order numbers in sequential order isn’t just about neatness, it’s about improving your store’s efficiency, accuracy, and customer service.
By default, WooCommerce generates order numbers based on WordPress post IDs, which can cause confusing gaps. But with the Sequential Order Numbers for WooCommerce plugin, you get full control over your WooCommerce order numbers.
- Set custom starting numbers and prefixes
- Reset order numbers daily, monthly, or yearly
- Create separate sequences for free orders
- Improve tracking, auditing, and stock management
For an even more streamlined workflow, pairing sequential order numbers with a WooCommerce PDF invoices plugin can help you generate professional invoices that align perfectly with your custom order sequence, making order management more organized and customer-friendly.
That’s it, folks! We’ve reached the end of this guide on how to reset WooCommerce order numbers in sequential order. We hope this article has helped you reset order numbers on your WooCommerce store. If you have any queries, drop them in the comments section. We’d be happy to help you.
Thank you for reading!
Comments (6)
ANDREW ALLEN
November 12, 2024
Hi
We have one site where they have gaps in their order numbers – other sites are fine. Is there a reason for having gaps?
Many thanks,
Andrew
Sanjai Valsan
November 14, 2024
Hi Andrew,
Thank you for reaching out!
The gaps in the order numbers appear to be a site-specific issue. To investigate and resolve this, we recommend contacting our customer support team. They will be able to assist you further.
Timothy
October 14, 2024
Hello,
Is it possible to set the pickup-date in the order number?
Best regards,
Timothy
Sanjai Valsan
October 28, 2024
Hi Timothy,
Thank you for reaching out!
With the Sequential Order Numbers for WooCommerce plugin, store owners can customize their order numbers. However, currently, adding the pickup date directly to the order number isn’t supported.
Sunaina
October 5, 2023
Hi, I am wondering if we enable this feature “Apply for all orders – Enable to apply the above format for all existing orders” in Sequential Order Number for WooCommerce, will it trigger sending emails to all the customers associated with the previous orders when the order numbers are changed (we don’t want this to happen)?
Hema
October 17, 2023
Hello Sunaina,
Thanks for reaching out. If you enable the ‘apply for all orders’ option it won’t affect the already generated orders. So no emails will be sent to the customer’s. But if you place a new order, the post id of that email will be replaced by the sequential number (unless the website uses another email customizer plugins).