Some of the most frequently asked questions about bulk editing in WooCommerce

We often encounter some of the most common problems when we use WooCommerce batch editing, let's take a look below.

What is the best way to batch edit a WooCommerce product?

The best way to batch update products in WooCommerce is to use the native features of the plugin. By default, WooCommerce allows editing multiple products at the same time.

Simply go to "offerings" → "All Products". Then, use the filters provided to select the items to be updated. From the Batch Operations menu, select "compiler", and then click "appliance".

It is then possible to change product data such as regular and sale prices, stock availability, taxes and shipping categories. After saving the edits, the changes will be applied to all selected products.

How do I change the price of each WooCommerce product immediately?

The price of each WooCommerce product can be changed immediately using the plugin's bulk editing feature. First, go toProducts → All Products, then check the first box to select all items in the list. Then, select all the items in the list from thebatch operationmenucompilerand clickApplications.

Now, scroll down to the"Product data"Part and find"Price."Fields. If you click on the drop-down menu, you will see three options.

To use the same price for all products, please select "change into " and enter the amount. To raise or lower the price of all products by a certain amount or percentage, simply select the appropriate option and enter the value.

How to open the sales price of each product at the same time in WooCommerce?

WooCommerce can sell in stores, but may be wondering how to bulk edit the sales price of all products.

Required in "All Products " page to select all items, and then from the "batch operation " in the selection "compiler "Options.

Then, in "Product Data"look up"Selling."Fields. The drop-down menu provides several options.

To apply the same promotional price to all products, select thechange toand enter the amount. Alternatively, you can use theSet to regular price reduction (fixed amount or percentage)option to reduce the current price of all products by a fixed amount or percentage.

Note that it is also possible to increase or decrease the existing sale price by selecting the appropriate option. If you decide to remove the sale price, simply selectSet to normal price reduction (fixed amount or percentage)and leave the value field blank (or enter "0").

How to bulk upload/import products to WooCommerce?

By default, WooCommerce can import and export products in bulk. 

When the export option is selected, the plugin creates a downloadable CSV file containing a list of products and their corresponding details including product title, price, stock, status, etc.

This can be done in theFind it on the "Products" page."Export"Options.

Once you have downloaded the file, you can make batch edits in the spreadsheet and then return to this page to import the updated products. 

All you have to do is click"Import"button and select your CSV file.

Then, make sure that the imported data columns match the existing data columns in WooCommerce and run the import program.

You can also choose not to import certain data fields. For example, you may decide to import only updated data.

If you want to import and export other WooCommerce data, you can use the Woo extension, for exampleImport Export Suite for WooCommerce. This extension can also export/import product reviews, coupons and other details. 

Contact Us
Can't read the tutorial? Contact us for a free answer! Free help for personal, small business sites!	Customer Service
① Tel: 020-2206-9892
② QQ咨询：1025174874
(iii) E-mail: [email protected]
④ Working hours: Monday to Friday, 9:30-18:30, holidays off