Magento: Potential Date Field Product Import Bug

Note: Only tested so far with

A client that I am working on has a custom product attribute, which is a date field. They recently ran an import to update that field and noticed something strange. It seems that some of the dates worked fine, and others had the day and the month swapped, creating a wrong date.

They had probably 50+ products with the following value for the date: “2011-05-10 00:00:00”. Some of them worked properly and the date ‘5/10/11′ displays when editing the product in the admin. But, some of them switched the day and month and the date in the field is ’10/5/11’.

I tried reversing the day and month in the csv and imported again, and again, it switched the date around. So, now that the value in the admin was ‘5/10/11’, I ran an export of just that product, and the date was correct! I took that exact spreadsheet and imported it, and it switched the day and month again.

At this point, I don’t have time to really dig into trying to figure out the issue. If you have encountered this, or even better if you have figured out the issue, please comment! Please be sure to inclue your Magento version as well, as it may not just be

This entry was posted in Magento. Bookmark the permalink.

4 Responses to Magento: Potential Date Field Product Import Bug

  1. Have the same problem!
    the best way to upgrade magento.

  2. Latmiz says:


    I’m having the same problem. PLZ you resolve it? you can help?


  3. christophe says:

    possible solution is to adapt
    Line 37 (locale)
    Line 228
    Line 532 (date format is stored here)

  4. christophe says:


    I’m having the same problem and still looking for a solution. Did you already get any progress on this?