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.