Create and Submit a Batch of IAPs

You can submit a batch of in-app items using a Comma-Separated Values (CSV) file to upload the new and updated IAP items. The IAP Batch Submission feature provides the ability to export the existing In-App Purchase (IAP) items into a CSV file. Edit the file to update existing entries and add new entries, then import and submit the new and updated IAP items to the Appstore. The CSV file supports Consumable and Entitlement IAPs (but does not support Subscriptions). To make it easier to create IAPs, IAP icon images are optional. The CSV file does not support uploading icon images. To create or update single IAPs (and Subscription IAPs), use the Developer Console UI, as described in Submit Single In-App Items.

Capabilities

The IAP Batch Submission feature provides the following capabilities:

Export existing in-app items as a CSV file. Use this file as a starting point to update existing IAP items or to create new IAP items.
Import a CSV file to create new items and update existing items.
Two-step error handling:
- The system validates the CSV file for any formatting errors (such as missing price, or incorrect field formats).
- The system identifies post-submission errors, such as a duplicate Product ID.
If entries in the CSV file fail validation or post-submission checks, the system creates a file which lists errors for each failed entry.
The Developer Portal displays the number of added IAP items, updated items, and errors.
The CSV file may contain a mix of consumable items and entitlement items, new items and updated existing items.

CSV file format

The CSV file is a text file with a .csv file extension. The CSV file must use UTF-8 encoding, to support localized strings. The CSV file contains one header row (which displays the column titles). Each subsequent row in the file contains the information for one in-app item. The Product ID field defines a unique identifier for each item. The following table describes the fields for each entry (row) in the file:

Field	Type	Description
Product ID	String	Enter a unique Product ID for the IAP item. The Amazon Developer Portal calls this field the SKU. The Product ID value must be unique across all of your apps. It contains up to 150–characters that can include the characters a–z, A–Z, 0–9, underscores, periods, and dashes. The Product ID is case-sensitive. If you do not provide a Product ID value, the system ignores this row of the file.
Locale; Title; Description;	String	Specify the locale, title, and description for the item. Enter a set of three values, separated by semicolons, in the following order: Locale; Title; Description;. You can provide multiple sets of values (for different locales). However, you must provide English (en_US) text for each item even if your app is only available in countries that don’t use en_US encoding. See the following Supported Languages table for a list of the language abbreviations. For any locale where you do not provide translated text, the system displays the English text.
Auto Fill Prices	TRUE or FALSE	If you set Auto Fill Prices to TRUE, enter only one price value in the Price field (to set the Base Price). If you set Auto Fill Prices to FALSE, you must enter a marketplace price for each.
Price	PriceMicro	Enter 0 if you don’t charge for this item. If you set Auto Fill Prices to TRUE, provide a currency abbreviation and a price for the item. Otherwise, enter a price for each market using a pair of values separated by semicolons. Use the following format for each value pair: Country/Region Abbreviation; Price;. Don’t use a semicolon after the last pair. Set the price to a valid amount for each currency. See IAP price ranges for each currency. See the following example entries, and for countries/regions mapping to currencies. Enter the price in millionths of the currency base unit, without decimals. For example, enter a unit price of 1 USD (`US; 1000000;`) in the CSV file. If you do not provide a price for each market, the system marks the row as having an error.
IAP Type	Consumable or Entitlement	Enter the IAP type. If this field is blank or invalid, the system marks the row as having an error. The IAP type is case sensitive, and it doesn’t support Subscription.
TEST IAP Note: Present only when exporting items. Not used for importing items.	TRUE or FALSE	For IAPs submitted or published to only LAT (IAPs with a TEST label), the value of this field is TRUE. For IAPs created or submitted to both TEST and LIVE, the value of this field is FALSE.

When Auto Fill Prices are set to TRUE, enter a currency abbreviation. When Auto Fill Prices are set to False, enter a Country/Region Abbreviation. The following example shows a price entry, where Auto Fill Prices are set to FALSE. US;44000000;DE;41640000;IN;2933590000;JP;5015000000;IT;41640000;FR;41640000;ES;41640000;BR;137250000; AU;57990000;GB;36060000;CA;59020000 The following example shows a price entry, when the Auto Fill Price is set to TRUE: USD; 3840000

Country/region and currency abbreviations

The following table displays the Country/Region Abbreviation, currency abbreviation, and currency for each of the marketplaces:

Country/Region Abbreviation	Currency Abbreviation	Currency	Market
AU	AUD	Australian Dollars	Amazon.com.au
BR	BRL	Brazilian Reals	Amazon.com.br
CA	CAN	Canadian Dollars	Amazon.ca
DE	EUR	Euros	Amazon.de
ES	EUR	Euros	Amazon.es
FR	EUR	Euros	Amazon.fr
GB	GBP	Pounds Sterling	Amazon.co.uk
IN	INR	Indian Rupees	Amazon.in
IT	EUR	Euros	Amazon.it
JP	JPY	Japanese Yen	Amazon.co.jp
MX	MXN	Mexican Peso	Amazon.com.mx
US	USD	Dollars	Amazon.com

Supported languages

The following table displays the supported languages for the title and description fields:

Abbreviation	Language
zh_CN	Chinese (Pingyin not supported. See the following warning)
de_DE	German
en_AU	English (Australia)
en_GB	English (UK)
en_IN	English (India)
en_US	English (US)
es_ES	Spanish
es_MX	Spanish (Mexico)
fr_FR	French
it_IT	Italian
ja_JP	Japanese
pt_BR	Brazilian Portuguese

Error messages

When you upload a CSV file, the system validates each entry in the file. If the file contains errors, the system copies the input file and adds a message in the status column for each row that has an error. You can review the messages as a guide for fixing any problems.

Example CSV file

The CSV template file contains example entries. For instructions on downloading the file, see Create and Submit a Batch of IAPs. Notes about row format:

Use a comma to separate each field in the row.
Use a semicolon to separate values within a field. The system ignores spaces.

We recommend that you use Google Sheets to view and edit your CSV files. See Configuring UTF-8 for Excel for instructions on how to configure UTF-8 encoding for Excel and other tools. To import a UTF-8 CSV file into Excel:

Select File>Import
Select CSV as the file type
Choose the file to import
In the Text Import Wizard, select UTF-8 as the file origin.

​Capabilities

​CSV file format

​Country/region and currency abbreviations

​Supported languages

​Error messages

​Example CSV file