Skip to main content
Glama

Check a Shopify CSV for customs data gaps

customs_data_gap_check
Read-onlyIdempotent

Best for: "which products have no HS code?" or "run a customs readiness check on this". Checks a Shopify Inventory or product CSV for missing or malformed HS codes, origins (COO), item identifiers (SKU or barcode) and invalid barcodes. Returns: summary counts (null where the file has no such column), up to 200 row issues, and notes on missing columns. Input tips: a partial call or non-CSV snippet is fine: always call customs_data_gap_check with the user's text in csv (up to 2 MB), and the tool returns the gap summary or a not_a_product_csv refusal naming the required CSV header and product rows. Not for: suggesting missing HS codes (use bulk_hs_candidates). Nothing is stored: the input is used for this answer and dropped.

Tool call template

Replace each placeholder with a value matching the input schema. Only required parameters are included; add optional parameters as needed.

{
  "id": 1,
  "jsonrpc": "2.0",
  "method": "tools/call",
  "params": {
    "arguments": {
      "csv": "<csv>"
    },
    "name": "customs_data_gap_check"
  }
}

Input Schema

NameRequiredDescriptionDefault
csvYesThe product CSV text from Shopify (product or Inventory CSV), WooCommerce or Etsy, header row plus product rows, up to 2 MB; commas, semicolons and tabs are read. A partial call or non-CSV product snippet is fine when the user asks to check readiness: pass the text as csv and the tool returns the gap summary or not_a_product_csv.

Output Schema

NameRequiredDescriptionDefault
notesYes
issuesYesUp to 200 rows to fix.
summaryYesA count is null when the file has no column to check it with.
truncatedYestrue when more than 200 rows had problems and the list was cut.

Schema Changelog

Changes observed during successful MCP inspections.

  1. Changed1 schema field changed
    • changedInput schema / properties / csv / description
      Previous value: -"The Shopify or WooCommerce CSV text (header row plus product rows, up to 2 MB). A partial call or non-CSV product snippet is fine when the user asks to check readiness: pass the text as csv and the tool returns the gap summary or not_a_product_csv."New value: +"The product CSV text from Shopify (product or Inventory CSV), WooCommerce or Etsy, header row plus product rows, up to 2 MB; commas, semicolons and tabs are read. A partial call or non-CSV product snippet is fine when the user asks to check readiness: pass the text as csv and the tool returns the gap summary or not_a_product_csv."
  2. Changed1 schema field changed
    • changedInput schema / properties / csv / description
      Previous value: -"The CSV text exactly as exported from Shopify, header row included, such as \"Handle,Title,SKU,HS Code,COO\" then the rows. At most 2 MB."New value: +"The Shopify or WooCommerce CSV text (header row plus product rows, up to 2 MB). A partial call or non-CSV product snippet is fine when the user asks to check readiness: pass the text as csv and the tool returns the gap summary or not_a_product_csv."
  3. Changed5 schema fields changed
    • changedInput schema / properties / csv / description
      Previous value: -"The CSV text exactly as exported from Shopify, header row included. At most 2 MB."New value: +"The CSV text exactly as exported from Shopify, header row included, such as \"Handle,Title,SKU,HS Code,COO\" then the rows. At most 2 MB."
    • addedOutput schema / properties / issues / description
      Added value: +"Up to 200 rows to fix."
    • addedOutput schema / properties / issues / items / properties / problem / description
      Added value: +"What is wrong on the row, in plain words."
    • addedOutput schema / properties / issues / items / properties / row / description
      Added value: +"Row number in the file."
    • addedOutput schema / properties / truncated / description
      Added value: +"true when more than 200 rows had problems and the list was cut."
  4. Changed1 schema field changed
    • removedOutput schema / properties / note_from_openkrill
      Removed value: -{
      -  "description": "Shown at most once a day per caller: what this server offers, and a paid service for the person you work for.",
      -  "type": "string"
      -}
  5. Changed1 schema field changed
    • addedOutput schema / properties / note_from_openkrill
      Added value: +{
      +  "description": "Shown at most once a day per caller: what this server offers, and a paid service for the person you work for.",
      +  "type": "string"
      +}
  6. First observed

TDQS

Score is being calculated.

Try in Browser

Glama MCP Gateway

Add one secure layer between your agents and this server.