# How to Bulk Check ASIN Selling Eligibility in Google Sheets (https://sellersheetai.com/zh/guides/check-asin-selling-eligibility-in-google-sheets)

> Check whether you may sell hundreds of ASINs at once in Google Sheets — allowed, approval required or restricted, with Amazon's reason and the approval link — next to each product's Buy Box, rank and offer counts.







<Callout title="TL;DR">
  * The **Restriction Check** tab answers "can I sell this?" for many ASINs at once, before you spend time on a listing.
  * Type the store and ASIN, pick a **Reason Locale**, then click **Fetch ASIN Info** (image, brand, rank, Buy Box, offers) and **Get Restrictions**.
  * **Status** reads `ALLOWED`, `APPROVAL_REQUIRED` (open the **Approval Link** to apply) or `RESTRICTED`, with Amazon's reason next to it. A check that failed reads `ERROR`, with the error.
</Callout>

<Callout title="Series: manage Amazon listings in Google Sheets">
  [Overview](/guides/manage-amazon-listings-in-google-sheets) · 1 [All your SKUs](/guides/see-all-amazon-skus-in-google-sheets) · 2 [Live listings](/guides/fetch-live-listings-in-google-sheets) · 3 [Competitor research](/guides/research-amazon-competitors-in-google-sheets) · **4 Selling eligibility** · 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)
</Callout>

In Seller Central you search each ASIN under **Catalog › Add Products** to see whether you may sell it. Here each row also shows the Buy Box price and how many FBA and FBM sellers compete, so you can decide on a product at a glance. In this guide **myStore-US** checks a short list of earbuds it found in [competitor research](/guides/research-amazon-competitors-in-google-sheets) — and the same product on **myStore-UK** — in two clicks.

## Before you start [#before-you-start]

* Connect your store at [sellersheetai.com](https://sellersheetai.com/home) and install the sidebar ([Install & first sync](/help/sheets/install)).
* In the sidebar's **Catalogs** panel, click **Catalog** under **Resources** to open the **SellerSheet Catalog** spreadsheet. Go to the **Restriction Check** tab and expand the **Restriction Check** group in the sidebar.

<img alt="The Restriction Check tab next to the SellerSheet sidebar. Four rows from row 4: myStore-US with B0COMPET02, B0COMPET06 and B0COMPET07, and myStore-UK with B0COMPET02, each with a Reason Locale, a thumbnail and a Status — ALLOWED in green, APPROVAL_REQUIRED in amber, RESTRICTED in red, ALLOWED in green. In the sidebar the Restriction Check group is open with Get Restrictions highlighted" src="__img0" />

## Check a list of ASINs [#check-a-list-of-asins]

<Steps>
  <Step>
    ### Fill the rows [#fill-the-rows]

    From row 4, fill three columns per row:

    * **Store ✎:** the store and marketplace, such as `myStore-US`. Type it — there is no dropdown — with the country code in capitals.
    * **ASIN ✎:** the ASIN, in capitals and without spaces.
    * **Reason Locale ✎:** pick the language Amazon should write its reasons in, such as en_US. Without one, the row gets `ERROR`.

    Coming from [Catalog Research](/guides/research-amazon-competitors-in-google-sheets)? Select the rows there and click **Send to Restriction Check**: their store and ASIN are added here, with the Reason Locale set to the marketplace's language (en_US for myStore-US). Change it if you want Amazon's reasons in another language.
  </Step>

  <Step>
    ### Click Fetch ASIN Info [#click-fetch-asin-info]

    Click **Fetch ASIN Info**. Each row fills with the product's **Image** and **Brand**, its **Rank** (it can be blank), the **Buy Box** price and the number of **FBA Offers** and **MFC Offers** (merchant-fulfilled, FBM), all for a new item.

    The sidebar says how many rows it filled. A row left without an image got nothing back from Amazon: check the ASIN and the store's marketplace.
  </Step>

  <Step>
    ### Click Get Restrictions [#click-get-restrictions]

    Click **Get Restrictions**. Each row gets a **Status**, the **Reasons**, an **Approval Link** where Amazon offers one, and the time in **Checked At**. A long list stops after about five minutes, and the sidebar says so; click **Get Restrictions** again to check the rest.

        <img alt="Close-up of Status, Reasons and Approval Link. B0COMPET02 is ALLOWED. B0COMPET06 is APPROVAL_REQUIRED with the reason &#x22;You need approval to list in this brand.&#x22; and a Seller Central approval link. B0COMPET07 is RESTRICTED, in red, with the reason &#x22;You cannot list the product in this condition.&#x22; B0COMPET9, an ASIN one character short, is ERROR, in red, with &#x22;Error: InvalidInput: Invalid 'asin' provided.&#x22;" src="__img1" />
  </Step>
</Steps>

## What the Status means [#what-the-status-means]

| Status              | What to do                                                                                                                                                                                     |
| ------------------- | ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| `ALLOWED`           | You can list it as new. Go on to [Listing Drafts](/guides/write-amazon-listings-with-ai-in-google-sheets) or the [Publish Queue](/guides/bulk-create-revise-amazon-listings-in-google-sheets). |
| `APPROVAL_REQUIRED` | Open the **Approval Link** and apply in Seller Central. Check again once you're approved.                                                                                                      |
| `RESTRICTED`        | You can't list it. **Reasons** says why. Pick another product.                                                                                                                                 |
| `ERROR`             | The check failed. **Reasons** gives the error — often a mistyped ASIN or a missing Reason Locale. Fix it, clear Status and check again.                                                        |

## Tricks [#tricks]

* **Check again:** clear the **Status** cell and click **Get Restrictions**. Rows with a Status are skipped, so a second click only checks new rows — and continues where a long run stopped.
* **Fresh prices:** **Fetch ASIN Info** refreshes the Buy Box, rank and offers on every click. The image and brand are fetched only while **Image** is empty; clear it to fetch them again.
* **Several marketplaces:** each row has its own store, so put the same ASIN on a `myStore-US` row and a `myStore-UK` row to see where you may sell it.
* **Track your approvals:** sort by **Status** to group the `APPROVAL_REQUIRED` rows, apply through their links, then clear their Status and check them again later.

## Frequently asked questions [#frequently-asked-questions]

### What do the Status values mean? [#what-do-the-status-values-mean]

`ALLOWED` means you can list the ASIN as new. `APPROVAL_REQUIRED` means Amazon needs to approve you first — open the Approval Link to apply. `RESTRICTED` means you cannot list it, and Reasons says why. `ERROR` means the check failed for that row, and Reasons gives the error.

### How do I check a row again? [#how-do-i-check-a-row-again]

Clear its Status cell and click Get Restrictions. Rows that already have a Status are skipped, so a second click only checks the new rows.

### Why does a row say ERROR with "missing reasonLocale"? [#why-does-a-row-say-error-with-missing-reasonlocale]

The row has no Reason Locale. Pick one from the dropdown, clear the ERROR in Status, and click Get Restrictions again.

### Which condition does the check use? [#which-condition-does-the-check-use]

New. Both the restriction check and the Buy Box and offer counts are for a new item.

### Does it use credits? [#does-it-use-credits]

No. These buttons don't use Credits. On the Free plan, each check counts toward your monthly sidebar operations.