Title: Import problems “invalid date”
Last modified: March 4, 2024

---

# Import problems “invalid date”

 *  Resolved [kingsizefairy](https://wordpress.org/support/users/kingsizefairy/)
 * (@kingsizefairy)
 * [2 years, 2 months ago](https://wordpress.org/support/topic/import-problems-invalid-date/)
 * This is regarding the free plugin Order Export & Order Import for Woocommerce.
 * I had exported several files as I had to bulk update some information.
 * When I imported said file again, half of the orders were skipped because of an
   invalid date (I never changed anything in that column) and others were imported
   with a date of e.g. October 2024!
 * Now all my orders are messed up and the dates are wrong.
 * I need to fix this as soon as possible, please!

Viewing 2 replies - 1 through 2 (of 2 total)

 *  Plugin Support [WebToffee Support](https://wordpress.org/support/users/webtoffeesupport/)
 * (@webtoffeesupport)
 * [2 years, 2 months ago](https://wordpress.org/support/topic/import-problems-invalid-date/#post-17474772)
 *  Hi [@kingsizefairy](https://wordpress.org/support/users/kingsizefairy/),
 * It appears that the issue with the order dates may have arisen due to changes
   in the date format when the CSV file was opened in your spreadsheet application.
   To ensure the correct import of dates, please ensure that the date format in 
   the CSV file is YYYY-MM-DD before importing.
 * To fix the messed-up order dates, you can export the previous order export by
   navigating to WebToffee Import Export (Basic) > History and downloading the previously
   exported order by clicking on “download.” later you may import the exported file
   directly without opening it in your spreadsheet application.
 * To prevent this issue in the future, if you do not need to update the dates, 
   you can choose to unmap them during import to avoid unintended changes to the
   dates.
 *  Thread Starter [kingsizefairy](https://wordpress.org/support/users/kingsizefairy/)
 * (@kingsizefairy)
 * [2 years, 2 months ago](https://wordpress.org/support/topic/import-problems-invalid-date/#post-17475509)
 * Thank you so, so much for your help.
 * I followed your instructions and now everything is back where it should be 🙂

Viewing 2 replies - 1 through 2 (of 2 total)

The topic ‘Import problems “invalid date”’ is closed to new replies.

 * ![](https://ps.w.org/order-import-export-for-woocommerce/assets/icon-256x256.
   gif?rev=3133964)
 * [Order Export & Order Import for WooCommerce](https://wordpress.org/plugins/order-import-export-for-woocommerce/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/order-import-export-for-woocommerce/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/order-import-export-for-woocommerce/)
 * [Active Topics](https://wordpress.org/support/plugin/order-import-export-for-woocommerce/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/order-import-export-for-woocommerce/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/order-import-export-for-woocommerce/reviews/)

## Tags

 * [import failed](https://wordpress.org/support/topic-tag/import-failed/)
 * [Invalid date](https://wordpress.org/support/topic-tag/invalid-date/)

 * 2 replies
 * 2 participants
 * Last reply from: [kingsizefairy](https://wordpress.org/support/users/kingsizefairy/)
 * Last activity: [2 years, 2 months ago](https://wordpress.org/support/topic/import-problems-invalid-date/#post-17475509)
 * Status: resolved