Skip to main content
Solved

Migrating Order History

  • 15 March 2023
  • 1 reply
  • 480 views

Forum|alt.badge.img+3

Hi there, 

 

Is it possible to migrate order history from an excel file into Klaviyo? Is there a certain format the data would need to be in to be mapped correctly? 

The orders are from an old custom built store, not Shopify, and the store currently integrated into the KL account is on Shopware. 

 

Thanks in advance for any insight!

Best answer by Brian Turcotte

Hi @LydiaQuincy!

 

This is certainly possible with a couple simple steps! Here’s the Help Center article if you haven’t seen it:

 

You would need to import your Order History as a .CSV file, which you can easily create from your excel window via Save As > CSV. The above-linked Help Center article details how to format data and explains which data field you’ll need to have in order to import into Klaviyo. 

 

To summarize:

  • Each row in the .CSV file will represent an action or activity
  • The two required fields are a timestamp in the format YYYY-MM-DD HH:MM:SS, and a customer property (email or unique ID) to identify the person performing the action
  • For events with the same timestamp, include a unique $event_id
  • Optionally, you can add fields such as $value, Person//First Name, Person//Last Name, and others
  • After formatting the data, you can upload the .CSV file to Klaviyo under the Integrations tab

 

I hope this helps, and thanks for using the Community!

- Brian

View original
Did this topic or the replies in the thread help you find an answer to your question?

1 reply

Brian Turcotte
Forum|alt.badge.img+37
  • Klaviyo Alum
  • 1393 replies
  • Answer
  • March 15, 2023

Hi @LydiaQuincy!

 

This is certainly possible with a couple simple steps! Here’s the Help Center article if you haven’t seen it:

 

You would need to import your Order History as a .CSV file, which you can easily create from your excel window via Save As > CSV. The above-linked Help Center article details how to format data and explains which data field you’ll need to have in order to import into Klaviyo. 

 

To summarize:

  • Each row in the .CSV file will represent an action or activity
  • The two required fields are a timestamp in the format YYYY-MM-DD HH:MM:SS, and a customer property (email or unique ID) to identify the person performing the action
  • For events with the same timestamp, include a unique $event_id
  • Optionally, you can add fields such as $value, Person//First Name, Person//Last Name, and others
  • After formatting the data, you can upload the .CSV file to Klaviyo under the Integrations tab

 

I hope this helps, and thanks for using the Community!

- Brian


Reply