Table of Contents
Updated by Patrick Mares
If you sell OEM parts using our Ecommerce or Legacy Ecommerce systems, you can upload and apply custom prices by following the instructions below.
Price Upload Files
PSPRICE files are standard format CSV files with the .psprice file extension. All fields are required in each row:
- Brand Name: Brand Name indicates which Catalog the price file import will attempt to update.
- Rows that do not exactly match Part Number AND Brand Name to an Ecommerce item will not be imported.
- Part Number: Manufacturer Part Number or SKU.
- Cost: The cost from your manufacturer. If you do not wish to enter this value enter 0.
- Cost will not affect prices customers see, as imported prices override calculated prices.
- Dealer Price: The price you will charge for the item as a dealer.
- Call Us: Enter FALSE to display prices normally. Enter True to replace price with "Call Us".
Create a PSPrice file using Microsoft Excel
- Open the price file you received from the OEM in Excel. This price file should be in .CSV or .XLS format
- Create a new file in Excel and copy the data you need.
- Copy the name of the Catalog you are importing to in each row of Column A (do the other columns first if you do not know how many rows you will need).
- Paste Part Numbers in Column B
- Paste your dealer cost value in Column C.
- Paste your Customer Price Value in Column D
- Copy FALSE in each row of Column E if you wish to display prices.
- If you wish customers to call for prices on some or all parts enter TRUE in corresponding rows of Column E.
- Update the file so the first row contains the following headers: Brand Name, Part Number, Cost, Price, Call Us. There should be no spaces, commas or other characters before or after the header names.
- Paste the following Excel formula into the first cell in Column F
- Copy the cell in Column F with the Excel formula and paste it into every cell till you reach the bottom row. This will extract the data you need from each row with the correct format.
- Next we'll download the .psprice file. Log into Ecommerce.
- Go to Settings > Parts Manager
- Select "Upload Price File".
- Select "Download File Template" to download the price.psprice template file.
- Open the downloaded price.psprice file and paste the contents of Column F from your new Excel document in place of the headers. You should not see any change in the header row.
- Save price.psprice.
- In your Ecommerce interface use the Select File button and choose your edited .psprice file.
- Click Process Price File.If the upload is unsuccessful, the status will read as “Unsuccessful Download”. If this happens, go to the appropriate row under Upload History and find the link labeled "Download Error Log" to download an error log. You can also re-open your price file and manually check for any errors (like extra spaces in your headers or incorrect Call Us values).
- Error Message: Please verify column header and delimiter are in proper format in file
Brand Name,Part Number,Cost,Price,Call Usconfirm the first row of the file you uploaded matches these headers.
- Confirm Cost and Price fields contains only numbers and decimal points.
- Confirm all fields contain data.
- Confirm Call Us field contains exactly: TRUE or FALSE.
- Prices fail to update without an error. This typically indicates the file was formatted correctly, but the information in the file did not match the parts you intended to update OEM Part prices for.
- Confirm Brand Name is the exact catalog name.
- Confirm Part Number in .psprice file matches OEM part number visible on your website.