Can you nest data in csv file for Placed Order?

Hi,

We are trying to support our clients with importing historical sales data with csv file upload. We need to upload Placed Order data, but I don’t believe we can upload nested data like the items section. Instead, we would need to just flatten and simplify the data structure and send an array of product IDs in one column and send total order value as that is the key information Klaviyo users need when looking at Placed Order data. Is this the right approach that many Klaviyo clients take when they try to upload Placed Order data via csv file?

Page 1 / 1

Does escaping the JSON quotes per this thread help?

I don’t think so, because this is for inserting an array of values within one field. I was looking for a way to pass nested data like under Items section, you have 1st line item group with Product ID, Item description, Price, … and you have 2nd line item group with Product ID, Item description, Price, …. Typically, it’s not possible to create nested data via csv and you have to flatten the structure, but I just wanted to double confirm Klaviyo does not support in any way before I move forward.

Thank you for your attention to my question though!

Sign up

Use your Klaviyo credentials

Log in to the Community

Use your Klaviyo credentials

Scanning file for viruses.

This file cannot be downloaded