Synced reports
Your Amazon and noon reports, synced on a schedule into your own tables — your agent queries them in seconds, months back, without waiting on Amazon.
In short
SellerSheet syncs 72 report tables for every connected store — inventory, listings, orders, returns, settlements, Data Kiosk sales and traffic, every Sponsored Products, Brands and Display report, and noon. query_report_data filters, joins and totals them instantly.
How it works
Reports sync on their own
Each table has its own schedule, set when the store connects. Nothing to request, nothing to wait for. list_report_syncs shows what syncs for a store and when it last ran.
Your agent reads the schema first
get_table_schema returns the columns, types and unique key of one table, so the query uses real column names. Every table also has its own page on the Data tab.
One query, any date range
query_report_data takes the tables, columns, filters, grouping and sort — results come back in seconds and do not use Amazon's rate limits. Your agent writes them to your sheet when you work there.
Try asking
"What were my top 10 products by revenue last month?"
"From the synced inventory reports, find stock that hasn't sold in over 90 days."
"Total sales and sessions by week for the last 3 months, as a trend table."
A query, both ways
MCP — you ask: "How many orders did I get yesterday?" Your agent calls query_report_data on the orders table.
In an AI client (MCP)
{
"name": "query_report_data",
"arguments": {
"store": "myStore-US",
"tables": [
"rpt_orders"
],
"columns": [
"amazon_order_id",
"purchase_date",
"item_price"
],
"limit": 100
}
}From code (Tool API)
curl -X POST https://api.sellersheetai.com/api/v1/tools/query_report_data \
-H "Authorization: Bearer $SELLERSHEET_API_KEY" \
-H "Content-Type: application/json" \
-d '{"store":"myStore-US","tables":["rpt_orders"],"columns":["amazon_order_id","purchase_date","item_price"],"limit":100}'Tools on this page
| Tool | Access | What it does |
|---|---|---|
query_report_data | read | Query the synced report warehouse (rpt_* tables) — rows without calling Amazon. |
get_table_schema | read | Return the schema for one rpt_* table — column names, types, unique key. |
list_report_syncs | read | List a store's report sync schedules — check sync health before trusting rpt_* data. |
FAQ
I need data fresher than the last sync.
Request a report from Amazon directly — see On-demand reports — or call the live tool for that area, such as Orders or FBA inventory.
Where is the list of tables?
On the Data tab — each table with its report type, cadence and columns.
Is there a skill for this?
Yes — the report-data skill teaches your agent the tables and the query patterns. See Install the skills.