Volume pricing allows you to offer special product pricing based on the quantity purchased by a customer. For example, if an item normally sells for $5.00 each, you can configure a volume discount so that the price drops to $4.50 when 50 or more units are ordered. RepZio gives you the flexibility to apply volume pricing across individual items or groups of products.
Enabling Volume Pricing
Before you can begin setting up volume pricing, the feature must be enabled in WebManager.
To enable:
-
Log into WebManager
-
Go to Settings > RepZio App Settings > Pricing Customizations
-
Toggle Enable Volume Pricing to green
-
Click Save Changes, then Push Data Live
Accessing the Volume Pricing Interface
While volume pricing is set up through an import file, you can review and lightly edit volume pricing rules directly in WebManager.
To access:
-
Log into WebManager
-
Click on Products > Volume Pricing
This opens a spreadsheet-style interface with the following fields:
-
ItemID – The SKU of the product
-
Qty – Quantity required to trigger the volume price
-
PriceLevel0–5 – Volume prices per price level (BasePrice through PriceLevel5)
-
IsDeleted – FALSE if active, TRUE if inactive
Editing Notes:
-
Click a cell to edit it. A red triangle will appear in the corner of the edited cell.
-
A red Save Changes button will appear in the top-right of the screen.
-
After pushing updates live, sales reps must log out and back in to see changes. If the item is in an open cart, it must be removed and re-added.
Setting Up Volume Pricing Using the Import Template
Volume pricing must be created using the Import Volume Pricing Template (repzio_import_volume_pricing.xls). This file should be saved in .XLS or Tab Delimited (.TXT) format.
Template Fields Overview
-
ItemID – Product SKU.
-
Qty – Quantity threshold for price break.
-
PriceLevel0–20 – Price per level at the specified quantity.
-
IsDeleted – Use "FALSE" to activate pricing, "TRUE" to deactivate.
To set multiple pricing tiers for a product (e.g., discounts at 25, 50, and 100 units), list the same ItemID multiple times with different Qty and corresponding prices.
Group Volume Pricing
Group Volume Pricing allows you to offer quantity-based discounts across a collection of related products. For example, a discount could apply when a customer purchases 10 or more cases of any soft drink flavors (e.g., 5 Cherry, 5 Vanilla).
Steps to Set Up Group Volume Pricing:
-
Set Up Individual Volume Pricing
Use the standard volume pricing template to assign pricing to each product in the group.Example
ItemID Qty PriceLevel0 IsDeleted ANDYCOLA-RG 10 5.99 False ANDYCOLA-DT 10 5.99 False ANDYCOLA-SP 10 5.99 False ANDYCOLA-VB 10 6.99 False ANDYCOLA-LE 10 6.99 False ANDYCOLA-CH 10 6.99 False -
Choose a Group Code
Select one ItemID as the group code (e.g.,ANDYCOLA-RG), then enter this code into an unused UDF column (e.g., UDF8) for all related products in your product template.Example
ItemName Category BasePrice udf8 Andy Cola Reg Drinks/SoftDrinks 8.99 ANDYCOLA-RG Andy Cola Diet Drinks/SoftDrinks 8.99 ANDYCOLA-RG Andy Cola Sparkling Drinks/SoftDrinks 8.99 ANDYCOLA-RG Andy Cola Vanilla Drinks/SoftDrinks 8.99 ANDYCOLA-RG Andy Cola Lemon Drinks/SoftDrinks 8.99 ANDYCOLA-RG Andy Cola Cherry Drinks/SoftDrinks 8.99 ANDYCOLA-RG -
Upload Product & Pricing Templates
-
Log into WebManager
-
Upload your updated Product and Volume Pricing spreadsheets
-
Go to Settings > App Settings > Pricing Customizations
-
Enter the UDF column name used (e.g.,
UDF8) into the Volume Pricing Group Column Name field -
Click Save Changes and then Push Data Live
-
-
Group Pricing Now Active
The group pricing discount will apply once the total quantity of grouped items in the cart meets the threshold.
❓ Frequently Asked Questions (FAQs)
Q: Can volume pricing be created directly in WebManager?
A: No, volume pricing must be set up using the import template.
Q: Can volume pricing be enabled for specific price levels only?
A: No, enabling volume pricing activates it for all price levels.
Q: What happens if I upload duplicate volume pricing rules for the same product and quantity?
A: The most recently uploaded rule will overwrite any existing rule for the same product and quantity combination.
Q: Can I apply both flat pricing and percentage-based pricing in the same volume pricing file?
A: No. If you choose to use percentage-based pricing (IsPercentage = TRUE), you must leave all PriceLevel fields blank. Mixing both types in one row will result in an error.
Q: How can I remove volume pricing from a product?
A: To remove volume pricing, upload a volume pricing record with IsDeleted set to TRUE for the relevant ItemID and quantity.
Q: Can I apply different volume pricing tiers for different customer types or accounts?
A: Volume pricing supports different PriceLevels (0–5), which can be associated with customer groups. Assign your customers to the appropriate price level to apply custom volume pricing.
Q: How often should I update volume pricing data?
A: Update your volume pricing as often as your pricing strategy changes. Always remember to Push Data Live in WebManager after uploading changes.
Q: Can group volume pricing and standard volume pricing be used together?
A: Yes. You can set up both standard and group-based volume pricing. If a product is part of a group and also has its own volume pricing rule, RepZio will calculate discounts based on the group settings once the group threshold is met.