This is a complete guide to bulk edit WooCommerce products using the WP Sheet Editor plugin.
Managing a WooCommerce store often involves handling many products, each with their own attributes, prices, stock levels, descriptions, and any other relevant data. Manually updating your products one by one through the WordPress admin dashboard can be time-consuming and prone to errors. This is where the WP Sheet Editor – WooCommerce Products plugin comes in.
Table of Contents
WP Sheet Editor – WooCommerce Products
WP Sheet Editor – WooCommerce Products is a WordPress plugin that allows you to bulk manage your WooCommerce products using a spreadsheet on WordPress. This plugin completely transforms the way you manage your products’ data, making bulk editing and management tasks much more efficient. Instead of navigating through multiple pages and forms, you can edit all your products’ information in a spreadsheet view.
Key features
- Spreadsheet interface: You can view and edit all your product details in a spreadsheet. This includes titles, descriptions, prices, stock levels, SKUs, categories, and more.
- Powerful bulk editor: You can make changes to multiple products at once. Update prices, change stock levels, modify attributes, and so on.
- Advanced search: You can find and edit specific products using advanced search filters. Search by title, category, stock status, regular price, sale price, attribute, tag, stock, visibility, author, vendor, etc.
- Import/export: You can import and export product data using CSV files. This feature is perfect for making bulk changes offline and then uploading them to your WooCommerce store.
- Easy duplicates: You can duplicate any product to create hundreds or thousands of copies. Use a master product, create hundreds of duplicates, and then just customize each product using the spreadsheet.
- Easy variations management: You can bulk manage product variations using the spreadsheet. Bulk edit variation attributes, prices, and stock levels in bulk. Create variations in bulk, copy variations from one product to hundreds of products, convert simple products into variable products, convert variations into simple products, etc.
- Dark mode: You can view the spreadsheet in dark mode to give some rest to your eyes.
- Columns manager: You can hide/display/sort columns to customize/simplify the spreadsheet.
WP Sheet Editor – WooCommerce Products is a game-changer if you’re looking to simplify your WooCommerce product management.
Getting started → Install and activate WP Sheet Editor
If you want to get WP Sheet Editor, you need to purchase it using the button below:
You can download the plugin here:
Download WooCommerce Products Spreadsheet Plugin - or - Check the features
After completing the payment process, you will get a zip file that you must install as a plugin on your website.
- Go to Plugins > Add New Plugin
- Click on Upload plugin.
- Click on Choose file.
- Locate the file on your computer.
- Click on Install now.
- Click on Activate plugin.
- Enter your license and click on Activate License.
Quick editing products in the spreadsheet
WP Sheet Editor allows you to bulk edit WooCommerce products using a spreadsheet. This is a great way of quick editing products and saving a lot of time.
The spreadsheet displays all product fields as columns, and each field is displayed in cells according to the field type.
Let’s see how different fields are displayed on the spreadsheet.
a) Number fields (regular price, sale price, stock, etc.)
All number fields such as regular price, sale price, stock, and others accept numbers.
b) Dropdown fields (status, stock status, etc.)
All fields showing selectable options are displayed as drop-down fields.
c) Upload file fields (featured image, product gallery, etc.)
The file fields allow you to upload images, videos, documents, etc. You can upload files from your computer, select them from the media library, or paste the URLs of the files by double-clicking them.
If you click on the Upload button, will be able to upload files or select them from the media library.
d) Text editor fields (description)
Text editor fields such as TinyMCE editor will allow you to add plain text by double-clicking, or add formatted text using the editor that will open in the popup when you click edit.
This is the text editor popup that allows you to add formatted text.
e) Date fields (date created, date modified)
Date fields will display a calendar and time selector.
f) Checkbox fields (sold individually, virtual, etc.)
Checkbox fields will display the checkbox for you to select any value (Yes/No).
g) Taxonomy fields (category, tag, attributes like size, color, brand, etc.)
Taxonomy plugins such as categories, tags, attributes (color, size, brand, etc.), or custom taxonomies added with third-party plugins, allow you to easily select terms. Just start typing, and the term suggestions will be displayed. You can select taxonomies with one click as well.
Advanced products search
WP Sheet Editor – WooCommerce Products contains an advanced search tool that’s been designed to simplify the process of managing your WooCommerce products. Whether dealing with extensive product catalogs or detailed attribute configurations, the advanced search feature ensures you can quickly access the information you need.
The advanced search tool allows you to filter products using a wide range of criteria, including:
- Keyword in title or description: You can search for products that contain a specific keyword in the title or description.
- Categories: You can filter products based on their assigned categories to manage specific groups of products.
- Tags: You can search for products containing any specific tag.
- Attributes: You can find products containing specific attributes (size, color, material). This is useful to manage products with particular characteristics.
- Product type: You can search for simple, variable, grouped or external products.
- Shipping class: Use shipping classes as search criteria to find bulky products, frees shipping products, etc.
- Search on variations: You can filter product variations, not only parent products.
- SKU: You can use the product SKUs to find products, which is especially useful for inventory management and tracking.
- Price: You can filter products based on their price (regular price, sale price) or price range, which is useful for managing pricing strategies.
- Stock status: You can locate products based on their stock status (in stock, out of stock, on backorder) to manage inventory levels effectively.
- Date created/modified: You can search for your products based on their creation or modification dates, which is useful for recent updates or historical analysis.
- Custom Fields: If you’ve added custom fields using any plugin, you can use custom fields to target products with specific properties or additional metadata.
- And a lot more!
To filter your products with the advanced search tool, click on Search.
Once you’re in the search tool, select the search terms. In this example, we will run a combined search with these values:
- Keyword = t-shirt
- Category = Clothing
- Stock status = In stock
- Regular price >= 30
Once we’ve selected the search terms, let’s click on Run search
Once you filter your products, they will be displayed on the spreadsheet. You’ll see all the active filters above the products’ data, and you can remove any filter by clicking on it.
Bulk edit WooCommerce of products – thousands at once
With WP Sheet Editor, you can update thousands of products in bulk with a few clicks. You can edit all products, all products from a specific search, or all products you manually select in the spreadsheet.
These are some of the things you can do with the Bulk Edit tool:
- Bulk delete products
- Edit product prices in bulk (add new prices, decrease or decrease prices by percentage/amount)
- Update product status in bulk
- Bulk upload product images or galleries
- Move products from one category to another in bulk
- Assign products from one author to another
- Copy values between related fields (copy product variation to short variation and vice versa, copy regular price to sale price and decrease by percentage or amount, append category to product title, and a lot more.)
- Bulk edit product categories, tags, attributes (color, size, etc.)
- In short, you can edit any field in thousands of products!
In this example, we are going to edit all products from a specific search, and we will bulk update product prices.
You need to start by opening the Bulk Edit tool.
Once you’re in the Bulk Edit tool, you need to select these values (using the bulk edit is easy because it works the same for all fields):
- Select the rows that you want to update: In this case, we’ll edit all the rows from the last search
- What field do you want to edit: You can bulk update any field, but in this example, we will select the “Regular price” field.
- Select type of edit: The types of edit available will depend on the field you’ve selected. In this case, we will Increase by percentage.
- Increase the existing value by a percentage: Add the percentage here.
- You can Edit only parent products or Edit only variations.
- Finally, click on Execute Now.
As you can see below, we have bulk updated the product prices:
To read more tutorials on how to bulk edit WooCommerce products, you can read our blog.
View and manage product variations
If you want to manage WooCommerce variations, you would normally have to open a product, go to variations, and make changes to each variation. This is too complicated a process.
Fortunately, in WP Sheet Editor you can bulk manage product variations using the spreadsheet.
You just have to click on Display variations and the variations will be displayed on the spreadsheet next to their parent product.
WooCommerce bulk variations manager
If you want to create variations or copy variations between products, you can do it easily with our WooCommerce Variations Manager.
To open the Variations Manager, click on Create variations.
You’ll have two options:
1) Create variations
If you want to Create variations:
- The variations are for these products:
- Individual products
- All the products from a specific search
- All the variable products
- Select how many variations you want to create:
- A specific number of variations
- Create variations for every combination of attributes
2) Copy variations
If you want to Copy variations:
- Copy variations and attribute from this product: Here you can select any variable product containing variations, from which you’ll copy the variations and the attributes.
- I don’t want to copy all the variations: If you tick this checkbox, you can select specific variations to copy.
- The variaitons are for these products: You can select any of these options:
- Select individual products
- All products from a search
- All variable products
- Show advanced options:
- Use prices from simple product (parent) on the variations
- Only copy new variations
- Do not copy the variation images
Bulk edit WooCommerce products offline (Export to CSV)
WP Sheet Editor allows you to export your WooCommerce products data to a CSV file.
If you want to export all your WooCommerce products to bulk edit product data offline, you need to follow these steps:
First, open the Export tool.
Once you’re in the Export tool, you need to select these values:
- Which rows do you want to export: You can export all the products, all the products from a specific search, or all the products you’ve manually selected in the spreadsheet.
- What app will you use to edit this file: You can select any of these options:
- Microsoft Excel (Office 365)
- Older versions of Microsoft Excel
- Google Sheets
- Other
- Name of this export: You can add a name for this export in this field. Then, when you hover over the Export tool, you’ll be able to reuse this export.
- Click on Start new export.
Once the export process is complete, you’ll be able to bulk update your WooCommerce products using Excel, Google Sheets, or any other CSV editor.
Import WooCommerce products from CSV
After bulk editing your WooCommerce products in a CSV, you can import the products’ data back into your WordPress site.
To do this, you need to start by opening the Import tool.
Then you need to select the CSV file you’ll import by selecting these values:
- Source:
- CSV file from my computer (we’ll select this option)
- CSV file from URL
- Copy and paste from another spreadsheet or table
- CSV file in the server
- Click on Choose File and select the file from your computer.
- Click on Next.
You can Import all the columns or Select individual columns to import.
You need to select how you want to import the data:
- Do you want to update or create items:
- Create new items and update existing items
- Import all rows as new
- Only create new items, ignore existing items
- Only update existing items, ignore new items
- If you select any option to update existing items, you will have to match the rows using any field. We recommend the ID field.
- Click on Next.
Finally, you’ll see a preview.
If everything is OK, you need to click on The preview is fine, start import.
Important FAQ
Let’s consider some important questions about the WP Sheet Editor plugin.
Is WP Sheet Editor compatible with custom fields?
Yes. WP Sheet Editor is compatible with custom fields, so you’ll be able to edit fields added by plugins like Advanced Custom Fields and any other plugin that adds custom fields to your WooCommerce products.
Here are some plugins that allow you to add custom fields to your WooCommerce products, which you can edit with WP Sheet Editor in the spreadsheet:
- Advanced Custom Fields (ACF)
- Product Addons for WooCommerce
- Extra Product Options for WooCommerce
- Flexible Product Fields for WooCommerce
Is WP Sheet Editor compatible with multilingual / translation plugins?
Yes. WP Sheet Editor is compatible with popular multilingual plugins such as WPML, Polylang, and others.
Here are some related tutorials:
- Bulk translate products with WPML and WP Sheet Editor
- Export and import product translations made with Polylang
Best bulk editor for WooCommerce products
Running a WooCommerce store is great, but managing a lot of product data can be overwhelming sometimes. Imagine having to update prices, adjust stock levels, or tweak product descriptions for hundreds of items. That takes a lot of time. But what if there was a better way to do it?
Well, WP Sheet Editor is your best option. This powerful plugin brings the simplicity and efficiency of a spreadsheet directly to your WooCommerce store. You can bulk edit your products with a few simple clicks, reducing the hours you spend on product management.
Need to update the prices for a seasonal sale? Adjust stock levels after a big shipment? No problem. With WP Sheet Editor, you can bulk edit your WooCommerce products in minutes, not hours.
You can download the plugin here:
Download WooCommerce Products Spreadsheet Plugin - or - Check the features