Shop Duty Desk

 ⟨8 unchanged words⟩  exactly as exported from Shopify, header row included.included, such as \"Handle,Title,SKU,HS Code,COO\" then the rows. At most 2 MB.","maxLength":2000000, ⟨8 unchanged words⟩ 

{"properties":{"issues":{"description":"Up to 200 rows to fix.","items":{"properties":{"handle":{"type":"string"},"problem":{"description":"What is wrong on the row, in plain words.","type":"string"},"row":{"description":"Row number in the file.","type":"integer"}},"required":["row ⟨57 unchanged words⟩ ],"type":"object"},"truncated":{"description":"true when more than 200 rows had problems and the list was cut.","type":"boolean"}},"required":[" ⟨6 unchanged words⟩ 

{"additionalProperties":false,"properties":{"channel":{"description":"ioss:How the importgoods isenter the EU: \"ioss\" (VAT-exempt under the Import One-Stop Shop. postal: the goodsShop) travelor in\"postal\" (a postal consignment.consignment).","enum":["ioss","postal"], ⟨41 unchanged words⟩ :"string"},"lines":{"description":"Order lines of one consignment.Lines Each(1 lineto holds200), onlyeach {description, hs_codeorigin (optional),2 originletters), qty and unit_value_eur; lines(integer), withunit_value_eur any(euros), otheroptional fieldhs_code}, such as a customer name or address[{\"description\":\"mug\", are refused.\"origin\":\"CN\",\"qty\":2,\"unit_value_eur\":12}].","items":{"additionalProperties":false,"properties":{" ⟨15 unchanged words⟩ 6, 8 or 10 digit tariff code, dots allowed, if known (a candidate, not binding)","pattern":"^\\d{4}\\.?\\d{2}(\\.?\\d{2}(\\.?\\d{2})?)?$","type":"string"},"origin":{"description" ⟨4 unchanged words⟩  were made in, such as CN","pattern":"^[A-Za-z]{2}$","type":"string"},"qty":{"description":"Units on the line","maximum":100000,"minimum":1,"type":"integer"},"unit_value_eur":{"description":"Price of one unit in euros","maximum":1000000,"minimum":0,"type":"number"}} ⟨18 unchanged words⟩ 

 ⟨8 unchanged words⟩ "items":{"properties":{"duty_eur":{"description":"EUR 3 per item, or null when exempt_reason is set.","type":["number","null"]},"duty_if_identical_lines_grouped_eur":{"description":"Duty with identical lines merged, or null when exempt_reason is set.","type":["number","null"]},"exempt_reason":{"description":"Why no EUR 3 duty applies.","enum":["outside_validity_window","consignment_value_over_150_eur"],"type":"string"},"items":{"description":"Items as the lines are given: one per line.","type":"integer"},"items_if_identical_lines_grouped":{"description":"Items if lines with the same code, description and origin are merged.","type":"integer"},"note":{"description":"Plain-language reason when exempt_reason is set.","type":"string"},"value_eur":{"description":"Consignment value used for the EUR 150 test.","type":"number"}},"required":["items ⟨19 unchanged words⟩ },"type":"array"},"total_duty_eur":{"description":"Total EUR 3 duty in euros, as lines are given. 0 when the consignment is exempt.","type":"number"}},"required":[" ⟨6 unchanged words⟩ 

 ⟨22 unchanged words⟩ ,"type":"string"},"destination":{"description":"Where the goods are imported: \"UK\", \"US\" or \"EU\". EU duty is not looked up, only VAT.","enum":["UK","US","EU"] ⟨3 unchanged words⟩ :{"description":"Value of the goods, such as 80, in the one currency used for every amount (no conversion is done).","minimum":0,"type":"number"},"hs_code":{"description":"A full tariff line, (UK 10 digits, or US 8 or 10 digits), adots candidateallowed, notsuch binding.as EU\"6109100010\". ratesCopy areit notfrom lookedbulk_hs_candidates. up.A candidate, not binding.","maxLength":16,"minLength":6,"type ⟨32 unchanged words⟩ ":"Shipping and insurance to the destination, such as 12, in the same currencycurrency. Send 0 if none.","minimum":0,"type":"number"} ⟨41 unchanged words⟩ 

 ⟨2 unchanged words⟩ {"type":"string"},"chapter_99":{"description":"US only: extra chapter 99 duties that were added. They are already counted in duty; do not add them again.","items":{"properties":{"applied":{"type":"boolean"},"heading":{"description":"HTS chapter 99 heading, such as 9903.88.03.","type":"string"},"rate_pct":{"type":["number","null"]},"reason":{"description":"Why the heading was added or skipped.","type":"string"}},"required":["heading ⟨4 unchanged words⟩ ,"type":"array"},"chapter_99_skipped":{"description":"US only: chapter 99 headings that matched but were not added, each with the reason.","items":{"properties":{"applied":{"type":"boolean"},"heading":{"description":"HTS chapter 99 heading, such as 9903.88.03.","type":"string"},"rate_pct":{"type":["number","null"]},"reason":{"description":"Why the heading was added or skipped.","type":"string"}},"required":["heading ⟨4 unchanged words⟩ ,"type":"array"},"complete":{"description":"false when a part could not be worked out; then say what missing or notes list.","type":"boolean"},"destination":{"type":"string"},"duty":{"description":"Duty in the input currency. amount is null when the rate is not a plain percentage. For the US, rate and amount already include the chapter_99 lines that were added.","properties":{"amount":{"type":["number","null"]},"basis":{"description":"The value the rate applies to, or \"not calculated\".","type":"string"},"rate":{"description":"The rate applied. With chapter 99 lines it reads like 16.5% general + 20% chapter 99 = 36.5%.","type":["string","null"]},"rate_pct ⟨6 unchanged words⟩ ,"type":"object"},"fees":{"description":"US only: merchandise processing fee (MPF) and harbor fee (HMF).","items":{"properties":{"amount":{"type ⟨3 unchanged words⟩ {"type":"boolean"},"cite":{"description":"Legal source of the fee.","type":"string"},"name":{"enum":["MPF","HMF"],"type":"string"},"note":{"type" ⟨17 unchanged words⟩ {"type":"string"},"hs_status":{"description":"Always a candidate code, not a binding classification.","enum":["candidate, not binding"],"type":"string"},"missing":{"description":"What is missing when complete is false.","items":{"type":"string"},"type" ⟨14 unchanged words⟩ ,"type":"array"},"total":{"description":"Goods, shipping, duty, fees and VAT, in the input currency. Leaves out parts that are null.","type":"number"},"vat":{"description":"VAT in the input currency, on goods, shipping and duty. 0 for the US.","properties":{"amount":{"type":[" ⟨27 unchanged words⟩ 

 ⟨84 unchanged words⟩ {"description":"2-letter country the goods come fromfrom. (optional)Required for a complete US landed cost, so chapter 99 duties can be applied.","pattern":"^[A-Za-z]{2}$" ⟨13 unchanged words⟩  currency","minimum":0,"type":"number"},"transport":{"description":"How the goods travel into the US. ocean adds the harbor fee (0.125%). air and other add none. Required for a complete US landed cost.","enum":["ocean","air","other"],"type":"string"}},"required":["hs_code","destination" ⟨4 unchanged words⟩ 

{"properties":{"as_of":{"type":"string"},"chapter_99":{"items":{"properties":{"applied":{"type":"boolean"},"heading":{"type":"string"},"rate_pct":{"type":["number","null"]},"reason":{"type":"string"}},"required":["heading","reason","applied"],"type":"object"},"type":"array"},"chapter_99_skipped":{"items":{"properties":{"applied":{"type":"boolean"},"heading":{"type":"string"},"rate_pct":{"type":["number","null"]},"reason":{"type":"string"}},"required":["heading","reason","applied"],"type":"object"},"type":"array"},"complete":{"type":"boolean"},"destination" ⟨21 unchanged words⟩ ,"basis"],"type":"object"},"fees":{"items":{"properties":{"amount":{"type":["number","null"]},"applied":{"type":"boolean"},"cite":{"type":"string"},"name":{"type":"string"},"note":{"type":"string"},"rate_pct":{"type":"number"}},"required":["name","applied","cite","note"],"type":"object"},"type":"array"},"goods_value":{"type":"number"},"hs_code":{"type":"string"},"hs_status":{"type":"string"},"missing":{"items":{"type":"string"},"type":"array"},"notes":{"items":{"type" ⟨46 unchanged words⟩