I'm encountering errors when I import my csv file from Dropified into Shopify.
The main error seems to be "Created at has blank or invalid date format" on almost every line. I checked to make sure that the date format is correct. It still successfully imports around 5-10% of the reviews, even though all of them have the same date format in the 'Created at' column.
Anyone have any idea what's going on here and how I can fix it? Thank you!
Just had the problem recently and fixed it by changing the format to YYYY-MM-DD HH:MM:SS worked.
To change this in excel go the Number drop-down in the toolbars at the top --> Click Custom and then Custom again then in the Type box past YYYY-MM-DD HH:MM:SS.
Make sure you select the entire column before you change the format and it will be applied to all of the cells in that column.
Hope that helps a little bit.
This datetime format worked! Very frustrating that the import template is wrong. Also frustrating that the Import help page doesn't actually specify the format they're looking for.
The other thing I noticed is that all of the imported dates are wrong by one day. I'm not sure if that's because I selected "00:00:00" as the time of the review and it's bugging out, but whatever - close enough. I'm importing from Etsy BTW so my titles are all "Etsy Review" and for reviews without body I set the body text as "Star Rating Only from <author>" (I had to include the author or else the importer would incorrectly flag the review as duplicate. My emails were all set to firstname.lastname@example.org