How to Apply Custom Order Sequence to New and Existing WooCommerce Orders?

Every store owner wants a smooth way to manage orders without confusion in order numbering. Imagine scrolling through hundreds of WooCommerce orders and finding them scattered with default WordPress Post IDs that hardly make sense. This is where custom order sequencing comes in. By creating your own order number format, you can bring clarity to tracking, reporting, and even customer communication.

The WooCommerce Sequential Order Numbers plugin makes this possible. It allows you to apply a consistent order sequence to both new and existing orders, keeping your store records more structured and easier to manage. Whether you want a fresh start for upcoming orders or prefer to reorganize existing ones, this custom order number plugin provides the flexibility to set it up.

Ready to set up a structured WooCommerce order numbering system that improves internal workflows? Let’s get started!

Default WooCommerce order IDs are WordPress Post IDs, which often makes them appear random.

Let’s say you have two orders, Order A and Order B. The order ID for order A is 1000. After you receive Order A, you create a blog post on your website. In this case, the post IDs will be assigned to Order A first, then the blog post, and then Order B. So Order A will have the post ID 1000, the blog will have the post ID 1002, and Order B will have the post ID 1003.

This leads to gaps and inconsistencies that can be confusing. A scattered sequence also complicates record-keeping and makes it harder to match invoices or reports with specific transactions.

Applying a custom order number format solves this issue. It allows you to decide how your order numbers should look and follow a logical sequence. For example, you might want to include a prefix like ORD-2025 or reset the numbering from a specific point. This not only improves order tracking but also brings consistency across invoices, shipping documents, and customer communication.

Consider a wholesale store that processes hundreds of orders monthly. If the system uses default IDs, reconciling old orders during an audit becomes a struggle. By applying structured WooCommerce order numbering, the store can quickly locate transactions, confirm details, and keep operations efficient.

Not every business wants to treat old and new orders the same. Sometimes you need a fresh sequence for new purchases while keeping a different structure for past ones. The WebToffee Sequential Order Numbers plugin makes this distinction possible by letting you assign custom formats for both.

Here’s how you can apply it step by step:

Step 1: Install and Activate the Sequential Pro Plugin

Since we need the premium plugin for this setup, you’ll first need to purchase it from the website. After completing your purchase, download the plugin ZIP file, then upload it to your WordPress dashboard to install and activate it on your store.

Step 2: Set Up Order Number Sequence for Existing Orders

Now, to set up a sequential order number sequence,

• Go to WooCommerce > Settings > Sequential Order Number Pro
• In the Customize order number format settings, choose the order format and configure additional settings like order number length, custom prefixes and/or suffixes, and start number.

For example, if you want to apply the format WT-OLD01-2025, choose the order format [Prefix][Number][Suffix][Date]. Then:

• Enter WT-OLD as the Prefix
• Add – as the Suffix
• Choose the date format [Y]
• Set the start number to 1

You will see a preview of the final order number.

• Next, define the increment counter as “1” and set the reset option to Never.
• Scroll down to the Apply above custom order number format for setting and select Existing orders from date. Then, choose the desired order date.

• Now, click Save changes to apply the order number format to all existing orders.

Step 3: Set Custom Sequence for New & Upcoming Orders

To avoid confusion between past and new transactions, create a different sequence for upcoming orders.

For example, you might want the format “WT-2025-01”. To do this,

• Choose the order format [Prefix][Date][Number].
• Enter WT- as the Prefix
• Select the date format [Y]-
• Set the start number to 1
• Define the Order number length as “2” so the sequence displays as 01, 02, and so on.
• Next, define the increment counter and set the reset option to Yearly.

• Scroll down to Apply above custom order number format for and select Upcoming orders only. Save the changes.

After saving your changes, check your WooCommerce orders list. You’ll see that new and old orders now follow their respective numbering formats.

Simplify WooCommerce Order Tracking with the Sequential Plugin

Once you apply custom sequences, the real benefit shows up in daily operations. Tracking becomes smoother because every order follows a format you’ve designed. Staff can search by prefix or sequence range instead of digging through unrelated IDs. Customers also find it easier to reference their order numbers when reaching out for support.

The premium version of the Sequential Order Numbers plugin offers additional features such as,

• Set a custom starting number for orders
• Add a custom prefix, suffix, or order date
• Reset order numbers automatically
• Define custom increments for order sequences
• Set custom order number length
• Enable WooCommerce order tracking
• Set up custom sequences for free orders
• Order number preview available

With these features, WooCommerce order numbering becomes an organized system instead of a random string of IDs. Whether you’re managing hundreds or thousands of transactions, the plugin keeps everything structured.

Applying a custom order number format may seem like a small adjustment, but it makes a noticeable difference in how you handle WooCommerce orders. Clear sequences reduce errors, simplify audits, and give customers an easy way to reference their purchases. By separating new and existing orders into their own numbering patterns, you add an extra layer of organization that benefits both your team and your buyers.

The WooCommerce Sequential Order Numbers plugin brings this flexibility into your store. With options to customize prefixes, suffixes, starting numbers, and automation, it transforms default order IDs into structured records that actually support your workflow.

That’s it! We have come to the end of this short article on how to set up custom order number formats for WooCommerce orders for easy record-keeping and better tracking. Hope you found this article informative. Let us know your thoughts in the comments below.