Price Overrides: Import/Export

Price Overrides allow you to set the exact price for each Distributor SKU.   This feature grants you the ability to Import exact pricing for each Distributor SKU by way of CSV file.  

It also enables you to Export every single Price Override that you have in PSS at once.

PSS Home Page > File Center

On the left-hand menu under Price Overrides, click "Client: Import Price Overrides"

Step 1 - Download Template

Download the Compatible File Template which is in the blue hyperlink.  Open the File Template from your computer.

For this template and any others in PSS, make sure that you review the developer notes so that you can ensure that your file meets PSS specifications.

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.

*Make sure that you review the notes for using this template.  After you review the notes simply clear the contents of rows 3-7 so that you are working with an empty template.

Catalog.name

The catalog where the SKU that you are overriding exists.  Must be one of AFTERMARKET, OEM, PRIVATE

Source.name

This is the marketplace in which you want the override applied.  Must be one of Ebay, Amazon, Webstore, Walmart

If you want to override the price on both Amazon and eBay you will need to enter the SKU in question on two different lines; one for each marketplace.

DistributorPart.distributor_sku

The SKU from the distributor but in the PSS format with the proper prefix.  If you are unsure what the correct format or prefix is please visit this article on  SKU and MPN Definitions.

How do I get the distributor SKU into the PSS format?   Click Here

PriceOverride.price

The 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     Wrong way = $43.99

Correct way = 87.00     Wrong 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 in PSS.

Enter your email address if you want to be notified when the job is complete.  (optional).

Click Submit

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 PSS 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.

Extra Credit

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 

Paste Special - Text Only, Paste Values or Paste Unformatted Text.

Main Reasons That Files Fail

1. 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 last decimal of Price, no spaces after the marketplace.
2. Misspelled Marketplace.  Amazon spelled incorrectly, etc
3. Misspelled Catalog.  Aftermarket spelled incorrectly, etc