How to import products and prices to WooCommerce Wholesale Pro
WooCommerce Wholesale Pro works with any type of WooCommerce products, regardless of how they are added to your store. You can add your products manually (Products → Add New), edit them in bulk using a spreadsheet tool, or import them from a CSV or XML file. This article explains how to do this while setting product-specific pricing for each of your wholesale roles.
How to add or update products in WooCommerce
There are two main ways to bulk add or update products for use with WooCommerce Wholesale Pro. Choose the one that fits your workflow.
Option 1: Add and edit products with Setary (recommended)
Setary is the easiest way to add, edit, or update products for WooCommerce Wholesale Pro. It loads your WooCommerce store as a spreadsheet, so you can paste data straight from Excel or Google Sheets into your product catalog.
You can use Setary to:
- Create new products in bulk by typing or pasting into the spreadsheet.
- Edit prices, stock levels, descriptions, SKUs, categories, and product attributes across hundreds of products at once.
- Set product-specific or variation-specific wholesale prices for each wholesale role directly in the grid.
Setary detects the wholesale price columns added by WooCo
mmerce Wholesale Pro automatically, so there's no need to work out meta field names or format a CSV.
Option 2: Import products with a CSV import plugin
If you prefer to work from an existing CSV, Excel, or XML file, you can import products using a traditional import plugin instead.
Use the built-in WooCommerce importer, or a plugin such as Product CSV Import Suite. Before the import, prepare a spreadsheet, CSV file, or XML file with the data to be imported.
Adding wholesale prices
Once your products are in WooCommerce, you can add wholesale pricing in one of two ways.
Global or category pricing
The easiest option is to set the standard retail price for each product and use the global or category discounts in WooCommerce Wholesale Pro. Each wholesale user then sees a percentage discount based on their role.
The appropriate discount applies automatically when a wholesale user views the site. No per-product pricing is needed.
Product or variation-specific pricing with Setary
If you have enabled product-specific pricing for each wholesale role, Setary is the fastest way to add and edit those prices in bulk. Here's how to set it up.
- In WooCommerce → Settings → Wholesale → Wholesale roles, enable product-specific pricing for each wholesale role.
- Open the edit screen for any one product and manually set the wholesale prices for each role. This step is needed so that Setary can detect the wholesale price columns on your site.
- Go to the Setary app at https://setary.com/app/. Click the 'Columns' button at the top and search for 'WWP'. Enable the column for each of your wholesale roles. For example, if the role is called 'Gold', the column will be named 'Wwp gold'.
- Edit the wholesale price directly in each cell for your simple products and variations. To update many products at once, select multiple rows and use the bulk actions to change prices centrally.
Product or variation-specific pricing with a CSV import
You can also import wholesale prices through a CSV file, but this is more technical. You need to know the exact meta key that WooCommerce Wholesale Pro uses to store the price for each role.
The prices are attached to either the simple product or the individual variation (not the containing variable product) as meta data.
WooCommerce Wholesale Pro comes with a default wholesale role called wcwp_wholesale. For any additional roles you create, the meta key is generated from the role name as follows:
- All keys have the prefix
wcwp_. - The role name from the 'Add role' screen is used.
- All characters are lowercased, even if you used capital letters in the role name.
- Any spaces are replaced with dashes.
- Accent characters are converted to ASCII.
- If you rename a role later, the original meta key is kept. Renaming a role does not change the meta key.
For example, if the role name is 'Silver Wholesalers', the meta key is wcwp_silver_wholesalers. Import the wholesale price to this field.
Will my wholesale store display imported products?
The plugin will display your products correctly whether you add them through the WordPress admin, edit them in Setary, or import them from a CSV file. If your products appear in the 'Products' section of the WordPress admin, you can include them in your wholesale store.