Item Quantity Pricing Report
Effectively utilize item quantity pricing.
Written by Michael Cook
Updated at June 18th, 2025
Item Quantity Pricing Report
What This Report Is
This report shows you the different prices you have set for each item, depending on how many a customer buys. It lists the regular price and any quantity-based pricing (for example: Buy 2, pay a lower price).
Why It Matters
- Lets you quickly check if quantity discounts are set up correctly
- Helps catch pricing mistakes before they cost you money
- Useful for planning sales and promotions
- Helps make sure bulk pricing is profitable
What to Look For
| Column | What It Tells You | What to Watch Out For |
|---|---|---|
| Description | The name of the item | Make sure the correct item names show here |
| Unit Price ($) | Regular price for 1 item | Check for items with missing or wrong prices |
| Qty One | The number of items for first quantity discount | Watch for zero (means no discount set) |
| Quantity Price One ($) | The price for that first quantity discount | Make sure discount pricing makes sense |
| Qty Two / Quantity Price Two ($) | Second level discount price (if set) | Confirm higher quantity discounts are correct |
| Operations | Option to delete pricing rows | Be careful deleting—only do if sure it's wrong |
What to Do
- Review Prices Regularly: Make sure every item has the right price, especially after price changes from suppliers.
- Check Quantity Discounts: If you offer “buy more, save more” deals, confirm they’re set up correctly.
- Fix Errors Fast: Delete or correct any pricing that doesn’t make sense to avoid accidental discounts or lost revenue.
- Plan Promotions: Use this report to find items that might benefit from adding quantity discounts to encourage bigger purchases.