misssing timestap error during ecommerce event import

Question

Hi,I am trying to follow this guide to import past orders.Then I keep getting the error “The selected file is missing a timestamp column.” even though my csv file already has that column. I even tried to import this sample data and got the same error: What’s going on?

kaila.lawrence · Accepted Answer

Hey @noobmarket! Which type of file are you using? Sometimes the cell type can affect how data parses. Check out this guide on formatting specifically based on file source (like Google Sheets or Excel) and try that.

If it still doesn’t work, try a different acceptable date format:

2014-09-30 13:34:08

2014-09-30 13:34:08+00:00

09/30/2014 13:34:08

09/30/14 13:34:08

09/30/2014 13:34

09/30/14 13:34

2014-09-30T13:34:08

2014-09-30 13:34:08.000001

2014-09-30T13:34:08.000001

2014-09-30 13:34:08.000001-04:00

Maxbuzz · Answer

Hello @noobmarketplease check if the timestamp is in this formatYYYY-MM-DD HH:MM:SS

Reply

Sign up

Use your Klaviyo credentials

Log in to the Community

Use your Klaviyo credentials

Scanning file for viruses.

This file cannot be downloaded