Retaining your product catalog updated is a key a part of operating a WooCommerce retailer. Typically, it’s possible you’ll have to make store-wide adjustments or replace all merchandise in a sure class. For example, you might need so as to add a brand new dimension to your entire T-shirts or enhance the worth of all mugs. Making use of these adjustments one product at a time might be tedious and time-consuming.
The excellent news is that with WooCommerce, you don’t must manually replace particular person merchandise. WooCommerce allows you to bulk replace your merchandise, altering values like availability, inventory portions, value, and extra. Moreover, you need to use a Woo extension or a WooCommerce bulk edit plugin to entry extra superior bulk modifying options.
On this put up, we’ll focus on some situations the place it’s possible you’ll have to bulk replace merchandise in your on-line retailer. Then, we’ll present you the way to do that, utilizing the native WooCommerce bulk modifying characteristic or a third-party instrument. Lastly, we’ll evaluation the highest plugins for bulk updating WooCommerce merchandise. This manner, you possibly can select the choice that most closely fits your wants.
When you’re new to managing a web-based retailer, you won’t know loads about product and stock administration. So, we’re going to begin by discussing some conditions when it’s possible you’ll have to bulk replace merchandise.
Regardless of the dimensions of your retailer, or the kind of merchandise you promote, studying the way to bulk edit WooCommerce merchandise can are available in very useful.
For instance, in case you have a clothes store, you would possibly resolve so as to add a sizing chart to all jackets or make your T-shirts obtainable in extra colours. In case you have numerous these things, bulk updating the sizes and colours can prevent quite a lot of time.
Even should you don’t see your self introducing product variations, you should still have to replace issues like inventory availability and costs. For example, you would possibly add 5 extra models of every mug, or supply a ten p.c low cost on all jewellery.
After all, bulk modifying doesn’t essentially imply updating your entire merchandise on the similar time. It may possibly additionally contain updating merchandise in a sure class solely.
Luckily, WooCommerce additionally enables you to edit merchandise by sort (like downloadable or grouped merchandise) and inventory standing.
Now, let’s go over how one can bulk replace merchandise in WooCommerce. There are 3 ways you are able to do this:
- Use the native WooCommerce bulk modifying options
- Export your merchandise and edit them in a spreadsheet
- Set up a WooCommerce bulk edit plugin (or Woo extension) to entry extra superior choices
Within the subsequent few sections, we’ll present you the way to perform all three strategies.
Technique 1: Use the native WooCommerce bulk modifying options
WooCommerce allows you to bulk edit your merchandise from the WordPress dashboard in only a few clicks. To get began, navigate to Merchandise → All Merchandise. Right here, you’ll see a listing of all objects in your retailer.
If you wish to bulk edit your entire merchandise, test the primary field on the left (slightly below Bulk actions). This may routinely choose all objects within the record.
When you solely need to replace specific objects, click on on the Choose a class menu and select the class you need to work on.
Alternatively, you possibly can filter objects by product sort. This characteristic might be very helpful should you solely need to edit specific varieties of objects, like downloadable supplies or product bundles.
You even have the choice to filter by inventory standing. This allows you to bulk edit objects which can be in inventory, out of inventory, or on backorder.
No matter you choose, simply be certain that to hit the Filter button afterwards. This may refresh the record to show solely the merchandise that fall into your chosen class, product sort, or standing.
Be aware that you need to use all three filters concurrently. For example, you would possibly choose grouped merchandise which can be additionally in inventory.
Now, make it possible for all objects are chosen by clicking on the primary field (as proven earlier). Then, from the Bulk actions menu, choose Edit.
Lastly, click on on the Apply button. This may show the entire sections that you could edit.
Product standing, class, tags
Now let’s go over the principle fields that you could replace in bulk.
Within the BULK EDIT subject, you’ll see all of the merchandise which have been chosen. If there are any objects that you simply need to exclude from these adjustments, merely click on on the X to take away them.
Wish to bulk edit product classes? You’ll additionally see a subject with a listing of all current classes in your retailer. If you wish to assign a brand new class to your merchandise, you possibly can go forward and test the corresponding field.
For example, in case your mugs are categorized beneath “kitchenware”, you may additionally need to add them to the “items” class. This manner, you possibly can place them as a vacation merchandise.
Underneath Feedback, you possibly can select whether or not to permit or disable feedback on these product pages.
You may additionally need to change the standing of those merchandise. Be aware that this refers back to the merchandise’s visibility standing, not availability. You’ll be able to set it to Publish, Personal, Pending Overview, or Draft.
When you don’t need to make any adjustments to those two fields, you possibly can merely depart them each as No Change.
The Product tags subject allows you to add extra taxonomies to your chosen merchandise. For instance, should you promote meals merchandise and also you’re bulk modifying objects within the “Dips & Sauces” class, you would possibly add tags like “natural”, “vegan”, or “gluten-free”.
You’ll be able to select from current tags (these will routinely come up as you might be typing within the subject), or add new ones. Simply bear in mind to separate new tags by commas.
Worth
By default, WooCommerce enables you to bulk edit essential product information like value, sale, weight, and extra.
On the subject of altering the worth, you have got three choices:
- Change to
- Improve current value by (mounted quantity or p.c)
- Lower current value by (mounted quantity or p.c)
If you wish to set the identical value for all merchandise, you’ll want to decide on the primary possibility and enter the worth.
Likewise, should you’re rising or reducing the worth, you’ll want so as to add a quantity within the subject supplied.
Sale choices
You may as well bulk edit the sale choices in your merchandise. These embody:
- Change to: This allows you to change the gross sales value to a specified quantity.
- Improve current sale value by (mounted quantity or %): You should use this feature to extend the present sale value by a hard and fast quantity or proportion.
- Lower current sale value by (mounted quantity or %): Much like the earlier possibility, you possibly can enter a quantity or a proportion to lower the present sale value.
- Set to common value decreased by (mounted quantity or %): With this feature, you possibly can override the present gross sales value with a brand new one, by lowering the common value of the merchandise with both a hard and fast quantity or proportion.
If you choose the final possibility and depart the worth subject clean or enter 0, you’ll take away the gross sales value from the merchandise.
As you possibly can see, these choices allow you to make adjustments to presents and reductions in your chosen merchandise.
Tax and transport
In case you have taxes enabled in your WooCommerce retailer, you’ll additionally have the ability to bulk edit this data.
You’ll be able to change the tax standing of your chosen merchandise to Taxable, Delivery solely, or None.
Alternatively, you would possibly want to alter the tax class of those merchandise. The choices within the dropdown menu embody Normal, Lowered price, Zero price, and any customized tax lessons that you simply arrange when creating your retailer.
Weight and dimension
The subsequent two fields can come in useful should you create merchandise which will change in weight or dimension. These might embody something from meals objects and physique care merchandise to wall photographs and furnishings items.
If you wish to change the load, merely choose the Change to possibility and enter the quantity.
Equally, if you wish to replace the width, peak, and size of the merchandise, click on on Change to and enter the brand new dimensions.
You’ll have to enter the numbers in centimeters (or the default models you’ve configured in your WordPress web site).
Delivery class
Moreover, you possibly can bulk replace the transport particulars of your merchandise. These choices embody No transport in addition to any transport lessons you created in your WooCommerce retailer.
For instance, should you created a transport class for framed wall posters and also you’re bulk modifying these things, you possibly can go forward and choose it.
Delivery lessons might be very helpful should you promote merchandise of various weights and sizes.
Visibility, availability, and inventory amount
The previous few fields primarily must do with visibility, availability, and inventory amount.
WooCommerce permits you to decide on the place you need your merchandise to seem. You may make them seen in each the catalog and search outcomes, or within the catalog or search outcomes solely. You even have the choice to cover the merchandise altogether.
Subsequent, you possibly can select whether or not so as to add these merchandise to your Featured part, and let guests know whether or not they’re in inventory, out of inventory, or obtainable on backorder.
Moreover, you would possibly allow the Handle inventory? possibility so that you could observe inventory for these merchandise.
Then, you possibly can bulk replace the inventory amount of those merchandise. If you wish to apply the identical quantity to all merchandise, choose Change to and enter the quantity.
You even have the choice to extend or lower current inventory by a selected quantity.
On the subject of backorders, you have got three choices:
- Don’t permit
- Enable however notify the shopper (the unavailable product is displayed as “Accessible on Backorder” to the shopper, and in the event that they place an order they’ll be notified of its standing)
- Enable (the out-of-stock product might be displayed as “In Inventory” to the shopper, so that they received’t comprehend it’s a backorder)
Lastly, you possibly can specify whether or not merchandise are bought individually. If you choose Sure, clients will solely have the ability to buy one unit of an merchandise in a single order.
This may be very helpful should you promote customizable objects or bespoke items that are available in restricted portions.
When you’ve accomplished all of those adjustments, go forward and click on on Replace. WooCommerce will now apply these settings to your entire chosen merchandise.
Technique 2: Bulk edit merchandise in a spreadsheet
One other approach to bulk replace merchandise in WooCommerce is to export them, edit the info in a spreadsheet (utilizing Google Sheets or Excel), and import the objects into your web site once more. This may occasionally sound a bit sophisticated, however you need to use a Woo extension like Import Export Suite for WooCommerce to simplify the method.
This instrument allows you to export and import WooCommerce information as XML or CSV information. You’ll have to buy it from the Woo market and add it to your WordPress web site.
Then, go to WooCommerce → Import Export Suite in your WordPress dashboard and ensure the Export tab is chosen. Within the dropdown menu, choose Product because the put up sort.
Then, click on on the Step 2: Choose an export technique button to proceed. Right here, you possibly can select between a fast or a sophisticated export. If you wish to replace sure merchandise or fields, you’ll want to pick Superior export.
Within the subsequent step, you possibly can filter the info you need to export. For instance, you would possibly need to solely export sure product sorts.
You even have the choice to exclude specific merchandise, export objects by class and standing, and extra.
While you’re prepared, proceed to step 4. This exhibits you which ones columns might be exported. You’ll be able to deselect sure fields and rearrange them as you want.
Within the closing step, you can provide your export file a reputation, select the file format, and configure just a few different choices.
When you’re finished, click on on the Export button. Then, when prompted, choose Obtain File.
Now, you possibly can open the file you’ve simply downloaded to make your bulk edits. When you’ve used spreadsheets earlier than, then it’s possible you’ll already know that you need to use the search and exchange characteristic to alter sure information.
As you would possibly discover, this technique works finest for numerical fields. For example, you need to use it to set the identical value for sure objects or replace the inventory quantity.
All you must do is enter the outdated worth within the Discover what subject, and set the brand new worth within the Substitute with subject. Then, click on on Substitute All to use the adjustments to the entire merchandise that comprise the required worth within the Discover what subject.
However you too can use it for text-based fields. For example, if you wish to make your entire merchandise taxable, you possibly can exchange the phrase “none” with “taxable”.
While you’re prepared, save your adjustments and shut the doc. Return to the WordPress dashboard. This time, navigate to the Import tab on the Import Export Suite web page.
As soon as once more, choose Product because the put up sort and proceed to the subsequent step. Right here, you possibly can select Fast import as your most well-liked technique. Because you’ll be utilizing the identical instrument for importing the product information, you don’t have to configure any superior settings.
Subsequent, add your file within the field supplied and transfer on to step three.
Now, you’ll have to configure some settings in your imported merchandise.
You’ll want to pick Import as new merchandise for If product ID conflicts with an current Submit ID. Likewise, you’ll need to select Replace for If product exists within the retailer.
When you’ve configured your settings, click on on Import/Schedule and choose Import. When the method is full, you’ll see a hit message.
Now, you possibly can view your merchandise to verify they’ve been up to date appropriately.
Technique 3: Set up a plugin for superior bulk modifying choices
In order for you extra flexibility when bulk modifying merchandise, you’ll want to put in a devoted instrument.
Bulk Desk Editor is a Woo extension that permits you to bulk edit product variations, replace information, and arrange gross sales for a number of objects directly. You may as well use it to auto-generate or modify SKUs in bulk.
Because the title suggests, this extension supplies a desk interface that can assist you make bulk edits extra effectively. You’ll get two completely different tables: one for costs, gross sales, and inventory, and one other one for SKUs, tags, statuses, measurements, and extra.
When you’ve bought and put in the extension, go to WooCommerce → Settings and click on on the Bulk Desk Editor tab on the far proper of your display.
Right here, you possibly can configure the majority desk editor. For example, you would possibly select which product class you need to show within the desk, order objects by title, date, and different information.
Then, go to Merchandise → Bulk Desk Editor. This may take you to the Editor Dwelling tab. Right here, you need to use the obtainable filters to show sure objects solely (e.g. by value vary or class).
Let’s say you need to enhance the inventory for all objects. Underneath the Inventory column, add the worth within the empty subject and use the dropdown menu to pick Improve. The corresponding fields will routinely replace for all merchandise.
You’ll be able to comply with the identical process for the worth. As you possibly can see, the extension additionally allows you to schedule a sale interval for all of your chosen merchandise.
When you click on on the Different Values tab, you’ll have the ability to bulk edit different values. For example, you possibly can change the inventory standing for all merchandise, configure the size, select a transport class, and extra.
Lastly, should you go to Linked Merchandise, you’ll have the ability to handle your upsells and cross-sells.
As you possibly can see, the Bulk Desk Editor offers you extra management over your bulk modifying. You’ll be able to view your entire chosen merchandise on one display, and see the updates in actual time.
There are a number of different Woo extensions and WordPress plugins that you need to use to bulk edit merchandise. Listed below are a few of the finest WooCommerce bulk product editor plugins available on the market.
1. Product Bulk Editor for WooCommerce
This extension allows you to make adjustments to replace fields for a number of merchandise on the similar time. These embody product descriptions, costs, variations, and extra. You may as well add customized fields to make bigger bulk edits.
Key options:
- Filters for weight, transport class, common value, and different attributes to seek out related objects extra simply
- The power to create and alter attributes like dimension and shade straight from the extension’s dashboard
- The choice to schedule sale costs and common product costs for a number of merchandise
Worth: Product Bulk Editor for WooCommerce prices $6.59 monthly, and is billed yearly at $79.00.
2. Bulk Edit Merchandise, Costs, and Attributes
This extension has a user-friendly interface that means that you can filter merchandise and make bulk edits. You’ll be able to choose objects to edit by weight, class, common value, and extra.
It additionally allows you to preview the chosen objects and their particulars earlier than continuing with the replace. Then, you possibly can merely use the dropdown menus for various values and attributes to use these adjustments.
Key options:
- In depth filtering situations
- The power to schedule jobs for bulk updates
- Choices to bulk delete merchandise
- Bulk variation creation
Worth: The extension prices $6.59 monthly or $79.00 per yr.
3. Cumbersome
This freemium WordPress plugin offers you superior filtering choices when bulk modifying merchandise. For example, you possibly can choose objects by value vary, amount, slugs, weight and dimensions, and plenty of different attributes.
It additionally allows you to filter the fields that you simply need to bulk edit. This manner, you don’t must navigate by irrelevant choices, and you’ll full your adjustments extra shortly.
Fields that may be bulk edited (moreover the default WooCommerce choices) embody attributes (like shade and sizes), buy notes, descriptions, and extra.
Key options:
- Toggles to decide on which fields to incorporate and exclude from the majority modifying course of
- The power to make use of the plugin’s search characteristic to simply discover the fields you need to edit
- Customized meta fields from third-party plugins (obtainable with professional model solely)
Worth: You should use the free model of Cumbersome or improve to the premium model, which prices $32 for a daily license.
4. PW WooCommerce Bulk Edit
One other free WordPress plugin, PW WooCommerce Bulk Edit presents a stay preview of your adjustments. This manner, you possibly can see your updates in actual time.
Moreover, you may make inline edits together with bulk edits. The plugin additionally allows you to make adjustments to product variations.
With the professional model of PW WooCommerce Bulk Edit, you’ll additionally have the ability to set or clear product photographs, create new product variations, and modify chosen attributes in bulk.
Key options:
- A search/exchange characteristic for textual content
- Wildcard searches that can assist you discover particular merchandise
- The power to undo all adjustments earlier than saving
Worth: You should use the plugin without cost. Paid plans begin at $59 per yr.
5. Bear
Bear is a free WordPress plugin that allows you to edit and delete merchandise in bulk, primarily based on chosen standards. You may as well make adjustments to product variations, replace attributes, and extra.
And with Bear, you’ll have a historical past of all bulk edits. Plus, you possibly can rollback the adjustments that you simply make.
Key options:
- Binded modifying, which allows you to set the identical worth for some merchandise (however not others)
- A value calculator for modifying decimal fields
- The power so as to add and bulk edit meta fields
Worth: You may get began with the free plugin, or replace to the premium model for $49.
Let’s take a look at a few of the most frequently requested questions surrounding bulk modifying in WooCommerce.
What’s one of the best ways to edit WooCommerce merchandise in bulk?
One of the simplest ways to bulk replace merchandise in WooCommerce is to make use of the plugin’s native options. By default, WooCommerce enables you to edit a number of merchandise directly.
All you must do is go to Merchandise → All Merchandise. Then, use the filters supplied to pick the objects you need to replace. Select Edit from the Bulk actions menu and click on on Apply.
Then, you’ll have the ability to change product information like common and sale costs, inventory availability, tax and transport lessons, and much more. When you save your edits, these adjustments might be utilized to all chosen merchandise.
How do you alter the worth of each WooCommerce product directly?
You’ll be able to change the worth of each WooCommerce product directly utilizing the plugin’s bulk modifying characteristic.
To get began, go to Merchandise → All Merchandise and test the primary field to pick the entire objects within the record. Then, from the Bulk actions menu, select Edit and hit Apply.
Now, scroll all the way down to the Product information part and search for the Worth subject. When you click on on the dropdown menu, you’ll see three choices.
If you wish to apply the identical value to your entire merchandise, choose Change to and enter the quantity. If you wish to enhance or lower the product costs of all objects by a specific amount or proportion, all it’s essential do is choose the corresponding possibility and enter a price.
How do you flip each product’s sale value on directly in WooCommerce?
WooCommerce allows you to run gross sales in your retailer, however you could be questioning the way to bulk edit sale costs for your entire merchandise.
You’ll want to pick the entire objects on the All Merchandise web page and select the Edit possibility from Bulk actions.
Then, search for the Sale subject beneath Product information. The dropdown menu offers you many choices.
If you wish to apply the identical sale value to your entire merchandise, choose Change to and enter the quantity. Alternatively, you possibly can cut back the present value of all merchandise by a hard and fast quantity or proportion, utilizing the Set to common value decreased by (mounted quantity or %) possibility.
Be aware that you could additionally enhance or lower the present sale value by choosing the corresponding possibility. And should you resolve to take away the sale value, merely select Set to common value decreased by (mounted quantity or %) and depart the worth subject clean (or sort in “0”).
How do you bulk add / import merchandise into WooCommerce?
By default, WooCommerce allows you to import and export merchandise in bulk.
While you select the export possibility, the plugin will create a downloadable CSV file that comprises a listing of merchandise with their corresponding particulars, together with product title, value, inventory, standing, and extra.
You will discover the Export possibility on the Merchandise web page.
When you obtain the file, you may make bulk edits within the spreadsheet, then return to this web page to import the up to date merchandise.
All it’s essential do is click on on the Import button and select your CSV file.
Then, be certain that the imported information columns match the present ones in WooCommerce, and run the importer.
You even have the choice to not import sure information fields. For example, you would possibly solely resolve to import the info that has been up to date.
If you wish to import and export extra WooCommerce information, you need to use a Woo extension like Import Export Suite for WooCommerce. This extension additionally enables you to export/import product opinions, coupons, and different particulars.
To be an environment friendly and profitable on-line retailer proprietor, you’ll seemingly need to make adjustments to a number of merchandise on the similar time. These might embody value updates, inventory availability, tax and transport particulars, and different essential data. With this in thoughts, studying the way to bulk edit WooCommerce merchandise might help you get extra out of every day.
By default, WooCommerce allows you to choose merchandise by class, sort, and inventory standing — and make adjustments to all of them directly. For example, it enables you to enhance or lower the worth, change the load and dimensions, replace the inventory amount, and extra. Alternatively, you possibly can export the product information as a CSV file, make bulk edits in a spreadsheet, after which import the up to date merchandise again into WooCommerce.
Plus, Woo extensions like Bulk Desk Editor and Bulk Edit Merchandise, Costs, and Attributes allow you to make extra superior adjustments in bulk. Discover extra Woo extensions at this time!
