How to Automatically Sync & Import the AWD Inventory 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 Inventory".

Step 4.

Select columns that you need: SKU, inbound quantity, Available distributable quantity, Expiration date, Replenishment quantity, and other fields.

Step 5.

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

Step 6.

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

What is the Amazon Warehousing and Distribution Inventory Report?

The AWD Inventory page in Seller Central is a live dashboard that shows you the real-time status of your inventory across Amazon's entire network.

It's the only place you can see your complete inventory funnel, from your upstream bulk storage (AWD) to your "ready-to-sell" FBA inventory.

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

• Inbound into AWD: How many units are on their way from your supplier but not yet received at the AWD warehouse?

• Available in AWD: How many sellable units are sitting in low-cost bulk storage, ready to replenish FBA?

• Reserved in AWD: How many units are already allocated for FBA replenishment, in transfer, or being researched?

• Outbound to FBA: How many units have left AWD and are currently in transit to an FBA fulfillment center?

• Available in FBA: How many units are actually sellable and Prime-eligible right now?

• Undistributable: How much inventory is Warehouse Damaged, Lost, or Expired?

Without this complete, end-to-end view, you're blind to stockouts, over-ordering, and cash flow traps.

How to Analyze & Track Your AWD Inventory 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 4 "recipes" you can build immediately:

Recipe 1: Build a "Master Inventory Funnel"

This is the ultimate goal. Track your Amazon data from the entire supply chain in one row per SKU.

• List your SKUs in Column A.

• Sync Inbound into AWD into Column B.

• Sync Available in AWD into Column C.

• Sync Outbound to FBA into Column D.

• Sync Available in FBA into Column E.

• Create a "Total Inventory" formula: =[Col C] + [Col D] + [Col E]

You now have a real-time, holistic view of your entire inventory pipeline, allowing you to see exactly where your units are and identify bottlenecks instantly.

Recipe 2: Automatically Track Lost & Damaged Inventory

Stop hunting for reimbursement opportunities.

• Sync the Undistributable data into its own columns (Warehouse Damaged, Lost).

• Create a "Total Lost/Damaged" column.

• Sort by this column once a week to see exactly which SKUs require you to open a case for reimbursement.

Recipe 3: Automate Replenishment & Purchasing

You can now analyze your Amazon data to make decisions.

• Forecast FBA Stockouts: Create a formula: [Available in FBA] / [Avg 30-Day Sales] = Days of Supply. When this drops below 30, flag the row yellow.

• Forecast AWD Stockouts: Create a formula: [Available in AWD] / [Avg 30-Day Sales] = Upstream Days of Supply. When thisdrops below 60, flag the row red—it's time to place a new PO with your supplier.

Recipe 4: Reconcile Inbounds vs. Ledger

You can finally create an AWD inventory reconciliation spreadsheet that works.

• Tab 1: Sync your AWD Inbound Shipments Report (shows Quantity Expected and Quantity Received).

• Tab 2: Sync your AWD Inventory Ledger (shows Event Type = Received).

• Master Tab: Use SUMIF functions to compare the total Received from both reports for a specific Shipment ID. You can instantly flag shipments where the data doesn't match.

Common workflows this report unlocks

• High reserved share: investigate why AWD units are not available for moves; check replenishment/activity logs. 

• Low DoC alerts: flag SKUs with DoC < threshold to trigger AWD→FBA moves or supplier POs.

• Snapshot ↔ Ledger mismatches: when levels jump unexpectedly, cross-check AWD Inventory Ledger events (received/departed/lost/found/damaged). 

• Labeling/eligibility issues: if units appear “unavailable,” validate eligibility and recent AWD receipts before planning replenishment. 

FAQ about Amazon AWD Inventory

Q: Why shouldn't I just track this in Seller Central? 
You can, but it's incredibly inefficient and you can't combine FBA inventory information. The Seller Central dashboard doesn't let you analyze your data. You can't see all your SKUs in one view, calculate "Total Inventory" (AWD + FBA), or create custom alerts. To do any meaningful analysis, you must export your data to a spreadsheet. Automating this is the logical next step.

Q: Can Hopted also sync my AWD smart storage discount eligibility?
Yes. Hopted can pull all data points from the AWD dashboard, including the metrics for Automated replenishment ratio and Combined historical days of supply. This allows you to track your discount eligibility in your spreadsheet and create alerts if you are close to falling out of the discount-eligible tier.

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.

Q: How often should I sync?
Operations usually benefit from hourly syncs. Choose the cadence that matches your SLA risk tolerance.

Q: Can I analyze AWD Inventory 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.