Sharing order events via CSV

You can submit order events as CSV files to Hakuna so we can create and manage the insurance contracts appropriately.

This guide outlines the general requirements for sharing order events via CSV. If you are interested in this approach, please inform your Hakuna Account Manager. They will work with you to establish the specific requirements for your use case.

File requirements

The CSV file must be comma separated and UTF-8 encoded.

The file name must be unique.

Each row in the CSV file should represent an item in an order, with data identifying:

  • the order ID

  • the date and time at which the order was placed

  • if cancelled, the date and time at which the order was cancelled

  • if fulfilled, the date and time at which the line item was fulfilled

  • if refunded, the date and time at which the line item was refunded

  • the customer details (name, email, address)

  • the product details (line item ID, product ID, brand, title, price amount and currency)

All protection products should also have a reference to the product for which the protection was purchased.

If a product has a quantity of 2, it should be represented by two rows. Protection products should also be represented as separate rows.

You can determine the file structure (e.g., data formatting, column titles, etc.) based on what is available to you. Hakuna will transform and ingest the data into our platform as needed.

Upload

We will provide you with a AWS account with access to a shared S3 bucket where you can upload the CSV files using the AWS console.

Frequency

You can choose the frequency of data submission. New uploads will be processed immediately, as long as they have a unique file name.

Last updated