How to create sequential order numbers in WooCommerce

Open WooCommerce > Orders and note the largest order number currently in use. WooCommerce normally displays the underlying order ID, and those IDs are not sequential because WordPress assigns IDs to other content as well.

Decide whether you need a new display format only, such as SHOP-1234, or a separate sequential counter that starts at a chosen number. The second requirement needs more than a simple formatting change.

Create a backup and, if possible, make the change on a staging site first. Record your current highest order ID and take note of systems that read order numbers, such as payment gateways, invoices, fulfilment tools, exports and customer emails.

Do not edit order IDs directly in the database. WooCommerce uses the underlying ID to retrieve orders, while the order number is primarily the value shown and passed to compatible integrations.

If you only need a prefix or suffix, add a small PHP filter through a child theme or a code-snippets tool. The confirmed WooCommerce filter is woocommerce_order_number; it changes the value returned for display, while the underlying order ID remains unchanged.

This is not a true sequential-number system. A filter that adds SHOP- to the existing ID will still show gaps whenever WordPress has assigned IDs to products, pages, revisions or other records. Do not use this route if accounting or fulfilment requires its own consecutive counter.

For a genuine sequence, install a WooCommerce order-number extension, activate it, and open its settings. WooCommerce documents the Sequential Order Numbers Pro setup under WooCommerce > Settings > General, where you can set the starting number, minimum length, prefix and suffix.

Choose a starting number higher than your current largest order number. Existing orders normally keep their current numbers, while new orders continue from the larger of the configured starting value or the existing highest number.

Enter the format you actually want customers and staff to see, such as WEB-{YYYY}{MM}-0001, then save the settings. If the extension supports date tokens, fixed-width numbers or separate treatment for free orders, configure those before taking live orders. The documented extension supports prefixes, suffixes, date and time patterns, padded numbers and optional handling for free orders.

Avoid changing the format repeatedly after orders have been issued. Some extensions update how existing numbers are displayed, while others leave historical values unchanged, so check the extension's documentation before switching formats.

Place a test order using the same checkout experience your customers use, including the Checkout block if it is enabled. Check the number in the Orders screen, the confirmation page, emails, payment gateway, invoice and any fulfilment or accounting connection.

Watch for gaps after abandoned or automatically created checkout drafts. Support reports have identified Checkout block draft orders that receive numbers before the customer confirms payment, so a sequence can still contain gaps unless the extension handles those drafts specially.

The fast route is WooCommerce Sequential Order Numbers Pro: install it from the WordPress plugin uploader, activate it, then configure the order-number settings. It is intended for stores that need a separate sequential sequence with a chosen starting number, prefixes, suffixes and padded numbering.

Use the manual filter only for a simple display prefix or suffix. If you need reliable numbering for records, customer support or integrations, the extension saves you from maintaining a counter and handling existing orders yourself.