The more products your WooCommerce wholesale store offers, the more time-consuming it becomes to set bulk prices for each of them. Although modifying a product’s wholesale price is easy, all those dozens and hundreds of little changes add up quickly.
If you want to save time, learning how to execute a WooCommerce bulk price change is one of the best ways to do it. By using WooCommerce bulk edit options, you’ll be able to change wholesale prices for dozens of products at once.
In this article, we’re going to go over three ways that you can bulk price change your products in WooCommerce using the Wholesale Suite. Let’s get to it!
1. Set Wholesale Prices for Multiple Product Variations
As you may know, WooCommerce enables you to set different product types depending on what item you’re selling. For physical items, you have regular and variable products.
If, for example, you sell one type of shirt that comes in different colors and sizes, that’s what we’d call a variable product:
Although variable products are incredibly common in online stores, they represent a challenge when it comes to wholesale pricing.
That challenge is that by default, you need to set regular and wholesale prices for each product variation. If you have multiple items in your store with unique variations, that quickly adds up to a lot of work.
Using the Wholesale Suite, you can skip a big part of that process. For example, here we have the Product Data > Variations settings for a t-shirt with two product variations:
If you select the Add variation dropdown menu, you’ll see all the WooCommerce bulk edit options available to you:
From this menu, you can modify the “In stock” status of all your product variations, set sale dates, and modify their wholesale price. To do that, click on the Set wholesale prices option at the bottom of the list.
Once you do that, a pop-up menu will appear prompting you to set the price that you want to use across all variations.
Keep in mind that you might see multiple entries that all read Set wholesale prices, but for different types of wholesale user roles.
If you’re using the free version of WooCommerce Wholesale Prices, then you only have access to the default Wholesale Customer user role. With the wholesale suite, you can add as many custom wholesale roles as you want, though, and you’ll be able to set individual bulk prices for each of them.
2. Bulk Import Wholesale Prices Via CSV
WooCommerce enables you to import and export product information using Comma-Separated Values (CSV) files. Those are the kinds of files that you can edit using spreadsheet software and this method provides one of the fastest ways for WooCommerce bulk edits.
To get started, you’ll need to export a CSV file that contains your entire WooCommerce inventory. Go to Products > All Products on your dashboard and select the Export option at the top of the screen:
Now WooCommerce will ask you what product data you want it to export. Leave the default options as they are and tick the Export custom meta? setting:
Once you click on Generate CSV, it should only take a few seconds until a download starts (depending on how large your inventory is).
Open the resulting .csv file using your favorite spreadsheet software and you’ll see something like this:
Scroll to the right until you find the column that says Meta:wholesale_customer_wholesale_price. That column includes the wholesale prices for the Wholesale Customer user role.
All you have to do now is type the price that you want within each product’s row. Overall, it’s a much faster process than editing each price by hand within WooCommerce.
Keep in mind that if you have multiple wholesale customer user roles, you’ll see multiple columns similar to the one above. Each column contains prices for a different role, so make you double-check which values you’re editing before you move on.
Once you’re done, save the changes to your .csv file, and let’s import it into WordPress. Return to the Products > All Products tab and this time, click on the Import button.
WooCommerce will ask you what file you want to upload and whether it should override existing product information within your database. Say yes to the latter and select your .csv file:
Before the import begins, WooCommerce will ask you to doublecheck if each column name maps to a corresponding product data field in your database:
Unless you modified the name of the columns within the inventory .csv file, all of the values should match. In any case, it never hurts to confirm every field before you move on to the next step.
Once you run the importer, WooCommerce will let you know how many products it updated with the data that you set:
If you check any of your products now, you’ll see their updated wholesale prices.
3. Import Quantity-Based Wholesale Prices to Individual Products
This final method works very similarly to the last approach we discussed. The difference, in this case, is that you’re going to be editing wholesale discounts based on how many items users purchase.
First off, you need to enable Product Quantity Based Wholesale Pricing for at least one product in your inventory. You can do this by editing a product and going into its Product Data > Inventory settings:
In that example, we configured a 20% discount for wholesale customers that buy between 11-20 of that item. Go ahead and add any rule that you want and then save the changes to that product.
Once the changes are in, export your WooCommerce inventory data in a .csv file, following the same steps as in the last method. Open that .csv file and this time, look for the column that says Meta: wwpp_post_meta_quantity_discount_rule_mapping:
In case you can’t read what that row says, here’s the full quantity-based rule in CSV format:
[{“wholesale_role”:”wholesale_customer”,”start_qty”:”11″,”end_qty”:”20″,”price_type”:”percent-price”,”wholesale_price”:”20″}]
That’s the format that you need to use for any quantity-based discount rules that you want to add to other products. First off, you specify the wholesale user role it applies to, next you set the quantities, and finally, you get to the discount.
For example, if we wanted to add a second rule that applied to purchases above 20 items, here’s what it might look like:
[{“wholesale_role”:”wholesale_customer”,”start_qty”:”21″,”end_qty”:”30″,”price_type”:”percent-price”,”wholesale_price”:”40″}]
Note that a single product cell can contain multiple rules as long as they don’t ‘overlap’, so to speak. Now, go ahead and add the rest of the quantity-based discounts that you want to other products using that same format.
Once you’re done, save the changes to the .csv file and go ahead and import it into WooCommerce (as we did during the previous method). The plugin will update prices for all the products that you modified and you’ll be good to go.
Conclusion
Being able to execute WooCommerce bulk price changes is key if you want to run a successful wholesale business. After all, you’ll probably need to update your inventory often and you’ll need to do so for multiple levels of wholesale buyers.
Using the Wholesale Suite, you have access to three methods to do WooCommerce bulk edits for wholesale prices, which include:
- Set wholesale prices for multiple product variations.
- Bulk import wholesale prices via CSV.
- Import quantity-based wholesale pricing to individual products.
Do you have any questions about how run WooCommerce bulk price changes for wholesale products? Let’s talk about them in the comments section below!
Thank you for this article. I have been able to used the second option to bulk set sale price
Awesome Samuka! Glad it was helpful :)