1. Home
  2. Docs
  3. DataManager RT
  4. Importing
  5. Parts – Pricing Import

Parts – Pricing Import

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.

Print this article
Was this article helpful to you? Yes No

How can we help?