How to setup Sequential Order Numbers in WooCommerce?

Featured, WooCommerce, WordPress
How to setup Sequential Order Numbers in WooCommerce?

How to setup Sequential Order Numbers Pro plugin in WooCommerce?

The WooCommerce Sequential Order Numbers plugin allows you to have incremental order numbers rather than random numbers. Additionally, this plugin enables you to set an order starting number (i.e. 724), custom label your order prefix/suffix (i.e. WC-1001-UK), and most importantly, keep the same order numbers during a WooCommerce site migration from your old site to my new site (i.e. Order 339 on Site A is the same Order 339 on Site B).

In this guide, you will learn best practices for setting up the Sequential Order Numbers Pro plugin on your WooCommerce site. If you have not done so already, purchase and download the Sequential Order Numbers Pro plugin.

Note, this post will go through an example of using the Sequential Order Number plugin for purposes of your site migration. If you’d like to learn more about migrating your products, customers, and orders, please visit this blog post: How To Migrate Woocommerce Customers and Orders (Like A Pro!).

Let’s get started!

How to setup Sequential Orders on WooCommerce?

  1. Activate Sequential Order Number plugin on Site A
  2. Export Orders from Site A
  3. Activate Sequential Order Number plugin on Site B
  4. Import Orders to Site B
  5. Scenario A: Launched Site B Before Migrating All Historical Orders
  6. Scenario B: Launched Site B Before Migrating Some Historical Orders

1. Activate Sequential Order Number plugin on Site A

First, go to Site A and upload and activate the Sequential Order Numbers Pro plugin.

In part 2, we will be exporting your orders from Site A.

If you are more of a visual learner, see how to set up and use this plugin with this video:


2. Export Orders from Site A

The first step is to purchase, download and activate the Customer / Order CSV Export plugin on Site A.

Next, on your WordPress dashboard, hover over WooCommerce and click “CSV Export”, and then click the “Export” tab and click the Export button.

Finally, when the export is done, click the “Export list” tab and download the exported Orders CSV file.


3. Activate Sequential Order Number plugin on Site B

Next, go to Site B and upload and activate the Sequential Order Numbers Pro plugin.

Note, that no configuration is required for this plugin after activation as orders will automatically be numbered beginning at 1 for new sites with no orders, and orders will pick up. from the largest order number for sites with existing orders

If you’d like to configure settings such as customizing the order number start or setting an order number prefix/suffix, this can be found by hovering over your dashboard, click

Optional configuration settings to customize the order number can be found by navigating to your WordPress dashboard, and hover over WooCommerce, click “settings” and then toggle the tab that says “General”.

Pro tip >Order Number Start: If you’d like to enter in an Order Number Start, note that this is the starting number for any newly placed orders. This can be used to start order numbering at an arbitrary point (ie 4279) as long as it is higher than the current largest order number, or can be used to advance the order number in a shop with existing orders. For instance, if the current highest order number is 999 and this is set to 4279, the next orders placed will be: 4280, 4281, 4282, etc.

In part 4, we will be importing orders from Site A into Site B.


4. Import Orders to Site B

The next step is to purchase, download and activate the Customer / Order CSV Import Suite plugin on Site B.

Before importing your orders, I would highly recommend doing the following: Taking a backup of Site B. and Activate the Disable Emails plugin.

Step 1

First, navigate to Site B and on your WordPress dashboard hover over WooCommerce, click “CSV Import Suite”.

woocommerce-migrate-customers-csv-import-suite-settings

Then click “Import Orders”.

woocommerce-import-orders-between-sites

Step 2

Next, upload your Orders CSV file, click “Next” and configure the options.

import-woo-orders-options

When finished, click “Next”.

woocommerce-import-orders-settings

Pro tip: If your product SKUs have changed and want to import products with an updated SKU, open up your Orders CSV file, and run a search and replace on the product SKUs that have been updated before importing your orders.

Step 3

Then, make sure your Orders CSV file is mapped properly. Because you are migrating sequential orders, make sure to skip the first column “id” in the file mapping. Why? This is so the order_number and order_number_formatted fields within the imported order numbers file display the correct Order Number rather than the post_id.

import-orders-file-mapping-skip-order-id

The first 3 columns imported should be:

  1. id
  2. order_number
  3. order_number_formatted
  4. created_at

When finished, click “Next”.

Step 4

Finally, click run as a “Dry Run” and if everything went smoothly, click “Run a live import now”.

Finally, do a 2-3 live transactions on Site B and navigate to the “Orders” dashboard in WooCommerce. You should see that the orders are ascending (most recent order has the highest order number). For instance: Order #4280 (16 minutes ago), Order #4281 (10 minutes ago), Order #4282 (4 minutes ago),  and so forth. 

Congratulations! You have migrated your orders from Site A to Site B while keeping the same order numbers!

5. Scenario A: Launched Site B Before Migrating All Historical Orders

Example 1

I have 500 historical orders on Site A. I will not be able to migrate my 500 historical orders from my staging site (Site A) before I launch my new site (Site B).

Site A (Historical Orders): Min Order – Max Order

  • Starting Order #: 1001
  • Ending Order #: 1500

Example 1 Solution Steps

  1. Site B: Set the Custom Starting Order Number to the following: 1501 and higher (Remember, you’re able to choose any starting number that’s higher than your most current order number)
  2. Site B: Launch Site B
  3. Site A: Export the following order #s from Site A: 1001 – 1500
  4. Site B: Import the following orders #s to Site B: 1001 – 1500
  5. Site B: Do 3 test orders on the live site.
  6. Site B: Confirm the 3 test orders had the following order numbers: 1501, 1502, 1503

Example 2

I have 503 historical orders on Site A. I will not be able to migrate my 503 historical orders from my staging site (Site A) before I launch my new site (Site B).

Site A (Historical Orders): Min Order – Max Order

  • Starting Order #: 1001
  • Ending Order #: 1500
  • Other Order #s: 1871, 1923, 2384

Example 2A Solution Steps:

  1. Site B: Set the Custom Starting Order Number to the following: 2385 and higher (Remember, you’re able to choose any starting number that’s higher than your most current order number)
  2. Site B: Launch Site B
  3. Site A: Export the following order #s from Site A: 1001 – 1500, 1871, 1923, 2384
  4. Site B: Import the following orders #s to Site B: 1001 – 1500, 1871, 1923, 2384
  5. Site B: Do 3 test orders on the live site.
  6. Site B: Confirm the 3 test orders had the following order numbers: 2385, 2386, 2387

Example 2B Solution Steps: (Rename outlier order numbers > “1871 to “”1501”)

  1. Site B: Set the Custom Starting Order Number to the following: 1504 and higher (Remember, you’re able to choose any starting number that’s higher than your most current order number)
  2. Site B: Launch Site B
  3. Site A: Export the following order #s from Site A: 1001 – 1500
  4. Site B: Import the following orders #s to Site B: 1001 – 1500
  5. Site A: Export the following order #s from Site A (1871, 1923, 2384) into a CSV file. Then upload the csv file into Google Drive and rename the orders to the following:
    • “1871” to “1501”
    • “1923” to “1502”
    • “2384” to “1502”
  6. Site B: Import the following orders #s to Site B: 1501, 1502, 1503
  7. Site B: Do 3 test orders on the live site.
  8. Site B: Confirm the 3 test orders had the following order numbers: 1504, 1505, 1506

Example 2C Solution Steps: (Insert Prefix before outlier order numbers > “1871 to “”WC-1871”)

  1. Site B: Set the Custom Starting Order Number to the following: 1501 and higher (Remember, you’re able to choose any starting number that’s higher than your most current order number)
  2. Site B: Launch Site B
  3. Site A: Export the following order #s from Site A: 1001 – 1500
  4. Site B: Import the following orders #s to Site B: 1001 – 1500
  5. Site A: Export the following order #s from Site A (1871, 1923, 2384) into a CSV file. Then upload the csv file into Google Drive and rename the orders to the following:
    • “1871” to “WC-1871”
    • “1923” to “WC-1923”
    • “2384” to “WC-2384”
  6. Site B: Import the following orders #s to Site B: WC-1871, WC-1923, WC-2384
  7. Site B: Do 3 test orders on the live site.
  8. Site B: Confirm the 3 test orders had the following order numbers: 1501, 1502, 1503

6. Scenario A: Launched Site B Before Migrating Some Historical Orders

Example 1

I have 500 historical orders on Site A. I will not be able to migrate my 500 historical orders from my staging site (Site A) before I launch my new site (Site B). However, I was able to migrate 250 of the 500 orders from Site A to Site B.

Site A (Historical Orders): Min Order – Max Order

  • Starting Order #: 1001
  • Ending Order #: 1500

Example 1 Solution Steps

  1. Site A: Export the following order #s from Site A: 1001 – 1250
  2. Site B: Import the following orders #s to Site B: 1001 – 1250
  3. Site B: Set the Custom Starting Order Number to the following: 1501 and higher (Remember, you’re able to choose any starting number that’s higher than your most current order number)
  4. Site B: Launch Site B
  5. Site A: Export the following order #s from Site A: 1251 – 1500
  6. Site B: Import the following orders #s to Site B: 1251 – 1500
  7. Site B: Do 3 test orders on the live site.
  8. Site B: Confirm the 3 test orders had the following order numbers: 1501, 1502, 1503

Example 2

I will not be able to migrate my 503 historical orders from my staging site (Site A) before I launch my new site (Site B). However, I was able to migrate 250 of the 503 orders from Site A to Site B.

Site A (Historical Orders): Min Order – Max Order

  • Starting Order #: 1001
  • Ending Order #: 1500
  • Other Order #s: 1871, 1923, 2384

Example 2A Solution Steps

  1. Site A: Export the following order #s from Site A: 1001 – 1250
  2. Site B: Import the following orders #s to Site B: 1001 – 1250
  3. Site B: Set the Custom Starting Order Number to the following: 2385 and higher (Remember, you’re able to choose any starting number that’s higher than your most current order number)
  4. Site B: Launch Site B
  5. Site A: Export the following order #s from Site A: 1251 – 1500, 1871, 1923, 2384
  6. Site B: Import the following orders #s to Site B: 1251 – 1500, 1871, 1923, 2384
  7. Site B: Do 3 test orders on the live site.
  8. Site B: Confirm the 3 test orders had the following order numbers: 2385, 2386, 2387

Example 2B Solution Steps: (Rename outlier order numbers > “1871 to “”1501”)

  1. Site A: Export the following order #s from Site A: 1001 – 1250
  2. Site B: Import the following orders #s to Site B: 1001 – 1250
  3. Site B: Set the Custom Starting Order Number to the following: 1504 and higher (Remember, you’re able to choose any starting number that’s higher than your most current order number)
  4. Site B: Launch Site B
  5. Site A: Export the following order #s from Site A: 1251 – 1500
  6. Site B: Import the following orders #s to Site B: 1251 – 1500
  7. Site A: Export the following order #s from Site A (1871, 1923, 2384) into a CSV file. Then upload the csv file into Google Drive and rename the orders to the following:
    • “1871” to “1501”
    • “1923” to “1502”
    • “2384” to “1502”
  8. Site B: Import the following orders #s to Site B: 1501, 1502, 1503
  9. Site B: Do 3 test orders on the live site.
  10. Site B: Confirm the 3 test orders had the following order numbers: 1504, 1505, 1506

Example 2C Solution Steps: (Insert Prefix before outlier order numbers > “1871 to “”WC-1871”)

  1. Site A: Export the following order #s from Site A: 1001 – 1250
  2. Site B: Import the following orders #s to Site B: 1001 – 1250
  3. Site B: Set the Custom Starting Order Number to the following: 1501 and higher (Remember, you’re able to choose any starting number that’s higher than your most current order number)
  4. Site B: Launch Site B
  5. Site A: Export the following order #s from Site A: 1251 – 1500
  6. Site B: Import the following orders #s to Site B: 1251 – 1500
  7. Site A: Export the following order #s from Site A (1871, 1923, 2384) into a CSV file. Then upload the csv file into Google Drive and rename the orders to the following:
    • “1871” to “WC-1871”
    • “1923” to “WC-1923”
    • “2384” to “WC-2384”
  8. Site B: Import the following orders #s to Site B: WC-1871, WC-1923, WC-2384
  9. Site B: Do 3 test orders on the live site.
  10. Site B: Confirm the 3 test orders had the following order numbers: 1501, 1502, 1503

Video Tutorials

Sequential Order Numbers Pro

Migrate Customers and Orders (example #1)

Migrate Customers and Orders (example #2)


Additional Resources

Leave a reply

Comment policy: We love comments and appreciate the time that readers spend to share ideas and give feedback. However, all comments are manually moderated and those deemed to be spam or solely promotional will be deleted. Your email address will not be published. Required fields are marked*

FAQ

Migrations

Orders
How do I keep my WooCommerce order numbers the same when migrating sites?

How do I keep my order numbers the same during migration?

If you want your migrated orders to keep the same order number for each order, download the Sequential Order Numbers plugin (free) plugin or Sequential Order Numbers Pro plugin (paid) plugin on Site A before exporting your Orders and Site B before importing your Orders.

Every post on a WordPress site has a unique, auto-incremented post ID. This is also why your order numbers are not sequential by default: the order number typically equals order ID; this ID is pulling from a counter that’s also incremented each time a product, blog post, page, or other content is added.

woocommerce-sequential-order-numbers-plugin

Download the Sequential Order Numbers plugin on Site A and Site B.

Ensure the first and second columns are order_number and order_number_formatted and NOT IMPORTING the “id” column since this will be auto-incremented when importing to Site B.

Sequential Orders
Can I start the order numbers at a particular number, like 725? If so, how do I do that?

Yes, the Sequential Order Numbers Pro (paid) allows you to choose any starting number that’s higher than your most current order number.

To do this, go navigate to your WordPress Dashboard and then go to WooCommerce > Settings > General and scroll down to “Order Numbers” to set the Order Number Start.

Can I start the order numbers at a particular number, like 1? If so, how do I do that?

The Sequential Orders plugin doesn’t allow you to alter historical order numbers. So if you’re an existing store, there is a 99.9% chance that an order number such as “1” has already been used. If you have a new store, the order number will automatically start at “1”.

Thus, if you have an existing store, but would like to still start your orders, the only option is to permanently delete all orders in your store so that there are no historical order numbers.

My starting order number is not working. What could be the problem?

If your site already has existing orders, you must use a starting number which is greater than the biggest existing order number. For example, if the site has the following order numbers: 1, 2, 10, 125, 508, the only eligible starting order numbers are 509 and above. Note, this is done so that historical order numbers are not altered.

Can I set an order number prefix/suffix, like "WC-1001-UK"? If so, how do I do that?

Yes, the Sequential Order Numbers Pro (paid) plugin allows you to choose an Order Number prefix/suffix.

To do this, navigate to your WooCommerce dashboard, go to WooCommerce > Settings > General and scroll down to “Order Numbers” to set the prefix/suffix. In the example of “WC-1001-UK”, the prefix would be “WC-” and the suffix would be “-UK”.

Why are WordPress and WooCommerce order numbers not sequential by default?

Every post on a WordPress site has a unique, auto-incremented post ID. This is why your order numbers are not sequential by default: the order number typically equals order ID; this ID is pulling from a counter that’s also incremented each time a product, blog post, page, or other content is added.

Will the Order ID change for the orders migrated?

Yes! The post_ids for the orders imported from Site A to Site B would be the next auto-incremental number in the database.

What will happen when I activate the Sequential Order Number plugin on my site? What will change?

Once you activate the Sequential Order Number plugin on your site, any new orders will immediately and automatically start becoming sequential, starting from the most recent order number.

I will be launching my new site (Site B) before I will be able to migrate my historical orders from Site A. What should be my starting custom order number on Site B when I launch my site?

Example 1: I have 500 historical orders on Site A. I will not be able to migrate my 500 historical orders from my staging site (Site A) before I launch my new site (Site B).

Site A (Historical Orders): Min Order – Max Order

  • Starting Order #: 1001
  • Ending Order #: 1500

Example 1 Solution Steps

  1. Site B: Set the Custom Starting Order Number to the following: 1501 and higher (Remember, you’re able to choose any starting number that’s higher than your most current order number)
  2. Site B: Launch Site B
  3. Site A: Export the following order #s from Site A: 1001 – 1500
  4. Site B: Import the following orders #s to Site B: 1001 – 1500
  5. Site B: Do 3 test orders on the live site.
  6. Site B: Confirm the 3 test orders had the following order numbers: 1501, 1502, 1503

 

Example 2: I have 503 historical orders on Site A. I will not be able to migrate my 503 historical orders from my staging site (Site A) before I launch my new site (Site B).

Site A (Historical Orders): Min Order – Max Order

  • Starting Order #: 1001
  • Ending Order #: 1500
  • Other Order #s: 1871, 1923, 2384

Example 2A Solution Steps:

  1. Site B: Set the Custom Starting Order Number to the following: 2385 and higher (Remember, you’re able to choose any starting number that’s higher than your most current order number)
  2. Site B: Launch Site B
  3. Site A: Export the following order #s from Site A: 1001 – 1500, 1871, 1923, 2384
  4. Site B: Import the following orders #s to Site B: 1001 – 1500, 1871, 1923, 2384
  5. Site B: Do 3 test orders on the live site.
  6. Site B: Confirm the 3 test orders had the following order numbers: 2385, 2386, 2387

Example 2B Solution Steps: (Rename outlier order numbers > “1871 to “”1501”)

  1. Site B: Set the Custom Starting Order Number to the following: 1504 and higher (Remember, you’re able to choose any starting number that’s higher than your most current order number)
  2. Site B: Launch Site B
  3. Site A: Export the following order #s from Site A: 1001 – 1500
  4. Site B: Import the following orders #s to Site B: 1001 – 1500
  5. Site A: Export the following order #s from Site A (1871, 1923, 2384) into a CSV file. Then upload the csv file into Google Drive and rename the orders to the following:
    • “1871” to “1501”
    • “1923” to “1502”
    • “2384” to “1502”
  6. Site B: Import the following orders #s to Site B: 1501, 1502, 1503
  7. Site B: Do 3 test orders on the live site.
  8. Site B: Confirm the 3 test orders had the following order numbers: 1504, 1505, 1506

Example 2C Solution Steps: (Insert Prefix before outlier order numbers > “1871 to “”WC-1871”)

  1. Site B: Set the Custom Starting Order Number to the following: 1501 and higher (Remember, you’re able to choose any starting number that’s higher than your most current order number)
  2. Site B: Launch Site B
  3. Site A: Export the following order #s from Site A: 1001 – 1500
  4. Site B: Import the following orders #s to Site B: 1001 – 1500
  5. Site A: Export the following order #s from Site A (1871, 1923, 2384) into a CSV file. Then upload the csv file into Google Drive and rename the orders to the following:
    • “1871” to “WC-1871”
    • “1923” to “WC-1923”
    • “2384” to “WC-2384”
  6. Site B: Import the following orders #s to Site B: WC-1871, WC-1923, WC-2384
  7. Site B: Do 3 test orders on the live site.
  8. Site B: Confirm the 3 test orders had the following order numbers: 1501, 1502, 1503
I will be launching my new site (Site B) before I will be able to migrate all of my historical orders from Site A. I was able to migrate half of my historical orders from Site A. What should be my starting custom order number on Site B when I launch my site?

Example 1: I have 500 historical orders on Site A. I will not be able to migrate my 500 historical orders from my staging site (Site A) before I launch my new site (Site B). However, I was able to migrate 250 of the 500 orders from Site A to Site B.

Site A (Historical Orders): Min Order – Max Order

  • Starting Order #: 1001
  • Ending Order #: 1500

Example 1 Solution Steps

  1. Site A: Export the following order #s from Site A: 1001 – 1250
  2. Site B: Import the following orders #s to Site B: 1001 – 1250
  3. Site B: Set the Custom Starting Order Number to the following: 1501 and higher (Remember, you’re able to choose any starting number that’s higher than your most current order number)
  4. Site B: Launch Site B
  5. Site A: Export the following order #s from Site A: 1251 – 1500
  6. Site B: Import the following orders #s to Site B: 1251 – 1500
  7. Site B: Do 3 test orders on the live site.
  8. Site B: Confirm the 3 test orders had the following order numbers: 1501, 1502, 1503

Example 2: I will not be able to migrate my 503 historical orders from my staging site (Site A) before I launch my new site (Site B). However, I was able to migrate 250 of the 503 orders from Site A to Site B.

Site A (Historical Orders): Min Order – Max Order

  • Starting Order #: 1001
  • Ending Order #: 1500
  • Other Order #s: 1871, 1923, 2384

Example 2A Solution Steps

  1. Site A: Export the following order #s from Site A: 1001 – 1250
  2. Site B: Import the following orders #s to Site B: 1001 – 1250
  3. Site B: Set the Custom Starting Order Number to the following: 2385 and higher (Remember, you’re able to choose any starting number that’s higher than your most current order number)
  4. Site B: Launch Site B
  5. Site A: Export the following order #s from Site A: 1251 – 1500, 1871, 1923, 2384
  6. Site B: Import the following orders #s to Site B: 1251 – 1500, 1871, 1923, 2384
  7. Site B: Do 3 test orders on the live site.
  8. Site B: Confirm the 3 test orders had the following order numbers: 2385, 2386, 2387

Example 2B Solution Steps: (Rename outlier order numbers > “1871 to “”1501”)

  1. Site A: Export the following order #s from Site A: 1001 – 1250
  2. Site B: Import the following orders #s to Site B: 1001 – 1250
  3. Site B: Set the Custom Starting Order Number to the following: 1504 and higher (Remember, you’re able to choose any starting number that’s higher than your most current order number)
  4. Site B: Launch Site B
  5. Site A: Export the following order #s from Site A: 1251 – 1500
  6. Site B: Import the following orders #s to Site B: 1251 – 1500
  7. Site A: Export the following order #s from Site A (1871, 1923, 2384) into a CSV file. Then upload the csv file into Google Drive and rename the orders to the following:
    • “1871” to “1501”
    • “1923” to “1502”
    • “2384” to “1502”
  8. Site B: Import the following orders #s to Site B: 1501, 1502, 1503
  9. Site B: Do 3 test orders on the live site.
  10. Site B: Confirm the 3 test orders had the following order numbers: 1504, 1505, 1506

Example 2C Solution Steps: (Insert Prefix before outlier order numbers > “1871 to “”WC-1871”)

  1. Site A: Export the following order #s from Site A: 1001 – 1250
  2. Site B: Import the following orders #s to Site B: 1001 – 1250
  3. Site B: Set the Custom Starting Order Number to the following: 1501 and higher (Remember, you’re able to choose any starting number that’s higher than your most current order number)
  4. Site B: Launch Site B
  5. Site A: Export the following order #s from Site A: 1251 – 1500
  6. Site B: Import the following orders #s to Site B: 1251 – 1500
  7. Site A: Export the following order #s from Site A (1871, 1923, 2384) into a CSV file. Then upload the csv file into Google Drive and rename the orders to the following:
    • “1871” to “WC-1871”
    • “1923” to “WC-1923”
    • “2384” to “WC-2384”
  8. Site B: Import the following orders #s to Site B: WC-1871, WC-1923, WC-2384
  9. Site B: Do 3 test orders on the live site.
  10. Site B: Confirm the 3 test orders had the following order numbers: 1501, 1502, 1503