fbaInbound_create_sta_sheet

Create the plan workbook for an FBA inbound plan — the SAME workbook the sidebar's "Create STA SS" builds, so the sidebar buttons can continue any step: the stepper tab (STA-BoxFir

writeSellerSheet

st / STA-SplitFirst) copied from the master template into a workbook named after the plan in its own folder under Shipments/<store>/<CC>/<yyyy>/<MM>/; the Product Info IMPORTRANGE re-targeted to the FBA spreadsheet, row 9 filled by label, MSKUs from row 14, a _state tab (STA_CREATED). The human clicks the STA tab's D3 cell once ("Allow access" — the server cannot grant it), then fills Box No. (column A) per item row — Split First: Total Qty (column F) — before fbaInbound_orchestrate_packing.

Call it

In an AI client (MCP)

tools/call
{
  "name": "fbaInbound_create_sta_sheet",
  "arguments": {
    "store": "myStore-US",
    "plan_name": "<plan_name>",
    "skus": []
  }
}

From code (Tool API)

curl -X POST https://api.sellersheetai.com/api/v1/tools/fbaInbound_create_sta_sheet \
  -H "Authorization: Bearer $SELLERSHEET_API_KEY" \
  -H "Content-Type: application/json" \
  -d '{"store":"myStore-US","plan_name":"<plan_name>","skus":[]}'
Early access — the Tool API is open on request, contact us.

Arguments

NameTypeDescription
storerequiredstringthe store ref `<store>-<CC>` (name-country, e.g. 'myStore-US') — one of get_user_context's store_refs, verbatim.
plan_namerequiredstringthe plan name (the plan's Manage Shipments row).
skusrequiredobject[]the plan's MSKUs (the Manage Shipments SKUs cell, newline-split).
case_packedstring'YES' (default) | 'NO'.Default: "YES"
pallet_packedstring'YES' | 'NO' (default).Default: "NO"
shipping_modestringthe row-9 Shipping Mode GROUP (narrows the transport dropdown later); empty = every mode. Allowed: SPD | LTL / FTL.Default: ""
shipping_solutionstringthe row-9 Shipping Solution; empty = both. Allowed: AMAZON_PARTNERED_CARRIER | USE_YOUR_OWN_CARRIER.Default: ""
preferred_carrierstringe.g. 'DHL', 'UPS'; default 'Other'.Default: "Other"
fulfillment_splitstringtext containing 'Split First' picks STA-SplitFirst, anything else STA-BoxFirst (default 'Box First, Split Later').Default: "Box First, Split Later"
ship_datestringISO dates (e.g. '2026-04-07').Default: ""
delivery_window_start_datestringISO dates (e.g. '2026-04-07').Default: ""
unit_of_weightstringthe row-9 units; defaults 'KG' and 'CM'.Default: "KG"
unit_of_dimensionstringthe row-9 units; defaults 'KG' and 'CM'.Default: "CM"
fnsku_label_sizestringthe row-9 label sizes; defaults '50x30 mm' and '100x100 mm'.Default: "50x30 mm"
fba_box_label_sizestringthe row-9 label sizes; defaults '50x30 mm' and '100x100 mm'.Default: "100x100 mm"
warehouse_codestringthe Shipment Setting row's code (e.g. 'CN'); row 9 gets the key '<store>-<CC>-<code>' the sidebar resolves to the address. Refused before anything is created when that key is not a complete Shipment Setting row — the refusal lists the codes that exist.Default: ""
fba_spreadsheet_idstringthe user's SellerSheet FBA spreadsheet (defaults to the workspace setting) — the Product Info donor and Manage Shipments.
parent_folder_idstringDrive folder override.
source_spreadsheet_idstringolder name for fba_spreadsheet_id (that one wins).

Result

Every tool answers {notification, data, human_action}; data carries:

  • data.staSpreadsheetId / data.spreadsheetUrl / data.tabName / data.gid — the new workbook and its stepper tab.
  • data.planFolderId / data.planFolderUrl / data.planFolderName — the plan's Drive folder.
  • data.importrangeGranted — always false here (the D3 click above).
  • data.addressKeyKnown — false only when no warehouse_code was given or Shipment Setting could not be read — the human fills Send From Address (D9).
  • data.manageShipmentsFormulas — {planFolder, planName} — write both into the plan's Manage Shipments row (columns by row-1 key) so the sidebar finds the workbook.

On this page

Actions

View as Markdown

Ask an assistant

Ask ChatGPTAsk Claude