Read these warnings carefully before importing any price file. Mistakes made during a manual import can cause data loss that Blackpurl Support cannot reverse, and corrections may be billable to your dealership.

Complete all of the following before starting the import.
​

1. The vendor must already exist in Blackpurl. To create a new vendor, see Add and Edit Vendors in Blackpurl.
​

2. The price file must be in CSV format (.csv — comma-separated values).
​

3. The price file must include, at a minimum, these columns:

4. The price file data must be clean before importing:

​

In the Blackpurl header, click Tools, then select Price File Import.
​

This opens the Parts > Price Files section. Click Manual Import to begin.
​

​

Click in the Search for a vendor field and start typing the vendor's name. When the vendor appears in the search results, click to select it.
​

​

Once the vendor is selected, the Add your Price File section opens. Drag and drop your CSV file into the upload area, or click Browse to locate and select the file.
​

​

After the file is uploaded, review the Import Settings screen and confirm the following before continuing.
​

1. Confirm the correct vendor is listed. You can cancel at any time.
​

2. Confirm the correct price file is shown.
​

3. If the wrong file was uploaded, remove it and re-upload the correct one.
​

4. Check whether the field labels (column headers) appear at Record 1 in the preview section. Field labels are the column headers from your CSV file — for example, Part No., Description, Cost, Retail.
​

5. Review the data preview to confirm the file contents look correct.
​

Once you have reviewed the settings, click Next to continue to Field Mapping.
​

Field Mapping tells Blackpurl which column in your price file corresponds to each field in the system. Work through each field and select the matching column from your price file.
​

For example, if your price file has columns labelled Part No., Description, Cost, and Retail, the mapping would be:

If there is no matching column for a particular field, select None for that field.
​

​

If your price file includes a Packaged Qty column, map the Package Qty field to that column. Additional checkboxes will appear asking whether the cost and retail price shown in your file are per item (rather than per pack), and whether you want to override any existing packaged part settings already saved on part records in Blackpurl.
​

For example, if Part #XYZ has a Cost of $10 and a Retail Price of $15 and comes in a pack of 10, you need to confirm: are those prices for the full pack of 10, or per individual item? If Part #XYZ already exists in Blackpurl as a non-packaged part, do you want to override that setting? If you are unsure how to answer these questions, contact the vendor who supplied the price file.
​

If your price file includes a supersession column, the mapping depends on what that column contains:

Once all fields are mapped, review the preview screen to confirm the mappings are correct. When you are satisfied, click Submit to proceed.
​

​

Blackpurl will display a confirmation dialog asking you to confirm that you want to process the price file import. Review the details, then click Confirm Processing to begin the import.
​

​

Blackpurl imports the price file according to the field mappings you provided and displays the progress of the import on screen.
​

​

When the import finishes, Blackpurl displays a completion screen confirming that the price file import is complete and showing a summary of the results — including how many records were processed.
​

​

If you want to calculate MSRP and/or Retail Price using tiered markup rather than importing a fixed price from the file, select Calculated Value instead of a column when mapping the MSRP or Retail field. A new section opens at the bottom of the Field Mapping screen where you can enter the markup tiers and any other required information.
​

​

Contact Blackpurl Support in any of the following situations: