How to Bulk Add Up to 50,000 Existing ASINs to Your Amazon Catalog

Check eligibility, fill in SKUs, and submit — all from Google Sheets in minutes

Introduction

Want to sell products that already exist on Amazon? In Seller Central, you'd search for each ASIN, click "Sell this product," fill in your offer, and repeat — one at a time. For a catalog of hundreds or thousands of products, that's hours of manual work.

SellerSheet lets you add up to 50,000 existing ASINs to your catalog in a single submission from Google Sheets. The entire process takes three steps:

1

Check Eligibility

Verify you're approved to sell each ASIN.

2

Fill In SKUs & ASINs

Set productType to PRODUCT, add your SKU/ASIN pairs.

3

Submit to Amazon

One click — up to 50,000 SKUs per submission.

Video tutorial coming soon

Prerequisites

  • Store Authorization: Authorize your Amazon store on the SellerSheet Dashboard.
  • Sidebar Installed: Install the SellerSheet sidebar. See the Onboarding Guide.
  • A list of ASINs: The ASINs you want to add, plus your own SKU identifiers for each.

Step 1: Check Selling Eligibility

The Problem

Some ASINs are restricted — they require approval, brand gating, or category ungating before you can sell them. Finding out after submission wastes time. In Seller Central, you'd have to check each one individually.

Before adding ASINs, check if you're approved to sell them using the Listings Restrictions sheet tab in your SellerSheet Catalog spreadsheet:

  1. Go to the Listings Restrictions sheet tab.
  2. Enter your ASINs in the ASIN column.
  3. Click Check Restrictions in the sidebar.
  4. Review results — ASINs with no restrictions are ready to add. Restricted ASINs will show the required approval type.

Pro Tip: Check in Bulk

Paste all your ASINs at once — SellerSheet checks them in bulk. For a detailed walkthrough, see the ASIN Selling Eligibility guide.

Step 2: Prepare & Fill In Your SKUs

Now switch to the Create Listings sheet tab. Since you're adding existing products (not creating new ones), the setup is minimal:

  1. Set Store (A2) and Language Local (B2) for your marketplace.
  2. Write PRODUCT in the productType column (D) for each row.
  3. Click Prepare Template in the sidebar — this loads the PRODUCT template (very few columns needed).
  4. Set operationType to UPDATE in column C for each row.
  5. Fill in your sku (column B) — your own identifier for each product.
  6. Fill in the externally_assigned_product_identifier column with the ASIN for each row.

Why productType = PRODUCT?

PRODUCT is the simplest productType — designed specifically for matching existing catalog products. Since the product already exists on Amazon (with title, brand, images, etc.), you only need to provide your SKU and the ASIN. Amazon handles the rest.

Optionally, you can also fill in purchasable_offer (your price) and condition_type (new/used) if you want to set them during submission.

Pro Tip: Prepare Your Data in Advance

Have your SKU/ASIN list ready in another sheet tab or file. After Prepare Template loads the columns, just paste your data into the right columns. No manual entry needed.

Step 3: Submit & Track Results

Which button you click depends on how many SKUs you're submitting:

SKU CountActionProcessing
< 20 SKUsValidate Listing (dry-run), then Fully-update ListingImmediate — results appear instantly in Submission Log
20 – 50,000 SKUsSubmit ListingAmazon queue — Feed ID in Submission Log, click Update Log to check

Tracking Your Submission

  1. Go to the Submission Log sheet tab.
  2. Find your submission row — it shows the Feed ID (for Submit Listing) and a backup link.
  3. For Submit Listing: regularly click Update Log in the sidebar until the Processing Status shows DONE.
  4. Check the Processing Summary column for the result — it shows success/error details for each SKU.

Submission Log Columns

  • Feed ID: Amazon's identifier for bulk submissions.
  • Listing Backup: Hyperlink to a snapshot of the data you submitted.
  • Processing Status: DONE when Amazon finishes processing.
  • Processing Summary: JSON response with success/error details per SKU.
  • Remark: Your internal notes (e.g., "Batch 1 — US catalog").

Important: Size Limits

Submit Listing accepts up to 50,000 SKUs per submission, but the total payload must stay under 10 MB. Since PRODUCT listings are lightweight (just SKU + ASIN), you can typically hit the 50,000 SKU limit without hitting the size limit.

Tips for Maximum Efficiency

  • Always check restrictions first: Submitting restricted ASINs wastes time. Check eligibility in the Listings Restrictions sheet before filling in Create Listings.
  • Batch your submissions: Prepare all your SKU/ASIN pairs in the sheet first, then submit in one click. No need to submit row by row.
  • Update price/title later with PARTIAL_UPDATE: Once your ASINs are in your catalog, use the PARTIAL_UPDATE operation type to update specific attributes like price, title, or images without re-submitting everything.
  • Need full listing control? See the Create & Revise Listings guide for creating new listings, updating attributes, managing variations, and cross-marketplace expansion.
WhatsApp WhatsApp