Skip to main content
Glama

Nova Amazon MCP Server

get_stock_worksheet

Read-only

One stock region's replenishment worksheet — the rows of the Data Inputs 'Stocks' page as JSON: a row per (account, ASIN) that holds or sells stock in the region, with the row's OWN values (own: what import_stock_params wrote for that product × region), what each of the five parameters RESOLVES to (resolved: product row → product 'ALL' row → account default for the region → account default 'ALL'), where each came from (source: asin_region | asin_all | seller_region | seller_all | null = nothing → no recommendation), paramsComplete, and the velocity / FBA stock next to it. region 'ALL' lists the product × 'ALL' rows (where a production lead time naturally lives). Use it to match a seller's lead-time file to exact ASINs before import_stock_params; missingOnly=true keeps the products that still resolve nothing for at least one parameter. Paginate with limit/offset.

Input Schema

NameRequiredDescriptionDefault
limitNo
offsetNo
reasonNoOne 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.
regionYesA stock region as get_setup domain=stock lists them ('USA', 'EU_FBA', 'UK', 'Canada'…; 'US', 'EU', 'GB' are accepted) or 'ALL' (every region without its own row).
searchNoASIN or product name substring.
accountsNoRestrict 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.
missingOnlyNotrue = only products whose five RESOLVED parameters are not all set.

Schema Changelog

Changes observed during successful MCP inspections.

  1. Changed1 schema field changed
    • changedInput schema / properties / region / description
      Previous value: -"A stock region as get_stock_setup lists them ('USA', 'EU_FBA', 'UK', 'Canada'…; 'US', 'EU', 'GB' are accepted) or 'ALL' (every region without its own row)."New value: +"A stock region as get_setup domain=stock lists them ('USA', 'EU_FBA', 'UK', 'Canada'…; 'US', 'EU', 'GB' are accepted) or 'ALL' (every region without its own row)."
  2. First observed

TDQS

A4.3/5.0
Behavior4/5

Does the description disclose side effects, auth requirements, rate limits, or destructive behavior?

With readOnlyHint=true the safety profile is covered, and the description adds substantive behavior: the resolution precedence chain (product row → product 'ALL' → account default region → account default 'ALL'), the meaning of source=null (no recommendation), and region 'ALL' semantics. It doesn't describe pagination totals or return envelope, but the resolution model is unusually well disclosed.

Agents need to know what a tool does to the world before calling it. Descriptions should go beyond structured annotations to explain consequences.

Conciseness3/5

Is the description appropriately sized, front-loaded, and free of redundancy?

Purpose is front-loaded, but the body is a single dense run-on packed with internal jargon (own/resolved/source/paramsComplete) that is harder to parse than it needs to be. Most clauses earn their place, yet the structure could be broken up for readability.

Shorter descriptions cost fewer tokens and are easier for agents to parse. Every sentence should earn its place.

Completeness5/5

Given the tool's complexity, does the description cover enough for an agent to succeed on first attempt?

For a 7-param tool with no output schema, the description explains the return shape inline (own values, resolved values, source provenance, paramsComplete, velocity/FBA stock) and covers the resolution logic and 'ALL' region, so an agent knows both what it gets and how to interpret it.

Complex tools with many parameters or behaviors need more documentation. Simple tools need less. This dimension scales expectations accordingly.

Parameters4/5

Does the description clarify parameter syntax, constraints, interactions, or defaults beyond what the schema provides?

Schema coverage is 71% and already documents region, reason, search, accounts, and missingOnly. The description adds meaning beyond the schema: what region 'ALL' actually lists (product × 'ALL' rows where a production lead time lives) and that missingOnly filters on RESOLVED parameters resolving nothing. limit/offset are only touched by 'Paginate with limit/offset'.

Input schemas describe structure but not intent. Descriptions should explain non-obvious parameter relationships and valid value ranges.

Purpose5/5

Does the description clearly state what the tool does and how it differs from similar tools?

States a specific verb+resource ('get_stock_worksheet' → one region's replenishment worksheet = Data Inputs 'Stocks' page rows) and defines the row grain as (account, ASIN). It clearly differentiates itself from the *_worksheet siblings (cogs, fbm, vat, tags) by naming the exact page and the resolution semantics it returns.

Agents choose between tools based on descriptions. A clear purpose with a specific verb and resource helps agents select the right tool.

Usage Guidelines4/5

Does the description explain when to use this tool, when not to, or what alternatives exist?

Gives an explicit use case ('match a seller's lead-time file to exact ASINs before import_stock_params') and a conditional behavior (missingOnly=true keeps products that resolve nothing). It ties sequencing to import_stock_params, but doesn't explicitly say when to use a different worksheet tool instead.

Agents often have multiple tools that could apply. Explicit usage guidance like "use X instead of Y when Z" prevents misuse.

Try in Browser

Glama MCP Gateway

Add one secure layer between your agents and this server.