Bulk Upload In App Purchases - Google Play

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.

• product_id

  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.

• publish_state

  This is equivalent to the Publishing State setting in the In-app Products UI. Can be published or unpublished.

• purchase_type

  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.

• autotranslate

  This is equivalent to selecting the Fill fields with auto translation checkbox in the In-app Products UI. Can be true or false.

• locale

  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.

• title

  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, "\\">.

• description

  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, "\\">.

• autofill

  This is equivalent to clicking Auto Fill in the In-app Products UI. Can be true or 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:

  "true","default_price_in_home_currency"

  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; ..."

• country

  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.

• price

  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.

Table 1. Language codes you can use with the locale field.

To import the items that are specified in your CSV file, do the following:

1. Log in to your publisher account.
2. In the All Applications panel, click on the app name, then select In-app Products.
3. 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.

4. 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.