How to Automatically Sync & Import the AWD Inbound Shipments Report to Google Sheets (The Hopted Way)

Using an Amazon to Google Sheets integration like Hopted, you set up the connection once, and your data flows automatically.

Step 1.

Install the Hopted browser extension and sign in using your Google Account.

Step 2.

Securely connect your Amazon Seller Central to Google Sheets using Hopted's integration wizard.

Step 3.

In Google Sheets, from the list of available Amazon Seller Central reports, select "AWD Inbound Shipments" for a specific date range. This can be as recent as the "Last 7 days" or a custom range going as far back as 365 days. For this example, we'll select "Ignore closed shipments older than last 30 days".

Step 4.

Select columns that you need: ASIN, Destination City, Discrepancy, Expected qty, Received qty, Status, and other fields.

Step 5.

Set your schedule. Choose how often you want to export and refresh your Amazon AWD Shipments—every hour, every day, or less frequent.

Step 6.

Save your data pipeline. This will export your AWD Shipments from Seller Central into spreadsheets instead of dealing with CSVs. The AWD shipment information in your spreadsheets will be up to data forever.

What is the Amazon AWD Inbound Shipments Report?

"AWD" stands for Amazon Warehousing and Distribution. This is Amazon's upstream, low-cost bulk storage solution. Think of it as your personal holding warehouse before your inventory is sent to FBA fulfillment centers.

The AWD Inbound Shipments Report is the only report that gives you detailed, SKU-level tracking for inventory you've sent to these AWD centers.

This makes it the single source of truth for answering questions like:

• Expected vs. received (by shipment/SKU) — What’s the delta/shortage?

• Fill rate overall — Are AWD inbound shipments received in full?

• Open & aging — Which shipments are still pending check-in today?

• Receiving speed & SLA — Days shipped→received and which breached SLA.

• Shortage hotspots — Which DCs/carriers/SKUs drive the most shortages?

• Claims readiness — Which shipments are claimable and the claimable value.

• Incoming forecast (7–14 days) — What inbound is expected by DC/SKU for planning.

How to Analyze & Track Your Amazon AWD Shipments in Spreadsheets

Now that you have a live feed, you can move from data entry to data analysis. This is the real power of analyzing your Amazon Seller Central data in spreadsheets.

Here are 2 "recipes" you can build immediately:

Recipe 1: Build a Live Shipment Reconciliation Dashboard

This is the primary use case. With your AWD report data syncing automatically, you can use simple spreadsheet formulas to instantly flag problems.

• Create a new column: Discrepancy = Received Quantity - Expected Quantity

• Use Conditional Formatting to turn any cell red where Discrepancy is not "0".

• Add the Problem Type and Damaged Quantity columns right next to it.

Now, instead of manually hunting for errors, your dashboard tells you exactly which shipments need a claim filed, complete with the Shipment ID and SKU.

Recipe 2: Track Your "True" In-Transit Inventory

Tracking your Amazon data gets easier. You can combine this report with the FBA Inventory Ledger report (which Hopted also automates) in the same spreadsheet.

This gives you a complete, multi-stage view of your inventory:

• In-Transit to AWD: (From the AWD Inbound Report)

• Available in AWD: (From the AWD Inventory Report)

• In-Transit to FBA: (From the FBA Inventory Ledger)

• Available in FBA: (From the FBA Inventory Ledger)

Common workflows this report unlocks

• Shipment Reconciliation: This is the big one. The report shows you "Expected Quantity" vs. "Received Quantity" and "Damaged Quantity." This is your primary tool for catching discrepancies and filing claims for lost or damaged inventory.

• Tracking Upstream Inventory: It's the only way to get a real-time status on your inventory before it's in the FBA network. You can see if a shipment is SHIPPED, IN_TRANSIT, RECEIVING, or CLOSED.

• Cash Flow & Forecasting: Knowing exactly when your bulk inventory is received and CLOSED allows you to better manage cash flow and plan your FBA auto-replenishment, preventing costly stockouts.

FAQ about Amazon AWD Inbound Shipments

Q: How does this differ from AWD Inventory Ledger?
Ledger is a movement history (received/departed/lost/damaged). Inbound Shipments is shipment/line-level expected vs. received with discrepancy context. Use both for reconciliation.

Q: What is the difference between Amazon AWD vs FBA? 
Think of them as upstream and downstream. Amazon AWD program is a low-cost, bulk storage solution for your upstream inventory. You send large, consolidated shipments to AWD for long-term storage. FBA (Fulfillment by Amazon) is your "ready-to-sell" inventory, stored in fulfillment centers for picking, packing, and fast Prime shipping to customers. AWD's primary job is to automatically replenish your FBA inventory so you never stock out.

What are the main benefits of using Amazon AWD?
The primary benefits are cost savings and simplified logistics.

• Lower Storage Fees: AWD storage rates are significantly cheaper than FBA, especially for long-term and peak-season (Q4) storage.

• No FBA Restock Limits: Inventory held in AWD does not count against your FBA capacity or restock limits.

• Automated FBA Replenishment: AWD automatically sends your inventory to FBA fulfillment centers when your stock runs low, helping you stay in stock and avoid lost sales.

• Consolidation: You can send one large shipment to a single AWD center, and Amazon will manage the distribution to multiple FBA centers across the country, saving you on inbound placement fees.

How does Amazon AWD work?
The process is straightforward:

1. Send Bulk Inventory: You create a shipment in Seller Central and send your bulk inventory (in boxes, on pallets) to an assigned Amazon AWD center.

2. Low-Cost Storage: Amazon receives and stores your inventory at its low-cost daily rate.

3. Auto-Replenishment: Amazon's systems monitor your FBA inventory levels. When you start to run low, AWD automatically picks inventory and ships it to the necessary FBA fulfillment centers to keep your products in stock.

4. Multi-Channel: You can also use your AWD inventory to fulfill orders from other sales channels, not just Amazon.

How do I send inventory to an AWD center on Amazon?
You use the "Send to Amazon Warehousing and Distribution" workflow in Seller Central.

1. Go to the AWD Program page and select "Create shipment."

2. Choose the inventory (SKUs) you want to send.

3. Confirm your shipping details, including the carrier (you can use Amazon's Partnered Carrier or your own).

4. Print and apply the box and pallet labels provided by Amazon.

5. Your carrier will then pick up the shipment and deliver it to the designated AWD center.

What are the Amazon AWD fees?
AWD fees are broken down into three simple, pay-as-you-go parts:

1. Storage Fees: A low daily or monthly fee charged based on the volume (in cubic meters/feet) your inventory occupies.

2. Processing Fees: A fixed fee charged per box when your inventory is received (inbound) and again when it's shipped out to FBA (outbound).

3. Transportation Fees: A fee based on volume (per cubic meter/foot) for moving your inventory from the AWD center to an FBA fulfillment center.

Q: Can I analyze AWD Shipments without scripts?
Yes—Hopted writes clean, normalized rows to your sheet, ready for pivots and formulas.

Q: How is Hopted different from other Amazon seller software?
Most Amazon tools force you into their rigid dashboards and pre-built reports. You have to change your workflow to fit their software. With Hopted is the opposite. It’s a flexible data automation layer that works directly inside your existing spreadsheets (like Google Sheets). Instead of forcing you to learn a new system, Hopted brings all your scattered Amazon data (sales, inventory, AWD, etc.) right to you. You can build the fully custom reports and automations you need, not the ones a rigid tool dictates.

Related Automation & Reports

Once you've mastered the All Orders report, you can expand your automated dashboard:

• [Internal Link -> Pillar Page] Auto-Import Your Amazon Inventory Report: Sync your inventory levels to cross-reference with your sales data.

• [Internal Link -> Pillar Page] Connect Your Amazon FBA Shipments Report: Track your inbound FBA inventory.

• [Internal Link -> PillarPage] Automate Your Amazon Settlement Reports: Simplify your accounting and reconciliation.