avk84 Posted November 13, 2009 Share Posted November 13, 2009 Hi,i would like to know how we can upload product data to prestashop. I am using Version 1.2.4.0 - 1.221s.I have to import both categories and corresponding products. So what option should I select on the tools>>import.I tried to do an upload but its showing Hack attempt and no data is uploaded. I have to upload the data from eBay and as you know it has over 1000s of products. So I have to get the eBay category and product name and upload it to the database.I have got the data in the needed format.Any help or guidance is appreciated. I am very much stuck in this. I am attaching separate .csv files which i used to do the import.The prestadb.csv contains all the tables and fields I needs and ps_category and ps_product the individual files. prestadb.csv ps_category.csv ps_product.csv Link to comment Share on other sites More sharing options...
pastik Posted November 13, 2009 Share Posted November 13, 2009 Hi,try to import your data without names of columns in your CSV file and reorder your data in the same order as Presta shows you as a help in ImportTool. It works. Link to comment Share on other sites More sharing options...
avk84 Posted November 13, 2009 Author Share Posted November 13, 2009 Thanks for the reply., but I did not get you. when I tried to import by removing the column name it is showing error like Column Name must be set.I tried to upload the data directly to the database. the upload works fine and I have got category and product entered. But when I tried to access the category using the back end, it is showing Category cannot be loadedWhen I tried the catalog tracking it shows the added products.What is gone wrong in the direct upload.Actually I would like to make the upload through presashop backend to work but for the moment The direct import will also be fine. Link to comment Share on other sites More sharing options...
pastik Posted November 13, 2009 Share Posted November 13, 2009 Try this, it works for me well>-create category named as 'Notebooks' manually-in BackEnd select Tools/Import and upload attached file, then select which entity to import>Products andselect your csv file you uploaded-next step and importBelive, this works, maybe you have your *.csv files in bad format. products_notebooks.csv Link to comment Share on other sites More sharing options...
avk84 Posted November 13, 2009 Author Share Posted November 13, 2009 Hi,Thanks very much...my csv format was screwed up. But one more issue remains. The category is shown on back end but the product (Acer...) is not shown over there..How can this be rectified Link to comment Share on other sites More sharing options...
avk84 Posted November 13, 2009 Author Share Posted November 13, 2009 Also can we give image urls in prestashop?if possible how? Link to comment Share on other sites More sharing options...
pastik Posted November 13, 2009 Share Posted November 13, 2009 Yes, it is. I don't have filled up the semifinal attribute (image_url) in my svn file, it is only sample file from me.There are 31 attributes to fill up, fill up with your URL the 30th attribute, then you should see the picture of product. Link to comment Share on other sites More sharing options...
avk84 Posted November 16, 2009 Author Share Posted November 16, 2009 Hi,Thanks very much...I tried it and it works fine....I have one more doubt. The price is given as 1,19 and in csv it is entered separately as 1 and 19 and not as 119..why is it so?if i have to give a price like 31.45 how can i give it. Link to comment Share on other sites More sharing options...
silvianicoleta Posted August 17, 2010 Share Posted August 17, 2010 if the price is 1,19 try to put in your csv the price like this 1.19hope this works for you Link to comment Share on other sites More sharing options...
Recommended Posts