🔧 Quick Info: This tool updates price list entries in bulk from a spreadsheet. Upload a file with Price List Name, SKU, and prices, and we’ll create or update each entry. Perfect for wholesale pricing, customer groups, or channel-specific prices.
What It Does
In BigCommerce, a Price List lets you assign custom prices to a specific group of customers or storefronts. Instead of every shopper seeing the same price, a price list overrides prices for the customers or channels it’s attached to – think wholesale buyers, loyalty groups, or a particular sales channel. This tool lets you update those price list entries in bulk from a spreadsheet instead of editing them one at a time. You upload a file with Price List Name, SKU, and the prices you want, and the tool creates or updates the price list records so the new prices take effect for the customers and storefronts attached to that price list. You can even remove a SKU from a price list by entering delete in the Price column. 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 whenever you need to update price list prices in bulk. Common scenarios include running a seasonal sale and needing to update prices across a price list, doing a wholesale price refresh, updating prices based on cost changes, managing several price lists and wanting to update them all from a single file, or clearing specific SKUs out of a price list in bulk.
Before You Get Started
- Make sure the price lists you reference already exist in BigCommerce. This tool updates entries in existing price lists; it doesn’t create new price lists. Rows pointing at a price list name that doesn’t exist will be reported as errors.
- Confirm your SKUs match the SKUs in your store. Rows with a SKU that isn’t found in BigCommerce are skipped and reported.
- Prepare your file so the first row contains column headers, and include at least Price List Name, SKU, and Price 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 Updater tool in your Your Store Wizards dashboard for your BigCommerce store.
2 Upload Your File
On the Upload Price Updates step, upload your spreadsheet or provide a file URL. Remember that the first row must contain your column headers so the tool can understand your file structure.
3 Map Your Columns
Once the file is read, map each column in your file to the matching field. Price List Name and SKU are required; the others are optional. Only map the price columns you actually want to update.
4 Confirm Email Address
On the email delivery step, confirm the address that should receive the completion notice. Your account email is filled in by default.
5 Start the Update
Submit and the import is processed in the background. You can close the page and work on other things. When it finishes, check your email for the confirmation and any error report if rows had problems.
File and Field Reference
Your file’s first row must contain column headers. After upload, you map your columns to these fields. Price List Name and SKU are required; the price fields are optional. Price list names and SKUs are matched without regard to capitalization.
| Column Name | Required? | Notes |
|---|---|---|
| Map Price | No | Minimum advertised price. A number. Currency symbols, commas, and spaces are stripped automatically. |
| Price | Optional | A number, or the word delete to remove that SKU’s record from the price list. Currency symbols ($, £), commas, and spaces are stripped automatically. |
| Price List Name | Yes | Must match the name of an existing price list in BigCommerce. If no matching price list is found, every row for that name is reported as an error. |
| Retail Price | No | A number. Currency symbols, commas, and spaces are stripped automatically. |
| Sale Price | No | A number. Currency symbols, commas, and spaces are stripped automatically. |
| Sku | Yes | Must match a product (or variant) SKU in your store. SKUs that aren’t found are skipped and reported. |
Troubleshooting
A row says the price list was “not found in your store”
The Price List Name in that row doesn’t match any existing price list in BigCommerce. Create the price list first, or correct the name to match exactly.
A row says the SKU was “not found in BigCommerce”
That SKU doesn’t exist in your store, so it can’t be updated. Check for typos or make sure the product/variant actually exists.
I want to remove a price for a SKU
Put delete in the Price column for that row. The record will be removed from the price list.
My prices included currency symbols or commas
That’s fine. Currency symbols like $ and £, plus commas and spaces, are automatically removed before the price is saved.
The run failed with a permission error
Your store’s API access may be missing the permissions this tool needs. Check out our guide on resolving API permission errors.
Nothing happened immediately
The work runs in the background. You’ll get an email when it’s done, along with a report of any rows that couldn’t be processed.