Price List Updater Tool for BigCommerce
? Quick Info: You can import product price list records from a file, that will update or create product price list records.
In BigCommerce, a Price List lets you assign a custom set of 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 (for example, wholesale buyers, a loyalty group, or a particular sales channel). Each entry in a price list ties a product SKU to one or more prices (regular price, sale price, retail price, and MAP price).
This tool lets you update those price list entries in bulk from a spreadsheet, instead of editing them one at a time in BigCommerce.
What it does
- Reads a spreadsheet you upload (or fetch from a URL) and matches each row to an existing price list and product SKU in your store.
- Creates or updates the price list record for each matching SKU, so the new prices take effect for the customers and storefronts attached to that price list.
- Can remove a SKU from a price list when you enter
deletein the Price column. - Runs in the background and, if you turn email delivery on, emails you when it finishes, including a report of any rows that couldn’t be processed.
When to use it
- You need to change many price list prices at once (a seasonal sale, a wholesale price refresh, a cost-driven repricing).
- You’re managing several price lists and want to update them all from a single file.
- You want to clear specific SKUs out of a price list in bulk.
Before you start
- Make sure the price lists you reference already exist in BigCommerce. This tool updates entries in existing price lists; it does not create new price lists. A row pointing at a price list name that doesn’t exist will be reported as an error.
- 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 make sure it includes at least SKU, Price, and Price List Name columns.
- This is a paid tool. If it isn’t active for your store yet, you’ll be prompted to add it to your plan.
Step-by-step
1 Open the Price List Updater tool for your BigCommerce store.
2 On Upload Price Updates, upload your spreadsheet (or provide a file URL). Remember the first row must be your headers.
3 Once the file is read, the Match your file’s columns screen lists each column in your file. Pick the matching field for each one (Price List Name, SKU, Price, Sale Price, Retail Price, Map Price); most are matched automatically. Only Price List Name and SKU are required.
4 On the email delivery step, choose whether you’d like a completion notice by email. Delivery is off by default; your account email is prefilled if you turn it on.
5 Start the run. The import is processed in the background.
6 When it finishes, and if you turned email delivery on, check your email for the confirmation and the error report (if any rows had problems).
File / field reference
Your file’s first row must be headers. After upload, you map your columns to these fields:
| Column | Required? | Notes |
|---|---|---|
| Price List Name | Required | 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. |
| SKU | Required | Must match a product (or variant) SKU in your store. SKUs that aren’t found are skipped and reported. |
| 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. |
| Sale Price | Optional | A number. |
| Retail Price | Optional | A number. |
| Map Price | Optional | A number (minimum advertised price). |
Notes:
- Price list names and SKUs are matched without regard to capitalization.
- Up to the BigCommerce limit, records are sent in batches, so large files are supported.
Troubleshooting / FAQ
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 exists.
I want to remove a price for a SKU.
Put delete in the Price column for that row. The record is removed from the price list.
My prices included currency symbols or commas.
That’s fine. Symbols like $ and £, plus commas and spaces, are removed before the price is saved.
Nothing happened immediately.
The work runs in the background. If Email Delivery was set to “Yes,” you’ll get an email when it’s done, along with a report of any rows that couldn’t be processed.