Import and Export Purchases

The import and export system allows you to quickly add, update, and transfer purchase data between various platforms and your control panel.

---

Table of Contents

1. Quick Start: Import Using Our CSV Template
2. Updating Existing Purchases
3. Import from Yandex Games
4. Import from Any CSV
5. Export Purchases
6. Frequently Asked Questions

---

Quick Start: Import Using Our CSV Template

The easiest way to get started with importing is to use our ready-made CSV template.

Step 1: Export CSV Template

1. Open the "Purchases" section in your project

2. Click the "Export to CSV/JSON" button

   

3. In the opened window:

   • Make sure all fields are selected
   • Select the "CSV Table" format
   • Click "Export"

   

4. The products.csv file will be downloaded to your computer

Step 2: Fill in the CSV File

1. Open the downloaded file in Excel, Google Sheets, or any spreadsheet editor

2. Fill in the rows according to column names:

   • id - leave empty for new purchases
   • tag - unique human-readable identifier (e.g., GOLD_1000)
   • names.en - name in English
   • names.ru - name in Russian
   • descriptions.en - description in English
   • descriptions.ru - description in Russian
   • prices.YANDEX - price for Yandex Games
   • prices.PLATFORM_NAME - price for the desired platform
   • realPrices.RUB - price in real currency - rubles
   • realPrices.CURRENCY - price in real currency - by currency code
   • And other fields...

3. Save the file in CSV format

tip

For new purchases, leave the id field empty. The system will automatically create a new record.

Step 3: Upload CSV to Control Panel

1. Click the "Import from CSV" button

2. Drag the CSV file into the upload area or click to select file

3. The system will automatically recognize the "Our CSV Template" format

Step 4: Check Data and Import

1. Review the data table:

   • Green rows - new purchases that will be added
   • Cells with green line on the left - changed values
   • Red cells - validation errors (fix before importing)

   

2. If necessary, edit the data directly in the table (click on cell)

3. Make sure there are no errors (red cells)

4. Click "Import"

5. Done! Purchases have been added to your project

---

Updating Existing Purchases

If you need to update already existing purchases, follow these instructions.

Method 1: Through Export and Import (recommended)

1. Export current purchase list:

   • Click "Export to CSV/JSON"
   • Select the "CSV Table" format
   • Download the file

   

2. Make changes to the CSV file:

   • Open the file in a spreadsheet editor
   • Change the desired values in existing rows
   • You can also add new rows for new purchases
   • Do not delete the id column - it is used for matching

3. Upload the updated CSV:

   • Click "Import from CSV"
   • Upload the modified file
   • The system will automatically identify existing purchases by the id field

4. Check the changes:

   • Cells with a green stripe on the left show which values will be changed
   • Green rows - new purchases
   • Make sure everything is correct

   

5. Click "Import"

Method 2: Using Your Own CSV

If you have your own CSV file without an id field, you can select another field for matching:

1. Upload your CSV file

   • If you have a unique purchase identifier, place it as tag.

   

2. Select field for matching:

   • In the "Match records by field" section, select:
     • tag - if you have unique tags
     • yandexId - if you have IDs from Yandex Games
     • Or any other unique field

   

3. The system will find existing purchases and update them

tip

• When updating, only the fields specified in your CSV are changed
• Other fields remain unchanged

---

Import from Yandex Games

Import purchases directly from Yandex Games export.

Step 1: Download CSV from Yandex Games

1. Open the Yandex Games developer console

2. Go to the "In-app purchases" section

3. Click the three dots to the right of the "Upload CSV file" button, click "Download in-apps table"

   

Step 2: Upload CSV to Our Panel

1. Click "Import from CSV" in the purchases section
2. Upload the downloaded CSV file
3. The system will automatically detect the Yandex Games CSV format and configure field mapping

Step 3: Configure Mapping (optional)

For convenience when working with new purchases, you can:

1. Add ID → Tag mapping:

   • Click "Configure fields"
   • Find the row with id → (empty)
   • Select target field tag
   • This will automatically assign tags to new purchases

   

Step 4: Select Matching Key

For first import (new purchases):

• Leave the default key or select any, for example yandexId
• All records will be added as new

For updating existing purchases:

1. In the "Match records by field" field, select yandexId

2. The system will find existing purchases by their Yandex ID and update the data

   

Step 5: Check and Import

1. Check the data preview

2. Make sure the mapping is correct

3. Click "Import"

   

tip

When updating prices from Yandex Games, use yandexId for matching to avoid creating duplicates.

---

Import from Any CSV

Import purchases from any CSV file with flexible field configuration.

When to use this method?

• You have a CSV from another platform (not Yandex Games)
• Column names in your CSV differ from ours
• You need to map one field to multiple target fields

Step 1: Upload Your CSV File

1. Click "Import from CSV"
2. Upload your CSV file

Step 2: System Will Automatically Create Field List

If the system did not recognize the format automatically, it will:

• Create a list of all columns from your CSV
• Try to automatically match similar fields
• Show examples of values from the first row

Step 3: Configure Field Mapping

For each field from CSV, select where to import it:

Example 1: Simple Mapping

CSV field: product_name  →  Target field: names.en
CSV field: price         →  Target field: realPrices.RUB

tip

Below the name of your CSV field, an example is shown for easy orientation. Product name, price, etc.

Example 2: Price Mapping

For example, your CSV has a price_rub field with price in rubles, you can import it to:

• prices.YANDEX - if selling on Yandex Games

• prices.VK_PLAY - if selling on VK Play

• realPrices.RUB - real price in rubles (for Xsolla, Robokassa, Stripe, Google Play and other platforms)

• Or all of these fields at once (by creating multiple mappings for one CSV field)

  

Step 4: Check and Import

1. Click "Continue to preview"
2. Check the data in the table
3. Make sure everything is mapped correctly
4. Click "Import"

---

Export Purchases

Export purchases in various formats for use on other platforms.

Available Export Formats

1. CSV Table - universal format for Excel, Google Sheets
2. JSON Array - for developers and programmatic processing
3. JSON Object - object with key-value pairs
4. Xsolla JSON - ready format for uploading to Xsolla
5. Yandex Games CSV - ready format for uploading to Yandex Games

Export to CSV

1. Click "Export to CSV/JSON"

2. Select desired fields (all selected by default)

3. Select the "CSV Table" format

4. Click "Export"

   

Export to JSON

1. Click "Export to CSV/JSON"

2. Select desired fields

3. Select format:

   • JSON Array - simple array of objects
   • JSON Object - object with keys (need to select key field)

4. Configure options:

   • ☑️ Compressed JSON - single-line format (smaller size)
   • ☐ Compressed JSON - readable format with indentation

5. Click "Export"

   

Export to Xsolla Format

Special format for direct upload to Xsolla platform.

1. Click "Export to CSV/JSON"
2. Select the "Xsolla JSON" format
3. Click "Export"

The system automatically:

• Uses xsollaId or tag as product SKU
• Converts all names and descriptions into objects with languages
• Converts prices to the required format with currency specification
• Adds required Xsolla API fields

The resulting JSON can be directly uploaded to Xsolla.

Export to Yandex Games Format (CSV)

Special CSV format for uploading purchases to Yandex Games developer console.

1. Click "Export to CSV/JSON"
2. Select the "Yandex Games CSV" format
3. Click "Export"

The system automatically:

• Uses correct column names for Yandex Games
• Converts prices to the format expected by the platform
• Adds all necessary fields for correct import
• Formats data according to Yandex Games requirements

The resulting CSV file can be directly uploaded to Yandex Games developer console through the "In-app purchases" → "Upload CSV file" section.

---

Frequently Asked Questions

What to do if there are errors in the CSV?

Red cells show validation errors. Hover over the cell to see the error description. Click on the cell to fix the value directly in the table.

Can I change data directly in the preview table?

Yes! Just click on any cell, change the value and press Enter or click outside the cell.

How to avoid creating duplicates when importing?

Use the correct field for matching:

• id - for updating through our export
• tag - if you have unique tags
• yandexId - for purchases from Yandex Games
• xsollaId - for purchases from Xsolla

Can I import only some fields?

Yes! When importing, only the fields that are in your CSV are updated. Other fields remain unchanged.

What to do if the system did not recognize my CSV?

1. Check that the file is in UTF-8 encoding
2. Make sure the first row contains column headers
3. Use the "Custom mapping" mode for manual field configuration

How to add a new field to existing purchases?

1. Export current purchases to CSV
2. Add a new column with the desired value
3. Import the CSV back
4. The system will update all purchases, adding the new field

Can I cancel an import?

No, the import is applied immediately. We recommend:

1. Always check the preview before importing
2. Make an export of current data before large changes
3. Start with a test import on a small number of records

---

💡 Useful Tips

Working with Large Files

• For files with more than 100 records, use preview to ensure the first rows are correct
• Check the import statistics (how many new, changed, errors)

Multilingualism

• Use fields names.en, names.ru, names.fr, etc. for different languages
• Same for descriptions: descriptions.en, descriptions.ru, etc.

Prices on Different Platforms

• prices.YANDEX - price for Yandex Games
• prices.VK_PLAY - price for VK Play
• prices.GOOGLE_PLAY - price for Google Play
• realPrices.RUB, realPrices.USD - prices in real currencies

Stay in Touch

Other documents of this chapter available Here. To get started, welcome to the Tutorials chapter.

GamePush Community Telegram: @gs_community.

For your suggestions e-mail: official@gamepush.com

We Wish you Success!