File format for international product mappings
Using a simplified CSV file format, you can import mappings from your ERP's source codes to Determination international product codes using the product path. The international product code mapping import file applies only to existing products - those you created in Determination, or those you uploaded with Import/Export.
A product mapping maps your ERP (enterprise resource planning) codes to a non-US product code in the product tree by specifying the entire product path. The CSV file specifies the product path to map to a product code and whether it's a custom product.
Example product mappings - INTL file format
Column name | Format | Required | Description |
|---|---|---|---|
ProductCode | varchar2(100) | Yes | The source code passed in from your ERP system. |
ProductCodeType | N/A | N/A | Leave blank. Reserved for future use. |
ProductPath | varchar2 | Yes | The product path in ONESOURCE Determination. It's related to a product in the product tree.
|
StartDate | mm/dd/yyyy | Yes | The date (mm/dd/yyyy) on which the product mapping becomes active. |
EndDate | mm/dd/yyyy | No | The date (mm/dd/yyyy) on which the product mapping terminates. If left blank, the mapping doesn't automatically end. |
CustomProduct | varchar2(100) | Yes | Indicates whether the product mapping data applies to a Custom Product (Y) or a Tax Data Provider Product (N). |
ProductCodeDesc | varchar2(100) | No | Provide product code description in this field. |
Example product mappings - INTL file
For example, this file maps 3 product tree paths to 3 product codes with specific start dates, and indicates if it's a custom code.
sdiType=ProductMappings-INTL,,,,,,
ProductCode, ProductCodeType, ProductPath, StartDate, EndDate,
CustomProduct, ProductCodeDesc
ACME,,Goods,08/10/2020,,N,Sold in Brazil
TOOLS,, Goods, 09/01/2020,,N,
SPORTWEAR,, Goods.Apparel and Luggage and Personal Care
Products.Clothing.Athletic Wear, 11/03/2020,,Y,
note
You can't use CSV files to update existing product code mappings.