HOW TO IMPORT A VENDOR PRICE FILE
- 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
- The relevant Vendor must have already been created in Blackpurl.
- The Price File file format must be comma-separated values (.csv) file.
- The Price File must include as a minimum the following:
- Part Number
- Retail Price
- 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
- 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:
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)
5. Review the Preview of Price File to Import
- Time to do the Field Mapping.
- 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
- Retail field in Blackpurl = the Retail column (Column D) from the Price File
It maybe the case that there is nothing to map to a particular field - so just select NONE
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
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
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
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
- The system will ask for you to confirm the importing of the Price File into Blackpurl:
- 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:
If you have any issues in uploading the price file, please email the price file and vendor details to firstname.lastname@example.org
If you have price files that requires different parts to have different categories, then please contact email@example.com and one of our support team members will get in contact with you to find out your requirements.