Price list lines

Each price list line in a price list associates a product with a list price.

The difference between list price, unit price, and line price is as follows:

  • The list price is the price specified in the price list. The list price does not consider volume discounts, special pricing rules, or anything else that may affect the price.
  • The unit price is the calculated price of an item after a percentage adjustment or an absolute adjustment has been applied to the list price.
  • The line price is the price for a given line item. The line price depends upon the list price, quantity ordered, and pricing rules.

For example, the following table shows that MXWS-1000 has a list price of $10.00. A -$2.00 adjustment is applied to the list price, resulting in a calculated unit price of $8.00. The line quantity ordered for MXWS-1000 is 100, resulting in a line price of $800.00.

Product ID List price Absolute adjustment Unit price Quantity ordered Line price
MXWS-1000 $10.00 -$2.00 $8.00 100 $800.00

Each list price can have positive or negative adjustments associated to that price. The adjustments are usually discounts, and can be a percentage adjustment (such as, 10%) or an absolute adjustment (such as, $10.00). For example, you can have a price list containing several MXWS products, and you can apply adjustments to some or all of the list prices, as shown in the following table:

  • A -5% adjustment is applied to the $100.00 list price of MXWS-2000, resulting in a unit price of $95.00. A quantity of 2 is ordered, resulting in a line price of $190.00.
  • A -$10.00 adjustment is applied to the $120.00 list price of MXWS-3000, resulting in a unit price of $110.00. A quantity of 3 is ordered, resulting in a line price of $330.00.
  • No adjustment is applied to MXWS-4000. The list price and the unit price are the same. A quantity of 2 is ordered, resulting in a line price of $260.00.
    Product ID List price Adjustment Unit price Quantity ordered Line price
    MXWS-2000 $100.00 -5% $95.00 2 $190.00
    MXWS-3000 $120.00 -$10.00 $110.00 3 $330.00
    MXWS-4000 $130.00 None $130.00 2 $260.00

You can specify quantity tiers for the items in a price list. In quantity-tiered pricing, either absolute adjustments or percentage adjustments are applied to a list price depending on the quantity ordered. For example, you can have quantity tiers for order boundaries between 10 and 19, 20 and 29, and 30 or greater. Generally, the greater the quantity ordered, the greater the absolute discount or percentage discount. When the order quantity falls within one of these boundaries, either an absolute adjustment or a percentage adjustment is applied to the list price. If the quantity falls outside the specified boundaries, an adjustment is not applied, and the price defaults to the base list price.

For example, you can set up quantity-tiered pricing, as follows:

  • Percentage adjustments for product MXWS-1100

    If a customer orders between 10 and 99 of item MXWS-1100, a -10% adjustment is applied to the list price. If a customer orders between 100 and 199 of item MXWS-1100, a -15% adjustment is applied to the list price. If a customer orders 200 or more of item MXWS-1100, a -20% adjustment is applied to the list price. If a customer orders less than 10 numbers of item MXWS-1100, it defaults to the base list price.

  • Absolute adjustments for product RDMS-1100

    If a customer orders between 10 and 99 of item RDMS-1100, a -$1.00 adjustment is applied to the list price. If a customer orders between 100 and 199 of item RDMS-1100, a -$2.00 adjustment is applied to the list price. If a customer orders 200 or more of item RDMS-1100, a -$3.00 adjustment is applied to the list price. If a customer orders less than 10 numbers of item RDMS-110, it defaults to the base list price.

The following table illustrates these examples:

Product ID List price Quantity ordered Percentage adjustment Absolute adjustment Unit price Line price
MXWS-1100 $10.00 50 -10%   $9.00 $450.00
MXWS-1100 $10.00 150 -15%   $8.50 $1,275.00
MXWS-1100 $10.00 200 -20%   $8.00 $1,600.00
MXWS-1100 $10.00 5 None   $10.00 $50.00
RDMS-1100 $10.00 50   -$1.00 $9.00 $450.00
RDMS-1100 $10.00 150   -$2.00 $8.00 $1,200.00
RDMS-1100 $10.00 200   -$3.00 $7.00 $1,400.00
RDMS-1100 $10.00 5   None $10.00 $50.00

Effectivity dates can also be specified for the items in a price list.