Product Variants
đź’Ž Built for Sidekick
⚡ Sidekick does this for you
shopify
sidekick
variants
customs
catalog
Backfill Variant Country of Origin and HS Code for Customs
Fill in the missing Country/Region of Origin and Harmonized System code on variants shipping internationally, matched from a reference table, so customs declarations generate correctly.
đź“‹ Prompt
Find every variant in [SCOPE, e.g. “all products in the Apparel collection” or “every active product”] that is missing a Country/Region of Origin, an HS (Harmonized System) code, or both – these are the per-variant fields Shopify uses to generate customs paperwork for international orders. Match each missing value using this source: [MATCH_SOURCE, e.g. “the product_type field: T-shirts = HS 6109.10, Origin = Vietnam” or “this reference table I’ll paste: product type -> HS code -> origin country”]. For each variant: Show current Country of Origin (or “missing”), current HS code (or “missing”), matched origin, and matched HS code from the source, in one table before applying anything. Flag any variant whose product type has no entry in the match source, and leave those fields blank rather than guessing a customs code. Flag any variant where the matched HS code looks inconsistent with a sibling variant of the same product (possible data error in the source table). Apply the values only after I review and approve the table. Note clearly that Sidekick is applying the codes I’ve supplied or confirmed from my source data – it isn’t classifying products under HS law, so I should verify codes with a customs broker if I’m unsure. Afterward, give me a summary: variants updated, variants flagged for missing source data, and a count of products now fully ready for international customs declarations.
How to Use
- Copy the prompt above
- Open Shopify Sidekick in your Shopify admin
- Paste the prompt and replace the bracketed placeholders with your details
- Review Sidekick's response and apply the suggestions