To bulk upload a list of In App Purchases, we must first navigate to the In App Products screen of Google Play.
After logging in, click the name of your application and on the left hand menu click In App Products.
From here click the Import/Export drop down menu and select Import in-app products from CSV file
Following the formatting outlined below will produce the In App Products in bulk.
Note: An example CSV is attached to ensure that your formatting is correct.
The CSV file uses commas (,) and semi-colons (;) to separate data values. Commas are used to separate primary data values, and semi-colons are used to separate sub values. For example, the syntax for the CSV file is as follows:
"product_id","publish_state","purchase_type","autotranslate ","locale; title; description","autofill","country; price"
Descriptions and usage details are provided below.
This is equivalent to the In-app Product ID setting in the In-app Products UI. If you specify a product_id that already exists in a product list, and you choose to overwrite the product list while importing the CSV file, the data for the existing item is overwritten with the values specified in the CSV file. The overwrite feature does not delete items that are on a product list but not present in the CSV file.
This is equivalent to the Publishing State setting in the In-app Products UI. Can be
This is equivalent to the Product Type setting in the In-app Products UI. Can be
managed_by_android, which is equivalent to Managed per user account in the In-app Products UI, or
managed_by_publisher, which is equivalent to Unmanaged in the In-app Products UI.
This is equivalent to selecting the Fill fields with auto translation checkbox in the In-app Products UI. Can be
This is equivalent to the Language setting in the In-app Products UI. You must have an entry for the default locale. The default locale must be the first entry in the list of locales, and it must include a title and description. If you want to provide translated versions of the title and description in addition to the default, you must use the following syntax rules:
If autotranslate is
true, you must specify the default locale, default title, default description, and other locales using the following format:
"true,"default_locale; default_locale_title; default_locale_description; locale_2; locale_3, ..."
If autotranslate is
false, you must specify the default locale, default title, and default description as well as the translated titles and descriptions using the following format:
"false,"default_locale; default_locale_title; default_locale_description; locale_2; locale_2_title; local_2_description; locale_3; locale_3_title; locale_3_description; ..."
See table 1 for a list of the language codes you can use with the locale field.
This is equivalent to the Title setting in the In-app Products UI. If the title contains a semicolon, it must be escaped with a backslash (for example, "\;"). A backslash should also be escaped with a backslash (for example, "\\">.
This is equivalent to the Description in the In-app Products UI. If the description contains a semicolon, it must be escaped with a backslash (for example, "\;"). A backslash should also be escaped with a backslash (for example, "\\">.
This is equivalent to clicking Auto Fill in the In-app Products UI. Can be
false. The syntax for specifying the country and price varies depending on which autofill setting you use.
If autofill is set to
true, you need to specify only the default price in your home currency and you must use this syntax:
If autofill is set to
false, you need to specify a country and a price for each currency and you must use the following syntax:
"false", "home_country; default_price_in_home_currency; country_2; country_2_price; country_3; country_3_price; ..."
The country for which you are specifying a price. You can only list countries that your application is targeting. The country codes are two-letter uppercase ISO country codes (such as "US") as defined by ISO 3166-2.
This is equivalent to the Price in the In-app Products UI. The price must be specified in micro-units. To convert a currency value to micro-units, you multiply the real value by 1,000,000. For example, if you want to sell an in-app item for $1.99 you specify 1990000 in the price field.
To import the items that are specified in your CSV file, do the following:
- Log in to your publisher account.
- In the All Applications panel, click on the app name, then select In-app Products.
- On the In-app Products List page, click Import/Export > Import in-app products from CSV file, then select your CSV file.
The CSV file must be on your local computer or on a local disk that is connected to your computer.
- Select the Overwrite checkbox if you want to overwrite existing items in your product list.
This option overwrites values of existing items only if the value of the product_id in the CSV file matches the In-app Product ID for an existing item in the product list. Overwriting does not delete items that are on a product list but not present in the CSV file.
You can also export an existing product list to a CSV file by clicking Export to CSV on the In-app Product List page. This is useful if you have manually added items to a product list and you want to start managing the product list through a CSV file.