Keep your part pricing current by importing vendor price files. Blackpurl offers three approaches: manual upload for complete control, processed files where Blackpurl handles formatting, and automated integrations for hands-off updates.
Choose Your Import Method
Method | Best For | Setup Effort |
Processed Price Files | Most dealerships - Blackpurl formats the file, you control when to import | Low - email file to Blackpurl |
Manual Import | Full control over file format and mapping | Medium - you handle formatting |
Automated (Turn 14) | Nightly automatic updates | One-time setup with vendor |
Processed Price Files (Recommended)
Blackpurl formats vendor price files and makes them available for import at your convenience.
How It Works
Email your price file to [email protected] with:
Dealership Name
Full Vendor Name
BP Vendor Code
New file or update to existing?
Special requests (prefixes, suffixes)
Blackpurl formats the file and adds it to your Processed Price Files queue
When ready, you map the pricing fields and import
Check for Available Updates
A notification badge on the Price Files tab in Parts Workspace shows how many files are ready.
Go to Tools > Price File Import and scroll to the Processed Price Files section. Look for tiles showing Update Available.
Pro Tip: Only users with the Price file import permission see notifications and can access this tool.
Import a Processed Price File
Go to Tools > Price File Import
In the Processed Price Files section, click the tile showing Update Available
Configure your pricing mappings:
MSRP Mapping:
Select the column representing MSRP
Add markup percentage tiers (up to 11 levels)
Enable Rounded to round results Retail Mapping:
Select the retail price column
Add markup tiers if desired
Enable rounding as needed Cost Mapping:
Select the cost column
Add markup tiers if applicable
Review additional mappings if present:
Packaged Parts - Critical if you've manually changed package settings on part records
Categories - Map vendor categories to Blackpurl categories
Click Import Price File
Import Queue and Status
After clicking import, files enter a processing queue that runs every 10 minutes.
Status Indicators:
Update Available - New version ready to import
Queued - Waiting in import queue
Processing - Currently importing
Completed - Successfully imported
Completed with Errors - Imported but some items failed
Handle Import Errors
If you see Completed with Errors:
Click the error icon on the tile
Review the summary showing successful vs. failed items
Click Export to download a CSV of failed items
Review why items failed (duplicates, invalid data, etc.)
Decide whether to add failed parts manually
Manual Price File Import
Import your own formatted price files when you need complete control.
Before You Start
⚠️ Critical Warnings:
Don't import files without pricing data - Importing a file without Cost/Retail/MSRP will zero out existing prices on those part records. Blackpurl cannot restore previous pricing.
Watch for leading zeros - Opening CSV files incorrectly in Excel drops leading zeros. Part number 0012563 becomes 12563.
One vendor per file - Don't combine multiple vendors in one price file.
Data fix costs - If you need Blackpurl Support to fix a bad import, it may be billable.
File Requirements
Format: Comma-separated values (.csv)
Required columns: Part Number, Description, Cost, Retail Price, MSRP
Clean data: Remove dollar signs, currency symbols, commas from price columns
Remove unnecessary columns and random characters
Import Process
Go to Tools > Price File Import
Search for and select the vendor
Drag and drop your file or click to browse
Confirm Field labels are at Record 1 if your file has column headers
Preview the data and click Continue
Map Your Fields
Tell Blackpurl which columns match which fields:
Blackpurl Field | Map To |
Part Number | Your part number column |
Description | Your description column |
Item Cost | Your cost column |
Retail | Your retail price column |
MSRP | Your MSRP column (can be same as Retail) |
Select NONE for fields that don't have a corresponding column.
Markup Options: For Retail and MSRP, you can apply percentage markups with up to 11 tiers based on cost ranges.
Package Quantity: If your file includes packaged parts:
Map the Package Qty column
Specify if costs/prices are per-item or per-package
Choose whether to override existing package settings on part records
Automated Price Files (Turn 14)
Set up automatic nightly imports from Turn 14 - no manual intervention required.
Turn 14 Setup
Log in to turn14.com
Go to Settings & Data > API tab
Complete and agree to Terms & Request Access
Select Blackpurl as your Integration Partner and save
Request Production access (admin only)
Wait for Turn 14 approval (under 24 hours)
Record your API credentials when issued
Blackpurl Setup
Submit the Request Turn 14 Automated Price File form at the Blackpurl request portal with:
Turn 14 Account Number (Dealer ID)
Client ID
Client Secret
Blackpurl Support completes the configuration and notifies you when active.
How Automated Updates Work
Once configured:
Blackpurl retrieves Turn 14's price file nightly
Updates import automatically to your part records
Check status at Tools > Processed Price Files
The Turn 14 tile shows:
Automatic badge
Last Import Date
Status: Review Import / Up to date / Review errors
If errors occur, click the error icon to see summary and export failed items for review.
Bottom Line
Processed Price Files give most dealerships the best balance of convenience and control - Blackpurl handles the formatting headaches while you decide exactly when to import and how to configure markups. For Turn 14 dealers, the automated integration eliminates price file management entirely.