Update Price Overrides by CSV Import
Updated by Patrick Mares
Price Override imports grant you the ability to Import exact pricing for each Distributor SKU in Aftermarket and Private Catalogs. They also enable you to Export every single Price Override that you have in place already.
If you are looking to update OEM pricing see Ecommerce OEM Price update by Price File Import.
Browse to File Center from the main navigation bar.
Step 1 - Download Template
On the left-hand menu under Price Overrides, click "Client: Import Price Overrides".
Download the Compatible File Template which is in the blue hyperlink. Open the File Template from your computer.
Step 2 - Populate Template with Data
Open the csv file that you just downloaded. This template has four (4) columns, some of which are optional. Below we offer an explanation of what each column header represents.
Catalog.nameThe catalog where the sku that you are overriding exists.
- If you are trying to override an aftermarket sku and you would enter AFTERMARKET (all caps)
- If you are trying to override a Private Catalog sku you would enter PRIVATE.
Source.nameThis is where you want the override applied. Enter Webstore (proper capitalization)
DistributorPart.distributor_skuThe sku from the distributor but in the software's format with the proper prefix. If you are unsure what the correct format or prefix is please visit this article pertaining to the Aftermarket Catalog and distributor prefixes.
How do I get the distributor SKU into the correct format with prefix? Click Here
PriceOverride.priceThe exact price that you want this SKU to display on the provided marketplace. Must be a valid decimal number. No $ symbol
Correct way = 43.99 Incorrect way = $43.99
Correct way = 87.00 Incorrect way = 87
Step 3 - Upload Your Data
When you click "Client: Import Price Overrides" you will see "Choose File" next to File Upload. Click this button to locate the file on your computer. Double click your file and it will be ready to go.
Enter your email address if you want to be notified when the job is complete. (optional)
Step 4 - Monitor Job Processing
You will want to monitor the Price Override Job that you just ran in File Center. The job will be in a Pending or Processing status until the system has completed it. These jobs typically take 30-60 minutes depending on the size of the csv file.
Once finished you will see the job Completed or Complete w/ Warnings. Click on the job and you will have access to a Processing Report. Open the report and the success or failure of each line item will be reported.
How to Clear a Price Override
You can clear an override by supplying an empty cell on the Price Override input.
Careful with your Copy/Paste
When you are working with multiple files and templates there is no doubt that you will do some copy and paste. Make sure that when you copy data that you do one of the following:
- Paste Special - Text Only
- Paste Values
- Paste Unformatted Text
Main Reasons for File Upload Failure
- Trailing space on the end of a cell value. Make sure there are no spaces after the last character on your Distributor sku, no spaces after the last decimal of price, no spaces after the marketplace.
- Misspelled Marketplace. Webstore spelled incorrectly, etc
- Misspelled Catalog. Aftermarket spelled incorrectly, etc
Export Applied Overrides
Next to the Import Price Overrides job you will also see an export option. This allows you to export all Price Overrides that exist in your application for future changes.