5.20. pricing

This database works in conjunction with the CommonAdjust directive to allow quantity pricing for one product or for a group of products (sometimes known as mix-and-match). The fields q2, q5, q10, etc. are for the quantity levels; the price_group field selects the mix-and-match category for the product.

Fields

Field	Description
sku	Unique key, shared with products table
price_group	Mix-and-match category
q2	Retail, 2 or more
q5	Retail, 5 or more
q10	Retail, 10 or more
q25	Retail, 25 or more
q100	Retail, 100 or more
w2	Wholesale, 2 or more
w5	Wholesale, 5 or more
w10	Wholesale, 10 or more
w25	Wholesale, 25 or more
w100	Wholesale, 100 or more

5.20.1. sku

Example Data

   os28004
   os28006
   os28057c
   os28069

Unique key, matching the sku for an entry in products table.

5.20.2. price_group

Example Data

   general

This field determines mix-and-match categories if you want to allow mix-and-match quantity pricing (i.e., where 5 of these plus 5 of those afford the q10 price for both these and those).

5.20.3. q2

If set, this will be the price per item when the order quantity is 2 or greater.

5.20.4. q5

If set, this will be the price per item when the order quantity is 5 or greater.

5.20.5. q10

If set, this will be the price per item when the order quantity is 10 or greater.

5.20.6. q25

If set, this will be the price per item when the order quantity is 25 or greater.

5.20.7. q100

If set, this will be the price per item when the order quantity is 100 or greater.

5.20.8. w2

If set, this will be the dealer price per item when the order quantity is 2 or greater.

5.20.9. w5

If set, this will be the dealer price per item when the order quantity is 5 or greater.

5.20.10. w10

If set, this will be the dealer price per item when the order quantity is 10 or greater.

5.20.11. w25

If set, this will be the dealer price per item when the order quantity is 25 or greater.

5.20.12. w100

If set, this will be the dealer price per item when the order quantity is 100 or greater.