How to import products and prices to WooCommerce Wholesale Pro
WooCommerce Wholesale Pro works with any type of WooCommerce products. You can add your products manually (Products → Add New) or by importing them into the appropriate tables on the MySQL database for your WordPress site.
How to import products to WooCommerce
You can bulk import products to WooCommerce using the built-in WooCommerce importer, or any import plugin such as Product CSV Import Suite.
Before the import, you will need to prepare an Excel spreadsheet, CSV file, XML file or similar with the data to be imported.
Please note that product imports can be very complex and you will need to use the documentation for your import plugin to get the format of the spreadsheet exactly right. You may need an experienced developer to help you with this.
Importing wholesale prices
Consider how you will be adding the wholesale prices:
Global or category pricing
The easiest option is to add the standard price for each product to the main price field, and import the products without a wholesale price. You can then use the global or category discounts in WooCommerce Wholesale Pro to give a percentage discount to each wholesale user based on their role.
The appropriate % discount will automatically be deducted from the price for each product when a wholesale user views the site.
Product or variation-specific pricing
If you have enabled product-specific pricing for each wholesale role, then you can import an exact wholesale price for each product. To do this, you need to work out the correct name for the meta field which WooCommerce Wholesale Pro uses to store the product-specific pricing for each wholesale role. The following information will help you to do this.
The prices are attached to either the simple product or individual variation product (not the containing variable product) meta data.
The key for the price meta data depends on the name that you gave to the wholesale role when you created it using WooCommerce Wholesale Pro.
WooCommerce Wholesale Pro comes with a default wholesale role which is created automatically when you first install the plugin. This will always be called
If you have created additional wholesale roles then the key is created based on the name that you gave to the role as follows:
- All keys have a prefix of:
- The role name given in the Wholesale Pro 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.
- Any accent characters will be converted to ASCII characters for the role name.
- If you change the name of the role, then key of the original role name given is retained. The actual meta key which is used to store data about the wholesale role does NOT change if you rename the role in future.
For example, if the role name is 'Silver Wholesalers' then the meta key will be
wcwp_silver_wholesalers, so you need to import the wholesale price to this field.
Tip: If you're only importing products in order to set prices, then it might be easier to use a tool called Setary to add/edit the wholesale prices for your existing products in bulk.
Will my wholesale store display imported products?
The plugin will display your products correctly whether you add them directly to the WordPress admin, or if you import them from CSV, Excel or similar. If your products are listed in the 'Products' section of the WordPress admin, then you can include them in your wholesale store.