Author 诗语

How To Import Wholesale Prices And Other Wholesale Data Into Your WooCommerce Store

Whether you』re moving your products to another site or just want to bulk edit the wholesale prices, it』s important to know the correct way of importing wholesale data with your products in the CSV file.
You have multiple options for importing as there are many tools on the market for it.
In this article, we will cover two ways:

Importing using the built-in WooCommerce CSV import/export tool
Importing using the popular WP All Import plugin

Importing using built-in WooCommerce Product import/export tool
In WooCommerce version v3.1, they introduced the Product Import/Export tool, which you can use to download and upload your product CSV file with wholesale data.
We recommend doing the following steps:
1. Create one or two products and set the Regular Price and Wholesale Price. If you』re using WooCommerce Wholesale Prices Premium, you can apply more features such as Minimum Order Quantity, Minimum Order Step and etc. Doing this will generate the custom meta fields when you export the Product CSV.

Apply Wholesale Prices on Product Settings (Click to Zoom)

2. Afterwards, go to Products > All Products, at the top part, click the Export button. Make sure to check the Export Custom Meta before clicking Generate CSV.

WooCommerce Export Tool (Click to Zoom)

3. Once the download is completed, open the CSV file and you should find the wholesale price meta key that should be named like this: wholesale_customer_wholesale_price
4. Edit the CSV by adding the wholesale prices, and other wholesale data to your products and then save your file.
5. Import your CSV file back using WooCommerce Product Import tool. You』ll notice that our custom meta keys are already set as Import as Meta. Just click the Run Importer

WooCommerce Import Tool (Click to Zoom)

Wholesale Suite Data Import as Meta (Click to Zoom)

6. After the upload is complete, your wholesale prices should now be applied to the products on your site. 

Subscribe to Wholesale Suite

Importing using WP All Import
You can also import the wholesale data by using WP All Import with their WooCommerce Add-On Pro. We suggest reading their documentation first on how to import WooCommerce products here.
1. Go to WP All Import Dashboard, whether you like to add new items or update existing ones, and select the option for WooCommerce Products

WP All Import Dashboard (Click to Zoom)

2. Continue to Step 3  and out the necessary data for the fields (Title, WooCommerce fields), then on the Custom Fields, click See Detected Fields.

WP All Import Custom Fields (Click to Zoom)

3. It should auto-detect the available custom fields and you should find our custom meta keys like wholesale_customer_wholesale_price. You』ll notice that it will have a value by default. Remove the value and replace it by dragging the title key from the upper right box to the field value instead.

WP All Import Custom Fields and Values (Click to Zoom)

4. Continue to step 4 and click the Auto-detect for the Unique Identifier. Select the necessary settings before you continue.

WP All Import Unique Identifier (Click to Zoom)

5. Proceed until you finish the import process. The wholesale data should now be applied to your Products.
Importing Product Quantity Based Wholesale Pricing
Our Quantity Based Wholesale Pricing metadata is saved as serialized data in the database. Previously, it was not possible to import/export this data in the product CSV when using the WooCommerce Product Import/Export Tool. But as of WooCommerce Wholesale Prices Premium version 1.17, you can now export user-friendly readable data that you can edit and import back to your Product page.
The two important meta keys to remember are Meta: wwpp_post_meta_enable_quantity_discount_rule and Meta: wwpp_post_meta_quantity_discount_rule_mapping.
The value of the first meta key should be set to yes if you want to enable quantity-based wholesale pricing.
The second meta key determines the values of the quantity discount pricing for that product.
For example, if I have this quantity based discounts in a product:

The corresponding value in your CSV for meta:wwpp_post_meta_quantity_discount_rule_mapping, should be:
[{「wholesale_role」:」wholesale_customer」,」start_qty」:」2″,」end_qty」:」10″,」price_type」:」fixed-price」,」wholesale_price」:」50″},{「wholesale_role」:」wholesale_customer」,」start_qty」:」11″,」end_qty」:」20″,」price_type」:」fixed-price」,」wholesale_price」:」40″},{「wholesale_role」:」wholesale_customer」,」start_qty」:」21″,」end_qty」:」」,」price_type」:」fixed-price」,」wholesale_price」:」30″}]
Based on this format, you can easily edit and copy this to your other products to apply the Quantity based wholesale pricing during your import.

Subscribe to Wholesale Suite

Note
In case you』re having visibility issues after importing, we recommend to visit this guide.

How To Send User Information To Zapier On Approval

Zapier is a very powerful tool that acts as the agent in between API』s. If you haven』t heard of it, and you are in need of shifting data around from one place to another, definitely check it out.
This guide is an advanced guide and I』m assuming you have knowledge of PHP coding and how APIs and Webhooks work.
With that out of the way, we recently had a case where we had to send the user the wholesale customer』s email and name to a special wholesale mailing list in Campaign Monitor on approval. This is a task that is very well suited to Zapier because it has integrations already with all the major email marketing platforms.
The only part missing was the ability to get the data out of WordPress and over to Zapier, we chose to do this with a simple webhook POST.
In Zapier you can set up a webhook to collect data, I』ll leave the explanation of this part to them:

https://zapier.com/zapbook/webhook/
https://zapier.com/blog/how-use-zapier-webhooks/

What we』re interested in is how to send the data over to Zapier and here is a code snippet of how to do it when a new wholesale user is approved:

function wwlcSendWebhook( $user ) {
$url = 'https://zapier.com/hooks/catch/XXXXXXXX'; // replace this with your Zapier provided webhook URL

$args = array(
'method' => 'POST',
'body' => array(
'first_name' => $user->user_firstname,
'last_name' => $user->user_lastname,
'email_address' => $user->user_email,
)
);

wp_remote_post( $url, $args );
}

add_action( 'wwlc_action_after_approve_user', 'wwlcSendWebhook', 10, 1 );

Add the above code to your functions.php and it will send the user』s data to the defined Zapier webhook URL whenever a wholesale customer user is Approved.

How to translate Wholesale Suite plugins

If you have a non-English site and you want to translate our Wholesale Suite plugins to a different language, our plugins are translation-ready and you can easily translate them with the help of this guide.
There are different ways to translate WordPress plugins and listed below are the recommended ways on how to do it.

Use of WPML plugins (paid plugin)
Use of free third-party translation plugin (preferably Loco Translate)
Use of PoEdit (software translation tool)

1. WPML
WPML is a paid plugin that allows your WordPress site to be fully multilingual. You can translate WordPress pages, posts, plugins, and other WooCommerce-related strings when used with other WPML』s add-ons.

Getting Started Guide

In translating the Wholesale Suite plugins, it is required to install these 4 WPML plugins:

WooCommerce Multilingual
WPML Multilingual CMS
WPML String Translation
WPML Translation Management

Steps:

On your Dashboard, go to WPML > String Translation
On the 「Select strings within domain」, select the Wholesale Suite plugin you want to translate.
You can use the 「Search for」 option to easily locate the string you want to add the translation.
Add the Translation and make sure that the code format remains similar to the original.
Check the Translation is complete and click Save.

2. Loco Translate

Loco Translate

Loco Translate is a free WordPress plugin that you can download and install to your Plugins page. Once installed, you can easily translate the strings from our plugin to the language you want.
Steps:

On your Dashboard, go to Loco Translate > Plugin and find the Wholesale Suite plugin you want to translate.
Choose the language and location where you want to save the translation file.
Find the string you want to translate and its translation.
Then hit the Save button.

Step 1: Loco Translate > Plugin and choose a Wholesale Suite plugin

Step 2: Choose the language and language location.

Step 3: Find the string you want to translate and add the translation

For more information on how to use Loco Translate, please check their beginner』s guide here.

3. PoEdit
PoEdit is a translation tool that you can use to translate PO files and you can use this editor to translate strings of our Wholesale Suite plugins.
Steps:
1. Download and install PoEdit on your computer.
2. After installing, get the pot file of the plugin you want to translate.
In the image below, let』s say we want to translate strings from the WooCommerce Wholesale Prices Premium. You can get the pot file on the plugin folder of your site, then on /woocommerce-wholesale-prices-premium/languages/

3. Open the pot file using PoEdit and create the translation. You can use the search feature to easily locate strings.

4. After adding the translated string, please make sure that the coding format is retained. Once satisfied with the translation, click Save As and it is important that the file is named correctly.
There is a naming convention when saving Pot files to Po and Mo files. It should have the original name and followed by the suffix of the translated language.
In the example below, I』m translating the original English string to the Spanish language so I need to use es_ES suffix.

5. After saving, the Mo and Po translation file should be generated and you can upload it to your site using FTP and place it inside the same language folder of the translated Pot file.

Additional Notes:
WordPress has a repository of translated plugins by the contributors for the free plugin. You can search our WooCommerce Wholesale Prices plugin if there』s a contributor that started a project to translate our plugin. You can check plugin projects here: https://translate.wordpress.org/

How To Enable Account Upgrade Request For A Regular Customer

Allowing an existing regular customer to upgrade their account to a wholesale customer was one of the most frequently asked features we received. In WooCommerce Wholesale Lead Capture 1.15, we finally introduced a new feature to allow this account upgrade request for a regular customer to become a wholesale customer.
Please go to WooCommerce > Settings > Wholesale Lead > General > then enable the Account Upgrade option.

Account Upgrade option in Wholesale Lead setting

When you have enabled this option, there』ll be a notice in the Dashboard section of a retail customer』s account page. This notice is customizable in the Wholesale Lead setting under the Upgrade Message option.

Account upgrade message for a regular customer

If the regular customer clicks the request an account upgrade link they』ll get redirected to the wholesale customer registration page with an Upgrade Account Request detail.

Wholesale Registration page – Upgrade Account Request

If you enabled the Automatic Approval option, their request will be automatically approved and they』ll get the wholesale customer role. If you enabled the Manual Approval Required, you can review their application first before to approve or reject their request.
When waiting for your approval, there』ll be a notice in the Dashboard section of their account page. Then, if you have approved them, they』ll see a notice as well that their account request has been approved. They』ll be able to get the wholesale price when browsing your shop.

Account is pending for approval notice

Account upgrade request has been approved notice

Is There A Changelog For Wholesale Suite plugins?

We publish a detailed changelog on every release for every one of our plugins.
Here are the changelog links:

WooCommerce Wholesale Prices (Free Version) Changelog
WooCommerce Wholesale Prices Premium Changelog
WooCommerce Wholesale Order Form Changelog
WooCommerce Wholesale Lead Capture Changelog

The changelog pages also show compatibility details about which versions of WooCommerce and WordPress we are compatible up to.
Usually, that is the latest version as we do regression testing with our plugins prior to the official WooCommerce and WordPress release using their beta and release candidates.
Even though we might not always push compatibility updates for each WordPress or WooCommerce release (because often it』s not needed) you can be assured that we』re always compatible with the latest versions of both.
If you are ever in doubt, we invite you to get in touch with our friendly support team to double check.

Issue Updating: Plugin doesn』t meet minimum requirements error

Sometimes when we roll out new features we need to release an update to both the free WooCommerce Wholesale Prices plugin and the WooCommerce Wholesale Prices Premium plugin. They need to be updated at the same time.
If your website hasn』t pinged our server to check for updates of the WooCommerce Wholesale Prices Premium plugin yet and you have already updated the free plugin you may see a notice in your Dashboard like:
「Important Notice: We have detected an outdated version of WooCommerce Wholesale Prices Premium. You require at least version [version number] for this version of WooCommerce Wholesale Prices ([version number]). Please update now.」
To solve this notice, you just need to update WooCommerce Wholesale Prices Premium.
You can access the latest version of your plugins by logging into your account. You』ll find a link to the My Account page under the Download tab. Please download it then you could upload it manually to your website using FTP.
If you have WordPress 5.5 and above, you can upload the new plugin zip file by going to:
1. Plugins > Installed Plugins
2. Click Add New button
3. Click the Upload Plugin button
4. Click Choose File and navigate to your ZIP file
5. Click Install Now
If you are still having issues, please reach out to support here, noting what you have tried already, and we will happily assist you.

How to Enable The Order Form Beta?

We are building a more efficient  WooCommerce Wholesale Order Form v2.0 powered by React JS with exciting new features and improvements such as making it much more lightweight to boost the speed and allowing you to customize the style easily from the backend using a drag and drop interface. 
This order form v2.0 beta is available for early access. If what you need isn』t too complicated or you just simply can』t wait to check it out, feel free to try it!
Kindly note that we don』t recommend using it for production environments yet.  Some integrations and features may be incomplete or not working to the same standard as the current stable form. 
How To Enable The Order Form v2.0 Beta
In this step-by-step guide, we will show you how to easily enable the order form v2.0 beta. 
1. Generate WooCommerce API Key
The new form relies on the WooCommerce API. In order to use the API, the order form will need its own API access key. 
You can generate one from
Copy the key and secret and go to WooCommerce ➝ Settings ➝ Wholesale Ordering tab ➝ Beta in the submenu, and paste them in.

Next, click 「Auto Generate」 and it』ll generate the WooCommerce API Key automatically for you.

2.  Enable Beta Access
Click the 「Enable React JS Order Form」 checkbox to enable the form v2.0 beta.

3. Create Your New Form
In the order form v1.0, you could only have one form. In the new order form v2.0, you will be able to have multiple forms and each form has its own shortcode that you can place onto a page​​.
To create a new form, simply go to WooCommerce ➝ Wholesale Order Forms ➝ hit the 「Add Form」 button.
This 「Wholesale Order Forms」 page will show the list of  all order forms you have created. You can see the shortcodes, where the form is located and the status whether it』s been published or not.

There are three main sections on the  form:

Order Form Header
Order Form Table
Order Form Footer

For the header and footer, you can add sections and determine how many columns you want on each section. You can then drag elements into those sections.
There is only one section for the product listing table. You can drag the elements from the right over to the table and arrange the rows how you like.

If you click on the settings button (a pencil icon) of an element as you wave over it, you will be able to see configuration and styling options on the right side.
Once you are happy with your form, click the 「Publish」 button on the top. This will generate the order form』s shortcode.

Copy and paste the shortcode onto a page to show the order form on the front end of your site.

Current Scope & Limitations
Things we』ve worked on already and are considered working:

Form layout and display – products can show including variable products (each variation is shown individually or in a dropdown).
Speed – it』s lightning-fast and we』re aiming to keep it that way.
Multiple order forms – you can have more than one form in the system now
Each form has a shortcode that can be placed anywhere to show a custom order form
Element level configuration & styling – we』re working on improving this but you can alter the behavior of individual elements on your form

Things that still need attention:

It』s mostly integrated with WooCommerce Wholesale Prices Premium, but there are still some smaller features we』re yet to tackle.
No third-party plugin integrations (e.g. WPML)  as yet but we』re working on it.
Improvements to element level styling
Improvements to settings placement for elements

Found a bug in the v2.0 beta form? Report it to us 🙂
We』re more than happy to assist anymore in trying our new order form and are very grateful for any feedback you have for us.
As mentioned this is a beta feature so there』s bound to be a couple of bugs (though we are testing thoroughly as we go!).
If you need assistance in setting up your order form or find a bug, please send a message to our support including the steps you have figured out to reproduce the issue. It would also be helpful if we could get a copy of your WooCommerce Status report along with it.

How to Force Minimum Quantity for Bulk Product?

In many cases, wholesale discounts are only applicable if the customers buy the product in bulk for certain quantities. Using our WooCommerce Wholesale Prices Premium plugin, you will be able to set the minimum quantity requirement and enforce it to be automatically added to the cart on the product page.
Setting the minimum and step quantity of a product
By default, when you have set the minimum and step quantity of a product, your wholesale customers will have the minimum and step quantity automatically added to the cart on the product page. Your wholesale customers will only be able to add the quantity in bulk per step quantity that you have set.
For example, you have set the step quantity to 12, therefore your wholesale customers can only buy the product in 12, 24, 36, etc. You can use this feature to implement basic bulk purchases. 

Wholesale Minimum Order Quantity & Wholesale Quantity Step Setting

Open the product page and scroll down to Product data — Variable product
Click the Variations section and go to the product variation 
Scroll down to Wholesale Minimum Order Quantity and Wholesale Order Quantity Step, then input the minimum and step quantity

You can also enforce this minimum order quantity steps in the Cart page by enabling the Enforce Product Min/Step On Cart Page in the Wholesale Price setting.

Enforce Product Min/Step On Cart Page Setting

Setting a bulk product variant to be exclusive for wholesale customers
However, you can also opt not to use the step quantity. You can add a separate product variant for the bulk purchase and hide it from your regular customers by making it exclusive so that only your wholesale customers are able to see it.
So for example, you would have 1 Pcs Variation and 1 Dozen Variation. You can make the 1 Dozen variation to be wholesale exclusive.

Wholesale Exclusive Variation Setting

Open the product page and scroll down to Product data — Variable product
Click the Variations section and go to the exclusive product variation 
Scroll down to Wholesale Exclusive Variation to specify which roles are allowed to see and buy the product
If you want to include multiple roles: click, hold, and drag the roles or click control/cmd + choose the roles

Displaying Only Wholesale Products for Wholesale Customers
Since you have made an additional bulk product variant, now you might also want to hide the non-bulk product variants from your wholesale customers.
Please navigate to the WooCommerce ➝ Settings ➝ Wholesale Prices ➝ General ➝ scroll down to Wholesale Products and tick the box to enable displaying wholesale products to wholesale customers only as shown below

Only Wholesale Products for Wholesale Customers Setting

Wholesale Pricing Guide – How Wholesale Pricing Works In Wholesale Suite

Our Wholesale Prices and Wholesale Prices Premium plugins allow you to add wholesale prices to your products.
The WooCommerce Wholesale Prices (free) provides an option to add a fixed wholesale price to your individual products. This can be found on your product page setting.

Example of Wholesale Prices in the product page setting(click to zoom)

With the WooCommerce Wholesale Prices Premium, there are two additional discounts that you can apply to your products: (1) The Percentage-based discount and (2) Quantity-based discount. These discounts are available in your General/Global settings, User settings, Product Category settings, and Individual Product settings.
Types of Wholesale Prices

Fixed Wholesale Price
Percentage-based Discount
Quantity-based Discount

Important notes to remember:

Wholesale prices are based on your wholesale role/user. By default, there is a Wholesale Customer user role created from the free plugin. If you want to create more wholesale roles/users, please go to WooCommerce > Wholesale Roles. Here』s a guide for further reference.
Wholesale prices will NOT apply if the product doesn』t have a regular price or if the regular price is zero. This is because, without a regular price, WooCommerce itself determines that the product is 「not sellable」
If you have more than one wholesale discount enabled, there is an order of precedence that overrides the other discount. The order of priority (from highest to lowest) is the Individual Product Wholesale Price > Product Category Wholesale Price > User Override Wholesale Price > General/Global Wholesale Price.

Fixed Wholesale Price
If you prefer giving a fixed wholesale price to your products, you can set this up by going to your individual product settings, which can be found on your admin Dashboard > Products > Edit.

Example Fixed Wholesale Price Discount in the Individual Product Settings(click to zoom)

In the screenshot above, retail/regular customers will get $35 for this Simple product. When a user with a Wholesale Customer role logs in, the price of the product will become $33, the Bronze user role will get $30, the Silver user will get $28 and the Gold user will get $25.
Bulk Editing Product Based Pricing
If you wish to apply fixed wholesale prices to all your products, you can use the WooCommerce Product Import/Export tool to generate the CSV file of your products and bulk edit the wholesale prices.
For reference, here』s a guide on how to import wholesale data to your products.

Subscribe to Wholesale Suite

Percentage-based Discounts
If you』re looking for an easy and hassle-free set up of wholesale discounts, the percentage-based discount can conveniently give wholesale prices to your products. We have three settings where you can apply the percentage-based discounts.
General/Global settings
The General/Global settings can be found on WooCommerce > Settings > Wholesale Prices > Discount. This type of percentage-based wholesale discount will apply to all of your products that have a regular price.

In the screenshot above, we』ve given the Wholesale Customer a 10% discount, which will apply to all your products that have regular prices.(click to zoom)

User settings (Override General settings)
The User settings can override the general percentage-based wholesale discount per user/customer. This setting can be found on the Edit User of Users > All User page. Just edit the user you want to override the wholesale general discount.

User discount will override the General/Global percentage discount(click to zoom)

Product Category settings
If you wish to apply wholesale prices to specific product categories, we also have an option to apply percentage-based discounts to your product category settings.
This setting can be found on your Products > Categories > Edit Category.

Example of Product Category Discount (click to zoom)

Subscribe to Wholesale Suite

Quantity-based Discount
Quantity-based discounts are additional discounts given to wholesale customers when they meet the required quantity. This feature can be applied to all of the 4 settings and overrides the main wholesale discount.

General Quantity Based Discount

User Override Quantity Discount

Product Category Quantity Based Discount

Individual Product Quantity Based Discount

To apply the quantity-based discount, first, you need to select the wholesale role, then add the starting quantity, ending quantity, and the wholesale discount.

An example of a Percentage Quantity-based Discount in the General/Global settings(click to zoom)

Example of Wholesale Product with Quantity-based discount – wholesale customer view(click to zoom)

Few notes to remember:

It is required to set the main wholesale price first before the quantity-based discount is applied to your products. For example, if you have quantity-based discounts on the General settings, you need to set the main Wholesale Price in the General Setting first. The same logic applies if you have quantity-based discounts on the Product Category settings, you also need to set the main Wholesale Price in the same level of settings.
Please keep in mind that you need to make sure that the checkbox is checked so that the Quantity-based discounts are enabled. You can turn on these checkboxes in the General settings (General Quantity Based Discounts), User settings (Define Alternate Quantity Based Discounts For This User), Product Category settings and Individual Product settings (Enable further wholesale pricing discounts based on quantity purchased?).
The General, User Override and Product Category settings have two options to determine how to meet the quantity requirement and apply the discounts. (1) You can select to count the quantity of the total products in the cart and apply the quantity-based discount to all your products or (2) Apply the discount based on the quantity of the individual product and the quantity-based discount is only applied to eligible products.

Subscribe to Wholesale Suite

Compatibility & Integrations
Our Wholesale Prices Premium also supports wholesale prices for Variable Products, Product Add-ons, Product Bundles, Composite products and more. Click here to check out the full list of integrations.
Help & Assistance
If you need further assistance in applying wholesale prices to your products, feel free to reach out to our support team for any questions!

Wholesale Suite API

In version 1.12 of WooCommerce Wholesale Prices (WWP) and version 1.25 of  WooCommerce Wholesale Prices Premium (WWPP) introduce integration with the WooCommerce API. This allows Wholesale Products to be created, read, updated, and deleted using WordPress REST API Authentication methods and standard HTTP verbs which are understood by most HTTP clients. In this version, we introduce our own endpoint wholesale/v1/. With this API you can:

List, Create, Update, Delete Wholesale Products.
List, Create, Update, Delete Wholesale Variations.
List and Update Wholesale Role. (WWP only have 1 wholesale role)

For a full technical details for this API, please check here.