The Pricing Import brings in price values for the Price Groups defined in the Catalog Settings.
The table shown below shows sample part numbers with values for Audiences – US Dealers and Canadian Dealers. The values in the audience would define whether the dollar value was US Dollars or Canadian Dollars (or Euros, or Pesos, etc.). The audience can be called anything, but the currency assigned when you create the audience will determine the currency indicator. For example, if you create a group to show prices in Euros, the dollar symbol would be irrelevant, the 1.00 or 5.00 would be treated as a Euro value. The dollar symbols shown here are for illustration purposes only.
Part Number | Audience | Cost | MSRP | As Of Date |
TEST PN 1 | Canadian Dealer | $1.00 | 7/18/2016 | |
TEST PN 1 | US Dealer | $5.00 | $6.00 | 7/18/2016 |
TEST002 | Canadian Dealer | $2.00 | ||
TEST003 | Canadian Dealer | $3.62 | $10.00 | 7/18/2016 |
TEST004 | Canadian Dealer | $4.00 | $9.00 | |
TEST005 | Canadian Dealer | $5.00 | $8.00 | 7/18/2016 |
TEST006 | Canadian Dealer | $6.00 | $7.00 | |
TEST007 | US Dealer | $7.00 | $6.00 | 7/18/2016 |
TEST008 | US Dealer | $8.00 | ||
TEST009 | US Dealer | $9.27 | $4.00 | 7/18/2016 |
TEST010 | US Dealer | $10.00 | $3.00 | |
TEST011 | US Dealer | $11.00 | $2.00 | 7/18/2016 |
TEST012 | US Dealer | $12.00 |
Some catalogs supply an MSRP value but no cost (or vice versa). This allowed and normal.
As Of Date is optional. If it is supplied, that value will be stored in the Data Manager data. If no value is supplied, the date the import was conducted will be used.
It is presumed part numbers named in this file will already exist in the data. Part numbers will NOT be added as part of this import. They will simply be ignored. When the import is run, a summary of parts that didn’t come in along with the reason will be shown in the Import History on the Parts – Pricing Import tab.
It may also be desirable, for clarity’s sake, to import one set of prices at a time. For example, you might decide to create one file with US Dealer pricing, import that one, then import another file for Canadian Dealer pricing, etc.