Use this format to send or receive product master data. This structure does not accomodate advanced structures like bills of materials. For those strucutres, use the JSON format.
To assemble the CSV file, concatenate all fields in the order they appear in this document from top to bottom.
| Name | Description | |||||||||
|---|---|---|---|---|---|---|---|---|---|---|
| Root | The top level document | |||||||||
| Product | A product is a representation of a physical item. Depending on which identifying fields are included in the specification, a product may represent a group of similar items like a style or an individual stock keeping unit.
| |||||||||
| Classification | A tariff classification for a particular country. | |||||||||
| UsEPA | Product related data for United States Environmental Protection Agency | |||||||||
| UsFDA | Product related data for United States Food & Drug Administration | |||||||||
| ClassificationUS | US-specific customs fields related to customs document. | |||||||||
| UsTTB | Product-related data for United States Alcohol and Tobacco Tax and Trade Bureau | |||||||||
| PackagingBreakout | Breakout used to convert outer and inner packages for an individual product like a 10 pack of socks. | |||||||||
| UsAPHIS | US Animal and Plant Health Inspection Service information |
| Name | Data Type | Description | Required |
|---|---|---|---|
product_id | String | Product identifier (often correlates to style) | |
sku | String | Stock Keeping Unit number. The lowest level of detail at which all products are the same. | |
upc | String | Universal Product Code number | |
product_name | String | Product name (like IPhone 11 Max) | |
product_description | String | A general description of the product | |
unit_of_measure | String | Unit of measure code used for maintaining product inventory. | |
unit_of_measure_description | String | Description of the unit of measure. | |
division_code | String | The code of the division responsible for selling the product | |
division_name | String | The name of the division responsible for selling the product | |
manufacturer_name | String | The name of the manufacturer providing the product. If sourced from multiple manufacturers, leave this blank and transmit on a per-shipment basis. | |
classification | Classification | A customs classification related to a specific country and import/export direction. | |
packagingBreakout | PackagingBreakout | The list of conversion codes an quantities to represent inner packages within a product |
| Name | Data Type | Description | Required |
|---|---|---|---|
country_iso | String | Country of the customs authority for which this classification applies. | |
special_program_indicator | String | Indicator that the product qualifies for a customs special program like a free trade agreement. | |
related_parties | boolean | Does the customs authority consider the buying and selling parties related? If this varies, leave blank and send on a per-shipment basis. | |
country_of_origin | String | The 2 - digit ISO code of the product's origin. | |
binding_ruling | String | The ruling reference from the customs authority. | |
ruling_type | String | The type of ruling reference from the customs authority. | |
import_export | String | Whether the classification is for import or export purposes. If not defined, assume it is for import. | |
manufacturer_id | String | The manufacturer's ID. For the United States, use the MID code. | |
supplier_id | String | The supplier's ID. | |
special_program_indicator_2 | String | The second special program indicator. | |
source_system_id | String | Record identifier in the system that hosts the master copy of this record. | |
description | String | The description to be presented to the customs authority. | |
currency | String | The 3-character ISO 4217 currency code. | |
ttb_indicator | String | US Alcohol and Tobacco Tax and Trade Bureau indicator. | |
price_per_unit | Decimal | Price per unit. | |
hts_code_1 | String | The product's primary harmonized tariff code. | |
hts_code_2 | String | The product's second harmonized tariff code. | |
hts_code_3 | String | The product's third harmonized tariff code. | |
hts_code_4 | String | The product's 4th harmonized tariff code. | |
hts_code_5 | String | The product's 5th harmonized tariff code. | |
secondary_hts_1 | String | An additional temporary HTS code, relates to chapter 98 and 99. | |
secondary_hts_2 | String | An second additional temporary HTS code, relates to chapter 98 and 99. | |
effective_start | Date | The date on which the classification becomes valid for use. | |
effective_end | Date | The date after which the classification is no longer valid for use. | |
spi1_effective_start | Date | The date on which the first special program becomes valid for use. | |
spi1_effective_end | Date | The date after which the first special program is no longer valid for use. | |
us_epa | UsEPA | Product related data for United States Environmental Protection Agency | |
us_fda | UsFDA | Product related data for United States Food & Drug Administration. | |
classification_us | ClassificationUS | US-specific customs fields related to customs document. | |
us_aphis | UsAPHIS | US Animal and Plant Health Inspection Service information. |
| Name | Data Type | Description | Required |
|---|---|---|---|
cas_number | String | Chemical Abstracts Service registry number | |
tsca_negative_certification | Boolean | Set this field to true to disclaim TSCA. ("I certify that all chemicals in this shipment are not subject to TSCA.") |
| Name | Data Type | Description | Required |
|---|---|---|---|
ace_indicator | Boolean | ACE indicator code | |
product_code | String | The FDA Product code | |
affirmation_of_compliance_1 | String | An FDA Affirmation of Compliance Code | |
affirmation_of_compliance_2 | String | An FDA Affirmation of Compliance Code | |
affirmation_of_compliance_3 | String | An FDA Affirmation of Compliance Code | |
affirmation_of_compliance_4 | String | An FDA Affirmation of Compliance Code | |
affirmation_of_compliance_5 | String | An FDA Affirmation of Compliance Code | |
aoc_qualifier_1 | String | The qualifier assoicated with the affirmation of compliance code | |
aoc_qualifier_2 | String | The qualifier assoicated with the affirmation of compliance code | |
aoc_qualifier_3 | String | The qualifier assoicated with the affirmation of compliance code | |
aoc_qualifier_4 | String | The qualifier assoicated with the affirmation of compliance code | |
aoc_qualifier_5 | String | The qualifier assoicated with the affirmation of compliance code | |
manufacturer_id | String | The MID code associated with the manufacturer | |
shipper_id | String | The MID code associated with the shipper | |
country_of_origin | String | The country of origin to be reported to FDA | |
production_country | String | Country where the product was produced | |
importer_customer_number | String | Customs Broker's internal customer number for the FDA importer | |
processing_code | String | FDA Processing Code | |
food_facility_registration_number | String | FDA Food Facility Registration Number | |
quantity_1_unit_of_measure | String | Unit of Measure for Quantity 1 | |
quantity_2_unit_of_measure | String | Unit of Measure for Quantity 1 | |
quantity_3_unit_of_measure | String | Unit of Measure for Quantity 1 | |
quantity_1 | Decimal | Quantity 1 | |
quantity_2 | Decimal | Quantity 2 | |
quantity_3 | Decimal | Quantity 3 |
| Name | Data Type | Description | Required |
|---|---|---|---|
add_case_number | String | Anti-Dumping Case Number. | |
cvd_case_number | String | Countervailing Duty Case Number. | |
export_control_classification_number | String | Export Control (ECCN) number | |
tax_applicability_flag | String | US Customs Tax Applicability Flag. | |
tax_code | String | US Customs Tax Code. | |
tax_rate | Decimal | US Customs Tax Rate. | |
tax_rate_description | String | US Customs Tax Rate Description. | |
us_ttb | UsTTB | US Customs Tax Rate Description. |
| Name | Data Type | Description | Required |
|---|---|---|---|
code | String | TTB Code. | |
cola | String | Certification/Exemption of Label/Bottle Approval. | |
cola_foreign_certificate_country | String | Country of Foreign Certificate for Certification/Exemption of Label/Bottle Approval | |
is_bonded | Boolean | Is the product moving to a bonded facility | |
permit_number | String | TTB Permit Number. | |
processing_code | String | TTB Processing Code. |
| Name | Data Type | Description | Required |
|---|---|---|---|
inner_code | String | Inner package code. | |
inner_count | Integer | The number of inner packages in the outer package. | |
outer_code | String | Outer package code. |
1.0,PROD01,SKU123,UPC123,EA,Each,MNC,MenCasual,US,,false 1.0,PROD01,SKU123,UPC123,EA,Each,MNC,MenCasual,GB,,false