Trouble with imported Product Review dates

Highlighted
Shopify Partner
166 2 137

Hi There,

The creation date shown in the example template is 9/01/17 16:40 (when open in Excell).

The dates of my reviews seem to be the same: 7/08/17 9:14. But weirdly, this date displays on the site as Aug 17, 0007

Is the format of the date in the example template correct or is the Product Review App not interpreting the dates correctly?

The 'Import using month/day/year date format' was left unticked because we don'ty use american dates if that makes sense.

Any help would be much appreciated as our imported reviews look fake!

Cheers 

1 Like
Highlighted
Shopify Partner
166 2 137

The problem was Microsft (as usual).

If you open the example .csv in Excell to use as a template (most of us use Excel for this) then Excell will screw the date format.

I'd recommend that Shopify also recognise the date format output by Excel when importing .csv files.

1 Like
Highlighted
Shopify Partner
166 2 137

Solved, the issue is that while most of us edit .csv files in Excel, the Shopify importer doesn't recognise Excel dates.

I'd recommend updating the importer to also recognise the date format output by Excel.

1 Like
Highlighted
New Member
3 0 0

how did you solve this? 3 years now its still the same issue

 

0 Likes