Customer Pricing Based on Products Record

If you have a small number of groups, you can specify a different field in the products table to be used as the price for each group.

 

For example, you may have three types - retail, wholesale and distributor - and they see three different prices.

 

Compared to our previous 6.50 version where you have to setup the Xcustomerpricetypes, Xcustomerpricefields and Xcustomerpriceidentifier configurations, in the new VPCART 8.00, everything can be set up from the Customer Groups record instead.

 

The following Software Configuration value turns on enhanced customer pricing:

 

Xcustomerprices

Setting this to Yes turns on customer-based pricing.

 

Below are the steps you can follow to setup the customer pricing based on products:

1.  Create each customer group you will have except for retail as normal price will be set for retail customers. Then you will only need to create 2 customer groups named Wholesale and Distributor.

Please refer to page 293 on how to create customer groups and assigning your customers to the groups.

 

2.  When adding/editing a customer group, make sure you fill in a value for the “Product Price Field”field. The value should be the name of a field in Products table that is storing the product price.

 

As an example, for Wholesale customer group, we will set pother2 as product price.

For Distributor customer group, we will set pother3 as product price.

 

3.  You then go to edit your products so that you will have the price for the fields you have setup in “Product Price Field”. In this example, you need to enter price for Other4 and Other5 in the edit products page.

 

Wholesale and Distributors would need to login before they shop and VPCART will take note of their customer group and display the pricing based on setup.