# How to See All Your Amazon SKUs in Google Sheets (https://sellersheetai.com/zh/guides/see-all-amazon-skus-in-google-sheets)
> List every SKU of an Amazon store in Google Sheets — thumbnail, price, stock, status and fulfillment — filter it in seconds and pass SKUs on to Listing Snapshot or the Publish Queue.
* The **Catalog** tab lists every SKU of one store: thumbnail, ASIN, name, price, quantity, status, live status and fulfillment.
* Type the store in **A4** and click **Sync Catalog**. Then filter row 5 as you like — no new sync needed.
* A first win: filter **Fulfillment** to FBM and **Qty** to 0. These are the listings you can't ship today.
* Use the list as the starting point for everything else: paste its SKUs into [Listing Snapshot](/guides/fetch-live-listings-in-google-sheets) or the [Publish Queue](/guides/bulk-create-revise-amazon-listings-in-google-sheets).
[Overview](/guides/manage-amazon-listings-in-google-sheets) · **1 All your SKUs** · 2 [Live listings](/guides/fetch-live-listings-in-google-sheets) · 3 [Competitor research](/guides/research-amazon-competitors-in-google-sheets) · 4 [Selling eligibility](/guides/check-asin-selling-eligibility-in-google-sheets) · 5 [Write listings with AI](/guides/write-amazon-listings-with-ai-in-google-sheets) · 6 [Bulk create & revise](/guides/bulk-create-revise-amazon-listings-in-google-sheets)
Seller Central's inventory page shows your listings a page at a time. The Catalog tab puts the whole store in one sheet you can sort, filter and copy from. In this guide the store is **myStore-US**, selling earbuds under **myBrand**.
## Before you start [#before-you-start]
* Connect your Amazon store at [sellersheetai.com](https://sellersheetai.com/home) under **Settings → Stores & Marketplaces**. SellerSheet then syncs Amazon's All Listings report for it every day.
* Install the SellerSheet sidebar. See [Install & first sync](/help/sheets/install).
* Open the **SellerSheet Catalog** spreadsheet from the sidebar's **Catalogs** panel (under **Resources**). If another tab is open when you click **Sync Catalog**, the sidebar switches to the Catalog tab for you; type the store and click again.
## Sync the list [#sync-the-list]
### Type the store in A4 [#type-the-store-in-a4]
Type one store and marketplace, such as `myStore-US`: your store name, a dash, and the country code. Not sure of the name? Leave A4 empty and click **Sync Catalog** — the message lists your stores.
### Click Sync Catalog [#click-sync-catalog]
Click **Catalog › Sync Catalog**. The rows land from row 6, sorted by SKU. **B4 Last Sync** shows when you synced, and **C4 Data as of** shows the date of the Amazon report the rows come from.
### Read and filter [#read-and-filter]
| Column | What it shows |
| ---------------------------- | ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| **Image** | The main image as a thumbnail. |
| **Store, SKU, ASIN** | One row per SKU, marketplace and condition. |
| **Product Name, Price, Qty** | As on the listing. Qty is your own stock on an FBM listing; Amazon's report doesn't carry FBA stock. |
| **Status** | The listing status from Amazon's report, such as Active. |
| **Condition** | Amazon's condition code; 11 means New. |
| **Live** | What Amazon last reported. `BUYABLE, DISCOVERABLE`: shoppers can buy and find it. `DISCOVERABLE` alone: they can find it but not buy it. Checked in the background, so it can be weeks old. |
| **Fulfillment** | **FBA** or **FBM**. |
| **Open Date** | When the listing was created. |
Use the filter buttons on row 5 to narrow the list. A filter works at once, without a new sync.
## Things to do with the list [#things-to-do-with-the-list]
* **Find the gaps:** filter **Qty** to 0 and **Fulfillment** to FBM to see what you can't ship. Or filter **Live** with **Text does not contain** `BUYABLE`, then check those SKUs on Listing Snapshot for today's status.
* **Audit them:** copy the SKUs of column C into column B of [Listing Snapshot](/guides/fetch-live-listings-in-google-sheets) from row 4, with the store in column A, and click **Fetch by SKU** to see each listing's issues.
* **Edit them in bulk:** on the [Publish Queue](/guides/bulk-create-revise-amazon-listings-in-google-sheets), type the store in **A3**, paste the SKUs in column B from row 7 and click **Fetch by SKU**. Each row fills from its live listing, ready to change only the cells you edit (`PARTIAL_UPDATE`).
* **Delete old SKUs:** paste them into the Publish Queue with `DELETE` in column C — that is all a `DELETE` row needs. A `DELETE` can't be undone, so click **Backup** first.
## Tricks [#tricks]
* **Keep your filters:** each sync rebuilds the row-5 filter and clears its settings. Save the ones you use as a filter view (**Data › Filter views › Create new filter view**); a sync leaves filter views alone.
* **Keep your notes elsewhere:** a sync rewrites everything from row 5 down, and re-sorts it. Put your own notes on another tab and look them up by SKU with `XLOOKUP`, so they never fall out of line.
* **Another marketplace:** change A4 (for example to `myStore-UK`) and sync again. The table is replaced with that marketplace's SKUs.
* **A listing you created today** appears after Amazon's next daily report.
## If the sync stops [#if-the-sync-stops]
| The message says | What to do |
| --------------------------------------------------------------- | ------------------------------------------------------------------------------------------------------------------------------------- |
| Type ONE store in A4 before syncing | A4 is empty or says All. Type one store; the message lists yours. |
| A4 accepts ONE store, but 2 were given | Keep one store in A4. |
| "…" is not a store you own or have been given access to | Check the spelling against the list in the message. |
| No … listings in the SellerSheet warehouse for this store | That marketplace's listings report isn't syncing. Check the store's report sync and marketplace on the dashboard. |
| The SellerSheet warehouse has NO listings for this store at all | Its listings report isn't syncing. Re-authorize the store, or check its report sync on the dashboard. |
| ROW CAP HIT | The store has more than 50,000 listings; the first 50,000 are shown. |
| … hit the 50,000-row query cap … the table is incomplete | A store that sells in several marketplaces can reach this with fewer listings in one marketplace. Some SKUs are missing from the tab. |
## Frequently asked questions [#frequently-asked-questions]
### Where does the Catalog tab get its data? [#where-does-the-catalog-tab-get-its-data]
From Amazon's All Listings report, which SellerSheet syncs for your store every day once the store is connected. Sync Catalog reads the newest copy SellerSheet holds — it does not ask Amazon live.
### Why is "Data as of" amber? [#why-is-data-as-of-amber]
C4 shows the date of the Amazon report the rows come from, and turns amber when it is more than a day old. A catalog that has not changed is not stored again, so the date can be a few days old while the list is still current.
### Can I see every marketplace at once? [#can-i-see-every-marketplace-at-once]
No. A4 takes one store and marketplace, such as myStore-US. To see another marketplace, change A4 and click Sync Catalog again; the table is replaced.
### Why are the Image or Live cells blank for some SKUs? [#why-are-the-image-or-live-cells-blank-for-some-skus]
Images and the live status are filled in the background, newest SKUs first, and each SKU is checked again about every 60 days. A SKU that has not been reached yet shows blank cells; sync again later.