QuantityDiscounts Table

This is the table where you can specify products, categories and quantity ranges for quantity discounts.

 

categoryid

If you want to apply a discount to products in a particular category, enter the category ID here.

catalogid

If you want to apply a discount to a particular product, enter the catalog ID here.

minquantity

This is the minimum quantity to be ordered before the discount is applied.

quantity1

The upper level of the quantity. For example, if a discount is to be applied for purchases of 5 to 10 items, set minquantity to 5 and enter 10 in this field.

discount1

The amount of discount. If it is less than 1 (for example.10) it is treated as a percentage discount. If it is greater than 1, it is treated as an actual discount amount.

quantity2 and discount2…

These are the next ranges. The quantity must be higher than that of the previous quantity. You must set the last quantity to a high number such as 99999 to cover all quantities that can be ordered.

groupfordiscount

Entering a keyword in here tells VPCART to group products that have this keyword in their groupfordiscount field before calculating the discount. This allows you to apply a discount across a range of products.

 

Note: If using this function, make sure catalogid and categoryid fields of the record are not filled out.