Sales
Sync your Amazon orders into the Sales spreadsheet, refresh any single order, and generate PDF invoices in bulk.
The Sales panel keeps an up-to-date copy of your Amazon orders in Google Sheets and turns shipped orders into invoices. It works on the SellerSheet Sales spreadsheet (open it from the panel's Resources links).
Main steps
Sync orders
Click Sync Orders — it works from any sheet. The first run brings in the last 30 days; after that it fetches everything since the last sync and keeps itself running about every 2 hours, together with the fees sync. Click it any time for an immediate refresh.
Refresh or look up one order
On the Orders sheet, click the Amazon Order ID cell of an order, then Update Order to refresh that row from Amazon. Order Details fetches the line items of the selected order.
Create invoices
Fill your company details once on the Store Info sheet. On the Invoices sheet, give each row a Store and an Order ID, then click Create Invoices: every row without a link yet gets a PDF invoice in Drive (the order must be Shipped).
Clear Orders empties every data row of the Orders sheet (headers stay) — press Ctrl+Z right after if you clicked it by mistake.
Every button
| Button | 中文 | What it does | Effect |
|---|---|---|---|
| Sync Orders | 同步订单 | Syncs new and changed orders into the Orders sheet, continuing where the last run stopped, then keeps itself running about every 2 hours. Only the spreadsheet's owner syncs. | WRITES SHEET |
| Re-sync | 重新同步 | Clears this tab and reads the ticked stores again from scratch, as far back as First sync reads. | WRITES SHEET |
| Update Order | 更新订单 | Click the Amazon Order ID cell of an order first, then this refreshes that row from Amazon. | WRITES SHEET |
| Clear Orders | 清空订单 | Clears ALL data rows from the Orders sheet (headers kept). Ctrl+Z to undo right after. | WRITES SHEET |
| Order Details | 获取订单明细 | Fetches line items of the selected order from Amazon. | WRITES SHEET |
| Create Invoices | 生成发票 | On the Invoices sheet: generates a PDF invoice in Drive for every row with Store + Order ID and no link yet (order must be Shipped; company info from Store Info sheet). | WRITES DRIVEWRITES SHEET |
Prefer to ask an agent?
The same orders are available over MCP and the API: orders_searchOrders and orders_getOrder, or the synced rpt_orders table through query_report_data. Guide: How to Sync Amazon Orders to Your Google Sheets.