FBA
Send stock to Amazon with Send to Amazon (STA) plans built in Google Sheets — box first or split first — plus labels, shipment tracking and an inventory health view.
The FBA panel creates and tracks FBA inbound shipments from Google Sheets, and keeps a live inventory health view of every FBA SKU. Each plan gets its own STA spreadsheet; the numbered stepper on it shows which step is DONE.
Main steps — create a shipment
Start the plan
On Manage Shipments, add a row for the plan, click a cell in it and use Create STA SS: SellerSheet creates a dedicated STA spreadsheet for that shipment.
Box first — you know your boxes
On STA-BoxFirst: Initiate Plan (from row 9 and the box lines from row 14) → Confirm Pack if Amazon offered several packing options → Set Box Info → Gen Placement Opts. (each placement's warehouses, weight, volume and fees land in STA-Options; price your own carrier there) → pick a placement → Gen Trans. Opts. → pick carriers (Match Carriers copies shipment 1's carrier to the rest) → Gen Delivery Window for own-carrier shipments → Confirm Shipment.
Or split first — Amazon splits first
On STA-SplitFirst: Initiate Plan → Confirm Placement (builds STA-Pack, one box block per shipment) → fill the boxes → Set Box Info → Gen Trans. Opts. → Gen Delivery Window (own carrier only) → Confirm Shipment.
Labels and tracking
Get FBA Box Labels saves the box labels PDF to the plan folder and links it from the FBA ID; Get FNSKU Labels opens item labels in a print dialog. Get Ref. ID and Refresh Shipment keep status, Reference ID and warehouse current on Manage Shipments.
Confirm Shipment books the shipment on Amazon, and Cancel Plan cancels the inbound plan — both change your account. The Ship Date must be today or later, or Amazon returns no carrier options.
Inventory Health and past plans
- Refresh Data (Inventory Health) reloads the hidden data layer from the SellerSheet warehouse for the stores in the Stores filter (A4); the live table re-queries instantly. No Amazon call.
- List Inbound Plans (Search Inbound Plans) lists your inbound plans of the last 365 days using the row-4 filters.
Every button
| Button | 中文 | What it does | Effect |
|---|---|---|---|
| Refresh Data | 刷新数据 | Refresh the hidden data layer from the SellerSheet database — stores picked in the Stores filter (A4); the live table re-queries instantly. No Amazon call. Runs on the Inventory Health sheet — clicked elsewhere it jumps there (creating the tab if needed) so you can run it again. | WRITES SHEET |
| Create STA SS | 创建 STA 表格 | Create an STA spreadsheet for the active row’s shipment. | WRITES DRIVEWRITES SHEET |
| Refresh Shipment | 刷新货件 | Refresh status for every non-terminal shipment on this sheet from Amazon. | WRITES SHEET |
| Initiate Plan | 创建入库计划 | Creates the inbound plan from row 9 and the box lines (row 14+) and lists Amazon's packing options; a single packing group is confirmed with its box info at once (1a–1c DONE). Several groups mean the items cannot ship together: the error lists each group's SKUs below the items — cancel, keep one group's SKUs and run again. | LIVE ON AMAZONWRITES SHEET |
| Confirm Pack | 确认装箱 | Re-confirms the packing option ID in the stepper's 1b cell (1b DONE); Initiate Plan normally does this for you. | LIVE ON AMAZONWRITES SHEET |
| Set Box Info | 填写箱子信息 | Re-sends every box line's dimensions and weight (row 14+, units in H9/I9) for the packing group in the stepper's 1c cell — after you edit the box lines (1c DONE); refused once the shipment is confirmed. | LIVE ON AMAZONWRITES SHEET |
| Gen Placement Opts. | 生成分仓方案 | Fetches Amazon's placement options and fees; each shipment's warehouse, weight and volume land in STA-Options, where Rate/kg ✎ or Rate/m³ ✎ prices your own carrier. Pick one in the stepper's 2 cell. Click again to refresh from Amazon (rates carry over by warehouse). | WRITES SHEET |
| Gen Trans. Opts. | 生成运输方案 | Fetches carrier options (cost, mode, partnered or own) for every placement's shipments into the STA-Options Transportation dropdowns and rebuilds STA-PL; pick per shipment there (3 DONE). | WRITES SHEET |
| Match Carriers | 匹配承运商 | Run on the STA-Options tab: for every placement with 2+ shipments, shipment 1's picked Transportation Option fills the rest with the same carrier (SPD / LTL partnered rules). | WRITES SHEET |
| Gen Delivery Window | 生成送达时间窗 | Own-carrier shipments only: fetches delivery windows for the picked placement's shipments (every placement when none is picked) into the STA-Options Delivery Window dropdowns (3b DONE). | WRITES SHEET |
| Confirm Shipment | 确认货件 | Confirms the placement picked in the stepper's 2 cell and each shipment's Transportation + Delivery Window from STA-Options — books on Amazon. FBA ID, Reference ID and warehouse land in row 12, STA-Options (the FBA ID becomes the label link when Amazon returns labels) and Manage Shipments (2 and 4 DONE). | LIVE ON AMAZONWRITES SHEET |
| Get Ref. ID | 获取参考 ID | Re-reads each confirmed shipment from Amazon: status, Reference ID and warehouse refresh in STA-Options and row 12; the Reference ID is mirrored to Manage Shipments. | WRITES SHEET |
| Get FBA Box Labels | 获取 FBA 箱标 | Fetches Amazon box labels for the picked placement's shipments whose FBA ID in STA-Options is not a link yet (page count from that row; cut to the FBA Box Label Size you chose in row 9 — required: 100x150 as is, 100x100 top square). Saves the PDF to the plan folder, turns the FBA ID into its link and mirrors it to Manage Shipments. Remove a link to fetch again. | WRITES DRIVEWRITES SHEET |
| Get FNSKU Labels | 获取 FNSKU 标签 | Builds FNSKU item labels from the items table — one per unit (Qty/Box × Boxes), at the FNSKU Label Size you chose in row 9 (required) — and opens them in a print dialog; nothing is written to the sheet. | READ |
| Cancel Plan | 取消计划 | Cancels the inbound plan on Amazon; every stepper step and the Status cell become CANCELLED. | LIVE ON AMAZONWRITES SHEET |
| Initiate Plan | 创建入库计划 | Creates the inbound plan from row 9 and the item lines (row 14+) and lists Amazon's placement options in STA-Options and the stepper's 2 dropdown (1 DONE). | LIVE ON AMAZONWRITES SHEET |
| Confirm Placement | 确认分仓 | Confirms the placement picked in the stepper's 2 cell with Amazon and builds STA-Pack, one box block per shipment (2 DONE). | LIVE ON AMAZONWRITES SHEET |
| Set Box Info | 填写箱子信息 | Sends STA-Pack's box rows (dimensions + weight per shipment, units in H9/I9) to Amazon as packing information; needs 2 DONE (3 DONE). | LIVE ON AMAZONWRITES SHEET |
| Gen Trans. Opts. | 生成运输方案 | Fetches carrier options (cost, mode, partnered or own) for the confirmed placement's shipments into the STA-Options Transportation dropdowns; needs Ship Date and 3 DONE (4 DONE). | WRITES SHEET |
| Gen Delivery Window | 生成送达时间窗 | Own-carrier shipments only: fetches delivery windows for the confirmed placement's shipments into the STA-Options Delivery Window dropdowns (5 DONE). | WRITES SHEET |
| Confirm Shipment | 确认货件 | Confirms each shipment's Transportation + Delivery Window from STA-Options — books on Amazon. FBA ID, Reference ID and warehouse land in row 12, STA-Options (the FBA ID becomes the label link when Amazon returns labels) and Manage Shipments (6 DONE). | LIVE ON AMAZONWRITES SHEET |
| Get FBA Box Labels | 获取 FBA 箱标 | Fetches Amazon box labels for the picked placement's shipments whose FBA ID in STA-Options is not a link yet (page count from that row; cut to the FBA Box Label Size you chose in row 9 — required: 100x150 as is, 100x100 top square). Saves the PDF to the plan folder, turns the FBA ID into its link and mirrors it to Manage Shipments. Remove a link to fetch again. | WRITES DRIVEWRITES SHEET |
| Get FNSKU Labels | 获取 FNSKU 标签 | Builds FNSKU item labels from the items table — one per unit (Qty/Box × Boxes), at the FNSKU Label Size you chose in row 9 (required) — and opens them in a print dialog; nothing is written to the sheet. | READ |
| Cancel Plan | 取消计划 | Cancels the inbound plan on Amazon; every stepper step and the Status cell become CANCELLED. | LIVE ON AMAZONWRITES SHEET |
| List Inbound Plans | 列出入库计划 | List your inbound plans (last 365 days) using the row-4 filters; newest first. | WRITES SHEET |
| Setup Sheet | 设置表格 | Create or reset the Search Inbound Plans sheet header block. | WRITES SHEET |
Prefer to ask an agent?
An agent can build the same STA workbook with fbaInbound_create_sta_sheet and walk the plan over MCP, from fbaInbound_createInboundPlan to fbaInbound_get_labels. Guides: Create STA shipments, Inventory health dashboard.