Price List Updater Tool for BigCommerce
🔧 Quick Info: Price List Updater creates, updates, or removes product and variant pricing records inside existing BigCommerce Price Lists from a CSV or Excel spreadsheet.
What Is a Price List?
A BigCommerce Price List lets you assign custom prices to a specific customer group, storefront, or sales channel.
Instead of every shopper seeing the same product price, a Price List overrides the standard catalog price for the customers or channels assigned to it. For example, you could use separate Price Lists for wholesale buyers, loyalty members, contract customers, or a specific storefront.
Each Price List record connects a product or variant SKU to one or more supported price values:
- Price
- Sale Price
- Retail Price
- MAP Price
What It Does
Price List Updater lets you manage Price List records in bulk from a spreadsheet instead of editing them one at a time in BigCommerce.
The tool reads a CSV or Excel file you upload, or retrieves a file from a URL. It matches each row to an existing BigCommerce Price List and a product or variant SKU.
For each matching row, the tool creates a new Price List record or updates the existing record with the prices included in your file.
You can also remove a SKU from a Price List by entering the following value in the Price column:
delete
Existing Price Lists Only: Price List Updater creates and updates records inside existing Price Lists. It does not create the Price Lists themselves.
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. If any rows could not be processed, the results include an error report explaining what went wrong.
When Should You Use This?
- You need to update prices for many products or variants in a Price List.
- You are preparing a seasonal promotion or customer-group sale.
- You need to refresh wholesale, contract, or loyalty pricing.
- You are changing prices because of updated product costs.
- You manage several Price Lists and want to update them from one spreadsheet.
- You want to add new product or variant records to existing Price Lists.
- You need to remove selected SKUs from one or more Price Lists.
- You exported your existing Price List pricing, edited the file, and want to import it back into BigCommerce.
A common workflow is to first use Export Price List Pricing, edit the exported spreadsheet, and then use Price List Updater to apply your 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.
- Every Price List named in your file must already exist in BigCommerce.
- Every SKU must match an existing product or variant in your store.
- Prepare a CSV or Excel spreadsheet.
- The first row of the file must contain column headers.
- Your file must include at least Price List Name, SKU, and one price field to update.
- Confirm that you are working with the correct connected store.
Subscription Required: Price List Updater is a paid tool. If it is not active for your store, you’ll be prompted to add it to your plan before you can run an update.
How to Use It
1 Open the Tool
Open Price List Updater for your connected BigCommerce store.
2 Upload the Price File
On the Upload Price Updates step, upload your CSV or Excel spreadsheet.
You can also provide a file URL when that option is available.
The first row of the file must contain the column headers.
3 Map the Columns
After the file is read, match each spreadsheet column to the corresponding Price List field.
Map the following identifying fields:
- Price List Name
- SKU
Then map any price fields you want to create or update:
- Price
- Sale Price
- Retail Price
- MAP Price
Columns you do not map are ignored.
4 Confirm Email Delivery
Continue to the Email Delivery step and confirm the address that should receive the completion notice. Your account email is filled in by default, but you can change it.
5 Start the Update
Start the run. The tool processes the spreadsheet as a background job, so you can close the page while it works.
6 Review the Results
When the update is complete, check your email for the confirmation.
If any rows could not be processed, download the error report, review the reason for each failure, correct the affected rows, and import them again.
How Rows Are Matched
Each row is matched using two values:
- The Price List Name identifies the Price List to update.
- The SKU identifies the product or variant record inside that Price List.
| Lookup Result | What Happens |
|---|---|
| Price List and SKU both found | The Price List record is created or updated with the mapped price values. |
| Price List not found | The row is skipped and reported as an error. |
| SKU not found | The row is skipped and reported as an error. |
| Price contains delete | The matching SKU record is removed from the Price List. |
Case-Insensitive Matching: Price List names and SKUs are matched without regard to capitalization. The remaining letters, numbers, punctuation, and spaces must still identify the correct Price List and SKU.
Removing a SKU from a Price List
To remove a product or variant record from a Price List, enter the following value in the Price column:
delete
The tool removes the matching SKU’s entire record from the named Price List.
Use Carefully: Entering delete in the Price column removes the record from the Price List. It does not simply clear the regular price while preserving the other Price List values.
Price Value Formatting
Price values must resolve to valid numbers. The tool automatically removes common formatting characters before saving them, including:
- Currency symbols such as
$and£ - Commas
- Spaces
| Value in File | Processed Value |
|---|---|
| $19.99 | 19.99 |
| 1,249.50 | 1249.50 |
| £ 89.00 | 89.00 |
File and Field Reference
The first row of your spreadsheet must contain headers. After uploading the file, map your columns to the fields below.
| Column | Required? | Notes |
|---|---|---|
| Price List Name | Yes | The name of the existing BigCommerce Price List to update. If no matching Price List is found, every row using that name is reported as an error. |
| SKU | Yes | The product or variant SKU. It must match an existing SKU in your BigCommerce store. |
| Price | No | The regular Price List price. Enter a number, or enter delete to remove the SKU’s record from the Price List. Currency symbols, commas, and spaces are removed automatically. |
| Sale Price | No | The Price List sale price. Use a numeric value. |
| Retail Price | No | The Price List retail or manufacturer’s suggested price. Use a numeric value. |
| MAP Price | No | The minimum advertised price for the Price List record. Use a numeric value. |
Large Files Supported: Price List records are sent to BigCommerce in batches up to the platform’s supported limits, allowing the tool to process large spreadsheets.
Troubleshooting and FAQ
The Price List was not found in the store
The Price List Name in the row does not match an existing BigCommerce Price List. Confirm that the Price List has already been created and review the name for spelling, punctuation, and extra spaces.
Matching is not case-sensitive, but the remaining characters must identify the correct Price List.
The SKU was not found in BigCommerce
The SKU does not match an existing product or variant in your store, so the row cannot be processed. Check for typing errors, spaces, or punctuation differences and confirm that the product or variant still exists.
How do I remove a SKU from a Price List?
Enter delete in the Price column for that Price List Name and SKU. The matching record is removed from the Price List.
My prices contain currency symbols or commas
This is supported. The tool removes common currency symbols, commas, and spaces before processing the price. Make sure the remaining value is a valid number.
Some price fields did not change
Only columns included in the file and mapped during the upload are processed. Unmapped columns are ignored.
Nothing happened immediately
The update runs as a background job. You do not need to keep the page open. Check the inbox and spam folder for the email address shown on the Email Delivery step.
Some rows could not be processed
Download the error report included with the completion results. Review the error for each failed row, correct the Price List Name, SKU, or price values, and import those rows again.