Unable to Export / Import Products Excel

Saturday, February 27, 2021 1:16:54 PM
  • Posted: Monday, January 25, 2021 6:15 AM
  • 30
Hello.  Pretty unexpected - I thought this would be well tested!   Using the latest Grandnode 4.80.0 in windows
( actually the same thing happens on the Digital ocean droplet I installed )

Export any product(s) to Excel then import into another site and the import fails

Error at the top:    String '' was not recognized as a valid DateTime when importing.

  • Posted: Monday, January 25, 2021 6:42 AM
  • Team
  • 848
Hello, Martin.

If you don't want to use the PreorderAvailability Date or New Product Start/End date, remove that three columns. Columns BO, CD, CE. It's not necessary to use all fields that you have available in the excel sheets, if you don't use them.

Otherwise, if you would like to use that fields, here is the date format that you should use: 1/25/2021 12:00:00 AM
Best regards,

GrandNode Team
  • Posted: Monday, January 25, 2021 6:51 AM
  • 30
Thanks.   I guess I would have expected
- the fact that it has false in the column to not use it and/or
- import something that exported from the other system fine.

to just import well - or give some sort of message.

thanks for your time.
back to top