• 00Days
  • 00Hours
  • 00Mins
  • 00Sec
40% Off

Use coupon code

Limited Offer!

Customizing WooCommerce order numbers, prefixes, and sequences

How to Change WooCommerce Order Numbers & Make Them Sequential

AI Summary

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.

Can You Change Woocommerce Order Numbers?

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.

How to Make WooCommerce Order Numbers Sequential?

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 4 can 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
Configuring Sequential order number settings

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.
Reset past WooCommerce number order

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.

Shortcode for tracking WooCommerce 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.

preview of Track WooCommerce order when 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.

How to Reset WooCommerce Order Numbers Automatically?

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.
Reset WooCommerce Order Numbers Monthly in sequential order

How to Create Separate Order Numbers for Free Orders?

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.
Organize free order by number separately

This will create a separate order number sequence for free orders in your store.

How to Reset to Default WooCommerce Order Numbers?

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.
Reset to default WooCommerce 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.

WooCommerce Sequential Order Numbers Plugin Pro: An Overview

reset woocommerce order number in sequential order with the premium WebToffee plugin

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

Are WooCommerce order numbers sequential?

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.

Why Are My WooCommerce Order Numbers Skipping Numbers?

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.

How do I change a WooCommerce order number?

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.

Does resetting WooCommerce order numbers affect past orders?

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.

How do I start WooCommerce order numbers from 1?

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.

How to add prefixes to WooCommerce order numbers?

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.

How do I change the order number format in WooCommerce?

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.

How to generate order numbers for free orders in WooCommerce?

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.

How to export WooCommerce orders to a CSV file?

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?

Wrapping Up

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!

Article by

A bibliophile, movie buff, shutterbug, potter head who turned into a writer. Currently writing content for WebToffee.

Comments (6)

Got any query? Please leave a comment or reach out to our support

Your email address will not be published. Required fields are marked *

Google Preferred Source

Keep Order Numbers Sequentially Organized Through BFCM