get_cogs_worksheet
One region's COGS worksheet — the import template as JSON: a row per (account, ASIN, SKU) catalog product and per existing cost period/batch, with the CURRENT value (currentCogs null = no COGS yet). Use it to match a seller's source file to exact SKUs/ASINs before building import_cogs rows (match by SKU first, ASIN as fallback), and to read a SKU's full FIFO ladder before restating it. missingOnly=true keeps only rows without a value. Paginate with limit/offset (total is returned). Vendor Central (1P) products are listed too, each row then carrying its channel ('SELLER' = Seller Central, 'VENDOR' = Vendor Central).
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| limit | No | ||
| offset | No | ||
| reason | No | One sentence, ALWAYS IN ENGLISH (regardless of the conversation language), on WHY you are making this call — the user question or your analytical goal. Recorded so the seller can see how their data is used. | |
| region | Yes | COGS region code (from get_setup domain=cogs): 'US', 'UK', the Pan-EU pool 'EU', an EU country ('DE', 'FR', …), … | |
| accounts | No | Restrict to a subset of your own seller account IDs (from list_accounts). Omit to include all your accounts. A brand/account name is accepted and resolved to its id when it matches one of your accounts unambiguously; a label that carries the id ("Brand (A1B2C3D4E5F6G)") resolves to that id. | |
| missingOnly | No | true = only products without a current COGS value. |