sixpks Posted September 30, 2009 Share Posted September 30, 2009 Hi , I am trying to import products from my csv file. i a bunch of columsn in my csv file. I am trying to map columns to the source columsn on the dbase, but The number of columns i have are more than what is bein provided by prestashop.I am attaching the sample csv file. THEre are some attributes that are null for some products and there are products which have 1-3 subcategories.I am not sure how to map the columns since there are more columns that what is being provided by prestashop.ANy help is greatly appreciated. sample.xls Link to comment Share on other sites More sharing options...
sixpks Posted October 1, 2009 Author Share Posted October 1, 2009 Is there nobody here to help? Link to comment Share on other sites More sharing options...
rocky Posted October 2, 2009 Share Posted October 2, 2009 Your CSV file is in the wrong format. I've attached an example CSV in the right format. To make it easiest for you to import, you should include all the product fields and then add all the features at the end. See the Instructions tab of the attached file for more details. products.xls Link to comment Share on other sites More sharing options...
sixpks Posted October 2, 2009 Author Share Posted October 2, 2009 Hi rocky,I think the attachment you sent, doesnt have all the fields nor the instructions tab. Can you resend the file again please.thankss Link to comment Share on other sites More sharing options...
rocky Posted October 2, 2009 Share Posted October 2, 2009 I just downloaded the file and opened it in Excel and I can see all the fields on the Products sheet and the instructions on the Instructions sheet. What are you opening it in? Link to comment Share on other sites More sharing options...
sixpks Posted October 2, 2009 Author Share Posted October 2, 2009 hi rocky,Thanks i was able to open it now. Once again thank you for your help.Is there a place on your website where i can check your consulting experitse and other information If i wanted to decide upon consulting.thanks Link to comment Share on other sites More sharing options...
rocky Posted October 3, 2009 Share Posted October 3, 2009 Hi sixpks,You can use the contact form on my website if you want my services. I'm pretty busy at the moment, but feel free to contact me in the future if you need help with your CSV file or anything other Prestashop work done. Link to comment Share on other sites More sharing options...
sixpks Posted October 4, 2009 Author Share Posted October 4, 2009 hi rocky,I was able to figure out all the parts of my csv sheet for the improt except the categories part. I have the categories setup in the csv >Like thisab,abc, abcdab,abc,abcdeab,abc,abcdefDo i have it setup rght or do i have to change the categories to Integers?If i do change them to integers,Howdo i refernece them ? Link to comment Share on other sites More sharing options...
rocky Posted October 4, 2009 Share Posted October 4, 2009 It is best to use the category IDs instead of names to avoid problems with categories that have the same name. Link to comment Share on other sites More sharing options...
sixpks Posted October 4, 2009 Author Share Posted October 4, 2009 So I would assume I would build a Master List of all Categories One list and import it into the categories and Then i would customize the products list and reference those ids in the Products file.So finally the category column in products colum will be somthing like this1)1,2,32)1,2,53)1,4,9so on and so forth. Thank you so much for your patience in answering questions. Link to comment Share on other sites More sharing options...
rocky Posted October 4, 2009 Share Posted October 4, 2009 Yes, that is right. Let me know if this works for you. Many people are having problems importing CSV files. Even I have been having trouble importing some Unicode CSV files. Link to comment Share on other sites More sharing options...
sixpks Posted October 14, 2009 Author Share Posted October 14, 2009 Hi ROcky,I tried many tims and finally gave up. I think i have to wait few more monthts before Prestashop upload feature is streamlined. Too bad its an amazing cart though.thanks for all your help. I will go with oscommerce for now. But eventually once things streamline with Presta i can come back and hopefully get things right.thankss Link to comment Share on other sites More sharing options...
phantomeye Posted October 14, 2009 Share Posted October 14, 2009 Hi Sixpks,Where are you getting stuck, i just imported successfully about 8000 products. Yes initially i got frustrated, but once you know the format, it works very well. OScommerce is a very heavy, slow, complicated cart and is not a Web2.0 product.Cheers Link to comment Share on other sites More sharing options...
sixpks Posted October 14, 2009 Author Share Posted October 14, 2009 Hi Phantomeye,I have a csv file that has 14000 products . I am getting confused at the part where we have subcatergories under each category. I am attaching the xl file for you,it wold be great if you can guide me in the right direction.thanks test.csv Link to comment Share on other sites More sharing options...
rocky Posted October 14, 2009 Share Posted October 14, 2009 The CSV you attached is not formated correctly. It has the Reference # under Product ID, and it has the categories in separate columns. The categories should all be listed in the same column. You should use ; to separate columns and , to separate category IDs. Have another look at the products.xls I attached above for the correct format. Link to comment Share on other sites More sharing options...
phantomeye Posted October 15, 2009 Share Posted October 15, 2009 your csv file needs to be formatted to the exact requirements. Read the link below and it gives you all the details you need to import the data. Keep in mind that you have way more fields than what prestashop will allow you to import. So you will have to format it accordingly.http://www.prestashop.com/forums/viewthread/28426/help_configuration___use/moving_oscomm_catalog_to_psTo answer your question on categories, it needs to be integers seperated by ; but make sure you specify that in the back office import settings under the field "multiple value separator"another option you can try (im not sure how it may work, so just import 1 item) is to put each subcategories in a seperate column, it should populate them all.hope this helps you. Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now