(Untitled)
Keeping your product catalog up to date is an essential aspect of running a store. There are times when you'll have to make store-wide changes or update all products that fall into a particular class. As an example, you could need to change the size for all your shirts or increase the price of every mug. Applying these changes one product at a time can be laborious and lengthy.
The good news is that using a software program, you do not need to update each of your items. It allows you to update bulk your products, changing values like stock availability, inventory quantities prices, etc. Additionally, you can use Woo extensions or a Woo extension or bulk edit plugin to access additional advanced features for bulk editing.
In this article, we'll discuss some scenarios that require you to make bulk updates to products within your store online. Then, we'll show you the steps to accomplish this using the native bulk editing feature or using a third-party software. Then, we'll look at the top plugins to bulk update software. This way, you can choose the option that best fits your needs.
When you might need to bulk update products
It doesn't matter how big your business, or kind of merchandise you offer the ability to bulk edit products will be very useful.
In the case of, say, if you own a clothing store it is possible to attach a sizing chart to all jackets or offer T-shirts with additional colours. If you own a significant quantity of these products, mass updating sizes and colors will save you a lot of time.
Although you may not see yourself introducing product variations it is possible to update things like stock price and availability. You could, for instance, increase the number of units in each mug, or offer a ten percent discount for all your jewelry.
However, bulk editing doesn't necessarily require updating all your products at the same at the same time. It can also involve the updating of products within a specific category only.
In addition, you can edit products by the type (like downloads or group products) as well as stock status.
Three methods to update your product
We'll now look at the methods to bulk update the products you have in . There are three methods you can do this:
- Make use of the native bulk editing features
- Edit your exported products, then export the spreadsheet
In the coming sections, we'll show you how to implement all three methods.
Method 1: Use the bulk editing feature of your native system.
enables you to bulk edit your product's content through the WordPress dashboard in only a couple of steps. For a start, go to Products - All Products. Here, you'll see a list of all items you can purchase from your shop.
If you want to edit in bulk all your items, make sure you check the first box to the left (just beneath "Bulk Actions"). This will automatically select all items in the list.
If you are only looking to change specific items, click on the Choose a category menu, then select the category you want to work on.
Alternately, you can sort items by product type. This can be extremely useful if you only want edit certain types of products, such as downloadable materials or product bundles.
Additionally, you can choose to filter by stock status. This enables you to make bulk edits to items that are in stock or out of stock or backordered.
Whichever you decide to select, be sure to click the filter button following that. This will refresh the list so that it only shows the items that fall into your selected category, type of product, or status.
Note that you can use all three filters at once. For instance, you might pick grouped items which are available.
Make sure all items are selected by clicking on the first box (as shown earlier). Then, from the Bulk action menu, choose Edit.
Then, hit The Apply button. The application will then show all the sections that you can alter.
Status of the product, category, tags
We'll now look at the main fields that you could update on a regular basis.
In the BULK EDIT section, you'll find all the products that have been selected. If there are any items that you want to exclude from the changes, just select the X to eliminate them.
Want to bulk edit product categories? The field will also be filled which lists the categories that are currently available that you have in your store. If you want to assign a new category to your products, you can proceed to check the corresponding box.
You might also want to alter their status on these items. Note that this refers to the item's visibility status and not its availability. You can set it to Public, Private, Pending Review and Draft.
If you do not want to change anything in the two fields you can simply leave them both as None Change.
The tag field for the product field allows you to create additional taxonomies for your selected products. For instance for example, if you're selling foods and are bulk editing products in the "Dips & sauces" category, you could use tags such as "organic", "vegan", or "gluten-free".
You can choose from existing tags (these will appear automatically when you type in the field) you can add your own ones. Make sure you separate the each new tag with commas.
Price
In default, it allows you to make bulk edits to important data about the product like price, sale, weight and much more.
In the event of changing the price, you can choose from three options:
- Transition to
- Increase existing price by (fixed percentage or amount)
- Reduce the price of your current product by (fixed quantity or percentage)
If you'd like to have the same price for each product, then you'll need to choose the first option and enter the price.
Likewise, if you're altering or reducing the cost of the item, then you'll have to enter a number into the box given.
Sale options
You can also modify the sales options in bulk for your products. This includes:
- Change to: This enables you to change the sales price to a specified amount.
- Increase existing sale price by (fixed percentage or fixed amount): You can use this option to increase the current sale price by a fixed quantity or a percentage.
- Diminish the price of your current sale by (fixed percentage or amount): Similar to the earlier choice, you are able to enter a number or a percentage to decrease the current cost of sale.
- Set to regular price, but reduced by (fixed quantity or percentage) In this choice, you could override the existing sales price by introducing a new price, in which case you can reduce the cost for the item by an amount fixed or a percentage.
If you pick the last option and leave the value area blank, or simply enter 0, you'll remove the price of sales from the products.
As you can see, the options allow you to modify offers or discounts for your chosen items.
Shipping and tax
You can modify the tax classification of your selected products to tax-paying, Shipping only, as well as No tax status..
Alternately, you could need to change the tax category of these products. The options in the dropdown menu are Normal, Reduced rate, Zero rate, and any special tax classes that you create when you created your store.
Weight and size
The following two areas can be useful if you make products that alter in size or weight. This could include everything from food items and body care products as well as wall art and furniture items.
If you'd like to change the weight, simply select Change to option and then enter the weight. change tooption optionand input the weight.
Similar to that, if you wish to alter the dimensions of width, height, and length of the products then click Change to and enter the new dimensions.
Then, enter the number in centimeters (or the units that you've configured for your WordPress website).
Shipping Class
In this case, for instance, you've designed a shipping course for framed wall posters and are bulk editing the objects, choose it.
Shipping classes can be very helpful if your business sells products of varying weights and sizes.
Visibility, availability, and the amount of stock
The final few fields mostly concern visibility, availability and stock quantity.
enables you to choose where you want your products to appear. They can be displayed on both catalogs as well as search results. Or, you can make them appear within the catalog or search results only. There is also the option to hide these products completely.
Next, you can choose whether or not to add the products to your Featuredsection to let users know if they're available or out of stock or available on backorder.
In addition, you can activate the Manage stock? option so that it is possible to keep track of stock in these products.
After that, you'll be able to batch update the quantity of these products. If you wish to apply the exact number across all the products, choose "Change to" and input the number.
Also, you have the choice to either increase or reduce the stock you have in place by a specific number.
In the case of backorders there are three choices:
- Do not permit
- Allow however, inform the user(the unavailable product is listed as "Available On backorder" to the buyer when they make an order, they'll receive notification of the condition)
- Allow(the products that are out of stock will be displayed in the form of "In Stock" for the buyer, so they won't know that it's backordered)
Finally, you can decide if the items are offered in separate units. If you select Yes, customers will only be able to purchase one unit of an item in a single order.
After you've made all the changes above, you can go ahead by clicking update. These settings will be applied for your entire selection of products.
Method 2: Bulk modify products within an Excel spreadsheet
The tool lets you export and import data as XML or CSV files. You'll need to purchase it from the Woo marketplace and upload the file to your WordPress site.
Then, go to Then, import Export Suite in your WordPress dashboard and make sure you select the Export tab is chosen. The dropdown menu will let you select Product as the type of post.
After that, you can click the second step: choose an option to export step to continue. Here, you can choose either a simple or advanced export. If you're looking to change specific fields or products, you'll need to select advanced export.
The next step is to ensure that you will be able to filter the information you wish to export. For example, you might want to only export certain product types.
You also have the option to restrict certain items and export products by category and status, as well as many more.
If you're all set, move on to step 4. It will show you the columns that will be exported. You are able to select certain fields and rearrange them as you wish.
At the end of the process, you will need to give the export file a title, select the file format and set up a couple of alternatives.
After you're finished, click on the Export button. If you're prompted to choose the Download File option.
You can now access the spreadsheet you just downloaded to make your bulk changes. If you've used spreadsheets before, then you may already be aware of the feature search and replace to modify certain types of data.
You'll notice that this approach is most effective for fields that are numerical. In other words, you could use it to set the same price for certain products or to update the inventory number.
The only thing you must do is enter the old value in the Find what field, and set your new value in the Replace with field. Click on replace all for the change to all products with the value you entered within the Find What field.
You can use it for field types that are text-based. In the case of, say, if you wish to make all your products taxable by replacing the word "none" by "taxable".
When you're ready, save your changes and close the document. Go back to your WordPress dashboard. Next time, click the Import section on the Import Export Suite page.
Select Product as the post type and proceed to the next step. In this case, you have the option of selecting Quick import as the method you prefer. Because you'll use the same program to import the product data there is no need to configure any advanced settings.
Next, upload your document to the file box that is provided and move on to step three.
The next step is to configure some settings for your imported products.
You'll need to select Import as new item to determine If product ID conflicts in any way with an old Post ID. Also, it is recommended to select the option to update in the event products that are already available on the site.
After you've set your settings, go to Import/Schedule and select the import option. After the import is completed it will display a confirmation message.
You can now look over your products to make sure you've updated them correctly.
Method 3. Install a plugin to allow advanced bulk editing
If you want more flexibility in bulk editing your products then you'll have to use the right program.
Like the title suggests, this extension provides the table interface that can help users make large edits more efficiently. There are two tables: one for pricing, sales and stock, and another one for SKUs, tags measurement, statuses and measurements. and much more.
After having purchased and installed the extension, go to - Settings and then click the Bulk Table Editor tab at the bottom right side of the screen.
Here, you can configure this editor to be a bulk one. In this case, you could choose which product category you want to display in the table. Or, you can order items according to name, date as well as other details.
Go to Products Then, go to Products Bulk Table Editor. This will take you directly to the Editor Home tab. You can make use of the filters that are available to display specific items in a particular order (e.g. by price range or category).
It is possible to expand the stocks of all items. In the Stock column, add the amount in the empty field and use the dropdown menu option to choose an increase. The relevant fields will then automatically be updated for all items.
The similar procedure with regard to pricing. You can observe that this extension allows the user to set up a sales period for all your selected items.
When you select the Other Values tab on the left, you'll be able make bulk changes to other values. For instance, you can change the stock status for all products, configure the dimensions, choose an appropriate shipping method, and other things.
Finally, if you go to Linked Products, you'll be able manage your upsells and cross-sells.
As you can see, as you can see, the Bulk Table Editor provides you with the ability to control your bulk editing. You are able to see all your products that you've selected on a single screen and view the actual changes as they happen.
Five of the best the bulk editing of products
The extension allows you to make changes to update fields in multiple products simultaneously. They include descriptions of the product, prices, variations, and more. You can also add custom fields to make larger bulk edits.
Features that are important:
- Filters for the weight, shipping class, regular price, and other attributes to find pertinent items faster.
- The capability to define and modify attributes such as size and color right via the extension's dashboard
- Option to set up the sale price and regular price for multiple items
Pricing: Product Bulk Editor is priced at $6.59 per month, and will be charged annually at $79.00.
This extension offers a friendly interface, which lets you select products to filter and then make large edits. You can select items to edit by weight, class, normal price and more.
It also enables you to review the chosen items as well as their information prior to completing the update. You can then select dropdown menus to apply the various attributes and values to make these adjustments.
The most important features are:
- Filtering conditions that are extensive
- The ability to schedule jobs to update the entire batch
- Options to bulk delete products
- Creation of Bulk Variation
Cost:The extension costs $6.59 per month or $79.00 annually.
3. Bulky
This no-cost WordPress plugin provides the most advanced filters when editing your products. In particular, you could select items by price range or quantity, as well as slugs sizes and weights as well as other features.
Additionally, it lets you select the fields you'd like to make bulk edits on. This way, you don't have to navigate through irrelevant alternatives, and can complete your changes more quickly.
The fields that can be altered in bulk (besides the default options) include attributes (like color and sizes), purchase notes, descriptions and much more.
Features that are important:
- You can toggle the fields that you want to include or are excluded from the bulk editing process
- The ability to use the plugin's search feature to easily find the fields you wish to edit
- Custom meta fields made by plugins from third parties (available in the pro version only)
Cost:You can use the Bulky for free Bulky as well as upgrade to the premium version, which costs $32 for a standard license.
4. PW Bulk Edit
Another free WordPress plugin available for free, PW Bulk Edit offers a live preview of changes. So, you'll be able to see your updates live in real-time.
You can also perform inline editing as well as bulk editing. It also allows users to modify product variations.
With the pro version that comes with PW Bulk Edit, you'll also have the ability to change or clear product images as well as create a variety of new products or modify characteristics with a bulk.
Features that are important:
- The search and replace feature is available to search text
- Use wildcard search terms to help identify specific products
- The ability to undo all changes before saving
Cost: You can use the plug-in for no cost. Plans that are paid start at $59 for a year.
5. Bear
Bear is a cost-free WordPress plugin that lets you to edit and delete items in bulk according to a set of criteria. You can also make changes to the product's variations, add attributes, and many more.
In addition, with Bear the program, you'll get a history of all major changes. You can also rollback the modifications you've made.
Key features:
- Binded editing, which enables you to set the same value for some items (but not other products)
- Price calculator to edit decimal fields
- Ability to bulk edit and add meta fields
Pricing: You can get going with the plugin for free or upgrade to Premium version for $49.
Commonly requested questions
Let's take a look at some the most frequently addressed questions regarding the bulk editing process in .
What's the most efficient way to modify products at a large scale?
The most efficient way to mass edit products by using plugin's features native to it. It is the default setting that lets you edit multiple items at the same time.
All you have to do is go to Products All you have to do is go to Products All Products. Use the filters available to choose the items you want to change. Select Edit from the Bulk actions menu and then select apply.
You'll then be able edit the data of your products, such as regular and sale prices inventory availability, taxes and shipping classes, and a lot more. Once you save your edits the changes you make are applied to all of the products you've selected.
How do you change the price of every product all at once?
It is possible to alter the price of each product in one go by using the plugin's bulk editing feature.
To get started, go to Products and then All Productsand check the first box that allows you to choose each item on the listing. After that, in the Bulk actions menu, click Editand press the Apply button.
Scroll down the product data section, and then look for the price field. If you click on the dropdown menu, you'll see three options.
If you wish you to use the identical price for all your items choose change to and then enter the price. If you want to increase or decrease the prices of all items by a certain quantity or percentage, all you need to do is select the option that corresponds to your needs and input the amount.
How can you change every sales price for a product all at once ?
You can run sales in your store It is possible to run sales in your store, however you may be wondering how to modify the sale price in bulk for all of your products.
To do this, you must select every item from the All Products page and then choose Edit from the Editoption in the the Bulk actions.
Look for then the Look for the area under the Product information. The dropdown menu gives you several options.
If you wish to apply the same sale price to all of your products, click Change to and enter the amount. Alternately, you could reduce the current price of each product by a predetermined amount or percentage, selecting the option to set the price to the regular rate reduced by (fixed percentage or amount) option.
It is important to note that you are able to raise or lower the selling price using the appropriate option. If you choose to remove the sale price then simply click "Set to normal price" diminished by (fixed percentage or amount)and leave the value field unfilled (or type in "0").
How do you bulk upload / import products into ?
In default, you are able to import and export items in large quantities.
When you choose the export option, the plugin generates a downloadable CSV file that includes an inventory of the products along and their associated details including product title, prices, stock, status, and many more.
The export Option on the page for Products. page.
Once you download the file, you can modify the file in bulk on the spreadsheet. You can then go back here to upload new products.
All you have to do is click the Import button, and then choose the CSV file.
Make sure that you correspond to the columns in the data importer, then run it.
Also, you have the option not to import specific data fields. In this case, you could only decide to import the latest data.
The bulk update process is simple thanks to
In default, you are able to select products by category, type, and stock status -- and change each of them simultaneously. For instance, it allows you to increase or decrease the cost, modify dimensions and weights and update the quantity of stock, and more. You can also export the product data as CSV file. For instance, you can export the product data as a CSV file, make bulk changes in spreadsheets, and then import the updated items in .