The Price List Updater Tool offers an quick and easy way for store owners to update item pricing in multiple price lists at once using a CSV file. This tool simplifies the otherwise tedious task of manual price updates, ensuring accuracy and saving valuable time for store owners.
Step 1: Create Your CSV FIle
The Price List Updater Tool allows you to update prices by uploading a CSV file.
To begin, you will first need to create a CSV file with your pricing data. Your CSV file can contain any of these supported fields:
- SKU – the item’s SKU, this is not the BigCommerce Product ID, but the actual SKU. Our tool does not require the use of the BigCommerce Product ID. SKUs for variants can be entered as well.
- price – the regular selling price of the item for customers assigned to the specific price list.
- This value does NOT impact the default price on the item for customers not assigned a price list.
- sale-price – the sale price of the item for customers assigned to the specific price list.
- This value does NOT impact the sale-price price on the item for customers not assigned a price list.
- If you leave the sale-price field empty, no changes to the existing sale price will be made.
- If you place a 0 in the sale-price field, the sale price will be removed from the item.
- retail-price – if you use the MSRP field, you can update that value via your CSV.
- map-price - the MAP (Minimum Advertised Price) for the item in the price list. Setting a value will override any existing or Catalog MAP price for the variant/product. If empty, the map-price will be treated as not being set.
- price-list - the EXACT name of the price list in your BigCommerce store that you want the pricing data updated on.
When creating your CSV file, as mentioned above, the name of the price list must be an exact match to the name in your BigCommerce store. If the price list name is not an exact match, you will receive an error.
You can update multiple price lists at once with one CSV file, however, the update must be contained on a separate line as shown in the example below:
Step 2: Launch Tool & Select File
To begin, launch the Price List Updater Tool from the tile on the Your Store Tools dashboard.
Step 3: Map Your Fields
Map the columns in your CSV file to the appropriate fields, then click Next.
Step 4: Select Your Notification Type and Submit
By default, Your Store Tools will provide a notification on the dashboard as well as a notification via email when the job is complete. If you choose not to receive a notification via email, you can turn this option off on this screen, or change the email address it will be sent to.
Once your selection is made, click Submit to finish.
Additional Tool Features
By accessing the stacked menu in the upper right corner of the tool's tile from the dashboard, you can access the following:
- History - a list of the last 7 days of processing history for this tool.
- Help - a link to this support document.
Additional Options for Premium Plan Subscribers
Scheduling a Tool to Run at a Later Day and Time
Premium subscribers have access to schedule tools to run in advance. This option will be displayed after you set your notification type.
By default, the scheduling option is set to No. If you do not want to schedule the tool, click Submit.
If you want to schedule the tool to run at a later time, click Yes.
From here you can select to schedule the tool to run at a specific date and time:
The scheduled start time is the time the tool will run, not complete.
Once you set the day and time for the tool to run, click Submit.
Scheduling a Tool to Run on a Recurring Schedule
Premium subscribers have access to schedule tools to run in advance. This option will be displayed after you set your notification type.
By default, the scheduling option is set to No. If you do not want to schedule the tool, click Submit.
If you want to schedule the tool to run at a later time, click Yes.
From here you can select to run the tool on a recurring basis:
Options for recurring jobs include:
- Schedule Start Date and Time: The day and time the first instance will run.
- Repeat: The recurring schedule for this tool, which can be:
- Daily
- Weekly
- Monthly
- Specify Hour: The hour of the day the tool will run.
- Times are based on the time zone set up in your Company Profile.
- Recurring runs can only be schedule at the top of the hour.
- Ends: When the recurring job should stop. Options include:
- Never
- After a set number of runs have completed
- On a specific date and time
The scheduled start time is the time the tool will run, not complete.
Once your recurring options are set, click Submit.
Scheduling the Update Guest Order Tool to Automatically Check Historical Orders
In addition to the regular scheduling option available on all tools with the premium plan, the Update Guest Order tool allows store owners an additional scheduling option for checking historical orders on a regular, recurring basis.
This additional schedule, allows you to do the following:
- Schedule a daily run to check and associate orders from the previous day.
- Schedule a weekly run to check and associate orders from the previous day, week, two weeks, or three weeks.
- Schedule a monthly run to check and associate orders from the previous day, week, two weeks, three weeks, month, two months, or three months.
In order to use this method for scheduling, you must set the schedule by going to the tool's tile in the Your Store Tools dashboard and select Create Schedule from the stacked menu:
From there you can schedule the tool to run on a daily, weekly, or monthly basis.
Did you find an error or need additional support? Contact us at support@yourstorewizards.com to let us know!