Continue with Google
Introduction
Adding existing ASINs to your catalog in bulk can significantly streamline your Amazon selling process. Instead of creating listings one by one, SellerSheet allows you to efficiently match your inventory to products already existing in the Amazon catalog.
Why do this?
Matching to existing ASINs prevents duplicate listings and ensures your offer appears on the main product detail page with established traffic and reviews.
Prerequisites
- Active Amazon Professional Seller Account.
- SellerSheet Add-on installed in Google Sheets.
- A list of ASINs and your corresponding SKUs/Prices.
Step-by-Step Process
Prepare your Data
Open the SellerSheet sidebar and navigate to the Listings module. Ensure your Google Sheet has columns for ASIN, SKU, Price, and Condition.
Select "Add Offers"
In the sidebar menu, select the option for "Bulk Add Offers". This function is specifically designed to attach your offer to existing catalog pages.
Map Columns & Submit
Map your spreadsheet columns to the required Amazon fields in the sidebar interface. Once verified, click Submit. SellerSheet will use the JSON Listings Feed API to process your request in the background.
Best Practices
- Verify ASINs: Double-check that the ASINs match your physical product exactly (color, size, version).
- SKU Naming: Use a consistent SKU naming convention (e.g.,
BRAND-MODEL-COND) to manage inventory easily later. - Backup Data: Always keep a copy of your original upload sheet in a separate tab within Google Sheets.
Conclusion
By automating the ASIN matching process via Google Sheets, you save hours of manual data entry in Seller Central. This method allows you to scale your inventory management efficiently.
