skarnival Posted January 17, 2009 Share Posted January 17, 2009 It was a breeze uploading my categories and manufacturers. But I can't even upload 1 product. I have spent 72 hours on this. Can someone please help me correct the attached csv. And please tell me what I'm doing wrong.Thanks. Oneproduct.csv Link to comment Share on other sites More sharing options...
cor3ys Posted January 17, 2009 Share Posted January 17, 2009 have you tried removing from the description and meta desrption and from Text when in-stock. i know my CSV had to be stripped of most of these tags before i could get them to go up. Link to comment Share on other sites More sharing options...
skarnival Posted January 17, 2009 Author Share Posted January 17, 2009 I will try that now and post an update.Thanks for your quick response. Link to comment Share on other sites More sharing options...
skarnival Posted January 17, 2009 Author Share Posted January 17, 2009 It worked. do you know how I can change the html format in excel? I have a lot of products and It would take forever to manually do this. Link to comment Share on other sites More sharing options...
cor3ys Posted January 17, 2009 Share Posted January 17, 2009 i had about 1500 products in my CSV, and it took me at least a day to strip all the tags out of it...i used excel find and replace, a long way of doing it but i do not know any other way. maybe someone around here might know a short cut....Glad i could help solve the issue tho 72 hours is a long time ;-) Link to comment Share on other sites More sharing options...
skarnival Posted January 17, 2009 Author Share Posted January 17, 2009 cor3ys,Your Magento store looks nice-http://www.primestyles.co.uk . Are you on a shared or dedicated hosting? I have a magento- transnicaintl.com - on shared hosting with simple helix. I was only able to get 800 products in so far. It just stucks at processed 0%.Well,I hope I can get this import here working, so at least I will have one working store.Thanks. Link to comment Share on other sites More sharing options...
Bleep Posted January 17, 2009 Share Posted January 17, 2009 If you are trying to upload html for the description in a CSV file this is what worked for me: First, I customized the look in the WYSIWYG on an actual description box in the back office. Then I clicked on the HTML button and copied it. Then in excel, I pasted the html. The only way I could get it to work, was to delete any returns. For example, all of the tags should be right next to each other. Also I had to format the cell for numbers. Hope this helps. It worked. do you know how I can change the html format in excel? I have a lot of products and It would take forever to manually do this. Link to comment Share on other sites More sharing options...
cor3ys Posted January 17, 2009 Share Posted January 17, 2009 skarnivalthats not magneto that is prestashop ;-) it does say so in my sig Link to comment Share on other sites More sharing options...
Bleep Posted January 17, 2009 Share Posted January 17, 2009 I know the pain, I spent 24 hours and got assistance from John before I got it working. i had about 1500 products in my CSV, and it took me at least a day to strip all the tags out of it...i used excel find and replace, a long way of doing it but i do not know any other way. maybe someone around here might know a short cut....Glad i could help solve the issue tho 72 hours is a long time ;-) Link to comment Share on other sites More sharing options...
skarnival Posted January 17, 2009 Author Share Posted January 17, 2009 cor3ys,Forgive me, you are absolutely correct. This is a presta store. Link to comment Share on other sites More sharing options...
skarnival Posted January 17, 2009 Author Share Posted January 17, 2009 Thanks Rory,I'll try this. Link to comment Share on other sites More sharing options...
Recommended Posts