Creating case discounts

In this feature, you can: 

• Create a discount so the shopper gains a percentage discount on all non-excluded items.

To access this feature, do the following:

1. This is an advanced feature and requires WebSell support to set up.

Description, what it does

• This is a discount type that allows the shopper to gain a percentage discount on all non-excluded items once they buy more than a defined trigger. 
• In the default case, all items are discounted by 10% once at least 12 items have been bought. The default situation is set up to encourage wine shoppers to buy a case worth of bottles.

How to Enable this Discount

• Each product that forms part of the discount needs data in a few fields. 
• This is best done using NscPAM and NscSync.

NscPAM

• In PAM create a new attribute column that will hold the number this item will contribute towards triggering the discount.
•  For most bottles this will be 1, for half cases, this will be 6 and for full cases, this will be 12.
• The column can take any figure, you are not limited to 1, 6, and 12. 
• If you don’t enter a value then the default is 0 – that is, the item does not contribute towards triggering the discount.

NscSync Mappings

• The Item Table

• product_weblinxcustomnumber# 

  • Map the PAM field set up above to one of your unused customer number fields;

• product_notdiscountable 

  •  Set this to 1 if the item counts towards reaching the trigger but is not itself dis-countable. 

  • By default items are set to 0 and can therefore be discounted. 

  • (RMS/RMH users this is not discountable at POS checkbox in the item options tab, for other POS users set this to a PAM boolean field);

• product_qtydiscountid 

  • We need an entry in the quantity discount table. 

  • The easiest way of doing this is to set up a mix and match discount in your POS system, Sync, then hijack the new mix and match id for this discount.

  •  Only items with this qtydiscountid will be considered when calculating the discount.

• The QuantityDiscount Table

• qtydiscount_id 

  • Same value as entered in product_qtydiscountid

• qtydiscount_type 

  • hard code to 4000

WebStore Manager

• The NscSync mappings described above will cause the discount to work but you will be limited to the default settings. 
• Set the trigger level, the custom number field that each items trigger value is contained in, the percentage discount and the name of the discount.
• Enter your values in the four boxes provided and the changes should take place immediately.

Limitations

• The WebSell system only allows one POS style discount on an item at a time. 
• You can’t combine this discount with a different mix and match of other quantity discounts
• The above example shows two items, both part of the discount scheme but only one of them discountable. The not discountable item counts towards hitting the trigger level but doesn’t get discounted.

Contact us

If you have any problems with this feature, contact our support team by opening a ticket.