How to read an Active Listings Report

The Active Listings Report is a tab-delimited file that you can open in any spreadsheet or database program, such as Microsoft Access or Microsoft Excel. Listing data and file columns can then be modified within the spreadsheet, and uploaded at any time using the Inventory Loader or Listing Loader. For more information, see Using Reports to Update Inventory.

If you open the report in Microsoft Excel, the leading zeroes for ISBNs in the product ID column will be dropped by Excel. You can prevent this by using the import wizard and forcing the product-id column to be imported as text. Please see Microsoft Excel help for more information on this feature.

Below is a list of fields that appear in the report, as well as definitions of those fields and examples for each. The unused fields are provided for backwards compatibility to allow sellers who originally integrated their business using these fields to continue with their current software programs. If you do not need any of these fields, you may simply delete the columns from your downloaded report.

Please review these fields to understand the Active Listings Report.

Field name	Definition	Example
item-name	The title of the item listed. This will be populated with Amazon catalog data.	向田邦子の手料理 [単行本] by 講談社; 和子, 向田
listing-id	An identifier created by Amazon when you create a listing. Consists of 4 digits, a capital letter, and 6 more digits.	1234A123456
seller-sku	Stock Keeping Units (SKUs) are unique blocks of letters and/or numbers that identify your products. SKUs are assigned by you as the seller.	154844
price	The price you are asking for the product.	1,299 JPY
quantity	The quantity of the product available for purchase.	15
open-date	The date the listing was created.	2009/09/18 15:18:58 JST
product-id-type	A numeric entry that indicates if the product-id is an ASIN, ISBN, UPC, JAN, or EAN code/number. When uploading files in Standard Book format, this field value will default to 2 (ISBN) unless otherwise specified. 1 = ASIN 2 = ISBN 3 = UPC 4 = JAN/EAN	1
item-note	Your description of the listing.	帯付き。一回読んだきりの良い状態です。
item-condition	This is your condition code for the listing. 1 = Used; Like New 2 = Used; Very Good 3 = Used; Good 4 = Used; Acceptable 5 = Collectible; Like New 6 = Collectible; Very Good 7 = Collectible; Good 8 = Collectible; Acceptable 11 = New	1
will-ship-internationally	When you choose to offer international shipping, enter "12", "13", or "14" in the column of Will-Ship-Internationally. When you choose to offer domestic shipping only, enter "11". 11 = Domestic only 12 = All areas in Asia 13 = All areas in Asia, North America and all areas in Europe 14 = All areas in the World (except Japan)	11
expedited-shipping	12 = Next day delivery 13 = Same day delivery 12, 13 = Next day delivery and Same day delivery 0 = Migrated to the new shipping settings blank = not offered	12, 13
merchant-shipping-group	Name of the shipping template assigned to SKU	migratedShippingTemplate
product-id	ASIN, ISBN, UPC, or JAN/EAN for the item	0312306180
pending-quantity	This is the quantity of the item that is pending purchase at the time of the report.	0
fulfillment-channel	This will indicate for FBA sellers if the listing is set for seller fulfilment or fulfilment by Amazon.	Amazon-fulfilled
optional-payment-type-exclusion	This filed will be displayed when Convenience Store Payment or Cash On Delivery is selected. This filed is displayed for products that have disabled either of Convenience Store Payment or Cash On Delivery, or both of them, as a payment method of buyers.	cvs (Exclude Convenience Store Payment) cash_on_delivery (Exclude Cash On Delivery) cash_on_delivery,cvs (Exclude both Cash On Delivery and Convenience Store Payment)
standard_price_points	Indicates Amazon Points you are offering for SKU.	130