Importing transactional data

By importing transactions to Synerise, you can prepare analyses of transactions. The output of the import is transaction.charge events generated on the profile cards of customers indicated in the imported file.

Requirements


  • You need user permissions that grants you access to Simple Imports or/and Automation
  • Prepare a .csv file that contains the following data (the list contains recommended column names, if you use different names you will be able to map/transform data during the process):
    • a client column - a column with profile identifiers, you can use one of the following identifiers: email, uuid, clientId, or customID.
      WARNING: If you choose an email as an identifier, pay attention to the correct format of emails. Otherwise, your import will fail.
    • an orderId column which contains IDs of the transactions
    • a paymentInfo.method column which describes how the transaction was paid (for example, cash, online, and so on)
    • a products.finalUnitPrice.amount column which contains the final price of items
    • a products.finalUnitPrice.currency column which contains the currency of the final price
    • a products.name column which contains the name of the purchased item
    • a products.quantity column which contains the number or quantity of purchased items
    • a products.sku column which contains the SKU of purchased items
    • a revenue.currency column which contains the currency of the transaction
    • a value.currency column which contains the currency of the transaction value before taxation
    • a source column which contains the source of transaction (for example, POS, WEB_MOBILE, WEB_DESKTOP, MOBILE_APP, MOBILE, DESKTOP)
    • Spaces and special characters in the column headers are not allowed.
    • .csv files must be UTF-8 encoded
    • The file cannot contain empty fields. If you want to leave empty fields, enter the null value.
    • Maximum file size: 200 MB.

Example

Image presents the example of file
Image presents the fragment of the example file

Tips for preparing a CSV file

  • Recommended file metacharacters:
    • A character that splits columns (delimiter): ,
    • A character that is used to contain the text (quotation mark): "
    • A character (escape character) that changes the default interpretation of a sign or string followed by the escape character: /
  • For more details about parameters and their accepted formats, click here.

Procedure


Selecting the file for import

In this part of the process, you will upload a file from your device.

  1. Go to Data Management icon Data Management > Data import > New import.
  2. As the data type for import, select Transactions.
  3. As the import method, select one of the following options:
    • Import a local file - To import a single .csv file to Synerise.
    • Import in Automation - To import a .csv, .json, .jsonl, and .xml files and execute periodical imports.
  1. Upload the .csv file by using the + Upload file or drop one here field.
  2. Optionally, you can customize the file metacharacters by clicking the arrow down icon.
    1. From the Delimiter dropdown, select the character that marks the end of a column.
    2. From the Quotation mark dropdown list, select the characters that contain the text or data type.
    3. From the Escape character dropdown lists, select the character which changes the default interpretation of a character or a string followed by the escape character.
  3. To proceed to the next step, click the Next button.

Mapping the columns with parameters in Synerise

In this part of the process, you will connect the columns from the file with their counterparts (the existing parameters) in Synerise. This way, you will point which parameters in Synerise will contain the event information from the imported file.
During mapping, you can:

  • exclude parameters from the import.
  • create new event parameters in Synerise to map the data in the input file to them. Note that all custom parameters will be imported as additional transaction parameters.

Remember that you can’t add new columns to the imported file while mapping.

  1. Next to the file column name, from the dropdown list, select the corresponding parameter in Synerise. Perform this step for all columns in your file.
  2. To exclude a parameter from import, next to the column name, click this icon: An arrow icon
    Result: The icon changes to Don't import icon
  3. To proceed to the summary of the import, click Next.

Counting revenue

In this part of the process, optionally, you can enable automatic calculation of the revenue which is the multiplication of the item quantity by its price.

  1. Enable the Calculate revenue option.
  2. In the Product unit price field, from the dropdown list select the name of the column that contains the price of a single piece of an item.
  3. Confirm by clicking Next. Result: The summary of the import is displayed.
  4. After checking the import summary, to start the import, click Run import.
    Result: The output of the import is transaction.charge events generated on the profile cards of customers indicated in the imported file.

Launching import

After steps described above you’ll be redirected to the mapping summary. If it’s correct, to launch the import, click Run import.

😕

We are sorry to hear that

Thank you for helping improve out documentation. If you need help or have any questions, please consider contacting support.

😉

Awesome!

Thank you for helping improve out documentation. If you need help or have any questions, please consider contacting support.

Close modal icon Placeholder alt for modal to satisfy link checker