How to quickly bulk update products in WooCommerce

Holding 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. As an example, you may need so as to add a brand new measurement to all your T-shirts or enhance the worth of all mugs. Making use of these adjustments one product at a time could be tedious and time-consuming.

The excellent news is that with WooCommerce, you don’t need to manually replace particular person merchandise. WooCommerce allows you to bulk replace your merchandise, altering values like availability, inventory portions, worth, and extra. Moreover, you should utilize a Woo extension or a WooCommerce bulk edit plugin to entry extra superior bulk enhancing options. 

On this submit, we’ll talk about some eventualities 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 enhancing characteristic or a third-party software. Lastly, we’ll overview the highest plugins for bulk updating WooCommerce merchandise. This manner, you’ll be able to select the choice that most closely fits your wants. 

If you happen to’re new to managing a web based retailer, you may not know lots about product and inventory management. So, we’re going to begin by discussing some conditions when it’s possible you’ll have to bulk replace merchandise.

Irrespective of the scale of your retailer, or the kind of merchandise you promote, studying methods to bulk edit WooCommerce merchandise can are available very useful.

For instance, when you’ve got a clothes store, you would possibly determine so as to add a sizing chart to all jackets or make your T-shirts out there in extra colours. If in case you have a lot of these things, bulk updating the sizes and colours can prevent loads of time. 

Even for those who don’t see your self introducing product variations, you should still have to replace issues like inventory availability and costs. As an example, you would possibly add 5 extra items of every mug, or supply a ten % low cost on all jewellery. 

In fact, bulk enhancing doesn’t essentially imply updating all your merchandise on the similar time. It may additionally contain updating merchandise in a sure class solely. 

Thankfully, WooCommerce additionally permits 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 enhancing 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 methods to perform all three strategies. 

Technique 1: Use the native WooCommerce bulk enhancing options

WooCommerce allows you to bulk edit your merchandise from the WordPress dashboard in just some clicks. To get began, navigate to Merchandise → All Merchandise. Right here, you’ll see a listing of all gadgets in your retailer.

If you wish to bulk edit all your merchandise, examine the primary field on the left (slightly below Bulk actions). It will mechanically choose all gadgets within the checklist.

If you happen to solely wish to replace specific gadgets, click on on the Choose a class menu and select the class you wish to work on.

Alternatively, you’ll be able to filter gadgets by product sort. This characteristic could be very helpful for those who solely wish to edit specific sorts of gadgets, like downloadable supplies or product bundles.

You even have the choice to filter by inventory standing. This allows you to bulk edit gadgets which can be in inventory, out of inventory, or on backorder.

No matter you choose, simply be sure to hit the Filter button afterwards. It will refresh the checklist to show solely the merchandise that fall into your chosen class, product sort, or standing. 

Notice that you should utilize all three filters concurrently. As an example, you would possibly choose grouped merchandise which can be additionally in inventory. 

Now, be sure that all gadgets 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. It will show the entire sections which you could edit.

Product standing, class, tags

Now let’s go over the primary fields which you could replace in bulk.

Within the BULK EDIT area, you’ll see all of the merchandise which were chosen. If there are any gadgets that you just wish to exclude from these adjustments, merely click on on the X to take away them.

Need to bulk edit product classes? You’ll additionally see a area with a listing of all current classes in your retailer. If you wish to assign a brand new class to your merchandise, you’ll be able to go forward and examine the corresponding field. 

As an example, in case your mugs are categorized below “kitchenware”, you may also wish to add them to the “presents” class. This manner, you’ll be able to position them as a holiday item.

Below Feedback, you’ll be able to select whether or not to permit or disable feedback on these product pages.

You may additionally wish to change the standing of those merchandise. Notice that this refers back to the merchandise’s visibility standing, not availability. You’ll be able to set it to Publish, Non-public, Pending Overview, or Draft.

If you happen to don’t wish to make any adjustments to those two fields, you’ll be able to merely depart them each as No Change.

The Product tags area allows you to add extra taxonomies to your chosen merchandise. For example, for those who promote meals merchandise and also you’re bulk enhancing gadgets 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 mechanically come up as you might be typing within the area), or add new ones. Simply keep in mind to separate new tags by commas.

Value

By default, WooCommerce permits you to bulk edit essential product information like worth, sale, weight, and extra.

With regards to altering the worth, you may have three choices:

1. Change to
2. Enhance current worth by (fastened quantity or %)
3. Lower current worth by (fastened quantity or %)

If you wish to set the identical worth for all merchandise, you’ll want to decide on the primary possibility and enter the worth.

Likewise, for those who’re growing or lowering the worth, you’ll want so as to add a quantity within the area offered.

Sale choices

You may also bulk edit the sale choices to your merchandise. These embrace:

• Change to: This allows you to change the gross sales worth to a specified quantity.
• Enhance current sale worth by (fastened quantity or %): You should utilize this selection to extend the present sale worth by a hard and fast quantity or proportion.
• Lower current sale worth by (fastened quantity or %): Much like the earlier possibility, you’ll be able to enter a quantity or a proportion to lower the present sale worth. 
• Set to common worth decreased by (fastened quantity or %): With this selection, you’ll be able to override the present gross sales worth with a brand new one, by decreasing the common worth of the merchandise with both a hard and fast quantity or proportion. 

If you choose the final possibility and depart the worth area clean or enter 0, you’ll take away the gross sales worth from the merchandise.

As you’ll be able to see, these choices allow you to make adjustments to presents and reductions in your chosen merchandise. 

Tax and delivery

If in case you have taxes enabled in your WooCommerce store, 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 vary the tax class of those merchandise. The choices within the dropdown menu embrace Normal, Decreased price, Zero price, and any customized tax lessons that you just arrange when creating your retailer. 

Weight and measurement

The following two fields can turn out to be useful for those who create merchandise that will change in weight or measurement. These might embrace something from meals gadgets and physique care merchandise to wall pictures 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 items you’ve configured in your WordPress web site). 

Delivery class

Moreover, you’ll be able to bulk replace the shipping details of your products. These choices embrace No delivery in addition to any delivery lessons you created in your WooCommerce retailer.

For example, for those who created a delivery class for framed wall posters and also you’re bulk enhancing these things, you’ll be able to go forward and choose it.

Delivery lessons could be very helpful for those who promote merchandise of various weights and sizes. 

Visibility, availability, and inventory amount

The previous couple of fields primarily need to do with visibility, availability, and inventory amount. 

WooCommerce allows you to decide on the place you need your merchandise to look. 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’ll be able to 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 out there on backorder.

Moreover, you would possibly allow the Handle inventory? possibility in an effort to observe inventory for these merchandise. 

Then, you’ll be able to 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. 

With regards to backorders, you may have three choices:

• Don’t enable
• Enable however notify the client (the unavailable product is displayed as “Obtainable on Backorder” to the client, and in the event that they place an order they’ll be notified of its standing)
• Enable (the out-of-stock product will probably be displayed as “In Inventory” to the client, in order that they gained’t understand it’s a backorder)

Lastly, you’ll be able to specify whether or not merchandise are offered 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 for those who sell customizable items or bespoke items that are available restricted portions. 

When you’ve accomplished all of those adjustments, go forward and click on on Replace. WooCommerce will now apply these settings to all your chosen merchandise. 

Technique 2: Bulk edit merchandise in a spreadsheet

One other method to bulk replace merchandise in WooCommerce is to export them, edit the info in a spreadsheet (utilizing Google Sheets or Excel), and import the gadgets into your web site once more. This may occasionally sound slightly sophisticated, however you should utilize a Woo extension like Import Export Suite for WooCommerce to simplify the method. 

This software 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 submit sort.

Then, click on on the Step 2: Choose an export methodology button to proceed. Right here, you’ll be able to select between a fast or a complicated export. If you wish to replace sure merchandise or fields, you’ll want to pick out Superior export.

Within the subsequent step, you’ll be able to filter the info you wish to export. For instance, you would possibly wish to solely export sure product varieties.

You even have the choice to exclude specific merchandise, export gadgets by class and standing, and extra.

Once you’re prepared, proceed to step 4. This reveals you which ones columns will probably 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 a number of different choices.

When you’re achieved, click on on the Export button. Then, when prompted, choose Obtain File.

Now, you’ll be able to open the file you’ve simply downloaded to make your bulk edits. If you happen to’ve used spreadsheets earlier than, then it’s possible you’ll already know that you should utilize the search and change characteristic to vary sure information.

As you would possibly discover, this methodology works finest for numerical fields. As an example, you should utilize it to set the identical worth for sure gadgets or replace the inventory quantity. 

All you must do is enter the outdated worth within the Discover what area, and set the brand new worth within the Substitute with area. Then, click on on Substitute All to use the adjustments to the entire merchandise that comprise the desired worth within the Discover what area. 

However you can too use it for text-based fields. As an example, if you wish to make all your merchandise taxable, you’ll be able to change the phrase “none” with “taxable”.

Once 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 submit sort and proceed to the following step. Right here, you’ll be able to select Fast import as your most well-liked methodology. Because you’ll be utilizing the identical software for importing the product information, you don’t have to configure any superior settings.

Subsequent, add your file within the field offered and transfer on to step three.

Now, you’ll have to configure some settings to your imported merchandise.

You’ll want to pick out Import as new merchandise for If product ID conflicts with an current Publish ID. Likewise, you’ll wish 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’ll be able to view your merchandise to verify they’ve been up to date appropriately. 

Technique 3: Set up a plugin for superior bulk enhancing choices

If you need extra flexibility when bulk enhancing merchandise, you’ll want to put in a devoted software.

Bulk Table Editor is a Woo extension that permits you to bulk edit product variations, replace information, and arrange gross sales for a number of gadgets directly. You may also use it to auto-generate or modify SKUs in bulk.

Because the title suggests, this extension offers 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’ll be able to configure the majority desk editor. As an example, you would possibly select which product class you wish to show within the desk, order gadgets by title, date, and different information.

Then, go to Merchandise → Bulk Desk Editor. It will take you to the Editor Dwelling tab. Right here, you should utilize the out there filters to show sure gadgets solely (e.g. by worth vary or class).

Let’s say you wish to enhance the inventory for all gadgets. Below the Inventory column, add the worth within the empty area and use the dropdown menu to pick out Enhance. The corresponding fields will mechanically replace for all merchandise.

You’ll be able to observe the identical process for the worth. As you’ll be able to see, the extension additionally allows you to schedule a sale interval for all of your chosen merchandise.

If you happen to click on on the Different Values tab, you’ll have the ability to bulk edit different values. As an example, you’ll be able to change the inventory standing for all merchandise, configure the size, select a delivery class, and extra.

Lastly, for those who go to Linked Merchandise, you’ll have the ability to handle your upsells and cross-sells. 

As you’ll be able to see, the Bulk Desk Editor provides you extra management over your bulk enhancing. You’ll be able to view all your 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 should utilize to bulk edit merchandise. Listed below are among the finest WooCommerce bulk product editor plugins in the marketplace. 

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 embrace product descriptions, costs, variations, and extra. You may also add customized fields to make bigger bulk edits.  

Key options:

• Filters for weight, delivery class, common worth, and different attributes to seek out related gadgets extra simply
• The power to create and alter attributes like measurement and colour straight from the extension’s dashboard
• The choice to schedule sale costs and common product costs for a number of merchandise

Value: Product Bulk Editor for WooCommerce prices $6.59 per thirty days, and is billed yearly at $79.00. 

2. Bulk Edit Products, Prices, and Attributes

This extension has a user-friendly interface that permits you to filter merchandise and make bulk edits. You’ll be able to choose gadgets to edit by weight, class, common worth, and extra. 

It additionally allows you to preview the chosen gadgets and their particulars earlier than continuing with the replace. Then, you’ll be able to merely use the dropdown menus for various values and attributes to use these adjustments. 

Key options:

• In depth filtering circumstances
• The power to schedule jobs for bulk updates
• Choices to bulk delete merchandise
• Bulk variation creation

Value: The extension prices $6.59 per thirty days or $79.00 per yr.

3. Bulky

This freemium WordPress plugin provides you superior filtering choices when bulk enhancing merchandise. As an example, you’ll be able to choose gadgets by worth vary, amount, slugs, weight and dimensions, and plenty of different attributes. 

It additionally allows you to filter the fields that you just wish to bulk edit. This manner, you don’t need to navigate via irrelevant choices, and you may full your adjustments extra rapidly. 

Fields that may be bulk edited (moreover the default WooCommerce choices) embrace attributes (like colour and sizes), buy notes, descriptions, and extra. 

Key options:

• Toggles to decide on which fields to incorporate and exclude from the majority enhancing course of
• The power to make use of the plugin’s search characteristic to simply discover the fields you wish to edit
• Customized meta fields from third-party plugins (out there with professional model solely)

Value: You should utilize the free model of Cumbersome or improve to the premium model, which costs $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’ll be able to see your updates in actual time. 

Moreover, you can also 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 photos, create new product variations, and modify chosen attributes in bulk.

Key options:

• A search/change characteristic for textual content
• Wildcard searches that can assist you discover particular merchandise
• The power to undo all adjustments earlier than saving

Value: You should utilize the plugin without cost. Paid plans begin at $59 per year. 

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 also make adjustments to product variations, replace attributes, and extra.

And with Bear, you’ll have a historical past of all bulk edits. Plus, you’ll be able to rollback the adjustments that you just make.

Key options:

• Binded enhancing, which allows you to set the identical worth for some merchandise (however not others)
• A worth calculator for enhancing decimal fields
• The power so as to add and bulk edit meta fields

Value: You will get began with the free plugin, or replace to the premium version for $49.

Let’s have a look at among the most frequently requested questions surrounding bulk enhancing in WooCommerce. 

What’s one of the simplest ways to edit WooCommerce merchandise in bulk?

One of the best ways to bulk replace merchandise in WooCommerce is to make use of the plugin’s native options. By default, WooCommerce permits you to edit a number of merchandise directly. 

All you must do is go to Merchandise → All Merchandise. Then, use the filters offered to pick out the gadgets you wish 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 delivery lessons, and much more. When you save your edits, these adjustments will probably 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 enhancing characteristic. 

To get began, go to Merchandise → All Merchandise and examine the primary field to pick out the entire gadgets within the checklist. Then, from the Bulk actions menu, select Edit and hit Apply.

Now, scroll right down to the Product information part and search for the Value area. If you happen to click on on the dropdown menu, you’ll see three choices.

If you wish to apply the identical worth to all your merchandise, choose Change to and enter the quantity. If you wish to enhance or lower the product costs of all gadgets by a certain quantity or proportion, all you should do is choose the corresponding possibility and enter a price. 

How do you flip each product’s sale worth on directly in WooCommerce?

WooCommerce allows you to run gross sales in your retailer, however you is perhaps questioning methods to bulk edit sale costs for all your merchandise. 

You’ll want to pick out the entire gadgets on the All Merchandise web page and select the Edit possibility from Bulk actions.

Then, search for the Sale area below Product information. The dropdown menu provides you many choices.

If you wish to apply the identical sale worth to all your merchandise, choose Change to and enter the quantity. Alternatively, you’ll be able to scale back the present worth of all merchandise by a hard and fast quantity or proportion, utilizing the Set to common worth decreased by (fastened quantity or %) possibility.

Notice which you could additionally enhance or lower the present sale worth by deciding on the corresponding possibility. And for those who determine to take away the sale worth, merely select Set to common worth decreased by (fastened quantity or %) and depart the worth area 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. 

Once you select the export possibility, the plugin will create a downloadable CSV file that accommodates a listing of merchandise with their corresponding particulars, together with product title, worth, inventory, standing, and extra.

Yow will discover the Export possibility on the Merchandise web page.

When you obtain the file, you can also make bulk edits within the spreadsheet, then return to this web page to import the up to date merchandise. 

All you should do is click on on the Import button and select your CSV file.

Then, be sure 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. As an example, you would possibly solely determine to import the info that has been up to date.

If you wish to import and export extra WooCommerce information, you should utilize a Woo extension like Import Export Suite for WooCommerce. This extension additionally permits you to export/import product critiques, coupons, and different particulars. 

To be an environment friendly and successful online store owner, you’ll seemingly wish to make adjustments to a number of merchandise on the similar time. These might embrace worth updates, inventory availability, tax and delivery particulars, and different essential data. With this in thoughts, studying methods to bulk edit WooCommerce merchandise can assist 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. As an example, it permits you to enhance or lower the worth, change the load and dimensions, replace the inventory amount, and extra. Alternatively, you’ll be able to 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 Table Editor and Bulk Edit Products, Prices, and Attributes allow you to make extra superior adjustments in bulk. Discover extra Woo extensions right now!