Customer Prices

You can set personalized prices for your customers for specific products based on the agreements you have with them. You can also decide whether you want additional discounts on these items to apply for this customer and be calculated on top of their own special price. Let’s see how you can do this.

Setting Customer Prices Manually

You can set customer prices for specific products manually by following these steps:

Step 1. Go to Products >Products, and click on the product you want to set a customer price.

Step 2. Look for the “Customer prices” tab, then complete the necessary information on the page. Specifically, here, you’ll need to define the following information:

Customer	Enter the name of the customer for which you want to set a special price
Variant	Select the variant for which the customer price applies from the drop-down menu, if applicable. Note that this field will appear only if the specific product has variants
Price	Type the product’s price for this customer
Apply extra discounts (%)	Check this box to allow additional customer or product discounts to be applied on top of the customer price

Step 3. Once you’ve entered the necessary information, click “Save.” Customers for whom you’ve set specific prices can view these on your storefront.

NOTE: To add more customer prices to a product, click the “+” button.

In the example below, Wholesale Demo & Co has set the price for the product Mustard Sweater and its variants to $120 instead of $150 for their customer Mad Style.

Importing and Mass Assigning Customer Prices

You can import and assign in bulk customer prices to specific products through these steps:

Step 1. Go to Tools >Import Customer Prices, then click “Sample file import” to download a template file.

Step 2. Open the spreadsheet you’ve downloaded and fill out the necessary information.

Specifically:

customer_name	Type the customer’s company name
customer_email	Insert the customer’s email address
product_sku	Enter the product’s SKU number (e.g., SKU001)
price	Type the product’s price

Step 3. Once you’re done, go to Tools >Import Customer Prices, click “Choose File” and then “Import” to upload customer prices. Remember that your file should be in .xlsx format.

NOTE: To assign customer prices to product variants, add a column in your spreadsheet named “variant_sku” next to the “product_sku” column. Also, to define if you want to allow additional customer or product discounts, you can add a column named “apply_extra_discounts” at the end of your spreadsheet. Remember to type “0” if you do not want extra discounts to apply and “1” if you want to allow additional reductions to be applied on top of the customer price.

Exporting Customer Prices

To export customer prices, complete these steps:

Step 1. Go to Tools >Import Customer Prices and click “Export Customer Prices.”

Step 2. Next, click “Export” on the page that opens to download customer prices.

Updating Customer Prices

You can update customer prices by downloading and re-uploading them on your B2B eCommerce platform. To do this:

Step 1. Go to Tools >Import Customer Prices and click “Export Customer Prices.” Next, click “Export” to download customer prices.

Step 2. Open the spreadsheet and make the necessary changes to the file.

Here, you’ll find the following columns:

customer_name	Corresponds to the customer’s company name
customer_email	Refers to the customer’s email address
product_sku	Corresponds to the the product’s SKU number (e.g., SKU001)
product_variant_id	Refers to the variant’s identification code used internally on B2B Wave. Note that this column will appear only if the specific product has variants
variant_sku	Reflects the product variant’s code (e.g., SKU001-L). Note that this column will appear only if the specific product has variants
price	Corresponds to the product’s customer price
apply_extra_discounts	Refers to allowing extra discounts to apply on top of the set customer price. The value will be “0” if you have opted out for additional discounts to be applied on top of the customer price. Otherwise, the value will be “1”

Step 3. Once you’re done, go to Tools >Import Customer Prices, click “Choose File” and then “Import” to update customer prices. Remember that your file should be in .xlsx format.

Deleting Customer Prices Manually

You can delete customer prices manually through these steps:

Step 1. Go to Products >Products, and click the product for which to delete customer prices.

Step 2. Look for the “Customer prices” tab, then click the “x” button and “Save.”

Deleting Customer Prices in Bulk

To mass delete customer prices, follow these steps:

Step 1. Go to Tools >Import Customer Prices and click “Export Customer Prices.” Next, click “Export” on the open page to download customer prices.

Step 2. Open the spreadsheet, go to the “price” column, then enter a dash “-” to remove these customer prices.

Step 3. Once you’re done, go to Tools >Import Customer Prices, click “Choose File” and then “Import.”