coolcatkelso Posted January 25, 2013 Share Posted January 25, 2013 (edited) Hi Guys Using the new version 1.5.3 I have a small test Product CSV File with the following 2,1,Test1,Accessories;air,1.20,,0.80,,,,,,,, and so on This is made from excel 2010 and exported as CSv using comma (I do change the import in admin from ; to , and vice versa Categories are Home: Tropical Fish (with Subs) Chiclids (With Subs) Accessories Air Food Whenever I try to import this csv file all goes well untill I check the shop and Test1 product is under home and I would have to manually change this through admin panel to Accessories - Air Am I missing something? Edited January 25, 2013 by coolcatkelso (see edit history) Link to comment Share on other sites More sharing options...
Rafn Posted February 8, 2013 Share Posted February 8, 2013 Hi coolcatkelso, I'm having the same issue: my imported products are all being assigned under the Home category and not my subcategory. Did you find a resolution for the problem? Eric Link to comment Share on other sites More sharing options...
coolcatkelso Posted February 8, 2013 Author Share Posted February 8, 2013 Hi m8 Yes I managed to figure it out If you are using csv to import, instead of using the category name use the I'd number Mines is like Category's: Main: Tropical fish (1) Marine fish (2) And sub cats for tropical: Guppies (12) Mollies (13) Etc So in csv do it like Id Name. Unit price. Whole sale. Category 1. Fish 1. 1.99. 0.79. 1;12 1 being tropical fish and 12 being subcategory I used use excel to create the csv file but this is done using comma, so just make sure you thing that setting in upload setting Field separator , ; is default Multiple items. ; , is default And hit upload Link to comment Share on other sites More sharing options...
Rafn Posted February 8, 2013 Share Posted February 8, 2013 Hi m8, thank you for the quick response! Although, after I used the category IDs the products still are being put in the home category. I used the default CSV file (http://localhost/ps/docs/csv_import/products_import.csv) from my installation of prestashop and changed the category names to category IDs. I'm using version 1.5.3.1 and using a language other than the default "English (English)" I'm going to: check my php error log read the documentation of how to create a category (just in case I'm creating the categories wrong) Any suggestions? Eric Link to comment Share on other sites More sharing options...
Rafn Posted February 11, 2013 Share Posted February 11, 2013 This code fixed the problem: https://github.com/PrestaShop/PrestaShop/commit/8d7196daf3b39d280c631882f0e3ebe473233d07 Link to comment Share on other sites More sharing options...
Recommended Posts