Do you need to change the SKU prefixes for many WooCommerce products at once? Doing it manually takes a lot of time. In this tutorial, we’ll show you how to bulk edit SKU prefixes in WooCommerce quickly and easily, using a simple spreadsheet interface.
This is helpful if you’re changing suppliers, organizing your products better, or updating old SKUs. With this method, you can update many SKUs at the same time… no coding, no CSV files, and no stress.
We’ll use WP Sheet Editor – WooCommerce Products, which allows you to edit WooCommerce products in bulk using a spreadsheet directly in your WordPress dashboard. It’s perfect if you want to save time and keep your product catalog organized.
You can download the plugin here:
Download WooCommerce Products Spreadsheet Plugin - or - Check the features
Once you install the plugin and activate your license, you need to follow the steps below to bulk modify the SKU prefixes of your WooCommerce products.
1- Open the spreadsheet
Go to WP Sheet Editor > Edit products and you’ll see all your WooCommerce products displayed in the spreadsheet.
2- Search for the products by SKU prefix
The first thing you need to do is to search for all the products you want to edit. For example, it is possible that not all your products have the same SKU prefix. This makes the task of editing your product prefixes complex.
Fortunately, WP Sheet Editor’s advanced search tools allow you to search for your products using any field as a search filter. In this case, you will be able to search for your products by SKU prefix.
As you can see in the screenshot below, many of our products have the prefix “2024-”. But we need to filter the products that have that prefix in the SKU, to make sure we edit all the relevant products.
To search for products by SKU prefix, we will use the Search tool.
Once you’re in the Search tool, you need to select these values:
- Tick the Enable advanced filters checkbox.
- Field: SKU
- Operator: STARTS WITH
- Value: Enter the SKU prefix here. We will enter “2024-“, without the quotation marks.
- Click on Run search.
After running the search, all the products containing the selected SKU prefix will be displayed in the spreadsheet. You can see the active search filter above the spreadsheet and corroborate that the results match the selected filters.
3- Bulk edit SKU prefix in WooCommerce products
Although you could edit the SKU prefixes one by one in the spreadsheet (by editing the values in the cells of the SKU column), we want to show you how to replace the SKU prefix in bulk.
This allows you to save many hours of work and complete the task in a few seconds.
Let’s start by opening the Bulk Edit tool.
Once you’re in the Bulk Edit tool, you need to select these values to bulk modify or bulk replace SKU prefix:
- Select the rows that you want to update: Edit all the rows from my current search (including non-visible rows)
- What field do you want to edit: SKU
- Select type of edit: Replace
- Replace this: Add the old SKU prefix. In this case, we will enter “2024-” without the quotation marks.
- With this: Enter the new SKU prefix. In this example, we will enter “2025-” without the quotation marks.
- You can click on Show preview to see the results before apply the changes.
- You can Edit only parent products or Edit only product variations.
- Click on Execute Now when you’re ready to apply the changes.
After applying the changes, you may see no results in the spreadsheet if you have the previous search filter active. You just need to click on the active search filter to remove it.
And here you can see the products with the updated SKU prefix.
This is how you can bulk update SKU prefix in bulk for your WooCommerce products. You can quickly search for products containing a specific SKU prefix and replace it with a new prefix with a few clicks. This way, you can save a lot of time editing SKUs in bulk.
You can download the plugin here:
Download WooCommerce Products Spreadsheet Plugin - or - Check the features