Import failed on: Invalid date format in column order_date.

  • Resolved vannquish

    (@vannquish)


    1 year, 9 months ago

    Hi all.

    I’m trying to import the order data into a new website. The spreadsheet contains 12 order records from 2023 and it imports the first 10 records fine but fails on the last 2 dated from yesterday:
    13/02/2023 13:47
    13/02/2023 21:55

    The error code given in the logs is: Import failed on: Invalid date format 13/02/2023 13:47 in column order_date.

    The order_date format is the same for all 12 records on the CSV file so confused why only 10 of the 12 import correctly?

Viewing 1 replies (of 1 total)
  • Plugin Support WebToffee Support

    (@webtoffeesupport)

    Hi @vannquish,

    Thanks for reaching out to us.

    Currently, this version of the plugin supports the date format YYYY-MM-DD or MM/DD/YYYY. Can you please try editing your CSV file and use either of these two formats and try?

Viewing 1 replies (of 1 total)
  • The topic ‘Import failed on: Invalid date format in column order_date.’ is closed to new replies.