How to add and edit wholesale prices in bulk
WooCommerce Wholesale Pro lets you set wholesale prices automatically by applying a percentage discount for each wholesale role; or you can manually set wholesale prices for each product or variation.
Bulk-update wholesale prices across multiple products
If you're setting wholesale prices manually, then you might like an easy way to add and update the prices in bulk. We recommend Setary for this, which works perfectly with WooCommerce Wholesale Pro.
Setary is a bulk product editor, in which you apply changes quickly and easily using a spreadsheet-style interface. Each product and variation appears on its own row in the spreadsheet, so you can quickly make changes without having to visit multiple pages.
This is how to use Setary to bulk edit wholesale prices:
- In the WordPress admin for your store, go to WooCommerce → Settings → Wholesale → Roles and make sure product-specific pricing is enabled for your wholesale roles.
- Next, log into Setary and use the 'Columns' option to display columns for your wholesale roles. For example, in the screenshot below, you can see that we have enabled columns for the 'Wcwp Trade' and 'Wcwp Wholesale' roles, which were created using WooCommerce Wholesale Pro.
- In the spreadsheet editor, use these columns to bulk add and edit the wholesale prices for each product and variation.
Bulk-update wholesale variation prices
If you only need to update the wholesale prices for variations on a specific product, then you can do this using WooCommerce's bulk variation editor:
- Go to the 'Edit Product' screen for the relevant product.
- Open the 'Variations' tab in the Product Data section.
- Select the variations that you wish to bulk-edit the prices for. (Tip: Install our WooCommerce Bulk Variations plugin for an easy way to select variations based on specific data such as their attribute values. It adds filters to the Variations tab which you can use to filter the list before applying bulk actions.)
- Open the 'Bulk actions' dropdown and select 'Set wholesale prices'.
- In the next window, change the price as needed.