Price List Bulk Pricing Updater Tool for BigCommerce
🔧 Quick Info: You can import product price list bulk price records from a file, that will update or create price list bulk price records.
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; this tool sets the bulk (quantity-break) tiers within those lists from a spreadsheet. You upload a file, map your columns, and the tool creates or updates each price list record to match.
Price List bulk pricing vs. Product bulk pricing: This tool changes tiers inside a named Price List. If you instead manage bulk pricing directly on the product, use the Bulk Pricing Updater.
When to use it
- You run customer-group or wholesale pricing through Price Lists and want to update quantity breaks in bulk.
- You exported your current price list bulk pricing, edited it, and want to push it back. (See Export Price List Bulk Pricing.)
Before you start
- 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 are 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 (or use our Price List Updater Tool).
- Prepare your file as CSV or Excel (.xlsx). The first row must be column headers and must include SKU, Min Qty, Type, Amount, and Price List Name.
Step-by-step
1 Open the Price List Bulk Pricing Updater tool from your dashboard.
2 Upload Price List Bulk Pricing — upload your file (or import from a URL). The tool reads your header row.
3 Match your columns — the Match your file’s columns screen lists each column in your spreadsheet. Pick the tool field for each one (SKU, Min Qty, Type, Amount, Price List Name).
4 Email delivery — choose whether you’d like an email when the job finishes (off by default; your account email is prefilled if you turn it on).
5 Submit. The tool runs as a background job; if you turned email delivery on, we email you when it’s done, including any rows that couldn’t be processed.
File / field reference
Map your columns to these fields. All five are required.
| Column | Required? | Notes |
|---|---|---|
| SKU | Yes | The product SKU. Must already exist with a default price in the named price list. Matched case-insensitively. |
| Min Qty | Yes | Whole number. The minimum quantity at which this tier starts. The tool sets each tier’s max quantity automatically from the next tier’s Min Qty. |
| Type | Yes | One of price, percent, or fixed — how the Amount is applied (a set price, a percentage off, or a fixed amount off). |
| Amount | Yes | The 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. |
| Price List Name | Yes | The name of the BigCommerce Price List to update. Must match an existing price list (case-insensitive). |
How rows combine: Rows are grouped by Price List Name and then by SKU to build each record’s full set of tiers (ordered by Min Qty). If your tiers already exactly match what’s in BigCommerce, that SKU is left unchanged.
Troubleshooting / FAQ
“Price List … not found in your store”
— the Price List Name doesn’t match a price list in BigCommerce. Check the exact name.
“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 (or use our Price List Updater Tool), then re-run.
Nothing changed for some SKUs
— their tiers already match what’s in BigCommerce.
Removing a tier
— put delete in the Amount column for that row.