This article will go through how a Dealership can manually import their own Vendor Price Files into Blackpurl
Warning
- Do not use this functionality to just import a list of part numbers and part descriptions as this will mean that your Cost / Retail / MSRP will all be zero
- If the part record already exists in your Blackpurl and you import a Vendor Price File without having Cost / Retail Price / MSRP, it will zero out your Cost / Retail / MSRP
If this happens Blackpurl will be unable to restore your previous Cost / Retail / MSRP
- Take care on how you open the csv file in Excel prior to importing especially if the part numbers have leading zeros
If you open up the file the incorrect way, the leading zeros can drop off and if you don't notice and import the file anyway, this means it will import with the wrong part numbers - example: Import as 12563 when the part number is actually 0012563
Prerequisite
- The relevant Vendor must have already been created in Blackpurl
To create a new Vendor, review our article - How to Create / Add a New Vendor
- The Price File file format must be comma-separated values (.csv) file
3. The Price File must include as a minimum the following columns:
- Part Number
- Description
- Cost
- Retail Price
- MSRP
- Please ensure that the Price File data is clean by removing any columns that are not required / delete any random words or characters etc
For example
- Please ensure that the dollar columns ie Cost / Retail / MSRP columns do not have dollar signs or indicate what currency etc - these must be removed as the price file tool will return an error and they will not upload
For example:
How to Import a Vendor Price File
- From the Blackpurl Header > click on
> then 
- Search for Vendor the price file is for by clicking in Search for a vendor field and start typing the Vendor's name
Once the relevant Vendor's name appears in the search result, click to select
- The Vendor will now list in the Select a vendor field and the add your price file section will open up to Drag and Drop or click on
to add your Price File
- Once the Price File has been added, review / confirm the information on the screen:
1. Review that the correct Vendor is listing (you can cancel out at any time)
2. Review that the correct Price file is being imported
3. Remove Price file if not the correct one
4. Review and confirm the Field labels are located at Record 1 on the preview section (5.) to
confirm
(Field labels are column headers on the Price File Import File itself - see below)
5. Review the Preview of Price File to Import
Once reviewed click on 
to continue
to continue- Time to do the Field Mapping
This is basically where the columns from the Price File are mapped to particular fields in Blackpurl.
For example - this is a snapshot of our example Price File with the Field Lables / columns of Part No. / Description / Cost / Retail:
But what do the columns correspond to in Blackpurl?
Field Mapping is where the system is told that the:
- Part Number field in Blackpurl = the Part No. column (Column A) from the Price File
- Description field in Blackpurl = the Description column (Column B) from the Price File
- Item Cost field in Blackpurl = the Cost column (Column C) from the Price File
If you want markup or tiered pricing - see Additional Information at the bottom of this article
- Retail field in Blackpurl = the Retail column (Column D) from the Price File
If you want markup or tiered pricing - see Additional Information at the bottom of this article
- MSRP field in Blackpurl = as there is no MSRP on our Price File, you can select that the Retail column (Column D) from the Price File
If you want markup or tiered pricing - see Additional Information at the bottom of this article
Just work your way down each Field Mapping field ensuring that the correct mapping is selected for each field
It maybe the case that there is nothing to map to a particular field - so just select NONE
It maybe the case that there is nothing to map to a particular field - so just select NONE
For a simple price file such as our example above the mapping is very easy but you may get a price file with columns for Packaged Qty and Supersessions that will also need to be mapped
Packaged Qty
If you have a price file with a column that indicates there are Packaged Qty, you will need to map that column as well
Map the Package Qty field to what relevant column on your price file and then provide the system with additional information about the Packed Qty
The additional checkboxes are basically asking if the cost and price on the price file you are uploading is per item and if you want to override the part package setting already on existing part records
.
For example - your price file indicates that for Part # XYZ:
.
For example - your price file indicates that for Part # XYZ:
- Cost - $10
- Price / Retail Price - $15
- It comes in as a package part of 10 items BUT Part # XYZ part record already exists in Blackpurl and it indicates that it is NOT a packaged part
Is the Cost and Price/Retail Price for a pack of 10 or is the Cost and Price/Retail Price per item?
Do you want to override the package part details on existing part records to now reflect what the Price File has?
If you are unsure how to answer the additional questions, contact the Vendor who supplied the price file
Superseded Parts
Superseded Parts
The mapping for Superseded parts will depend on your price file
Does the superseded column indicate that the part has been superseded and it indicates the new superseded part number that is replacing it?
Does the superseded column indicate that the part has been superseded and it indicates the new superseded part number that is replacing it?
- If so you will need to map the field Replaced by Part# to that column
OR
Does the superseded column indicate that the part is the superseded part?
Does the superseded column indicate that the part is the superseded part?
- If so you will need to map the field Replaces Part# to that column
- Once you have finished the Field mapping, review the preview screen
Once you are happy with the Field mapping, click on 
- The system will ask for you to confirm the importing of the Price File into Blackpurl:
If you wish to proceed, click on 
- Blackpurl will now import the Price File as per the Field Mappings that were provided and show the progress of the import:
- Once the Price File import has finished, the system will confirm the results:
Additional Information
- Tiered Markup
If you are looking to add tiered Markup for MSRP and /or Retail, when mapping the columns, you will need to select Calculated Value instead of the column in the price file
A new section will open at the bottom of the page that you will need to fill out
For example:
The new section will require you, to fill out the relevant information ie markup tiers etc
- If you have any issues in uploading the price file, please email the price file and vendor details to our Price File team - pricefile@blackpurl.com
- If you have price files that requires different parts to have different categories, then please submit a case to our Blackpurl Support team by emailing - support@blackpurl.com