DocsUser guides

Data import file templates

Data imports and updates

Import customer, event, product, and sales data to Custobar with the help of these CSV template files. This is the easiest way to test what your data looks like in Custobar.

The CSV template files come in handy, for example, during the free trial period, when you want to test importing your data to Custobar but aren’t ready to activate a data integration yet.

How to import Customer data with the CSV file?

  1. Download the Customers data example CSV file.
  2. Open the CSV file to find some example customer data rows.
  3. Please take a look at our documentation on customer data fields, to get a deeper understanding of how to fill in the CSV file.
  4. One of the three first fields (external_id, phone_number, and email) is mandatory for each customer. All other fields are optional.
  5. Once you have your CSV file ready, go to your Custobar environment.
  6. Click “Customers” - “Data import,” and follow the instructions on the page to complete the import.

How to import Event data with the CSV file?

  1. Download the Events data example CSV file.
  2. Open the CSV file to find some example event data rows.
  3. Please take a look at our documentation on event data fields, to get a deeper understanding of how to fill in the CSV file.
  4. The two first fields (type and date) are mandatory for each event.
  5. You should also provide at least one of the customer identifying fields (customer_id, phone_number or email) along with each event to identify the customer.
  6. Depending on the event type, some additional fields are required.
    1. For browse events: label, product_ean, product_id, path, and/or utm_campaign.
    2. For mail_subscribe events: mailing_lists.
    3. For mail_unsubscribe events: mailing lists.
    4. For order_shipped events: tracking_number.
    5. For basket_add events: product_id.
    6. For sentiment event: sentiment_value.
  7. The rest of the fields are optional.
  8. Once you have your CSV file ready, go to your Custobar environment.
  9. Click “Customers” - “Data import,” and follow the instructions on the page to complete the import.

How to import Product data with the CSV file?

  1. Download the Products data example csv file.
  2. Please take a look at our documentation on product data fields, to get a deeper understanding of how to fill in the CSV file.
  3. The two first fields (external_id and price) are mandatory for each product.
  4. All other fields are optional, but recommended, as they enrich the data and allow you to make better marketing decisions.
  5. Once you have your CSV file ready, go to your Custobar environment.
  6. Click “Customers” - “Data import,” and follow the instructions on the page to complete the import.

How to import Sales data with the CSV file?

  1. Download the Sales data example csv file.
  2. Please take a look at our documentation on sales data fields, to get a deeper understanding of how to fill in the CSV file.
  3. One transaction consists of one or more sales. That means that one transaction can have multiple sales rows, see example rows 1-3.
  4. The mandatory fields for each transaction are sale_external_id and sale_date.
    1. sale_external_id is the transaction's ID
    2. external_id is the sale row's ID within the transaction
  5. The mandatory fields for each sale are external_id, product_id, quantity and unit_price.
  6. You should also provide at least one of the customer identifying fields (sale_customer_id, sale_phone_number or sale_email) along with each event to identify the customer.
  7. All other fields are optional, but recommended, as they enrich the data and allow you to make better marketing decisions.