Description

This documents explains how Special Pricing Schedules are created for customer groups.


In order to set pricing for a GROUP of customers the WMS uses the Customer Card IDENTIFIER.

It is recommended that the first 10 - 15 Identifiers are reserved for Customer Groups.

Any specials applied to these GROUPS will be applied to all customers with the same IDENTIFIER in their Card Details setting.

Special Pricing by Group works in conjunction with the other special pricing strategies support in WMS - for example by BRAND, by ITEM etc. The WMS will attempt to return the best price based on which ever strategy returns the lowest price.


  • This feature requires the optional Special Pricing module for WMS.
  • Ensure the SPS tag is switched on in Prefs.xml <WMSAsSPSSource>True</WMSAsSPSSource> (done by Datapel Support)
  • Ensure that SPS is also switched on in Preferences (Sales tab) under "Use Special Pricing Schedules (SPS)"
  • Special price uses best price , lowest price.
  • If the same Item involved in two or more SPS setups then if any setup price set to 0 price and/or 0 discount then WMS will default to Base Sell Price. To resolve this issue please amend/delete zero value line or put 100% discount to give for free to re-calculate correct price.

NOTE:

Tools > Preferences  > Sales setting - "Always use Item Special Price if available".


When this option is ON, Best price is ignored and the priority is individual Customer in special pricing then Group pricing.

For examples:
Item Standard price = $800.00
SPS for the customer = $1000.00
SPS for the customer Group = $500.00

If "Always use Item Special Price if available" is ON, the customer sales will be charged $1000.00
If "Always use Item Special Price if available" is OFF, the customer sales will be charged $500.00


Related Information

Detail Steps

1: A Customer Group Card must be created.

The Card must be of type CUSTOMER and must start with *CustomerGroup to be recognised by the WMS SPS module.

2: It is required that the Card Identification be set as the Group Name and the IDENTIFIER selected with a customised label. In the exact formatting of "*GROUPA" "*GROUPB" "*GROUPC" The asterisc is compulsary.

3: Set the Customer Group Identifier as shown.

4: Make sure the Customers are added to the group by selecting the identifier as per the group name - in this example Group A.

5. Follow this article to create new Special Price schedule Creating Special Pricing and select customer as *GROUPA" "*GROUPB" "*GROUPC" etc.




NOTE:

Tools > Preferences  > Sales setting - "Always use Item Special Price if available".


When this option is ON, Best price is ignored and the priority is individual Customer in special pricing then Group pricing.

For examples:
Item Standard price = $800.00
SPS for the customer = $1000.00
SPS for the customer Group = $500.00

If "Always use Item Special Price if available" is ON, the customer sales will be charged $1000.00
If "Always use Item Special Price if available" is OFF, the customer sales will be charged $500.00


Related Information

Setup in WMS