Sell on Amazon Sign In
This article applies to selling in: Japan

Upload inventory using the Inventory Loader

Inventory Loader features

To download the Inventory Loader, click here.

The Inventory Loader lets you do the following:

  • Upload thousands of listings in a single file for matching against existing product pages on Amazon
  • Keep your listings up-to-date by modifying existing products
  • Add new inventory
  • Delete or "zero" inventory quantities for unavailable products
  • Purge and replace all listings

To use the page matching features of Inventory Loader, you must provide a product identifier and specific information about your offer. You can use a SKU and selected listing data when modifying existing listings.

Because Inventory Loader cannot be used to create new product detail pages, you do not need to provide detailed product data. A single Inventory Loader file can be used to upload or modify listings in multiple product categories at the same time.

Inventory Loader or Listing Loader

The Inventory Loader and Listing Loader are similar templates with slightly different uses:

  • Inventory Loader enables you to enter shipping settings with optional fields for expedited-shipping and will-ship-internationally.
  • Listing Loader enables you to enter information for other features, with optional fields such as sale-start-date and is-gift-wrap-available.

For basic matching, either the Inventory Loader or Listing Loader can be used, though we recommend the Inventory Loader. However, when multiple matches are found for a product, the Listing Loader may help you resolve the issue more easily.

The Inventory Loader File Template

To create an Inventory Loader file, you must first download the Inventory Loader File Template to your hard drive. The template will open as a Microsoft Excel file and contains a preformatted worksheet where you provide your product data. The file includes additional worksheets to help you complete the template. You can also enable optional file macros to automate some of the steps for creating and uploading your file.

There are four basic steps to using the Inventory Loader File template:

  1. Download the Inventory Loader File template from the templates table on the Inventory File Templates page.
  2. On the InventoryLoaderTemplate tab, enter a SKU, product identifier, and listing data for the items you want to offer for sale. You can manually enter listing details one-by-one, or if you have macros enabled, you can import an existing file containing your listing information using the Import File macro.
  3. Check the information you entered for errors. If you have macros enabled, you can automate this process by clicking the Validate button from the file menu. The macro checks data completeness and greatly reduces upload failures due to input errors.
  4. Use the Upload File macro from the file menu and enter your selling account e-mail and password.
Note: If you don't have macros enabled, save the file in text (.txt) format and upload it through the Upload Products & Inventory tool.

Inventory Loader File Tabs

When you open the template, you will see several tabs along the bottom of the workbook:

Tab Name Description
Instructions An overview of how to use the product template.
Data Definitions A detailed review of each field in the inventory file, including label name, definition, use case, accepted values, and an example.

Yellow rows indicate required information. To have your product upload properly, you must complete all required fields.

Orange rows indicate desired information. Desired columns give customers the basic information they need to make an informed purchasing decision. It is highly recommended that you fill in all desired cells. Not doing so may result in poor product descriptions, and/or make your product hard to find.

For example, a product can exist in the catalog, but cannot be offered for sale without a price or quantity, in which case the product would not surface on the website.

White rows indicate optional information. Optional information may be useful, but not critical, when offering a product for sale. We encourage you to fill out all optional cells that apply to your products.

Template This is the actual worksheet in which you enter your product data using the specifications listed in the Data Definitions tab. This worksheet contains a row to help Amazon know which template you are using and another row with column headings (label names) representing each of the fields in your inventory file. It has color-coded column headers to indicate whether the field is required (yellow), desired (orange), or optional (white).

Inventory Loader File Macros

On the Add-Ins menu in the toolbar at the top of the template, you will find four macros: Validate, Upload File, Import File, and Update Template. With these macros, you can validate your data and learn how to correct any errors, as well as automate some of the tasks in populating and uploading your file. These macros are designed to simplify your experience and are highly recommended.

See Using Template Macros for detailed information about how to use each macro.

Required Inventory Loader Fields

If a value is not included in the field below, your listing will not go live on the Amazon website. Under certain circumstances, values are also required in other fields. (See details in the Desired Inventory Loader Fields section below.)

sku: A SKU is a "stock-keeping unit" used to track inventory. Each SKU you create must be unique to an individual item in your current template and existing listings. A SKU can be any alpha-numeric string. Avoid using symbols or spaces in your SKU.

Optional Inventory Loader Fields

The data you enter for these optional fields gives customers the basic information they need to make an informed purchasing decision. We highly recommend that you fill in all desired fields. Not providing data in desired fields can result in poor product descriptions and make your product hard to find. Note that if a product exists in the catalog but does not have a price or quantity, customers cannot buy it. Also double quotes should not be used.

  • product-id: Each product sold on Amazon also includes an industry standard product identifier. This is a required field for product matching when creating new listings. The id can be found between slashes in the URL of the product detail page on the site. There is a prefix such as the character of "ASIN" or "ISBN" before the slash. Copy & paste the number or enter the number using one-byte characters under the column header of Product ID.
    Note: The correct Product code can be confirmed on the Amazon site. Search your products on the Amazon. When you are on the product page, you just need to scroll down a little. Under product details you will see the ASIN or ISBN. Those identifiers can be copied to the spreadsheet software.
  • product-id-type: The product-id-type is a numerical entry that indicates if the product-id is an ASIN, ISBN, UPC, or JAN/EAN. This is a required field if product-id is provided. The following are your possible choices:
    • 1 = ASIN
    • 2 = ISBN
    • 3 = UPC
    • 4 = JAN/EAN
  • optional-payment-type-exclusion: If you exclude the payment type of Cash on Delivery, or Convenience Store Payment (include of Pay by e-Money or Internet Banking) which is chosen by buyers, use the following values. The payment will be unable to set if you leave blank, and the exclusion will not be applied. *If you cancel the previous setting and set "no excluded payment type", use exclude_none.
    • exclude cod (Exclude Cash On Delivery)
    • exclude cvs (Exclude Convenience Store Payment)
    • exclude cod, cvs (Exclude both Cash On Delivery and Convenience Store Payment)
    • exclude_none (no excluded payment type)
  • price: The price per item, in Japanese Yen. Do not enter the "\" symbol. This is a required field if product-id is provided and you are creating new listings. You must provide a price to make the item available for purchase on the website. See here for details.
  • item-condition:A numeric entry that indicates the condition of the item. (Review the Condition Guidelines Definitions.)
    • 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
    • 9 = Not used
    • 10 = Refurbished (for Electronics, Home & Gardens, and Major Appliances only)
    • 11 = New
  • quantity: You must enter a quantity when adding a new SKU. You can set the quantity anywhere between 1 and 1,000. This is a required field for seller-fulfilled items if product-id is provided, and to make the item available for purchase on the website. Items must be in stock and on hand at the time a purchase is made.  *Input the value of AMAZON_JP in the FulfillmentCenterID column when you list products as FBA items. Do not specify any quantity in the Quantity column.
  • add-delete: Use 'a' to add new items, use 'd' to delete offers (remove all inventory from sale), and use 'x' to delete offer and item data (remove SKU). Please see our page describing Inventory Loader SKU Deletion for more detail.
  • will-ship-internationally: A code that indicates the countries to which you are willing to ship to customers in outside of Japan, choose from "12" to "14". If you can ship only to customers in Japan, specify "11".  "14" (All areas in the World) is automatically set as default if you leave blank.
    • 11 = Domestic only
    • 12 = International: All areas in Asia
    • 13 = International: All areas in Asia, North America and all areas in Europe
    • 14 = International: All areas in the World(except Japan)

    *Products you can ship in outside of Japan are only for Books, CDs, DVDs and VHSs except any adult products. The rest of products including adults are not available to ship internationally. Sellers who choose the option of shipping internationally are responsible for compliance with regulations and related laws of the source and the destination country. Sellers may also be applied tariff and other consumption taxes depending on the rule of the destination country, and are responsible for dealing with it.

    Note: Any electronics such as cameras and video game products cannot be shipped internationally.
  • item-note: Use this field to describe any differences your item has from the new item sold by Amazon. This field is limited to 2000 bytes (666 two-byte characters).
  • fulfillment-center-id: This field is only required if you use Fulfillment by Amazon. If you don't use FBA, please leave this column blank. Input the value of "AMAZON_JP" in this column when you list products as FBA items.
    Note: Other fields can be ignored since they are not used.
  • Points (StandardPricePoints): Amazon Points you are offering for the SKU.
  • Points for sale price (SalesPricePoints): Amazon Points offering for Sales Price for SKU
Sign in to use the tool and get personalized help (desktop browser required). Sign In

Reach hundreds of millions of customers

Start selling on Amazon

© 1999-2022,, Inc. or its affiliates