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. |