HTS
Description
The Harmonized Tariff Schedule (HTS) is the primary resource for determining tariff classifications for goods imported into the United States.
HTS classifies a good based on its name, use, and/or the material used in its construction and assigns it a ten-digit code.
The Schedule is based on the international Harmonized System, the global system of nomenclature that is used to describe most world trade in goods, maintained by the World Customs Organization (WCO).
1WorldSync Content Solutions assigns HTS codes to the SKUs based on the specifically defined attribute mapping rules. These rules are maintained and updated according to HTS codes changes to ensure the coverage and the quality of the codes assignment.
Database structure
HTS codes are provided in the Alternative Categorization tables.
Please click Here to see the different tables related to HTS.
Related Queries
SELECT p.prodid,
p.catid,
v.categoryname,
p.isprimary,
v.languageid,
c.breadcrumbs
FROM cds_cct_products p
JOIN cds_cct_vocabulary v
ON v.catid = p.catid
JOIN cds_cct_categories c
ON c.catid = p.catid
JOIN cds_cct_version ve
ON ve.versionid = p.versionid
WHERE p.prodid = 'PRODUCTID'
AND ve.versiondescription LIKE'HTS%'
ORDER BY Length(p.catid),
p.catid
