Overview

Amazon's Price & Quantity template is a streamlined inventory file that allows sellers to quickly update pricing and stock levels across their catalog without dealing with the complexity of full inventory file uploads. For sellers managing large catalogs or making frequent price and quantity adjustments, this template offers the fastest processing time of any Amazon flat file format.

Key Points / What Sellers Need to Know

• Smallest flat file format - The Price & Quantity template contains only the essential fields needed to modify prices and quantities, making it the simplest inventory file Amazon offers.
• Fastest processing time - Because the file contains fewer fields than category-specific or full inventory templates, Amazon processes uploads significantly faster.
• Modifies existing listings only - This template is designed to update inventory that is already listed in your catalog. It cannot be used to create new product listings.
• Two core fields - The template primarily focuses on updating your item price and available quantity, along with the required SKU identifier.
• Available for download in Seller Central - The template can be downloaded directly from the Add Products via Upload section of your Seller Central account.

How It Works

The Price & Quantity template operates as a tab-delimited text file (flat file) that sellers fill out and upload through Seller Central. Each row in the file represents one SKU in your inventory, and you provide the updated price, quantity, or both for that item. The file requires a SKU column to identify which product you are updating, along with columns for price and quantity. Unlike the larger Listing Loader or category-specific templates, you do not need to supply product descriptions, bullet points, keywords, or other catalog data — only the fields related to pricing and stock levels.

Getting Started with the Template

To use the Price & Quantity template, navigate to the Inventory section in Seller Central and select "Add Products via Upload." From there, download the Price & Quantity file template, which will come pre-formatted with the correct column headers. Open the file in a spreadsheet application such as Microsoft Excel or Google Sheets, and populate each row with your SKU, the updated price, and the updated quantity. Be sure to follow Amazon's formatting guidelines — prices should be entered as numbers without currency symbols, and quantities should be whole numbers representing your available stock.