🔧 Quick Info: This tool updates quantity-break pricing tiers inside your BigCommerce Price Lists from a spreadsheet. Upload a file with Price List Name, SKU, minimum quantity, discount type, and amount, and we’ll create or update each tier.
Note: This tool updates quantity-break pricing tiers inside a named Price List (for customer groups or storefronts). If you manage bulk pricing directly on the product instead, use the Bulk Pricing Updater tool.
What It Does
This tool bulk-updates the quantity-break pricing tiers inside your BigCommerce Price Lists. Price Lists let you give different prices to different customer groups or storefronts; this tool sets the bulk (quantity-break) tiers within those lists from a spreadsheet. You upload a file with Price List Name, SKU, and tier details, map your columns, and the tool creates or updates each price list record to match. Rows are grouped by Price List Name and SKU to build each record’s full set of tiers, ordered by minimum quantity. If your tiers already exactly match what’s in BigCommerce, that SKU is left unchanged. The tool runs in the background and emails you when it finishes with a report of any rows that couldn’t be processed.
When Should You Use This?
Use this tool when you run customer-group or wholesale pricing through Price Lists and need to update quantity breaks in bulk. Common scenarios include running a seasonal quantity break promotion, updating wholesale tier pricing, or exporting your current price list bulk pricing, editing it, and pushing it back to your store.
Before You Get Started
- Your store must be connected to BigCommerce with the permissions this tool needs.
- The Price List must already exist in BigCommerce. Rows naming a price list that isn’t found will be reported as errors.
- Each SKU must already have a default (base) price set in the price list before you can add a bulk tier. If it doesn’t, the row is reported as an error – set a default price in the store first using the Price List Updater Tool.
- Prepare your file as CSV or Excel (.xlsx) with column headers in the first row, and include SKU, Min Qty, Type, Amount, and Price List Name columns.
- This is a paid add-on. If it isn’t active for your store yet, you’ll be prompted to add it to your plan.
How to Use It
1 Open the Tool
Navigate to the Price List Bulk Pricing Updater tool in your Your Store Wizards dashboard for your BigCommerce store.
2 Upload Your File
On the Upload Price List Bulk Pricing step, upload your CSV or Excel file or provide a file URL. The tool reads your header row to understand your file structure.
3 Map Your Columns
Once the file is read, match each of your spreadsheet columns to the tool’s fields. All five fields are required: SKU, Min Qty, Type, Amount, and Price List Name.
4 Confirm Email Address
On the email delivery step, confirm (or change) the address where we should send the completion notice.
5 Start the Update
Submit and the tool runs as a background job. You can close the page and work on other things. When it finishes, we’ll email you with a report of any rows that couldn’t be processed.
File and Field Reference
Your file’s first row must contain column headers. All five fields are required. Rows are grouped by Price List Name and then by SKU to build each record’s full set of tiers, ordered by minimum quantity. If your tiers already exactly match what’s in BigCommerce, that SKU is left unchanged.
| Column Name | Required? | Notes |
|---|---|---|
| Amount | Yes | The discount value for the tier. Currency symbols, commas, and spaces are stripped automatically. Enter the special value delete to remove that tier instead of setting it. |
| Min Qty | Yes | Whole number. The minimum quantity at which this tier starts. The tool automatically sets each tier’s max quantity from the next tier’s Min Qty. |
| Price List Name | Yes | The name of the BigCommerce Price List to update. Must match an existing price list (case-insensitive). |
| Sku | Yes | The product SKU. Must already exist with a default price in the named price list. Matched case-insensitively. |
| Type | Yes | One of price, percent, or fixed – how the Amount is applied (a set price, a percentage off, or a fixed amount off). |
Troubleshooting
“Price List … not found in your store”
The Price List Name doesn’t match a price list in BigCommerce. Check the exact name and make sure the price list exists.
“A default price must first be set for the SKU”
The SKU has no base price in that price list. Set a default price first using the Price List Updater Tool, then re-run this tool.
Nothing changed for some SKUs
Their tiers already match what’s in BigCommerce, so there’s nothing to update.
Removing a tier
Put delete in the Amount column for that row and the tool will remove that tier.
Permission errors
Check out our guide on resolving API permission errors.