Working with product feeds to Amazon’s sellers central – Part 1

Part 1 – Inventory Feeds

The different type of Amazon feeds

  • Inventory feed
  • Product feed

There are three things to consider when selecting a method to manage your price and inventory on Amazon; The offer information you need to manage, how often you need to update your offer information, and the amount of products you need to manage.

For this section we’ll focus on managing small amounts of products using Amazons Flat File Inventory Feeds.

Amazon provides three files for managing offer information. To add, remove and manage products in your Amazon catalog we can use Amazon’s Flat File Inventory Feed Spreadsheet. The flat file inventory feed allows you to add/remove, and update your offer information for products that already exist on Amazon. This is the file you should use if you are just starting to sell items on Amazon. This file lets you add/remove products on Amazon using existing product information that is already available on Amazon.

To list items on Amazon you need to define an SKU (Stock Keeping Unit). This is the identifier we use to manage our products internally.  The next thing we need to identify is the Product ID. Product ID is a more universal identifier. This is a unique identifier that a product is commonly identified by. Valid product IDs are ASIN (Amazon Standard Identification Numbers), ISBN (International Standard Book Number), UPC (Universal Product Code), EAN (European Article Number). This number lets you match your product to the existing products with the same product IDs already on Amazon. When choosing a product ID we have to take into account that some of the product IDs could map to more than just products on Amazon. The best product ID to use is the Amazon product ID (ASIN). The reason that this is the best product ID is that it uses one to one mapping. When you list a product using ASINs it will be offered on the correct product on Amazon. When you do not know the exact ASIN of the product you are listing to Amazon, it is important to check the ASIN that Amazon assigned to the SKU we uploaded to make sure the catalog information is the same as the product you are selling.

Some examples of discrepancies are for items sold in packs of more than one, items with different model numbers, or if your items could vary by something small. It is important to check your listings after they are uploaded to ensure your item is correctly listed and the product is not offered for sale under the wrong ASIN so you don’t sell a 12 pack of socks for 5 dollars when you really want to sell a single pair for 5 dollars.

With this file you can add an item for sale on Amazon with very little information. To list an item for sale using this feed you would only need an SKU, product ID, product ID type, price, and quantity for sale. This will list the item for sale on Amazon. Some of the other helpful information you should supply is tax information; is the item taxable? Item condition; is the item new, used? Lead time to ship; how long will it take to ship the item? The default is 3 days, so if it would take you longer than three days to ship an item it is imperative to include this in the feed to Amazon. If you want to allow people from outside the US to purchase the items we will also need to set the ‘will ship international’ to ‘Yes’.

If you already have items listed on Amazon and you just want to change the price and inventory you can use the price and inventory feed. This feed is designed to let you update your unit price, minimum price, maximum price, quantity, lead time to ship, and fulfillment channel based on your Amazon SKU.  You can use this feed to update any of the above attributes listed.

The last inventory flat file Amazon offers is called the Listing Loader File. This file is designed to help users match their products to products that already exist on Amazon. This is best used to find out if a product we want to sell is already on Amazon and to see which ones are not. We can also use this file to see which products match more than one product on Amazon and select the correct ASIN to list the product under.

For part 2 we will discuss Amazon’s product feeds.