It\’s also a verry big one of i look to the headers, maybe you can look if you really need everything?
I did it with our feed, i only putted the data in the feed that i need to import. So i don\’t have anny empty fields, on that way you have some overview.
We had in first time imported the products into other tables than the database tables of Magento. After that, i made a PHP script that made my new CSV to use in Magento Dataflow Profile.
I think you first need to determine wich information you whant to impor, try to get only this data in youre CSV file
You tried to import with the standard import? Dont use that one, go to Dataflow Profiles and add a profile. You can give the profile the standard Magento CSV file or you can make youre own. Than you can make youre own CSV in divisions.
While making the Profile, you have the option to make youre own profile. The first row is from the database the second row is the row of youre CSV file.
Thanks but I figured it out on my own. I exported the products again, this time through dataflow, export all products. Then had an issue with images, but I just had to move the images from the “media/catalog/products” folder into “media/import” folder. All products imported!
Holy hell this was a hassle to figure out!!! I finally got it to work.
Here’s a quick ‘how to’ for those who had the same issues.
In the Backend of Magento : System - Import/Export - Dataflow Profiles.
Choose Export All Products. Save the CSV.
Open that CSV in Calc in Open Office.
Check that everything looks ok, replace/add products then click
Save As - Text CSV
Another window will popup Export Text File.
Set the top option to UTF-8
second leave as , (comma)
third leave as “(double quote)
Check the box that says ‘Quote all cells”
Hit save - this will save the CSV
Backend Magento - System - Import/Export - Dataflow Profiles - Import All Products.
Upload your file in the Upload file tabe (I hit Save and continue edit).
then click Run Profile.
This will import everything.
I did have the same problem, gave me serious headache but i found a solution that works for me, the only way i can get it to work is to use open office instead of MS excell for it, no matter what i try with excell, i cannot get it to work.
Open it in open office, then save it as a text .csv and it worked for me surprisingly, i do not know why but excell does something with it that it is unreadable.
I use excell 2007 version and magento 18.104.22.168 , so that does not work.
Download open office and try it out.
I also use dutch translation, I hope this works for you !!!! Because it is hell if you break your head over it for a week and can’t upload a thing.
Doe anybody knows How I can upload new products, as this still gives me problems.
If it does not have an excisting SKU, i cant upload new products from a csv???
And that is really Works. Thanks for this post and Open office software.