Posting in the Magento forums has been disabled pending the implementation of a new and improved forum solution which should better serve the community.

For new questions please post at magento.stackexchange.com, the community-run support site for the Magento community. We will be providing updates on the new forum solution soon. For questions or concerns please email community@magento.com.

Magento Forum

Page 2 of 2
Product Import Does not work in 1.4.1.1
 
Flaxton
Sr. Member
 
Avatar
Total Posts:  137
Joined:  2010-06-03
Houston
 

UTF-8

Should solve 99* of the problems listed above.

 
Magento Community Magento Community
Magento Community
Magento Community
 
emmenko
Sr. Member
 
Total Posts:  96
Joined:  2010-10-20
 
Flaxton - 09 November 2010 07:20 AM

UTF-8

Should solve 99* of the problems listed above.

What do you mean? To read the csv file, right?

 
Magento Community Magento Community
Magento Community
Magento Community
 
Flaxton
Sr. Member
 
Avatar
Total Posts:  137
Joined:  2010-06-03
Houston
 

Yes…

Everyone has plenty of issues importing data, but this is the #1 reason people have issues.

 
Magento Community Magento Community
Magento Community
Magento Community
 
emmenko
Sr. Member
 
Total Posts:  96
Joined:  2010-10-20
 

Yeah, I know smile

PS: now I use Open Office that gives me no problem with csv....but at first I tried with Excel (on a Mac). I wasn’t able to create a right csv file without problem....do you have any tipp? ...and I didn’t find how to change configuration :(

 
Magento Community Magento Community
Magento Community
Magento Community
 
Flaxton
Sr. Member
 
Avatar
Total Posts:  137
Joined:  2010-06-03
Houston
 

I have 2 co-workers who compile all the data in Microsoft Office and when i get the files to look over before import I use Open Office(Libre Office now) and set the char type and delimiters there. I am unsure how to do either of those things in Microsoft Office and I personally, never use Microsoft Office. I stopped in 2007 with that god awful GUI and its lack of immediate CSV compatibilities.

 
Magento Community Magento Community
Magento Community
Magento Community
 
emmenko
Sr. Member
 
Total Posts:  96
Joined:  2010-10-20
 

Great...always problems with Microsoft! è_é

I lost 2 days trying to figure out something...then I downloaded Open Office smile

But I’m curious how to get it work...boh!

 
Magento Community Magento Community
Magento Community
Magento Community
 
brunomarshall
Guru
 
Avatar
Total Posts:  367
Joined:  2009-08-04
 
sleiweke - 09 November 2010 02:21 AM

Hello brunomarshall, thanks a lot for you info.

could you please publish a sample of your 3 csv files?

Thanks a lot
Sebastian

Hello Sebastian,
Here i have attached csvs which worked for me

File Attachments
FINAL WORKING SET OF CSVS.zip  (File Size: 35KB - Downloads: 147)
 
Magento Community Magento Community
Magento Community
Magento Community
 
sleiweke
Sr. Member
 
Total Posts:  85
Joined:  2009-03-10
Germany
 

Hello brunomarshall,

thanks a lot for sharing

Sebastian

 
Magento Community Magento Community
Magento Community
Magento Community
 
emmenko
Sr. Member
 
Total Posts:  96
Joined:  2010-10-20
 

Hi everyone,

Finally I managed to do a clean import with a cron!

I have to thx Quinty e amartinez for the support on the last days…

Anyway, soon amartinez will publish a stable version of his script for magento version 1.4+!!!
I (and we all I think) am looking forward for this…

Bye

Nicola

 
Magento Community Magento Community
Magento Community
Magento Community
 
jabratch
Jr. Member
 
Total Posts:  1
Joined:  2010-04-16
 

I’ve followed these steps and others from other threads and I keep getting this error for each of my rows whenever I try to import:

Skip import row, required field “entityid” not defined

I am using open office and making sure all import files are UTF-8. I have tried uploading with a new import profile as well as with import all products. Always get the entityid error. Anyone know what this error means?

 
Magento Community Magento Community
Magento Community
Magento Community
 
dweeves
Enthusiast
 
Total Posts:  877
Joined:  2010-06-26
FRANCE
 

have you ever tried magmi ?
just look at the post with 2000+ answers & this site

works from 1.3 to 1.6, many powerful features , and it’s free.

 
Magento Community Magento Community
Magento Community
Magento Community
 
mattb13
Jr. Member
 
Total Posts:  13
Joined:  2011-12-23
 

I’ve heard about magmi, never got to use it though

another suggestion is to try this service
I had a lot of headache cause of import, esp with product images, and these guys do it really well

 
Magento Community Magento Community
Magento Community
Magento Community
Magento Community
Magento Community
Back to top
Page 2 of 2