[Skip to main content](#vessel-content) # Import of categories tree ## - **[Bernhard7](/forum/user/36875-bernhard7 "View Bernhard7's Profile")** - [![Bernhard7's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/36875-bernhard7 "View Bernhard7's Profile") Topic Author - [ Offline](/forum/user/36875-bernhard7) Less More - Posts: 40 - Thank you received: 1 - - 11 years 7 months ago [\#198146](#198146) by [Bernhard7](/forum/user/36875-bernhard7 "View Bernhard7's Profile") *[Import of categories tree](/forum/37-import-export-csv-xls/876305-import-of-categories-tree#198146 "-- HikaShop version -- : 2.4.0 -- Joomla version -- : 3.4.1 -- PHP version -- : 5.4.16 -- Browser(s) name and version -- : Chrome 41.0.2272.118 m Hi, I have problems importing a category tree. the documentation does not answer my questions, so I post it here. Ist is possible to import the categories tree separately from the product import, or do I have to do the import of categories and products in 1 step? I have here a sample csv: parent_category;categories;categories_namekey 1;100;cat1Level1 100;101;cat1Level2 100;102;cat2Level2 101;103;cat1Level3 101;104;cat2Level3 102;105;cat3Level3 it creates sub-categories (on level 2) with the ids as their names. Where is the problem?")* was created by *[Bernhard7](/forum/user/36875-bernhard7 "View Bernhard7's Profile")* -- HikaShop version -- : 2.4.0 -- Joomla version -- : 3.4.1 -- PHP version -- : 5.4.16 -- Browser(s) name and version -- : Chrome 41.0.2272.118 m Hi, I have problems importing a category tree. the documentation does not answer my questions, so I post it here. Ist is possible to import the categories tree separately from the product import, or do I have to do the import of categories and products in 1 step? I have here a sample csv: parent_category;categories;categories_namekey 1;100;cat1Level1 100;101;cat1Level2 100;102;cat2Level2 101;103;cat1Level3 101;104;cat2Level3 102;105;cat3Level3 it creates sub-categories (on level 2) with the ids as their names. Where is the problem? Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtL2ltcG9ydC1leHBvcnQtY3N2LXhscy84NzYzMDUtaW1wb3J0LW9mLWNhdGVnb3JpZXMtdHJlZT90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[nicolas](/forum/user/63-nicolas "View nicolas's Profile")** - [![nicolas's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar63.png?1793428657)](/forum/user/63-nicolas "View nicolas's Profile") - [ Offline](/forum/user/63-nicolas) Less More - Posts: 86541 - Thank you received: 14304 - - 11 years 7 months ago [\#198169](#198169) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Import of categories tree](/forum/37-import-export-csv-xls/876305-import-of-categories-tree#198169 "-- HikaShop version -- : 2.4.0 -- Joomla version -- : 3.4.1 -- PHP version -- : 5.4.16 -- Browser(s) name and version -- : Chrome 41.0.2272.118 m Hi, I have problems importing a category tree. the documentation does not answer my questions, so I post it here. Ist is possible to import the categories tree separately from the product import, or do I have to do the import of categories and products in 1 step? I have here a sample csv: parent_category;categories;categories_namekey 1;100;cat1Level1 100;101;cat1Level2 100;102;cat2Level2 101;103;cat1Level3 101;104;cat2Level3 102;105;cat3Level3 it creates sub-categories (on level 2) with the ids as their names. Where is the problem?")* Hi, The categories_namekey column doesn't exist. You should put the name of the categories directly in the categories and parent_category columns like this: parent_category;categories ;cat1Level1 cat1Level1;cat1Level2 cat1Level1;cat2Level2 cat1Level2;cat1Level3 cat1Level2;cat2Level3 cat2Level2;cat3Level3 And you can even reduce that to: parent_category;categories ;cat1Level1 cat1Level1;cat1Level2,cat2Level2 cat1Level2;cat1Level3,cat2Level3 cat2Level2;cat3Level3 That's what we explain in the "Importing product categories" section of the import documentation. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtL2ltcG9ydC1leHBvcnQtY3N2LXhscy84NzYzMDUtaW1wb3J0LW9mLWNhdGVnb3JpZXMtdHJlZT90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[Harlequin](/forum/user/38080-harlequin "View Harlequin's Profile")** - [![Harlequin's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/38080-harlequin "View Harlequin's Profile") - [ Offline](/forum/user/38080-harlequin) Less More - Posts: 38 - Thank you received: 2 - - 11 years 1 month ago [\#216630](#216630) by [Harlequin](/forum/user/38080-harlequin "View Harlequin's Profile") Replied by *[Harlequin](/forum/user/38080-harlequin "View Harlequin's Profile")* on topic *[Import of categories tree](/forum/37-import-export-csv-xls/876305-import-of-categories-tree#216630 "-- HikaShop version -- : 2.4.0 -- Joomla version -- : 3.4.1 -- PHP version -- : 5.4.16 -- Browser(s) name and version -- : Chrome 41.0.2272.118 m Hi, I have problems importing a category tree. the documentation does not answer my questions, so I post it here. Ist is possible to import the categories tree separately from the product import, or do I have to do the import of categories and products in 1 step? I have here a sample csv: parent_category;categories;categories_namekey 1;100;cat1Level1 100;101;cat1Level2 100;102;cat2Level2 101;103;cat1Level3 101;104;cat2Level3 102;105;cat3Level3 it creates sub-categories (on level 2) with the ids as their names. Where is the problem?")* Hi Nicolas I am having similar problems to this. and I am not an expert with csv! So I have a tree like this Product category >GS&S >FG >EFG So this is a category (GS&S) which has a sub category (FG) which also has another Sub, category within it. I have tried exporting the CSV from my categories I have set up including category_depth? How is this actually presented in the excle spread sheet. Sorry if I am asking the same question but I am struggling to equate the answers to an actual spread sheet. What are the headers for the columns? Many thanks for your help in advance Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtL2ltcG9ydC1leHBvcnQtY3N2LXhscy84NzYzMDUtaW1wb3J0LW9mLWNhdGVnb3JpZXMtdHJlZT90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[nicolas](/forum/user/63-nicolas "View nicolas's Profile")** - [![nicolas's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar63.png?1793428657)](/forum/user/63-nicolas "View nicolas's Profile") - [ Offline](/forum/user/63-nicolas) Less More - Posts: 86541 - Thank you received: 14304 - - 11 years 1 month ago [\#216638](#216638) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Import of categories tree](/forum/37-import-export-csv-xls/876305-import-of-categories-tree#216638 "-- HikaShop version -- : 2.4.0 -- Joomla version -- : 3.4.1 -- PHP version -- : 5.4.16 -- Browser(s) name and version -- : Chrome 41.0.2272.118 m Hi, I have problems importing a category tree. the documentation does not answer my questions, so I post it here. Ist is possible to import the categories tree separately from the product import, or do I have to do the import of categories and products in 1 step? I have here a sample csv: parent_category;categories;categories_namekey 1;100;cat1Level1 100;101;cat1Level2 100;102;cat2Level2 101;103;cat1Level3 101;104;cat2Level3 102;105;cat3Level3 it creates sub-categories (on level 2) with the ids as their names. Where is the problem?")* You can use such CSV: parent_category;categories Product category;GS&S GS&S;FG FG;EFG The following user(s) said Thank You: [Harlequin](/forum/user/38080-harlequin "View Harlequin's Profile") Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtL2ltcG9ydC1leHBvcnQtY3N2LXhscy84NzYzMDUtaW1wb3J0LW9mLWNhdGVnb3JpZXMtdHJlZT90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[Harlequin](/forum/user/38080-harlequin "View Harlequin's Profile")** - [![Harlequin's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/38080-harlequin "View Harlequin's Profile") - [ Offline](/forum/user/38080-harlequin) Less More - Posts: 38 - Thank you received: 2 - - 11 years 1 month ago [\#216774](#216774) by [Harlequin](/forum/user/38080-harlequin "View Harlequin's Profile") Replied by *[Harlequin](/forum/user/38080-harlequin "View Harlequin's Profile")* on topic *[Import of categories tree](/forum/37-import-export-csv-xls/876305-import-of-categories-tree#216774 "-- HikaShop version -- : 2.4.0 -- Joomla version -- : 3.4.1 -- PHP version -- : 5.4.16 -- Browser(s) name and version -- : Chrome 41.0.2272.118 m Hi, I have problems importing a category tree. the documentation does not answer my questions, so I post it here. Ist is possible to import the categories tree separately from the product import, or do I have to do the import of categories and products in 1 step? I have here a sample csv: parent_category;categories;categories_namekey 1;100;cat1Level1 100;101;cat1Level2 100;102;cat2Level2 101;103;cat1Level3 101;104;cat2Level3 102;105;cat3Level3 it creates sub-categories (on level 2) with the ids as their names. Where is the problem?")* Thats great thanks, I hadn'tappreciated that the new parent_category would be the immediate one above the category I require. So I have around 8000 products and many multiple level categories. Can I import them all at the same time or should I set up the categories first as the products will be placed in the CSV along with their category; in the product catalogue serial number order. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtL2ltcG9ydC1leHBvcnQtY3N2LXhscy84NzYzMDUtaW1wb3J0LW9mLWNhdGVnb3JpZXMtdHJlZT90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[nicolas](/forum/user/63-nicolas "View nicolas's Profile")** - [![nicolas's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar63.png?1793428657)](/forum/user/63-nicolas "View nicolas's Profile") - [ Offline](/forum/user/63-nicolas) Less More - Posts: 86541 - Thank you received: 14304 - - 11 years 1 month ago [\#216814](#216814) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Import of categories tree](/forum/37-import-export-csv-xls/876305-import-of-categories-tree#216814 "-- HikaShop version -- : 2.4.0 -- Joomla version -- : 3.4.1 -- PHP version -- : 5.4.16 -- Browser(s) name and version -- : Chrome 41.0.2272.118 m Hi, I have problems importing a category tree. the documentation does not answer my questions, so I post it here. Ist is possible to import the categories tree separately from the product import, or do I have to do the import of categories and products in 1 step? I have here a sample csv: parent_category;categories;categories_namekey 1;100;cat1Level1 100;101;cat1Level2 100;102;cat2Level2 101;103;cat1Level3 101;104;cat2Level3 102;105;cat3Level3 it creates sub-categories (on level 2) with the ids as their names. Where is the problem?")* Hi, The best is to do like the CSV you get when you click on the "export" button of the products listing: First the categories tree is defined at the top of the CSV and then you get the products with the name of their category below. The following user(s) said Thank You: [Bernhard7](/forum/user/36875-bernhard7 "View Bernhard7's Profile") Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtL2ltcG9ydC1leHBvcnQtY3N2LXhscy84NzYzMDUtaW1wb3J0LW9mLWNhdGVnb3JpZXMtdHJlZT90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[Bernhard7](/forum/user/36875-bernhard7 "View Bernhard7's Profile")** - [![Bernhard7's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/36875-bernhard7 "View Bernhard7's Profile") Topic Author - [ Offline](/forum/user/36875-bernhard7) Less More - Posts: 40 - Thank you received: 1 - - 11 years 4 weeks ago [\#217345](#217345) by [Bernhard7](/forum/user/36875-bernhard7 "View Bernhard7's Profile") Replied by *[Bernhard7](/forum/user/36875-bernhard7 "View Bernhard7's Profile")* on topic *[Import of categories tree](/forum/37-import-export-csv-xls/876305-import-of-categories-tree#217345 "-- HikaShop version -- : 2.4.0 -- Joomla version -- : 3.4.1 -- PHP version -- : 5.4.16 -- Browser(s) name and version -- : Chrome 41.0.2272.118 m Hi, I have problems importing a category tree. the documentation does not answer my questions, so I post it here. Ist is possible to import the categories tree separately from the product import, or do I have to do the import of categories and products in 1 step? I have here a sample csv: parent_category;categories;categories_namekey 1;100;cat1Level1 100;101;cat1Level2 100;102;cat2Level2 101;103;cat1Level3 101;104;cat2Level3 102;105;cat3Level3 it creates sub-categories (on level 2) with the ids as their names. Where is the problem?")* ![:cheer:](/media/kunena/emoticons/2.png ":cheer:") Export is a great idea. I will do that. Thanks, Regards, Bernhard Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtL2ltcG9ydC1leHBvcnQtY3N2LXhscy84NzYzMDUtaW1wb3J0LW9mLWNhdGVnb3JpZXMtdHJlZT90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[Bernhard7](/forum/user/36875-bernhard7 "View Bernhard7's Profile")** - [![Bernhard7's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/36875-bernhard7 "View Bernhard7's Profile") Topic Author - [ Offline](/forum/user/36875-bernhard7) Less More - Posts: 40 - Thank you received: 1 - - 11 years 4 weeks ago [\#217346](#217346) by [Bernhard7](/forum/user/36875-bernhard7 "View Bernhard7's Profile") Replied by *[Bernhard7](/forum/user/36875-bernhard7 "View Bernhard7's Profile")* on topic *[Import of categories tree](/forum/37-import-export-csv-xls/876305-import-of-categories-tree#217346 "-- HikaShop version -- : 2.4.0 -- Joomla version -- : 3.4.1 -- PHP version -- : 5.4.16 -- Browser(s) name and version -- : Chrome 41.0.2272.118 m Hi, I have problems importing a category tree. the documentation does not answer my questions, so I post it here. Ist is possible to import the categories tree separately from the product import, or do I have to do the import of categories and products in 1 step? I have here a sample csv: parent_category;categories;categories_namekey 1;100;cat1Level1 100;101;cat1Level2 100;102;cat2Level2 101;103;cat1Level3 101;104;cat2Level3 102;105;cat3Level3 it creates sub-categories (on level 2) with the ids as their names. Where is the problem?")* > nicolas wrote: Hi, > > The best is to do like the CSV you get when you click on the "export" button of the products listing: > First the categories tree is defined at the top of the CSV and then you get the products with the name of their category below. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtL2ltcG9ydC1leHBvcnQtY3N2LXhscy84NzYzMDUtaW1wb3J0LW9mLWNhdGVnb3JpZXMtdHJlZT90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. Board Categories HikaShop Install & Update Product & Category Display Content Creation Sales and Orders Orders management Reports & Statistics Customers Checkout Payment Methods Shipping Methods Import & Export (CSV, XLS…) Specific Features Affilation Taxes Wishlist Vote Carousel & Slider Mass Actions Filters & Search Discount & Coupon Feature Request Integrations Showcase General Talk about HikaShop Development HikaShop 3.0 Beta Translation Commercial Jobs HikaShop Components HikaMarket Market: Feature requests Market: How to? Market: Bug Report HikaSerial General talk about HikaSerial Serial: Bug Report Serial: How to? Support en Français de HikaSerial (French Support) HikaSubscription HikaAuction Auction: Feature requests Auction: How to? Auction: Bug report Hikashop around the world Support en Français (French Support) Russian FAQ. Курс выживания с Hikashop. Частые вопросы и о Расширения Hikashop Наши сайты на Hikashop 日本語版サポート(Japanese Support) Thai German Archives Bug Report How to? [](/forum/topics/feed/mode-topics?format=feed&type=rss) Time to create page: 0.082 seconds [Powered by](/forum/credits) [Kunena Forum](https://www.kunena.org)