Bulk Wholesale Pricing

If you want to offer bulk quantities of your product to wholesale customers then use the bulk assigning option.

You can select the number of products and assign the wholesale price either fixed or percentage in single wholesale pricing option.

For multiple wholesale pricing option, you can perform bulk action by enabling the role for each product and assigning the wholesale prices. You can assign different level of pricing discounts to different wholesale role easily with bulk pricing.

Option 1

1. Go to Wholesale ???? Bulk Wholesale Pricing.
2. Select products ???? Select Wholesale Type (percentage of fixed) ???? Enter Wholesale Price.
3. Update to apply wholesale prices.

Option 2

1. You can also Check and select Individual Products.
2. Click on Individual Products to select discount type and assign wholesale prices.
3. Update to apply.

Option 3

1. Check the “Select all” option to select all products on a single page
2. Select discount type and assign wholesale prices.
3. Update to apply.

Enable/disable coupon codes

You can enable/disable Coupon Codes for Wholesale customers by clicking on the checkbox (as shown in the screenshot below). When coupon codes are disabled for any specific or all wholesale roles, the customers cannot utilize their coupons on cart and checkout page.

How-to-steps – Configure coupon code settings

1. Go to Wholesale ???? User Roles.
2. Add a new Role or Edit Existing Role.
3. Disable Coupon for selected roles.

Wholesale pricing column on products

• Navigate to WordPress Admin Dashboard → Products → All Products.

• Once you’re on the Products page, we can see a new column added titled Wholesale Pricing On.
• It will represent which type of Wholesale Pricing is enabled on that product.

• There are three types of Wholesale pricing types.

Wholesaler Product

• This tag highlights that the wholesale price is applied to the product.
• Navigate to the WordPress Admin Dashboard → Products → All Products.

• On the Products page, hover on any existing product to view the suboptions.
• Click on the Edit suboption.

• Go to the Wholesale User Pricing section once you’re on the Edit Product page.

• Click on the wholesale user role on which you want to configure this tag.

• Checkmark the Enable Role checkbox in the Role Activation option.
• Set the Discount Type.
• Set the Wholesale Price.
• Set the Min Quantity.
• Set the Product Tier Pricing. (Optional)

• Once done, click on the Update button.
• Now navigate to the WordPress Admin Dashboard → Products → All Products.
• We can see the Wholesaler A Product tag in the Wholesale Pricing On column on the product it is configured.

Wholesaler Category

• This tag highlights that the wholesale price is applied to the product.
• Navigate to the WordPress Admin Dashboard → Products → Categories.

• On the Product categories page, hover on any existing category to view the suboptions.
• Click on the Edit suboption.

• Go to the Wholesale Role section once you’re on the Edit category page.

• Click on the wholesale user role on which you want to configure this tag.

• Checkmark the Enable Role checkbox in the Role Activation option.
• Set the Discount Type.
• Set the Wholesale Price.
• Set the Min Quantity.
• Set the Category Tier Pricing. (Optional)

• Once done, click on the Update button.
• Now navigate to the WordPress Admin Dashboard → Products → All Products.
• We can see the Wholesaler B Category tag in the Wholesale Pricing On column on the configured category.

Wholesaler Global

• This tag highlights that the wholesale price is applied to the product.
• Navigate to the WordPress Admin Dashboard → Wholesale → Settings.

• Now navigate to the Wholesale Price Global tab.
• Click on the wholesale user role on which you want to configure this tag

• Checkmark the Enable Role checkbox in the Role Activation option.
• Set the Discount Type.
• Set the Wholesale Price.
• Set the Min Quantity.
• Set the Global Tier Pricing. (Optional)
• Once done, click on the Update button.

• Now navigate to the WordPress Admin Dashboard → Products → All Products.
• We can see the Wholesaler A Global tag in the Wholesale Pricing On column is applied globally.

CSV Import/Export Wholesale Prices

Wholesale store owners can import/export wholesale prices for each user role.  Wholesale store owners will easily able to update prices in bulk instead of manually changing them individually.

In Wholesale settings you will see the following options:

• Import
• Export

How-to-steps – Export CSV

1. Export from Wholesale > Settings
2. WooCommerce importer/exporter menu will appear.
3. Click on the “Generate CSV” button

In the CSV file, you will see the following options for each wholesale role:

• Wholesale_type
• Wholesale_price
• Wholesale_quantity

Wholesale_type: In CSV file you will see the Wholesale_type column as attached in the screenshot which you create from Wholesale > User Roles, all the wholesale roles will display in a CSV file, if any wholesale roles disabled from the product level wholesale prices will not import in a CSV,file if you enter the wholesale prices and minimum quantity in Wholesale_price and Wholesale_quantity column and then export again wholesale role automatically activate and wholesale prices will be applied.

Wholesale_price: In a CSV file you will see the Wholesale_price column of wholesale products, you can edit or change wholesale prices and export, if you export the CSV file without entering Wholesale_price then the wholesale role will not activate and no prices will apply on wholesale products.

Wholesale_quantity: You will see the Wholesale_quantity column in a CSV file, you can also edit or change the wholesale product’s quantity and export. Do not leave the Wholesale_quantity column blank if you want to apply or activate the wholesale role after export.

Note Wholesale CSV import/export will only work on product pricing. You can not import/export Global, Categories, wholesale prices.

How-to-steps – Import CSV

When you click on the import button you will see the CSV file upload option where you can upload a file with new prices or update existing products by selecting multiple checkboxes.

Note When importing/exporting the unique identifier is the product ID, please make sure that the product ID will remain the same when updating the existing product prices.

Once the file upload and click on continue, you will see the mapping option, from the mapping option you can select wholesale roles which you want to import.

If you do not want to import a specific role then select “do not import” so the not imported roles will be not activated and no prices will apply on those roles.

Note When importing either you can update the pricing of the existing products or add a new product both cannot be possible at the same time.