Skip to main content

Processed Price Files Tool

Learn how the Processed Price Files tool works, what benefits it offers, and how to import and map vendor price files in Blackpurl.

What Is the Processed Price Files Tool

The Processed Price Files tool gives dealerships a more controlled way to import vendor price files into Blackpurl. Instead of manually formatting each file, Blackpurl's price file team handles the initial format setup — then makes the file available for you to review, map, and import on your own schedule.

Benefits

The Processed Price Files tool offers the following advantages:

  • You control when price files are imported — choose a time that suits your dealership

  • You can see when the last update was completed for each vendor

  • You can email price files directly to the Blackpurl price file team at [email protected]

  • Blackpurl handles the initial format settings, since each vendor price file format is different

  • Once you complete the price file mapping, those settings are saved as the default for next time — ensuring consistency and giving you control over your own markups

Submitting a Price File to Blackpurl

When emailing your price file to [email protected], include the following details:

Your dealership name

The name of your dealership as it appears in Blackpurl

Full vendor name

The complete name of the vendor the price file is for

Blackpurl vendor code

The vendor code as set up in your Blackpurl account

New or existing price file

Confirm whether this is a new price file or an update to an existing one

Special requests

Note any special requirements, such as whether you use prefixes or suffixes on part numbers

How the Processed Price Files Tool Works

Once Blackpurl receives your price file, the team applies the initial format settings and makes the file available in the Processed Price Files tool. When a new price file is ready to import, a notification badge appears on the Price Files tab in the Parts workspace, showing the number of price files waiting to be imported. You can scroll through the list and look for any tile with a status of Update Available.

Screenshot showing the Blackpurl header with Tools dropdown menu expanded. A red box highlights 'Price File Import' opti


Note: Only users with the User Permission: Price file import will receive this notification and be able to access the Processed Price Files tool.

How to Use the Processed Price Files Tool

Step 1: Open the Tool

1. From the Blackpurl header, click Tools, then select Price File Import.

Screenshot of the Processed price files page showing a list of available price files with their vendor names, statuses,


This takes you to the Parts > Price Files section. The Processed Price Files list shows all price files available to your dealership and their current status.

Close-up screenshot of a single price file tile for 'MC Distribution' showing an 'Update available' status button in ora


Step 2: Select a Price File to Import

1. Find the vendor tile showing a status of Update Available.

2. Click anywhere on the tile to open the price file mapping section.

Large screenshot of the price file mapping interface for 'MC Distribution - Canada' showing numbered sections (1-6). Sec


Option 1: Skip This Update

If you do not want to import this price file right now, click Skip this update. This returns you to the Blackpurl homepage. The price file is not deleted — it remains available for import at a later date. To return to it when the notification banner is no longer showing, go to Blackpurl Header > Other Tools > Processed Price Files.

Option 2: Map and Import the Price File

Work through the mapping section to configure the price file settings before importing. Any settings you configure are saved and used as the default the next time you import from the same vendor.

The mapping section includes the following fields:

1. Vendor

This field shows the vendor associated with the price file.

2. MSRP

Screenshot showing MSRP section dropdown menu expanded with options like 'Price - Retail Price(Cad)' selected, and a tab
  • Use the dropdown to select which column in the price file represents MSRP.

  • Add a Markup percentage if required. If no markup is entered, the MSRP will match the price as listed in the price file. You can add up to 11 markup tiers.

  • Set the Rounded option to control whether results are rounded.

Screenshot of Cost section showing dropdown with 'Cost - Dealer Price(Cad)' selected and markup table with three tiers:


3. Retail

  • Use the dropdown to select which column in the price file represents Retail.

  • Add a Markup percentage if required. If no markup is entered, the Retail price will match the price as listed in the price file. You can add up to 11 markup tiers.

  • Set the Rounded option to control whether results are rounded.

Screenshot of Category mapping section showing a warning banner about changing categories potentially generating account


4. Cost

  • Use the dropdown to select which column in the price file represents Cost.

  • Add a Markup percentage if required. If no markup is entered, the Cost will match the price as listed in the price file. You can add up to 11 markup tiers.

Additional Mapping Fields

Some price files include additional fields that only appear when the price file references them. These may include:

Packaged Parts — This section is important if you have manually changed any packaged part settings on individual Part Records. When the price file includes packaged part data, Blackpurl will ask whether you want to force your existing Part Records to follow the price file's packaged part settings:

  • If you answer Yes, importing the price file will override your manual packaged part settings on the relevant Part Records.

  • If you answer No, Blackpurl will leave your manual packaged part settings unchanged, even if the price file specifies different values.

Category — Vendors may specify a category for each Part Record in their price file. Map each vendor-defined category to the relevant Blackpurl category. You also have the option to use Force Category to apply the new category settings to your existing Part Records.

Confirmation dialog titled 'Import MC Distribution' with text explaining the import process and warning not to close the


Step 3: Confirm and Queue the Import

1. Once you have completed the mapping settings, click Import Price File.

2. Blackpurl will ask for confirmation — click Confirm to proceed.

3. The price file is queued for importing. If you have multiple price files to import, repeat the mapping process for each one — each file will queue in order.

Once queued, you can return to your normal work. Blackpurl runs an automated process every 10 minutes that checks for queued price files and imports them in the order they were queued, as long as no other import is already in progress.

Step 4: Monitor Import Status

Status indicators on each vendor price file tile update as the import progresses:

  • Queued for import — The automated process has been triggered and the file is waiting to run.

  • Import in progress — Blackpurl is currently processing this price file.

  • Review import — The price file has been imported successfully. Click the status to view a summary of what was imported.

  • Review errors — The price file was imported but some line items failed. Click the status to see how many lines imported and how many failed.

Import results dialog showing 'Import USA:test price file' with statistics: 11 price file records processed, 9 part reco


Reviewing Import Errors

If some line items failed to import, click View errors to export a CSV file listing which line items did not import and the reason — for example, a duplicate part number.

CSV export table showing error details with columns for Part#, Field Name, and Error Message. Shows one row with part nu


Tip: If you need help resolving import errors, email the View Errors CSV file to [email protected].

Further Information

  • You can still manually import vendor price files using Price File Import if you prefer that method. For more information, see How to Import a Vendor Price File (no longer available).

  • To access Processed Price Files when no notification banner is showing, go to Blackpurl Header > Other Tools > Processed Price Files.

Did this answer your question?