Volume Pricing
Volume pricing reduces the unit price of a product as the ordered quantity increases, when a buyer adjusts their cart quantity, the price updates automatically to reflect the applicable tier, with no manual calculation required.
This article covers how volume pricing works, how it interacts with MOQ and IOQ settings, where it appears across the order flow, and how to set it up using Import and Export.
Platform: WizOrder & WizShop | Who is this for: Admins
To Get There: Manage > Import - Export > Product > Volume Pricing
Table of Contents
Before You Begin
- Ensure you have Admin access before setting up volume pricing.
- If this is your first time using Import and Export, read the Instructions sheet in the exported file before making any changes.
- If your pricing is managed through an ERP such as QuickBooks, NetSuite, Sage, Business Central, or Epicor, volume pricing tiers may sync automatically depending on your integration setup. Contact your Customer Success Manager to confirm how pricing data flows into WizCommerce.
A. How Volume Pricing Works
Volume pricing is configured per product as a set of quantity tiers. Each tier defines a minimum quantity and a corresponding unit price. When a buyer's quantity meets or exceeds a tier threshold, the product price updates automatically in the cart.
Buyers can see the full tier breakdown on the Product Detail Page (PDP) before adding anything to the cart — so they know exactly what they will pay at each quantity level.
Example:
| Quantity | Unit Price |
|---|---|
| 1–5 | $10.00 |
| 6–9 | $9.50 |
| 10+ | $9.30 |
If a buyer adds 6 units to their cart, the price per unit adjusts automatically to $9.50. If they increase to 10 units, it drops to $9.30.
B. Related Quantity Controls
Volume pricing works alongside two additional quantity settings that can be configured per product:
- MOQ (Minimum Order Quantity): The smallest number of units a buyer can order for a product. If the MOQ is 12, the buyer cannot add fewer than 12 units. The cart enforces this automatically.
- IOQ (Incremental Order Quantity): The increment in which quantities must be ordered. If the IOQ is 12, valid quantities are 12, 24, 36, and so on. Quantities outside this increment cannot be added to the cart. This is common for products sold in cases or packs.
Note: Volume pricing, MOQ, and IOQ can all be active on the same product at the same time. For example, a product may have an MOQ of 12, an IOQ of 12, and a volume pricing tier that offers a better rate at 48 units — encouraging buyers to order a full case rather than a smaller quantity.
C. Where Volume Pricing Appears
The table below outlines where volume pricing is displayed throughout the order flow.
| Location | What the Buyer or Rep Sees |
|---|---|
| Product Detail Page (PDP) | Full tier table showing quantity ranges and unit prices |
| Cart | Unit price updates automatically when the quantity meets a tier |
| Order confirmation | Unit price reflects the tier applied at the time of order |
D. Setting Up Volume Pricing via Import/ Export
Import and Export lets you configure volume pricing across multiple SKUs at once — setting quantity thresholds and price breaks in bulk. Use this when you are launching a new catalog or updating pricing across a large number of products.
Step 1: Download the Volume Pricing Template
- Go to Manage → Import / Export.

- Select Product, then click Export.

- Select the Volume Pricing from the dropdown.

- Click Export.

Step 2: Fill In the Data Sheet
- Open the downloaded file in Microsoft Excel or Google Sheets.
- If this is your first time using Import and Export, go through the Instructions sheet before making any changes. It explains what each column does.

- Go to the Data Sheet. In the Price Tier_Qty Break 1 column (e.g., Dealer_Qty Break 1), enter the quantity at which volume pricing should activate. For example, if volume pricing for SKU CB188618 should apply once the buyer orders more than 20 units, enter 20. Set the Price Tier_IOQ Break 1 column to the same IOQ value used for the base price.

- In the Price Tier_Price Break 1 column (e.g., Dealer_Price Break 1), enter the discounted price that applies once the quantity in Qty Break 1 is reached (e.g., $30).
- If you need a second price break for the same SKU, repeat the same process using the Price Tier_Qty Break 2 and Price Tier_Price Break 2 columns.
- Save the file once all tiers are set up.
- The changes reflect on the Product Detail Page immediately after a successful import.

Note: If volume pricing has never been set up for the catalog before, the exported file may not include columns such as Price Tier_Qty Break 1, Price Tier_Price Break 1, or Price Tier_Qty Break 2. In that case, add these columns manually to the Data Sheet before importing.
E. How Volume Pricing Fits Into the Broader Pricing Structure
When a buyer adds products to their cart, pricing is applied in this order:
- Price list determines the base price the buyer sees.
- Volume pricing adjusts the unit price as quantity increases.
- Discount Engine applies any eligible discounts on top.
The buyer sees the final price reflecting all applicable adjustments.
Note: If your pricing is managed through an ERP such as QuickBooks, NetSuite, Sage, Business Central, or Epicor, volume pricing tiers may sync automatically depending on your integration setup. Contact your Customer Success Manager to confirm how pricing data flows into WizCommerce.
FAQs
1. Can volume pricing, MOQ, and IOQ all be active on the same product?
A. Yes. All three can be active at the same time. For example, a product can have an MOQ of 12, an IOQ of 12, and a volume pricing tier that kicks in at 48 units — encouraging buyers to order a full case quantity.
2. Where can buyers see the volume pricing tiers before placing an order?
A. Buyers can see the full tier breakdown on the Product Detail Page (PDP) before adding anything to the cart. The price then updates automatically in the cart as the quantity changes.
3. What do I do if the volume pricing columns are missing from the exported file?
A. If volume pricing has never been set up for your catalog before, the exported file may not include the Qty Break and Price Break columns. To add these columns -- go to Import Section, select Volume Pricing from the dropdown, and download the Template.

Not finding what you need? Browse the WizCommerce Help Center, reach out to your Customer Success Manager, or contact our support team at help@wizcommerce.com.