Solved

misssing timestap error during ecommerce event import

  • 28 February 2024
  • 3 replies
  • 23 views

Badge +2

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?

icon

Best answer by kaila.lawrence 29 February 2024, 19:06

View original

3 replies

Userlevel 3
Badge +7

Hello @noobmarket 

 

please check if the timestamp is in this format

YYYY-MM-DD HH:MM:SS

Badge +2

It’s in the right format:
2014-03-10 08:55:01

Userlevel 4
Badge +24

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

Reply