Mastering Bulk Price Editing in WooCommerce (2 easy ways)
In the dynamic world of eCommerce, managing prices efficiently is crucial for maintaining competitiveness and profitability. Bulk price updates refer to the process of adjusting prices for multiple products simultaneously, rather than individually. This capability is especially valuable for store managers who need to make widespread pricing changes due to market trends, seasonal sales, or inventory adjustments.
Bulk editing, including bulk price updates, is a powerful tool that saves time and reduces the likelihood of errors. Instead of manually updating each product one by one, store managers can apply changes across numerous products in a single operation. This efficiency not only streamlines operations but also ensures that pricing strategies can be implemented quickly and accurately, helping to keep your WooCommerce store agile and responsive to market demands.
How to Bulk Edit Prices in WooCommerce
Bulk editing prices in WooCommerce is an efficient way to manage and update your product pricing. This feature can save you a lot of time, especially if you have a large inventory. Below, we outline the step-by-step process to perform bulk price edits in WooCommerce:
Method 1: Bulk Price Update with Default WooCommerce Bulk Editor
The first method for performing bulk price updates involves using the default WooCommerce functionalities. Follow these steps to update prices efficiently:
1. Navigate to All Products in WooCommerce
Go to your WooCommerce dashboard and select Products and then All Products to display a list of all your products.
2. Filter Products For Bulk Price Editing
Use the toolbar to filter your WooCommerce products based on specific criteria:
- Select Category: Choose the desired product category to filter WooCommerce products by category.
- Filter by Product Type: Select the type of product you want to filter.
- Filter by Stock Status: Choose the stock status to filter products accordingly.
After selecting your options, click on the Filter button to display the filtered list of products.
3. Initiate Bulk Action for Editing
Choose the products you want to bulk edit by selecting the checkboxes next to each product. Then, click on the Bulk Actions dropdown, select the Edit option, and then click the Apply button.
4. Adjust Prices in the Bulk Edit Form
In the opened bulk edit form, you will find 2 fields for adjusting regular prices and sale prices of selected products.
Regular Price Bulk Edit Options
- Change to: Set a new fixed price for selected products.
- Increase existing price by (fixed amount or %): Increase the current price of selected products by a specific amount or percentage.
- Decrease existing price by (fixed amount or %): Decrease the current price of selected products by a specific amount or percentage.
Sale Price Bulk Edit Options
- Change to: Set a new fixed sale price for selected products.
- Increase existing sale price by (fixed amount or %): Increase the current sale price of selected products by a specific amount or percentage.
- Decrease existing sale price by (fixed amount or %): Decrease the current sale price of selected products by a specific amount or percentage.
- Set to regular price decreased by (fixed amount or %): Set the sale price to be the regular price and decrease a specific amount or percentage based on the regular price.
5. Apply Bulk Price Changes
Once you have made the necessary adjustments, click Update to apply the bulk price changes to the selected products.
For example, we want to change the price of the selected products in the image above to $50. First, select those products and initiate bulk editing. Set the price operator to Change to and enter $50.
The output will be displayed as shown below:
Method 2: Using Third-Party Plugins For Bulk Editing WooCommerce Product Prices
Another effective method for bulk price updates in WooCommerce is by using third-party plugins. These plugins provide advanced features that streamline the process, allowing you to display your products in a table format and make bulk edits efficiently.
One such plugin is WooCommerce products bulk edit by iThemeland. This plugin enables you to view and edit multiple products simultaneously, supporting various product fields such as prices, titles, descriptions, feature images, stock status, and more.
How to Perform Bulk Price Edits Using WooCommerce Products Bulk Edit Plugin
The WooCommerce products bulk edit plugin is a powerful tool designed to help store managers efficiently manage and update their products, including both simple and variable products. With support for over 50 fields and a robust filter form, this plugin simplifies the process of bulk editing without errors, saving you valuable time.
To bulk edit prices by using the WooCommerce products bulk edit plugin, follow the steps below:
1. Install the Plugin and Access the Plugin
After purchasing the plugin, proceed with the installation and activation process. You can purchase the plugin from the official website or use the free version with limited features.
After installing and activating the plugin, in your WordPress dashboard, navigate to the iT Bulk Editing -> Woo Products to access plugin's main page.
2. Filter Desired Products for Bulk Edit Prices
In the plugin toolbar, click on the Filter tool to access the powerful filter form. Here, you can filter products by various criteria for detailed selection. This filter form includes several tabs such as filter by category, tag, taxonomy, attribute, price, and product type.
Each tab allows you to precisely filter the products you want to bulk edit, ensuring that the bulk edit operations are applied accurately to the selected products.
After setting the filter form fields, click on the Get Products button to display the filtered products.
3. Bulk Edit Products Prices in WooCommrce Products Bulk Edit Plugin
For bulk edit product prices, you first need to choose the products you want to bulk edit from the displayed list. Then, click on the Bulk Edit tool in the toolbar to open the Bulk Edit form.
In the Bulk Edit form, go to the Pricing tab where you can find several options to bulk edit prices:
Bulk Edit Regular Price
- Clear Value: Remove the current regular price from selected products.
- Formula: This operator enables you to modify the current value using a formula. In these formulas, the current value is denoted by X.
For example, (((X+10)*10)/100) means that the current value is increased by 10 and then 10% of the new value is calculated.
- Increase/decrease by value: Add/subtract a fixed amount to/from the current regular price of selected products.
- Increase/decrease by %: Increase/decrease the current regular price of selected products by a percentage.
- Increase by value (From sale): Increase the regular price of selected products by a fixed amount based on the sale price.
- Increase by % (From sale): Increase the regular price of selected products by a percentage based on the sale price.
Bulk Edit Product Sale Price
The operators available for this option are quite similar to those for the Regular Price field, except for the last two options, which we will examine below:
- Decrease by value (From Regular): This operator allows you to decrease the current sale price by a specific value based on the regular price. For example, if the regular price is $100 and you set this operator to decrease by $10, the new price will be $90.
- Decrease by % (From Regular): This operator allows you to decrease the current sale price by a certain percentage based on the regular price. For instance, if the regular price is $100 and you set this operator to decrease by 15%, the new price will be $85.
After you have set all the necessary adjustments for bulk editing the products, click on the Do Bulk Edit button to apply your changes.
For example, we intend to increase the regular price of all selected products shown in the image above by 10%.
The output will be displayed as shown below:
Other Features of WooCommerce Products Bulk Edit Plugin
This plugin boasts numerous features that enhance the overall functionality and user experience. Below, we highlight two of its most important features.
Bulk Edit Variable Products Prices and Other Fields
One notable feature of the WooCommerce products bulk edit plugin is its ability to bulk edit variable products, a functionality not available in default WooCommerce. To display variable products in the filter form:
- Go to the Type tab.
- Select Variable Products and click on the Get Products button.
- Click on Show Variations in the toolbar. This action shows all variations of variable products in the table.
- Finally, you must select the product variations that you want to edit in bulk and perform the bulk edit steps as described for the simple products.
Inline Editing Product Prices and Other Fields
Another valuable feature of this plugin is the inline editing capability, allowing you to edit directly from the product table without opening each product individually. For inline editing, simply click on the price field and make your changes inline by using the designed price calculator form.
This feature ensures you can efficiently manage and update product prices without navigating away from the main product list.
When Do We Use Bulk Price Editing?
Bulk editing prices in WooCommerce is particularly useful when you need to make widespread pricing changes across multiple products quickly and efficiently. This feature is ideal for managing sales, adjusting for cost changes, or updating pricing strategies. Below, we will examine some of the most important times for using bulk edit prices.
Seasonal Sales and Promotions
During special sales events like Black Friday, Cyber Monday, or holiday promotions, adjusting prices for a large number of products is necessary. Bulk edit price allows you to efficiently implement these changes across your entire product range.
Inventory Clearance
When you need to clear out old inventory to make room for new stock, reducing prices on multiple items quickly is essential. Bulk editing helps you adjust prices in bulk, making the process faster and less labor-intensive.
Market Price Adjustments
In response to market fluctuations, such as changes in supplier costs or competitive pricing, you may need to update prices on a variety of products. Bulk edit price enables you to stay competitive without manually changing each product's price.
Product Updates or Lunch
You may need to adjust prices across related items when introducing new product lines or updating existing ones with new features or improvements. Bulk editing helps manage these updates swiftly without individual product adjustments.
Importance of Using Bulk Edit Prices for Online Stores
- Time-Saving: One of the biggest advantages of using Bulk Edit Price is the significant time savings. Instead of editing the price of each product individually, you can easily and simultaneously change the prices of multiple products. This capability is particularly useful for large stores with numerous products.
- Error Reduction: When dealing with a large number of products, the likelihood of errors during manual price editing increases. By using bulk edit price, these errors are minimized as changes are applied automatically and uniformly.
- Better Management of Sales and Discounts: With this capability, you can easily and quickly apply new discounts or change product prices during specific sales seasons. This allows you to respond to market changes promptly and accurately.
- Greater Flexibility: Bulk Edit Price offers extensive options for various pricing adjustments. You can change prices based on formulas, percentages, or fixed amounts. This flexibility helps you implement your pricing strategies effectively.
- Increased Efficiency: Using this tool, the store management team can focus on more important activities like marketing and improving customer experience, rather than spending time on repetitive and time-consuming tasks. This overall improves the efficiency and productivity of the store.
Conclusion
In this guide, we explored two methods for bulk editing prices in WooCommerce. The first method involved using WooCommerce's default tools, which offer limited functionality and do not support bulk editing of variation products. While this method is straightforward, it may not meet the needs of store managers with more complex pricing requirements.
The second method utilized a third-party plugin, WooCommerce products bulk edit, which provides a wealth of features and greater flexibility. This plugin allows for comprehensive bulk editing, including the prices of variation products, and offers advanced filtering options and inline editing capabilities. By using this plugin, store managers can efficiently manage their product prices, saving time and reducing the risk of errors.