[Skip to main content](#vessel-content) # Import category and subcategory ## - **[ows2016](/forum/user/43901-ows2016 "View ows2016's Profile")** - [![ows2016's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/43901-ows2016 "View ows2016's Profile") Topic Author - [ Offline](/forum/user/43901-ows2016) Less More - Posts: 25 - Thank you received: 0 - - 9 years 4 months ago [\#271717](#271717) by [ows2016](/forum/user/43901-ows2016 "View ows2016's Profile") *[Import category and subcategory](/forum/37-import-export-csv-xls/890673-import-category-and-subcategory#271717 "-- HikaShop version -- : 3.1.1 -- Joomla version -- : 3.4.8 -- PHP version -- : 5.5.32 -- Browser(s) name and version -- : firefox Hi, i have a problem with the category and subcategory import, i have this scenario: main category -> subcategory-1 -> subcategory-2 -> product I don't understand how to place the categories in csv files, i tried in this way: product_name, product_code, parent_category, categories but it doesn't work. where i'm wrong? Can you help me please? thank you.")* was created by *[ows2016](/forum/user/43901-ows2016 "View ows2016's Profile")* -- HikaShop version -- : 3.1.1 -- Joomla version -- : 3.4.8 -- PHP version -- : 5.5.32 -- Browser(s) name and version -- : firefox Hi, i have a problem with the category and subcategory import, i have this scenario: **main category -> subcategory-1 -> subcategory-2 -> product** I don't understand how to place the categories in csv files, i tried in this way: product_name, product_code, parent_category, categories but it doesn't work. where i'm wrong? Can you help me please? thank you. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM3LWltcG9ydC1leHBvcnQtY3N2LXhscy84OTA2NzMtaW1wb3J0LWNhdGVnb3J5LWFuZC1zdWJjYXRlZ29yeT90bXBsPW1hcmtkb3du) 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)](/forum/user/63-nicolas "View nicolas's Profile") - [ Offline](/forum/user/63-nicolas) Less More - Posts: 86289 - Thank you received: 14265 - - 9 years 4 months ago [\#271730](#271730) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Import category and subcategory](/forum/37-import-export-csv-xls/890673-import-category-and-subcategory#271730 "-- HikaShop version -- : 3.1.1 -- Joomla version -- : 3.4.8 -- PHP version -- : 5.5.32 -- Browser(s) name and version -- : firefox Hi, i have a problem with the category and subcategory import, i have this scenario: main category -> subcategory-1 -> subcategory-2 -> product I don't understand how to place the categories in csv files, i tried in this way: product_name, product_code, parent_category, categories but it doesn't work. where i'm wrong? Can you help me please? thank you.")* Hi, You can do like that: Code: product_code;parent_category;categories ;main category;subcategory-1 product;subcategory-1;subcategory-2 Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM3LWltcG9ydC1leHBvcnQtY3N2LXhscy84OTA2NzMtaW1wb3J0LWNhdGVnb3J5LWFuZC1zdWJjYXRlZ29yeT90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[ows2016](/forum/user/43901-ows2016 "View ows2016's Profile")** - [![ows2016's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/43901-ows2016 "View ows2016's Profile") Topic Author - [ Offline](/forum/user/43901-ows2016) Less More - Posts: 25 - Thank you received: 0 - - 9 years 4 months ago [\#271817](#271817) by [ows2016](/forum/user/43901-ows2016 "View ows2016's Profile") Replied by *[ows2016](/forum/user/43901-ows2016 "View ows2016's Profile")* on topic *[Import category and subcategory](/forum/37-import-export-csv-xls/890673-import-category-and-subcategory#271817 "-- HikaShop version -- : 3.1.1 -- Joomla version -- : 3.4.8 -- PHP version -- : 5.5.32 -- Browser(s) name and version -- : firefox Hi, i have a problem with the category and subcategory import, i have this scenario: main category -> subcategory-1 -> subcategory-2 -> product I don't understand how to place the categories in csv files, i tried in this way: product_name, product_code, parent_category, categories but it doesn't work. where i'm wrong? Can you help me please? thank you.")* excuse but it's not clear for me i have 3 category level: main-category -> subcategory-1 -> subcategory-2 where i have to place the subcategory-1 and subcategory-2? [ ![header.jpg](/forum/attachment/38644) ](/forum/attachment/38644 "header.jpg") - [ ![header.jpg](/forum/attachment/38644) ](/forum/attachment/38644 "header.jpg") [ ](/forum/attachment/38644?download=1 "header.jpg") Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM3LWltcG9ydC1leHBvcnQtY3N2LXhscy84OTA2NzMtaW1wb3J0LWNhdGVnb3J5LWFuZC1zdWJjYXRlZ29yeT90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[ows2016](/forum/user/43901-ows2016 "View ows2016's Profile")** - [![ows2016's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/43901-ows2016 "View ows2016's Profile") Topic Author - [ Offline](/forum/user/43901-ows2016) Less More - Posts: 25 - Thank you received: 0 - - 9 years 4 months ago [\#271879](#271879) by [ows2016](/forum/user/43901-ows2016 "View ows2016's Profile") Replied by *[ows2016](/forum/user/43901-ows2016 "View ows2016's Profile")* on topic *[Import category and subcategory](/forum/37-import-export-csv-xls/890673-import-category-and-subcategory#271879 "-- HikaShop version -- : 3.1.1 -- Joomla version -- : 3.4.8 -- PHP version -- : 5.5.32 -- Browser(s) name and version -- : firefox Hi, i have a problem with the category and subcategory import, i have this scenario: main category -> subcategory-1 -> subcategory-2 -> product I don't understand how to place the categories in csv files, i tried in this way: product_name, product_code, parent_category, categories but it doesn't work. where i'm wrong? Can you help me please? thank you.")* ok, i understand that is possible but i have to make two different import. The first is a category tree import on two levels: parent_category; categories main-category, subcategory-1 then i made a 2nd import to set the sub-subcategory-1 under the subcategory-1 product_name; product_code; parent_category; categories myproductname, myproductcode, **subcategory-1**, sub-subcategory-1 In this way it works. I didn't find a way to made it in a single import. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM3LWltcG9ydC1leHBvcnQtY3N2LXhscy84OTA2NzMtaW1wb3J0LWNhdGVnb3J5LWFuZC1zdWJjYXRlZ29yeT90bXBsPW1hcmtkb3du) 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)](/forum/user/63-nicolas "View nicolas's Profile") - [ Offline](/forum/user/63-nicolas) Less More - Posts: 86289 - Thank you received: 14265 - - 9 years 4 months ago [\#271848](#271848) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Import category and subcategory](/forum/37-import-export-csv-xls/890673-import-category-and-subcategory#271848 "-- HikaShop version -- : 3.1.1 -- Joomla version -- : 3.4.8 -- PHP version -- : 5.5.32 -- Browser(s) name and version -- : firefox Hi, i have a problem with the category and subcategory import, i have this scenario: main category -> subcategory-1 -> subcategory-2 -> product I don't understand how to place the categories in csv files, i tried in this way: product_name, product_code, parent_category, categories but it doesn't work. where i'm wrong? Can you help me please? thank you.")* Hi, Copy/paste what I gave you in a text file and open it as a CSV in Excel and you'll see how that looks: [ monosnap.com/file/Wqq231XVhKOoHQM8fZS6X2VxHb9TaJ](https://monosnap.com/file/Wqq231XVhKOoHQM8fZS6X2VxHb9TaJ) In short, you need to have empty lines with just the categories to import the category tree, and then lines for the products which can reference these categories. If you click on the "export" button of the products listing in your backend (or in the backend of our demo website) you can see a more concrete example Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM3LWltcG9ydC1leHBvcnQtY3N2LXhscy84OTA2NzMtaW1wb3J0LWNhdGVnb3J5LWFuZC1zdWJjYXRlZ29yeT90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[ows2016](/forum/user/43901-ows2016 "View ows2016's Profile")** - [![ows2016's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/43901-ows2016 "View ows2016's Profile") Topic Author - [ Offline](/forum/user/43901-ows2016) Less More - Posts: 25 - Thank you received: 0 - - 9 years 4 months ago [\#271957](#271957) by [ows2016](/forum/user/43901-ows2016 "View ows2016's Profile") Replied by *[ows2016](/forum/user/43901-ows2016 "View ows2016's Profile")* on topic *[Import category and subcategory](/forum/37-import-export-csv-xls/890673-import-category-and-subcategory#271957 "-- HikaShop version -- : 3.1.1 -- Joomla version -- : 3.4.8 -- PHP version -- : 5.5.32 -- Browser(s) name and version -- : firefox Hi, i have a problem with the category and subcategory import, i have this scenario: main category -> subcategory-1 -> subcategory-2 -> product I don't understand how to place the categories in csv files, i tried in this way: product_name, product_code, parent_category, categories but it doesn't work. where i'm wrong? Can you help me please? thank you.")* ok, I will try in this way, now in excel format is clear, there is an empty cell. thank you. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM3LWltcG9ydC1leHBvcnQtY3N2LXhscy84OTA2NzMtaW1wb3J0LWNhdGVnb3J5LWFuZC1zdWJjYXRlZ29yeT90bXBsPW1hcmtkb3du) 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.250 seconds [Powered by](/forum/credits) [Kunena Forum](https://www.kunena.org) [](#top)