Sales: 1-800-929-8611 Hosting Support: 1-866-871-9414

Free Online Quote | Contact Us | Web Site Project Center

Web Site Hosting

Testimonials

"Affordable Web Design surpassed all of our expectations in redesigning our website. We were primarily concerned with establishing a professional website at a reasonable price and AWD achieved this objective in a timely and efficient manner." Jamie Hoffman

Project Center

Review your project's milestones, layouts, upload

AWARDS

Affordable Web Design, Inc. is the Golden Web Awards Winner (More info)

quantity based ecommerce discount

Web Store Quantity Discounts

To use quantity pricing set the following value in your Online Store Configuration.

xquantityprices

Yes tells your web store 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.

Your web store 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 your online store 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.

(Back to E-Commerce Online Store Features)

AWD Team Intranet