After downloading this file, complete the steps in Add business prices and quantity discounts
to your Manage Quotes feed file below.
Add quantity discounts to your Manage Quotes feed file
After downloading your Manage Quotes feed file, complete the following steps. This adds
business features to your existing offer; it does not change or replace your existing
To review requirements, open the Data Definitions tab in the Manage Quotes feed file.
Open the Upload Quantity Discounts worksheet.
Add a business price in the business-price row. You must add a business price before
adding quantity discounts. Your business price must be less than or equal to your standard
price. If your business price is higher than your standard price, your business price will
In the quantity-discount-type column, select the discount model you want to use (fixed
Specify your quantity tiers by setting lower-bounds in the quantity-lower-bound1,
quantity-lower-bound2, etc. rows. Lower-bounds represent the quantity at which a discount
becomes active. For example, if you want to offer only a quantity discount for customers
who buy 10 or more units, enter 10 in the quantity-lower-bound1 field. You can specify up
to 5 tiers in the rows labeled quantity-lower-bound1 through quantity-lower-bound5. Each
lower-bound has a price, such as quantity-price1, associated with it in the column
adjacent to the right.
Specify your quantity discounts. If you are using a fixed model, enter the
quantity-prices you want to charge in the quantity-price1, quantity-price2, etc. columns.
If you are using a percent model, enter a number between 0 and 99 for the discount you
want to offer.
Note: For the fixed model only, each consecutive quantity-price must be
lower than the last; quantity-price2 must be lower than quantity-price1, and so
In MS Excel, select Save.
Upload your file by going to the Manage Quotes portal and selecting Upload Quantity
Sign in to use the tool and get personalised help (desktop browser required).