3 Ways To Bulk Price Change Your Products In WooCommerce

3 Ways To Bulk Price Change Your Products In WooCommerce

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:

An example of a variable product in WooCommerce.
(click to zoom)

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:

(click to zoom)

If you select the Add variation dropdown menu, you’ll see all the WooCommerce bulk edit options available to you:

WooCommerce bulk edit
(click to zoom)

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:

(click to zoom)

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:

Selecting what product data to export.
(click to zoom)

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:

A WooCommerce spreadsheet.
(click to zoom)

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.

Using a CSV file to add wholesale prices
(click to zoom)

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:

Importing a CSV file.
(click to zoom)

Before the import begins, WooCommerce will ask you to doublecheck if each column name maps to a corresponding product data field in your database:

(click to zoom)

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:

A successful WooCommerce data import.
(click to zoom)

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:

Enabling product quantity wholesale discounts.
(click to zoom)

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:

The quantity-based discount rule in a CSV file.
(click to zoom)

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:

  1. Set wholesale prices for multiple product variations.
  2. Bulk import wholesale prices via CSV.
  3. 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!

Share on facebook
Facebook
Share on twitter
Twitter
Share on linkedin
LinkedIn
Share on email
Email

Leave a Reply

Your email address will not be published. Required fields are marked *

[FREE GUIDE]
[FREE GUIDE]
[FREE GUIDE]
[FREE GUIDE]