Categories in Product Import from Spreadsheet

Message Topic Search Topic Options Post Reply Create New Topic Printable Version Translate Topic

   New user question. Been scouring the documentation and I can't seem to find this. I have already set up my Categories, which nest 4 levels deep. I am now importing Products. I can easily import the categories I want for products that are in categories that only nest 2 levels by using "Category name" and "Parent Category" in the Products import spreadsheet. What I can't figure out is a way to describe 3rd or 4th level categories using these same fields. For example, if a book is in the Categories Fiction>Youth I can list those as the "Category name" and "Parent Category" and the categories import just fine. But how would I import the category information for a book which was in the Fiction>Youth>Pre-School third tier category. Simply listing the Parent as Youth and the Category as Pre-School won't work, because that same tree exists under the top-level Non-Fiction category.

Any help would be much appreciated as it far faster to import the category info with the products rather then manually configure in PC.

Thanks

Author	Message Topic Search Topic Options Post Reply Create New Topic Printable Version Translate Topic
prestonbrooks Members Profile Send Private Message Find Members Posts Add to Buddy List Newbie Joined: 03-March-2010 Status: Offline Points: 0	Post Options Post Reply Quote prestonbrooks Report Post Thanks(0) Quote Reply Topic: Categories in Product Import from Spreadsheet Posted: 03-March-2010 at 2:34pm
	New user question. Been scouring the documentation and I can't seem to find this. I have already set up my Categories, which nest 4 levels deep. I am now importing Products. I can easily import the categories I want for products that are in categories that only nest 2 levels by using "Category name" and "Parent Category" in the Products import spreadsheet. What I can't figure out is a way to describe 3rd or 4th level categories using these same fields. For example, if a book is in the Categories Fiction>Youth I can list those as the "Category name" and "Parent Category" and the categories import just fine. But how would I import the category information for a book which was in the Fiction>Youth>Pre-School third tier category. Simply listing the Parent as Youth and the Category as Pre-School won't work, because that same tree exists under the top-level Non-Fiction category. Any help would be much appreciated as it far faster to import the category info with the products rather then manually configure in PC. Thanks

Greg Dinger Members Profile Send Private Message Find Members Posts Add to Buddy List Certified ProductCart Developers Joined: 23-September-2006 Location: United States Status: Offline Points: 238	Post Options Post Reply Quote Greg Dinger Report Post Thanks(0) Quote Reply Posted: 03-March-2010 at 2:41pm
	Could you temporarily rename the tiers so that your example of "Pre-School" becomes "Pre-School2", thus you hit the correct category, then rename the categories after the importing is complete?

prestonbrooks Members Profile Send Private Message Find Members Posts Add to Buddy List Newbie Joined: 03-March-2010 Status: Offline Points: 0	Post Options Post Reply Quote prestonbrooks Report Post Thanks(0) Quote Reply Posted: 03-March-2010 at 2:43pm
	Greg: Good thought. I'll run a test with that and see if i can make it work. Thanks for taking time to post.