# How to Create FBA Shipments (Send to Amazon) in Google Sheets (https://sellersheetai.com/zh/guides/create-sta-shipments-in-google-sheets)

> Run Amazon's whole Send-to-Amazon (STA) workflow from Google Sheets with the SellerSheet sidebar — set up your warehouse and products once, then create, confirm, label and track every FBA shipment in a few clicks.



## Introduction [#introduction]

Creating FBA shipments in Seller Central means navigating multiple pages for every single shipment — entering your warehouse address, adding products one by one, filling box dimensions, choosing carriers, and downloading labels. It's repetitive, error-prone, and slow.

SellerSheet handles the entire **Send-to-Amazon (STA)** workflow from Google Sheets. Set up your warehouse address once, fill in your products and box configurations, then click through the sidebar buttons to initiate, confirm, and track your shipment — including FBA carton labels and FNSKU barcode labels.

This guide covers the **Box First, Split Later** workflow using 4 sheets: **Shipment Setting**, **Product Info**, **Manage Shipments**, and the **STA** working sheet. In four stages:

1. **Set up sheets** — address, products, tracking.
2. **Fill the STA sheet** — boxes, MSKUs, quantities.
3. **Create & confirm** — initiate, options, confirm.
4. **Get labels** — FBA + FNSKU labels.

## Prerequisites [#prerequisites]

* **Store connected:** your Amazon store is connected to your SellerSheet account — sign in at [sellersheetai.com](https://sellersheetai.com/home) and connect it under **Settings → Stores & Marketplaces**.
* **Sidebar installed:** the SellerSheet add-on is installed in Google Sheets. See [Install & first sync](/help/sheets/install).
* **FBA access:** your Amazon Seller Central account must have FBA (Fulfillment by Amazon) enabled.

## Setting up your sheets [#setting-up-your-sheets]

<Callout title="The problem">
  In Seller Central, you re-enter your warehouse address, product details, and box dimensions every time you create a shipment. There's no way to save templates or reuse configurations across plans.
</Callout>

SellerSheet uses an **FBA spreadsheet** with dedicated tabs so you configure your data once and reuse it for every shipment. The FBA spreadsheet contains 4 key tabs.

### 1. Shipment Setting [#1-shipment-setting]

Fill in your warehouse or ship-from address. Each row represents a different warehouse/location identified by a unique **Warehouse Code**. You only need to fill this once per warehouse.

\[\[TODO: screenshot Shipment Setting sheet showing warehouse address configuration (retake — the old one showed real store data)]]

| Column                                                | What it holds                                         |
| ----------------------------------------------------- | ----------------------------------------------------- |
| warehouseCode                                         | Unique ID for this warehouse (e.g. `myStore-US-WH1`). |
| companyName                                           | Company name on the shipping label.                   |
| name / phoneNumber / email                            | Contact information for the ship-from address.        |
| addressLine1 / addressLine2                           | Street address.                                       |
| city / stateOrProvinceCode / countryCode / postalCode | Location details.                                     |
| unitOfDimention                                       | Measurement unit for box dimensions (`CM` or `IN`).   |
| unitOfWeight                                          | Weight unit (`KG` or `LB`).                           |

### 2. Product Info [#2-product-info]

Fill in your product catalog with SKU, FNSKU, ASIN, box dimensions, and prep details. When you create an STA sheet, product data is pulled in automatically via VLOOKUP — so you only fill this once per product.

\[\[TODO: screenshot Product Info sheet showing SKU, FNSKU, ASIN, and box details (retake — the old one showed real store data)]]

| Column                   | What it holds                                                                                  |
| ------------------------ | ---------------------------------------------------------------------------------------------- |
| store                    | Store ref (e.g. `myStore-US`).                                                                 |
| msku                     | Your Merchant SKU.                                                                             |
| fnsku                    | Amazon's Fulfillment Network SKU.                                                              |
| asin                     | Amazon Standard Identification Number.                                                         |
| qtyPerBox                | Number of units per box.                                                                       |
| boxDimensions            | Length x Width x Height (e.g. `50x42.5x35`) in the units from Shipment Setting.                |
| boxWeight                | Weight per box in the units from Shipment Setting.                                             |
| labelOwner               | Who labels items (`SELLER` or `AMAZON`).                                                       |
| prepOwner                | Who preps items (`SELLER` or `AMAZON`).                                                        |
| prepCategory / prepTypes | Prep requirements (e.g. `NONE`, `ITEM_NO_PREP, ITEM_LABELING` — comma-separated for multiple). |

<Callout title="Pro tip: auto-import from FBA inventory reports">
  Use **Store Reports** to create an **FBA Inventory Report** — it gives you SKU, FNSKU, ASIN, and product title automatically. See the [Store Reports guide](/guides/create-store-reports-in-google-sheets) for details.
</Callout>

### 3. Manage Shipments [#3-manage-shipments]

This is your **central tracking hub** for all FBA shipments. Each row represents one shipment plan. You fill in the basic details here, then click **Create STA SS** to generate the working spreadsheet.

\[\[TODO: screenshot Manage Shipments sheet showing shipment tracking with sidebar (retake — the old one showed real store data)]]

| Column                             | What it holds                                                 |
| ---------------------------------- | ------------------------------------------------------------- |
| store / warehouseCode              | Which store and warehouse to ship from.                       |
| planName                           | Your label for this shipment plan.                            |
| fulfillmentSplit                   | Packing strategy (`Box First, Split Later`).                  |
| shipDate / deliveryWindowStartDate | Shipping schedule.                                            |
| planFolder                         | Hyperlink to the STA spreadsheet (auto-generated).            |
| planId / shipmentId                | Amazon's plan and shipment identifiers (auto-filled).         |
| fbaLabel / fbaId                   | FBA label PDF link and confirmation ID (auto-filled).         |
| amazonReferenceId                  | Amazon's reference number confirming readiness (auto-filled). |
| status                             | Current shipment status (`WORKING`, `SHIPPED`, `CLOSED`).     |
| carrier / tracking                 | Your carrier and tracking number.                             |
| remark                             | Internal notes.                                               |

## Creating your STA shipment [#creating-your-sta-shipment]

<Callout title="The problem">
  In Seller Central, creating an FBA shipment plan means clicking through 5+ pages of forms — entering the ship-from address, adding products one by one, filling box dimensions, selecting carriers. For each shipment. Every time.
</Callout>

SellerSheet's sidebar walks you through numbered steps. Each button calls the Amazon API and fills the results back into your sheet. The entire flow takes a few clicks instead of dozens of form pages. Every button of the panel is listed on [FBA](/help/sheets/sellers/fba).

### 1. Create the STA spreadsheet [#1-create-the-sta-spreadsheet]

On the **Manage Shipments** sheet, fill in a row with your shipment details:

1. Set **Store** and **Warehouse Code** (must match Shipment Setting).
2. Enter a **Plan Name** (your internal label).
3. Set **Fulfillment Split** to `Box First, Split Later`.
4. Fill in **Ship Date** and **Delivery Window Start Date**.
5. Click **Create STA SS** in the sidebar.

SellerSheet creates a new spreadsheet in organized Google Drive folders (Store › Country › Year › Month) and opens it. The STA sheet is pre-populated with your warehouse address from Shipment Setting and product data from Product Info via VLOOKUP.

### 2. Fill the STA sheet [#2-fill-the-sta-sheet]

The STA sheet has two main areas: the **header section** (filled from your Manage Shipments row, with a step-by-step progress stepper) and the **item grid** (where you fill in your products and box assignments).

\[\[TODO: screenshot STA sheet showing shipment overview, logistics, packing configuration, and item grid (retake — the old one showed real store data)]]

**Header section.** Holds the shipment overview (Store, Plan Name, Fulfillment Split, Send From Address, Ship Date, Delivery Window Start Date, the box dimension and weight units, FNSKU Label Size, FBA Box Label Size), the progress stepper with the IDs Amazon returns (Packing Option, Placement Option, fees), and — once confirmed — the FBA ID, Reference ID and warehouse.

**Item grid.** Columns boxNo, msku, image, fnsku, title, asin, qtyPerBox, boxDimensions, boxWeight, boxes, quantity, expiration, labelOwner, prepOwner, prepCategory, prepTypes. Fill in:

1. **boxNo** — which boxes contain this product (e.g. `1~3` means boxes 1 through 3).
2. **msku** — your Merchant SKU. VLOOKUP fills fnsku, title, asin, qtyPerBox, boxDimensions, boxWeight, labelOwner, prepOwner, prepCategory, and prepTypes from Product Info.
3. **boxes** — how many boxes for this product line (calculated from the boxNo range).

<Callout type="warn" title="Box number format">
  Use `1~3` to indicate boxes 1 through 3 share the same contents. Each range or number on a separate row represents a distinct product-to-box assignment.
</Callout>

### 3. Initiate the plan [#3-initiate-the-plan]

Click **Initiate Plan** in the sidebar. SellerSheet calls the Amazon API to:

1. Create an inbound plan with your products and box configuration.
2. Generate packing options.
3. Confirm the packing option at once if only one exists.

The progress stepper marks steps **1a** and **1b** as done.

<Callout title="Multiple packing options?">
  If Amazon returns several packing options, pick one in the stepper's **1b** cell, then click **Confirm Pack**. After packing is confirmed, click **Set Box Info** to send your box dimensions and weights to Amazon.
</Callout>

### 4. Generate options [#4-generate-options]

Amazon returns three types of options, each fetched by its own button:

* **Placement options** — click **Gen Placement Opts.** Amazon returns which fulfillment centers to ship to, with their placement fees. Each shipment's warehouse, weight and volume land in the **STA-Options** sheet. Pick a placement in the stepper's **2** cell.
* **Transportation options** — click **Gen Trans. Opts.** Shipping methods (Amazon Partnered Carrier vs. Use Your Own Carrier), with cost and mode, land in the STA-Options **Transportation** dropdowns — pick one per shipment there.
* **Delivery windows** — own-carrier shipments only: click **Gen Delivery Window** to fill the STA-Options **Delivery Window** dropdowns, then pick a slot per shipment.

When Amazon splits items to different warehouses, STA-Options holds one row per shipment, each with its own dropdowns. See [Handling multiple shipments](#handling-multiple-shipments) below.

| Transportation option      | What it means                                                                                                  |
| -------------------------- | -------------------------------------------------------------------------------------------------------------- |
| `AMAZON_PARTNERED_CARRIER` | Amazon handles pickup and delivery. No delivery window selection needed — Amazon manages the scheduling.       |
| `USE_YOUR_OWN_CARRIER`     | You arrange your own shipping. Click **Gen Delivery Window** to get available delivery slots, then select one. |

### 5. Confirm the shipment [#5-confirm-the-shipment]

Once you've selected your options, click **Confirm Shipment**. SellerSheet performs the full confirmation sequence:

1. Confirms the placement option picked in the stepper.
2. Confirms each shipment's transportation option (carrier selection).
3. Confirms each shipment's delivery window (if using your own carrier).

After confirmation:

* The **FBA ID**, **Reference ID** and warehouse appear in the STA header and in STA-Options; the FBA ID becomes the link to the label PDF once Amazon has it.
* **Status** updates to `WORKING`.
* The **Manage Shipments** sheet is updated with the confirmed shipment row.

<Callout title="Pro tip: multiple shipments confirmed in one click">
  When Amazon splits your plan into multiple shipments, **Confirm Shipment** processes all shipments for the selected placement option at once. Each gets its own FBA label PDF and row in Manage Shipments.
</Callout>

### 6. Get the Reference ID [#6-get-the-reference-id]

Click **Get Ref. ID** to check whether Amazon has assigned a Reference ID to your shipment. If ready, the Reference ID is filled in (and mirrored to Manage Shipments) and the status may update. If not ready yet, wait 5–10 minutes and try again.

<Callout title="Pro tip: Reference ID timing">
  The Reference ID confirms Amazon is ready to receive your shipment. It typically takes 5–10 minutes to generate after confirmation. Don't worry if it shows "Not Ready" immediately.
</Callout>

## Getting labels [#getting-labels]

<Callout title="The problem">
  Downloading FBA carton labels from Seller Central means finding the right shipment, navigating to the labels page, and downloading one PDF at a time. For FNSKU labels, you need a separate barcode generator tool.
</Callout>

### FBA carton labels [#fba-carton-labels]

Set **FBA Box Label Size** in the STA header, then click **Get FBA Box Labels** in the sidebar. SellerSheet downloads the FBA carton label PDF to your Google Drive in the plan folder. The **FBA ID** cell becomes a clickable hyperlink to the PDF.

This also works from the **Manage Shipments** sheet — select the row and download the labels for any shipment.

### FNSKU item labels [#fnsku-item-labels]

To generate FNSKU barcode labels for individual items:

1. Set **FNSKU Label Size** in the STA sheet header (e.g. `30x50 mm`, `4x6 inch`).
2. Click **Get FNSKU Labels** in the sidebar.

SellerSheet generates a barcode label for every unit across all boxes (qtyPerBox × boxes) and opens them in a print dialog. Labels are grouped by FNSKU with a summary page showing the box breakdown and total label count — ready for printing.

## Handling multiple shipments [#handling-multiple-shipments]

<Callout title="The problem">
  Amazon often splits your inbound plan into multiple shipments going to different fulfillment centers. In Seller Central, you have to manage each split separately — different carriers, different delivery windows, different labels. Tracking everything across multiple shipment IDs gets overwhelming.
</Callout>

When Amazon splits your items, SellerSheet fills the **STA-Options** sheet with one row per shipment per placement option. Each row has its own:

* **Shipment ID** — unique identifier for each split.
* **Transportation Option ID** — chosen independently per shipment (e.g. Amazon Partnered for one warehouse, your own carrier for another).
* **Delivery Window Option ID** — delivery slot per shipment (only needed for `USE_YOUR_OWN_CARRIER`).
* **Reference ID / Status** — tracked per shipment after confirmation.

How it works:

1. After **Gen Placement Opts.** and **Gen Trans. Opts.**, review the STA-Options rows.
2. Select the **Placement Option** in the stepper's **2** cell on the main STA sheet (options show the fulfillment centers and fee).
3. For each shipment row in STA-Options, select your preferred Transportation Option and Delivery Window Option. **Match Carriers** copies shipment 1's carrier to the other shipments of the same placement.
4. Click **Confirm Shipment** — all shipments for the selected placement are confirmed in one click.
5. Each shipment gets its own FBA label PDF and its own row in Manage Shipments.

An **Inbound PL** (Packing List) sheet is also created showing the detailed item breakdown per shipment — which products go to which fulfillment center.

<Callout type="warn" title="Compare placement fees">
  Different placement options may have different fees. Check the fee of each placement option before confirming — choose the option that balances cost and delivery speed for your needs.
</Callout>

## Track & manage shipments [#track--manage-shipments]

The **Manage Shipments** sheet is your central dashboard for all FBA shipments. After confirming, each shipment appears as a row with its data filled in:

* **Plan Folder** — clickable link back to the STA spreadsheet.
* **FBA Label** — direct link to the carton label PDF.
* **Status** — tracks the lifecycle: `WORKING` → `SHIPPED` → `CLOSED`.
* **Carrier / Tracking** — fill in your carrier name and tracking number after shipping.

Click **Refresh Shipment** in the sidebar to refresh the status of every open shipment on the sheet from Amazon at any time.

<Callout title="Pro tip: cancel if needed">
  Made a mistake? Click **Cancel Plan** in the sidebar before shipping to cancel the entire inbound plan. Every step of the stepper and the Status cell become `CANCELLED`.
</Callout>

## Quick reference [#quick-reference]

| What you need                 | Action                                                                                                      | Sheet                      |
| ----------------------------- | ----------------------------------------------------------------------------------------------------------- | -------------------------- |
| Set up warehouse address      | Fill once, reuse for all shipments                                                                          | `Shipment Setting`         |
| Prepare product catalog       | Fill SKU / FNSKU / ASIN / box details                                                                       | `Product Info`             |
| Create a new shipment         | Fill row → **Create STA SS**                                                                                | `Manage Shipments` → `STA` |
| Walk through the STA workflow | **Initiate Plan** → **Gen Placement Opts.** → **Gen Trans. Opts.** → **Confirm Shipment** → **Get Ref. ID** | `STA`                      |
| Print carton labels           | **Get FBA Box Labels**                                                                                      | `STA`                      |
| Print item barcodes           | **Get FNSKU Labels**                                                                                        | `STA`                      |
| Track all shipments           | View status, labels, tracking; **Refresh Shipment**                                                         | `Manage Shipments`         |

## Maximizing efficiency [#maximizing-efficiency]

* **Reuse Product Info:** fill your product catalog once. Every new STA sheet fills product data via VLOOKUP — no re-entering box dimensions or prep details.
* **Auto-import with FBA inventory reports:** use [Store Reports](/guides/create-store-reports-in-google-sheets) to create FBA Inventory Reports and get SKU, FNSKU, ASIN, and title imported automatically.
* **Batch shipments:** create multiple rows in Manage Shipments and generate STA spreadsheets for each — work on them in parallel across different tabs.
* **Multiple warehouses:** set up multiple warehouse codes in Shipment Setting for different ship-from locations. Select the right one per shipment.
* **After shipment:** for listing management (updating prices, titles, or adding ASINs), see the [Create Listings guide](/guides/bulk-create-revise-amazon-listings-in-google-sheets).