This article is explain how our Processed Price File tool works and what are the benefits
Benefits
We have introduced an easier way for Dealerships to have access to import Vendor price files into their Blackpurl through the Processed Price Files tool
The benefits for the Dealership are:
- More control over when the Dealership want to import the price files at a convenient time to them
- Allows Users to see when the last update was completed
- Dealerships can email their price files to our price file team - pricefile@blackpurl.com
If you are emailing your price file to our price file team, please also include the following details:
| Your Dealership Name: | |
| Full Vendor Name | |
| BP Vendor Code: | |
| Is it a NEW Price File or update on an existing Price File? | |
| Any special requests? IE do you use Prefixes or Suffixes |
- Blackpurl will do the initial format settings (this is required as each Vendor price file format is different) and then make the price file available in the Processed Price Files tool
- Once the price file mapping is set by the Dealership, the same settings will be the default for next time - allowing consistency as well as the Dealership is responsible for setting their own markups etc
How the Processed Price Files tool works
- Once a new price file is received from the Dealership, Blackpurl will do the initial format settings (remember that each Vendor price file format is different) and then the price file will be available through the Processed Price Files tool
- When a new price file is available for importing, the Dealership will receive notification in the form of an
orange banner that will appear at the top of the Blackpurl Homepage:
**Only those Users with the User Permission: Price file import - will receive the notification and also be able to access the Processed Price Files tool
- This notification banner will remain on the Blackpurl Homepage until a User clicks on
and decides on what to do with the new price file updates - Skip this Update or Import Price File
How to use the Processed Price Files tool:
Scenario - a notification has been received on the Blackpurl Homepage that there is a price file available for import
- User will click
from the notification banner to access the Processed Price Files section
In the Processed Price Files section, the user can see a list of all the price files available to the dealership and what their statuses are:
Let's do a quick rundown:
A. A list of all the price files that your Dealership has access to
B. The status of each price file:
B. The status of each price file:
- Up to date - means that your Dealership has already imported the latest price file for that Vendor
- Update available - these are the price files that needs to be reviewed as there is an update available
- Never Imported - means exactly that, the price file has never been imported
C. The name of the price file in our Price File Repository
D. The Vendor associated with the price file as per Blackpurl Vendor Record - Vendor ID & Vendor
Name
F. The last date when this particular price file was imported using the Processed Price Files tool
- Using our scenario, the User can see that there is an Update available for import for Vendor: MC Distribution
- Click anywhere on the relevant price file tile and it will open up the price file mapping section
Two options:
- If you do not wish to import this particular price file, go directly to Skip this update - See item 5. in the screen shot below
If you choose to Skip this update, it will take you back to the Blackpurl Homepage
This will not delete the price file or update the price file - it will be available for you to import at a later date (if needed)
To access at a later date (if the notification banner is no longer appearing), from the Blackpurl Homepage > Other Tools > Processed Price Files
This will not delete the price file or update the price file - it will be available for you to import at a later date (if needed)
To access at a later date (if the notification banner is no longer appearing), from the Blackpurl Homepage > Other Tools > Processed Price Files
OR
- Go through the price file mapping section and make sure that all the settings are good to go so you can Import Price File
** Any settings you make, will be retained for next time
1. The Vendor associated with this price file
2. MSRP
- Use the
to make your selection of what column from the price file represents MSRP
- Add any relevant Markup percentage
You do not have to indicate any markups and if you do not indicated any markups then the MSRP will be the price as indicated on the price file
However you can add up to 11 mark up tiers
- Rounded - Are the results to be rounded? Change the indicator to suit
For example:
3. Retail
- Use the
to make your selection of what column from the price file represents Retail - Add any relevant Markup percentage
You do not have to indicate any markups and if you do not indicated any markups then the Retail will be the price as indicated on the price file
However you can add up to 11 mark up tiers
- Rounded - Are the results to be rounded? Change the indicator to suit
For example:
4. Cost
- Use the
to make your selection of what column on the price file represents Cost
- Add any relevant Markup percentage
You do not have to indicate any markups and if you do not indicated any markups then the Cost will be the price as indicated on the price file
However you can add up to 11 mark up tiers
For example:
**Other mapping fields may generate but these additional fields will only appear if the price file you are working with, references them. For example:
- Packaged parts
This is very important section if you have manually changed any package part section on Part Records.
For example:
You may have manually changed some of your Part Records to no longer be packaged parts and depending on what you answer next is whether or not importing the price file, will change the packaged part section on the relevant Part Records
- If you answer YES, then when you import the price file, it will override all your manual settings on the relevant Part Records as the packaged part section will update as per the details on the price file
- If you answer NO, this will tell Blackpurl not to override the manual packaged part settings on the Part Records even though the price file packaged part setting may differ
- Category
Vendors may indicate on their price file what category they want specific Part Records to be
It is important that you complete the Vendor defined category and map it to the relevant Blackpurl Category
You will also have the option to Force Category and if you want to force your existing part records to obey the new category settings.
5. If you do not want to import the price file, click on 
6. If you have finished the mapping information, click on 
- Once you have finalised the mapping settings and clicked on
and the system will ask for confirmation > click on 
The system will then start importing the price file
It is important that you do not close the Price File window until the import has run to completion
- Once the import has finished, the import result will load:
If the result shows Price file records that failed to import, please make sure you click on 
This will produce an Excel file that will list all parts that failed to import and why
Here is an example:
Here is an example:
Tip: If you need assistance with these errors, you will need to email this View Errors report (excel file) through to support@blackpurl.com
Click on
- This will take you back to the Processed Price Files section
For the price file you just updated, the status will change to Up to Date and amend the Last Imported date
At that point, you can choose to import a further price file or just exit from the Processed Price Files section
Further Information
- You can still manually import Vendor Price Files through Price File Import if that is what you prefer
For more information, please review our article - How to Import a Vendor Price File
- To access Processed Price Files (if there is no notification banner to click on) > from the Blackpurl Header > Other Tools > Processed Price Files
