VP-ASP :: Shopping Cart Software

Shopping Cart Software Solutions for anywhere in the World

US/Canada(Toll Free): +1 888 587 2278
Europe/UK: +44 (020) 7193 9408
Australia/New Zealand: +61 3 9016 4497

Quantity Discounts

Quantity Discounts

To use quantity pricing set the following value in VP-ASP Configuration. This feature adds additional overhead. VP-ASP needs to check the database every time the quantity for an item is changed to recalculate the price.

xquantityprices

Yes tells VP-ASP to use quantity based pricing


Quantity Discounts Table

Each time the customer alters the quantity of a product, shopuserprice.asp is called. It looks up the product by catalogid or category. If it finds a record in the “ quantitydiscounts ” table it alters the prices based on the ranges set in that table.

VP-ASP will not group products to apply a discount. If you want different products to be treated as a group you must also set the following.

xproductgroupdiscount

Yes tells VP-ASP to group products. Products are grouped using a field in the products table groupfordiscount.

You can also specify in this table the following fields:

categoryid

Discount should apply to products in this category

catalogid

Discount should apply to this specific product

minquantity

The minimum quantity before the discount should apply

quantity1

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

discount1

The amount of discount. If it is less than 1 such as .10 it is treated as a percent and if greater than 1 it is treated as an actual discount amount

quantity2 and discount2…

These are the next ranges. The quantity must be higher that the previous quantity. You must set the last quantity to a high number such as 99999

groupfordiscount

Will group products before calculating the discount. This allows you to apply a discount across a range of products. This field must match the same field in the products table. If using this facility, make sure cataloged and categoryid are set to null

To display the Quantity Discount on your product pages you will need to set up templates. See this page for more information on templates:

http://www.vpasp.com/helpnotes/shopdisplayproducts.asp?
id=17&cat=Product+Formatting+%2D+Templates


The special field you need to add to your template file to display the quantity discount is [DISPLAY_QUANTITYDISCOUNTS]


Times Viewed:
2799
Added By:
Steve Baldwin
Date Created:
10/6/2005
Last Updated:
12/19/2005
Back Search other topics Submit a Ticket