Darkmarauder Posted May 4, 2009 Share Posted May 4, 2009 I have been having problems importing with my csv files into subcategories.For example I have Toys and Games as a main category, with Activity Toys as the subcategory.I then import the csv file with the field category in my csv file as Toys and Games, Activity ToysWhen I import the csv file, it creates the category 'Activity Toys' and imports the item there.So any help on importing into sub categories would be appreciated, I've attached an example csv to show what I'm working with. overall_pricing_test1.csv Link to comment Share on other sites More sharing options...
Snol Posted May 4, 2009 Share Posted May 4, 2009 Have you tried a semi colon ; for seperator.John Link to comment Share on other sites More sharing options...
Darkmarauder Posted May 5, 2009 Author Share Posted May 5, 2009 If you mean as the seperator for the overall file (instead of a comma) I don't know how to do that. If you mean the seperator in the catalogue row of the file it creates a hack attempt message. Link to comment Share on other sites More sharing options...
Snol Posted May 5, 2009 Share Posted May 5, 2009 I did mean the column seperator in the row as CSV, as this worked for me a while ago.Cant you create the sub categories in the PS admin back end first and then just import the category colum with just "activity toys" and not "toys& games,activity toys"the comma is what is confusing the csv file it thinks you want all main categories as I dont think the comma is used to seperate as subs, just as main categories.John Link to comment Share on other sites More sharing options...
Darkmarauder Posted May 5, 2009 Author Share Posted May 5, 2009 Thanks John, I now have progress! This is now 100% resolved.I have been fighting this problem for ages, this is going to safe me a lot of time so thank you very much for your help!.For people with this problem:-What I was doing was incorrectly using the categories field. I did not realise that if I had a subcategory existing somewhere within Prestashop (for example toys and games>activity toys) that I could just put 'activity toys' into the category list in the csv file and the item would be put there.Thanks again John. Link to comment Share on other sites More sharing options...
Snol Posted May 5, 2009 Share Posted May 5, 2009 well done, So what we are saying is that every category is its own entity in the csv file.. right? but we create subs in PS and then bring them in withn the sub name in the cat field? is that how it worked for you?John Link to comment Share on other sites More sharing options...
Darkmarauder Posted May 5, 2009 Author Share Posted May 5, 2009 That's right, did some more testing and definetly is the case.Regards Link to comment Share on other sites More sharing options...
Darkmarauder Posted May 6, 2009 Author Share Posted May 6, 2009 The only issue I have left now when it comes to importing is with importing the supplier.As per my post:-http://www.prestashop.com/forums/viewthread/18390/Any help anybody? Link to comment Share on other sites More sharing options...
Recommended Posts