125x125 Hosting & Servers at GoDaddy.com

New Amazon Listing Loader

Mar 26th, 2008 | By Max Leisten | Category: Amazon Announcements, Amazon Features

Amazon has introduced a new simpler means to load products to Amazon that already exist in Amazon’s catalog using its ASIN IDs or UPCs. The Listing Loader is essentially a Microsoft Excel spreadsheet on steroids that helps you not only validate your Amazon data but also load it to Amazon with the push of a button (via MS Excel macros).

Listing Loader offers a simple way to upload your inventory to Amazon. It enables you to provide the listing attributes without the product attributes, which are required when using product feeds. Listing Loader provides following functionality:

* List in all categories you are eligible to sell using a single template
* Import data from other flat files greatly reducing manual entry effort
* Ability to use a barcode scanner, again reducing manual entry effort
* Matching based on standard product-id alone reducing data required to list on Amazon
* Perform product look-up on Amazon allowing you to resolve matching conflicts prior to upload
* Validation checks for data completeness that greatly reduces upload failures due to input errors
* Direct upload to Amazon from within Excel saving you time

Amazon Listing Loader

The advantage is that if you have a product ID for your SKU (ASIN or UPC) you can reuse this identifier to easily load the product, price, quantity, condition and a few other required attributes along with optional attributes such as Sale Price and Condition Note (describing the shape the item is in). If the item can not be located then it will notify you to (a) load it manually or (b) troubleshoot the mismatch in ASIN / UPC against Amazon’s catalog.

Few caveats:

- If you are already or are planning to sell your products via Amazon Webstore then you will need to  continue to load the full product set so that this data may be pushed to the Webstore

- You can not use ASIN as a product ID for variation-enabled categories (such as Apparel or some Sporting Goods categories). You will need to use UPC.

Overall a great tool for small product catalogs even if you only have to frequently update price and quantity.

Related posts:

  1. Order Fulfillment Report and Inventory File Changes on Amazon.com Two important announcements today for online retailers directly listing to and retrieving orders from Amazon.com. Inventory File Changes When listing products to Amazon via an...
  2. Help! There are too many listings for my products on Amazon! Amazon's mission is to offer Earth's Biggest Selection and the best online shopping experience. An important part of this experience is to give buyers great...
  3. Bulk competitive product repricing on Amazon.com Amazon last week rolled out a few enhancements to their Manage Inventory view in the Amazon Seller Central dashboard (valid Seller Central ID required) that...


2 comments
Leave a comment »

  1. I am trying list products on amazon.com still cant understand concept of ASIN. can i assign same ASIN to all my inventory ?

  2. You cannot assign an ASIN to your listings. The acronym ASIN stands for “Amazon Standard Identification Number”. Each product sold on Amazon.com is given a unique ASIN. For books with a 10-digit ISBN, the ASIN and the ISBN are the same. Books without an ISBN and all other products are also assigned unique ASIN’s.

    If you would like to assign a unique identifier your listings, I would suggest assigning a SKU to each of the listings. This is the individual sellers way of identifying each of his products. Your sku can be whatever you would like it to be. I recommend using codes to indicate date listed, items storage location, version/condition of item. For example SKU0001070608ULNS8 (SKU item number 0001 date 07/06/2008 condition Used Like New, Shelf 8) This should help you with organization of your inventory.

Leave Comment