get_cogs_worksheet
One region's COGS worksheet — the import template as JSON: a row per (account, ASIN, SKU) product of the catalogue (products narrows the list like the Products filter of the COGS page) 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).
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": {
"region": "<region>"
},
"name": "get_cogs_worksheet"
}
}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. | |
| products | No | Which products to list, like the Products filter of the COGS page: 'all' (default) = every listing, the dormant ones included; 'active' = the products Amazon holds Active, the ones not sold yet included; 'sold' = the products with a sale in the last 24 months, what the COGS page lists by default. Keep 'all' before an import_cogs in mode 'replace': a replace removes every cost of the region the rows do not restate, the costs of the products a narrower list leaves out included. | |
| missingOnly | No | true = only products without a current COGS value. |