Commodity Mappings CSV Format

Using a simplified CSV file format, you can import mappings from your ERP's source codes to Determination products using Commodity Codes. The Commodity Mappings import file applies only to existing products - those you created in Determination, or those you uploaded with Import/Export.

Traditionally, a product mapping maps your ERP codes to a product in the Determination product tree. This requires specifying the entire product path, which is cumbersome and error-prone. If you wish, you can use a commodity code to directly map to a product code.

The commodity code replaces a full product path in a product mapping. The CSV file specifies the commodity codes to map to a product code and whether it is a custom product. You can use this alternative method of mapping your source system product codes to either standard Determination products or to your own custom products as long as these products have a commodity code.

For information about using CSV format files, see Best Practices for Importing Data with CSV Files.

Example CommodityMappings File Format

SDITYPE=CommodityMappings-US
Column Name	Format	Req?	Description
CommodityCode	varchar2(100) (See Description)	Y	The commodity code in Determination. It is related to a product in the Determination product tree.
ProductCode	varchar2(100) (See Description)	Y	The source code passed in from your ERP system.
StartDate	mm/dd/yyyy	Y	The date (mm/dd/yyyy) on which the product mapping becomes active.
EndDate	mm/dd/yyyy	N	The date (mm/dd/yyyy) on which the product mapping terminates. If left blank, the mapping does not automatically end.
CustomProduct	varchar2(100) (See Description)	Y	Indicates whether the Product Mapping data applies to a Custom Product (Y) or a Tax Data Provider Product (N).

Example Commodity Mappings File

Commodity mappings can be created for US commodities. For example, this file maps three US commodity codes to three product codes with specific start dates, and indicates if it is a custom code:

1. sdiType=CommodityMappings-US

2. CommodityCode,ProductCode,StartDate,EndDate,CustomProduct

3. 4011724.11,Q45J,08/10/2015,,N

4. 700000,T567,09/01/2015,,N

5. AgProd,FRM-23,11/03/2015,,Y