Format importing of special_date_to

Agence-DnD / PIMGento

PimGento is a Magento extension that allows you to import your catalog from Akeneo CSV files into Magento.

Open Software License 3.0

109 stars 48 forks source link

Format importing of special_date_to #158

Closed gammyduck closed 8 years ago

gammyduck commented 8 years ago

Currently dates are formatted differently in Magento and Akeneo.

Akeneo is 31/05/2016 Magento is 2016-04-13 00:00:00

I can't figure out how to import special_date_to into Magento using Pimgento?

Thanks

buttash commented 8 years ago

I got this working by configuring pim_catalog_date => date in the attributes options for PIMgento. I have special to/from dates populating Magento fine with this configuration. Hope that helps Martin

On 20 May 2016 at 16:04:12, gammyduck (notifications@github.com) wrote:

Currently dates are formatted differently in Magento and Akeneo.

Akeneo is 31/05/2016 Magento is 2016-04-13 00:00:00

I can't figure out how to import special_date_to into Magento using Pimgento?

Thanks

— You are receiving this because you are subscribed to this thread. Reply to this email directly or view it on GitHub

gammyduck commented 8 years ago

Can you show me your akeneo setup for that attribute? Should I still use "special_date_to" in Akeneo? Thanks

buttash commented 8 years ago

My attribute config is:

I use 'special_to_date' in Akeneo (as that is the name of my attribute in Magento) and have set that as a Date field:

Hope that helps

gammyduck commented 8 years ago

Hello, yeah I meant special_to_date, but no luck. thanks for sharing but this didn't solve my issue unfortunately.

buttash commented 8 years ago

What does your date look like in the product.csv file? My special_to_date is of the format "2016-04-07".

gammyduck commented 8 years ago

Magento: 2016-05-31 00:00:00

Akeneo: 31/05/2016

gammyduck commented 8 years ago

Cant get this working, spent all morning on it :S

buttash commented 8 years ago

My previous question obviously wasn't clear as you reposted your original post :o(

I asked what the special_to_date looked like in the product.csv (or whatever you call it) export from Akeneo that you then import into Magento...

I'm no expert in this area, but it might be down to locale difference between Akeneo and Magento? My locales are both set to en_gb. The date from Akeneo in my product.csv is "2016-04-07" which is picked up by my PIMGento extension in Magento. Looks like your date is formatted differently but I'm not sure where you are picking that date up.

gammyduck commented 8 years ago

oh right, I found this https://i.gyazo.com/79792cc9e5f7c0e9ac580f171d476d00.png

buttash commented 8 years ago

The format option on the export is probably going to help...I didn't need to configure this in my environment. Good luck.

gammyduck commented 8 years ago

That fixed it

On Tue, May 24, 2016 at 1:47 PM, buttash notifications@github.com wrote:

The format option on the export is probably going to help...I didn't need to configure this in my environment. Good luck.

— You are receiving this because you authored the thread. Reply to this email directly or view it on GitHub https://github.com/Agence-DnD/PIMGento/issues/158#issuecomment-221257791