How to Monitor Multi-Marketplace Amazon Inventory

Learn how to track Amazon inventory across global marketplaces, pull Seller Central data, and update weekly inventory spreadsheets.

August 25, 2026 By Hafiz Hamza

Learn how to extract inventory data from Amazon Seller Central across multiple global marketplaces and populate weekly tracking spreadsheets to calculate stock velocity, days of supply, and replenishment requirements.

This guide applies to e-commerce operations managers and Amazon inventory specialists who perform regular weekly stock reviews and replenishment planning.

Spreadsheet Structure Overview

The multi-marketplace tracking workbook contains individual tabs for each country (such as USA, Australia, UAE, Canada, UK, and Saudi Arabia) and an automated Main Sheet that aggregates key replenishment metrics.

Step #1: You can monitor the inventory of all marketplaces through the Main Sheet tab. — You can monitor the inventory of all marketplaces through the **Main Sheet** tab.

Step #2: Update data on all marketplace's tabs — Update data on all marketplace's tabs

Step #3: Click on the Aus 30 Days tab. — Click on the **Aus 30 Days** tab.

Method 1: Gathering Marketplace Data via Manage All Inventory

For regional marketplaces, retrieve live 30-day unit sales, reserved units, available units, and inbound quantities directly from Amazon Seller Central.

Step #4: Switch to your Amazon Seller Central browser window. — Switch to your **Amazon Seller Central** browser window.

Step #5: Click the merchant and marketplace switcher dropdown in the Seller Central header. — Click the merchant and marketplace switcher dropdown in the Seller Central header.

Step #6: Select the target account menu item. — Select the target account menu item.

Step #7: Click Australia (or your desired target marketplace) from the switcher dropdown. — Click **Australia** (or your desired target marketplace) from the switcher dropdown.

Step #8: Click Manage All Inventory in the navigation menu. — Click **Manage All Inventory** in the navigation menu.

Step #9: Copy the product ASIN from your spreadsheet. — Copy the product ASIN from your spreadsheet.

Step #10: Click into the search field on the Manage All Inventory page. — Click into the search field on the Manage All Inventory page.

Step #11: Click the search button to filter for the ASIN. — Click the search button to filter for the ASIN.

Step #12: Check the Units Sold figure in the Performance column for the last 30 days. — Check the **Units Sold** figure in the Performance column for the last 30 days.

Step #13: Click the quantity link under the Inventory column to open FBA inventory details. — Click the quantity link under the **Inventory** column to open FBA inventory details.

Step #14: Review the reserved quantity breakdown. — Review the reserved quantity breakdown.

Step #15: Review the total on-hand and available quantities. — Review the total on-hand and available quantities.

Step #16: Switch back to Google Sheets and enter the units sold, available, reserved, and inbound stock into the marketplace sheet. — Switch back to Google Sheets and enter the units sold, available, reserved, and inbound stock into the marketplace sheet.

Repeat this process for each required regional tab (Aus 30 Days, UAE 30 Days, CA 30 Days, UK 30 Days, SA 30 Days).

Method 2: Automating US Marketplace Data via Restock Reports

For larger marketplaces like the US, download a fulfillment restock report to populate data in bulk.

Step #17: Click the US Restock - Paste here tab in your Google Sheets workbook. — Click the **US Restock - Paste here** tab in your Google Sheets workbook.

Step #18: Switch to your Seller Central browser window. — Switch to your Seller Central browser window.

Step #19: Click the store and marketplace switcher dropdown. — Click the store and marketplace switcher dropdown.

Step #20: Select the United States marketplace. — Select the **United States** marketplace.

Step #21: Click the main menu icon in Seller Central. — Click the main menu icon in Seller Central.

Step #22: Select Fulfillment under the Reports menu. — Select **Fulfillment** under the Reports menu.

Step #23: Click Restock Inventory from the inventory reports list. — Click **Restock Inventory** from the inventory reports list.

Step #24: Click the Request .csv Download button and download the generated file. — Click the **Request .csv Download** button and download the generated file.

Step #25: Return to your spreadsheet workbook. — Return to your spreadsheet workbook.

Step #26: Paste the downloaded CSV contents into the US Restock - Paste here tab. — Paste the downloaded CSV contents into the **US Restock - Paste here** tab.

Ensure the first nine columns match the expected column order exactly so formulas on the USA 30 Days sheet can automatically pull data from this tab.

Step #27: Click on the USA 30 Days tab to confirm the stock figures populated correctly. — Click on the **USA 30 Days** tab to confirm the stock figures populated correctly.

Reviewing the Consolidated Main Sheet

Once all individual marketplace tabs are updated, review the summary calculations on the primary dashboard.

Step #28: Click on the Main Sheet tab. — Click on the **Main Sheet** tab.

Step #29: Review the 30-day sales volume column. — Review the 30-day sales volume column.

Step #30: Check the Replenish quantity column for stock reorder recommendations. — Check the **Replenish** quantity column for stock reorder recommendations.

Step #31: Review the Days Left column to monitor inventory runout timelines. — Review the **Days Left** column to monitor inventory runout timelines.

Updating the Weekly Global Inventory Tracker

Transfer your weekly snapshot data into the global tracking sheet for long-term historical records.

Step #32: Switch to the global e-commerce tracking spreadsheet tab. — Switch to the global e-commerce tracking spreadsheet tab.

Step #33: Press Ctrl + Right Arrow to jump to the far right end of the spreadsheet. — Press `Ctrl + Right Arrow` to jump to the far right end of the spreadsheet.

Step #34: Locate the product section header row. — Locate the product section header row.

Step #35: Right-click the last column header. — Right-click the last column header.

Step #36: Click + Insert 7 columns to the right to create space for the new weekly entry. — Click **+ Insert 7 columns to the right** to create space for the new weekly entry.

Copy and paste the header formatting into the new columns, then update the date header.

Step #38: Switch back to the DP Weekly Inventory spreadsheet. — Switch back to the **DP Weekly Inventory** spreadsheet.

Step #39: Copy the updated 30-day sales volume and stock totals. — Copy the updated 30-day sales volume and stock totals.

Step #40: Select the destination cell in the global tracking sheet. — Select the destination cell in the global tracking sheet.

Press Shift + Ctrl + V to paste values only without overwriting formatting.

Step #42: Copy remaining current stock values from the weekly inventory sheet. — Copy remaining current stock values from the weekly inventory sheet.

Step #43: Select the corresponding cell in the global tracker and paste values (Shift + Ctrl + V). — Select the corresponding cell in the global tracker and paste values (`Shift + Ctrl + V`).

Q: How often should this inventory data be updated?

A: Update the inventory sheet every Monday to keep replenishment calculations and runout velocity current.

Q: Why paste the US Restock report into a dedicated tab instead of entering it manually?

A: Downloading the Amazon US Restock CSV and pasting it into the dedicated tab allows formulas to automatically pull units sold, available stock, and inbound inventory, saving significant time for high-volume catalogs.

Q: Why use Paste Values (Shift + Ctrl + V) when updating the global sheet?

A: Pasting values prevents formula references and cell formatting from breaking across linked sheets.

Term	Definition
ASIN	Amazon Standard Identification Number, a unique 10-character alphanumeric identifier assigned to each product.
FBA Reserved Inventory	Units in Amazon fulfillment centers currently tied to hub transfers, or processing. Don't need to add customer orders in reserved.
Restock Report	An Amazon FBA fulfillment report detailing sales velocity, inventory levels, and recommended replenishment quantities.

How to Monitor Multi-Marketplace Amazon Inventory

Learn how to track Amazon inventory across global marketplaces, pull Seller Central data, and update weekly inventory spreadsheets.

August 25, 2026 By Hafiz Hamza

This guide applies to e-commerce operations managers and Amazon inventory specialists who perform regular weekly stock reviews and replenishment planning.

Spreadsheet Structure Overview

Method 1: Gathering Marketplace Data via Manage All Inventory

For regional marketplaces, retrieve live 30-day unit sales, reserved units, available units, and inbound quantities directly from Amazon Seller Central.

Repeat this process for each required regional tab (Aus 30 Days, UAE 30 Days, CA 30 Days, UK 30 Days, SA 30 Days).

Method 2: Automating US Marketplace Data via Restock Reports

For larger marketplaces like the US, download a fulfillment restock report to populate data in bulk.

Ensure the first nine columns match the expected column order exactly so formulas on the USA 30 Days sheet can automatically pull data from this tab.

Reviewing the Consolidated Main Sheet

Once all individual marketplace tabs are updated, review the summary calculations on the primary dashboard.

Updating the Weekly Global Inventory Tracker

Transfer your weekly snapshot data into the global tracking sheet for long-term historical records.

Copy and paste the header formatting into the new columns, then update the date header.

Press Shift + Ctrl + V to paste values only without overwriting formatting.

Q: How often should this inventory data be updated?

A: Update the inventory sheet every Monday to keep replenishment calculations and runout velocity current.

Q: Why paste the US Restock report into a dedicated tab instead of entering it manually?

Q: Why use Paste Values (Shift + Ctrl + V) when updating the global sheet?

A: Pasting values prevents formula references and cell formatting from breaking across linked sheets.

Term	Definition
ASIN	Amazon Standard Identification Number, a unique 10-character alphanumeric identifier assigned to each product.
FBA Reserved Inventory	Units in Amazon fulfillment centers currently tied to hub transfers, or processing. Don't need to add customer orders in reserved.
Restock Report	An Amazon FBA fulfillment report detailing sales velocity, inventory levels, and recommended replenishment quantities.