Price List Bulk Pricing Updater Tool for BigCommerce
🔧 Quick Info: Price List Bulk Pricing Updater creates, updates, or removes quantity-break pricing tiers inside existing BigCommerce Price Lists from a CSV or Excel spreadsheet.
What It Does
Price List Bulk Pricing Updater manages the quantity-break pricing tiers stored inside your BigCommerce Price Lists.
BigCommerce Price Lists let you assign different pricing to customer groups, wholesale customers, storefronts, or other pricing audiences. This tool updates the bulk-pricing tiers within those lists from a spreadsheet.
You upload a CSV or Excel file, map its columns to the required fields, and the tool creates or updates each matching Price List record. You can also remove an existing quantity tier by entering delete in the Amount column.
Price List Bulk Pricing vs. Product Bulk Pricing: This tool changes quantity tiers inside a named BigCommerce Price List. To manage bulk pricing directly on a product, use the Bulk Pricing Updater.
The update runs as a background job, so you can close the page after starting it. When the job is complete, you’ll receive an email notification. Any rows that could not be processed are included in an error report.
When Should You Use This?
- You use BigCommerce Price Lists for customer-group, wholesale, contract, or tiered pricing.
- You need to create or update quantity-break tiers for many SKUs at once.
- You want to remove selected bulk-pricing tiers from a Price List.
- You exported your existing Price List bulk pricing, edited the spreadsheet, and want to import the changes back into BigCommerce.
- You prefer managing quantity tiers in a spreadsheet instead of editing Price List records individually.
A common workflow is to first use Export Price List Bulk Pricing, edit the exported file, and then use this tool to apply the changes.
Before You Get Started
- Your BigCommerce store must be connected to the tool.
- Your store connection must have permission to read and update Price Lists through the BigCommerce API.
- The Price List named in each row must already exist in BigCommerce.
- Each SKU must already have a default or base price in the named Price List before a bulk-pricing tier can be added.
- Prepare your file in CSV or Excel format.
- The first row of the file must contain column headers.
- Your file must include SKU, Min Qty, Type, Amount, and Price List Name columns.
Default Price Required: A SKU must already have a base price in the named Price List before the tool can add quantity-break tiers. Set the default Price List price in BigCommerce first or use the Price List Updater tool.
How to Use It
1 Open the Tool
Open Price List Bulk Pricing Updater from your BigCommerce tools dashboard.
2 Upload the File
On the Upload Price List Bulk Pricing step, upload your CSV or Excel spreadsheet.
You can also import a file from a URL when that option is available.
The tool reads the first row of the file to identify the available column headers.
3 Map the Columns
After the file is uploaded, match each spreadsheet column to the corresponding tool field.
All five fields are required:
- SKU
- Min Qty
- Type
- Amount
- Price List Name
4 Confirm Email Delivery
Continue to the Email Delivery step and confirm the address where the completion notice should be sent. Change the address if necessary.
5 Start the Update
Submit the update. The tool processes the spreadsheet as a background job, so you can close the page while it runs.
6 Review the Results
When the job is complete, check your email for the completion notice.
If any rows could not be processed, download the error report, review the reported problem, correct the affected rows, and import them again.
How Rows Are Grouped
The tool groups rows first by Price List Name and then by SKU.
All rows for the same Price List and SKU are combined to build that record’s complete set of quantity tiers. The tiers are ordered by Min Qty.
| Price List Name | SKU | Min Qty | Type | Amount |
|---|---|---|---|---|
| Wholesale | ABC-100 | 10 | percent | 5 |
| Wholesale | ABC-100 | 25 | percent | 10 |
| Wholesale | ABC-100 | 50 | percent | 15 |
If the complete set of tiers in your file already matches the tiers stored in BigCommerce, the SKU is left unchanged.
How Quantity Ranges Are Calculated
You only provide the minimum quantity for each tier. The tool calculates each tier’s maximum quantity automatically using the next tier’s Min Qty.
| Min Qty in File | Calculated Quantity Range |
|---|---|
| 10 | 10 through 24 |
| 25 | 25 through 49 |
| 50 | 50 and above |
No Maximum Quantity Column Needed: Enter each tier’s starting quantity in Min Qty. The tool determines where the tier ends from the next quantity break.
Bulk Pricing Types
| Type | How Amount Is Applied |
|---|---|
price |
Sets a specific unit price for the quantity tier. |
percent |
Applies a percentage discount from the Price List’s default price. |
fixed |
Subtracts a fixed currency amount from the Price List’s default price. |
Removing a Quantity Tier
To remove an existing quantity tier, enter the following value in the Amount column for that Price List, SKU, and Min Qty combination:
delete
The tool removes that tier instead of creating or updating it.
Use Carefully: The value delete is treated as an instruction to remove the matching quantity tier.
File and Field Reference
The first row of your spreadsheet must contain column headers. All five fields below are required and must be mapped during the upload.
| Column | Required? | Notes |
|---|---|---|
| SKU | Yes | The product SKU. It must already exist and have a default price in the named Price List. Matching is not case-sensitive. |
| Min Qty | Yes | The minimum quantity at which the tier begins. Must be a whole number. The maximum quantity is calculated automatically from the next tier. |
| Type | Yes | Controls how the Amount is applied. Use price, percent, or fixed. |
| Amount | Yes | The value used for the tier. Currency symbols, commas, and spaces are removed automatically. Enter delete to remove the matching tier. |
| Price List Name | Yes | The name of the existing BigCommerce Price List to update. Matching is not case-sensitive. |
Troubleshooting and FAQ
The error says the Price List was not found
The Price List Name in the file does not match an existing BigCommerce Price List. Confirm that the Price List exists and check the name for spelling, punctuation, or extra spaces.
Name matching is not case-sensitive, but the remaining characters must identify the correct Price List.
The error says a default price must first be set for the SKU
The SKU does not have a default or base price in the named Price List. BigCommerce requires that base record before quantity tiers can be added.
Set a default Price List price in BigCommerce or use the Price List Updater tool, then import the quantity tiers again.
Nothing changed for some SKUs
If the complete set of quantity tiers in your file already matches the tiers stored in BigCommerce, the tool leaves that SKU unchanged.
How do I remove a quantity tier?
Enter delete in the Amount column for the matching Price List Name, SKU, and Min Qty row.
The amount contains currency symbols or commas
The tool automatically removes currency symbols, commas, and spaces from the Amount value before processing it. Make sure the remaining value is a valid number for the selected pricing type.
The quantity ranges are not what I expected
Review the Min Qty values for all rows belonging to the same Price List and SKU. The tool orders those values and sets each tier’s maximum quantity based on the next tier’s starting quantity.
Where do the results go?
Successful changes are written directly to your BigCommerce Price Lists. When the background job is complete, you’ll receive an email notification. Rows that could not be processed are included in an error report.