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