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



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:

  

User-added image




**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 User-added imageand 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


  1. User will click  User-added image 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: 


  • 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 


  1. Using our scenario, the User can see that there is an Update available for import for Vendor: MC Distribution 


User-added image


  1. 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

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

User-added image
1.   The Vendor associated with this price file


2.   MSRP
  • Use the User-added image 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 User-added image 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 User-added image 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

User-added image

- 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.

User-added image
5.   If you do not want to import the price file, click on  User-added image
6.   If you have finished the mapping information, click on User-added image


  1. Once you have finalised the mapping settings and clicked on User-added image and the system will ask for confirmation > click on User-added image
User-added image
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


  1. Once the import has finished, the import result will load:
User-added image
If the result shows Price file records that failed to import, please make sure you click on User-added image


This will produce an Excel file that will list all parts that failed to import and why

Here is an example:


User-added image


 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 User-added image


  1. 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

User-added image
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


User-added image