lucsar Posted December 16, 2010 Share Posted December 16, 2010 Hi all,I have to import my category/products from csv file supplied by my dropshipper.In this file, category are listed like |aaa->bbb->ccc| and cannot be imported due the arrows (I use "category x, y, z ..." field)Changing with |aaa-bbb-ccc| import goes well but I get a single link like this "aaa-bbb-ccc" Instead, I need to have a menu list that I can open/collapse like this.+aaa +bbb cccThanks for your help Link to comment Share on other sites More sharing options...
rocky Posted December 19, 2010 Share Posted December 19, 2010 You need to create a category CSV file like this:Category ID;Name;Parent Category ID2;aaa;13;bbb;24;ccc;3This will make "aaa" a subcategory of the "Home" category, "bbb" a subcategory of "aaa" and "ccc" a subcategory of "bbb". Link to comment Share on other sites More sharing options...
lucsar Posted December 20, 2010 Author Share Posted December 20, 2010 You need to create a category CSV file like this:Category ID;Parent Category ID;2;aaa;13;bbb;24;ccc;3This will make "aaa" a subcategory of the "Home" category, "bbb" a subcategory of "aaa" and "ccc" a subcategory of "bbb". It works!! thank you!Now, with this method I have to find all category listed like aaa->bbb->ccc in my csv file (4000 records) and add manually category and parent ID's for each accordingly. I'm wondering if I can use XML file to get/import live feed from my dropshopper directly into my db 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