[Skip to main content](#vessel-content)

#   Import products

##

- **[lensky84](/forum/user/3974-lensky84 "View lensky84's Profile")**
- [![lensky84's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar3974.jpg)](/forum/user/3974-lensky84 "View lensky84's Profile") Topic Author
- [ Offline](/forum/user/3974-lensky84)

Less More

- Posts: 4
- Thank you received: 0
-
-
- [](http://www.beeldstudio.be)
-

15 years 1 week ago [\#28089](#28089) by [lensky84](/forum/user/3974-lensky84 "View lensky84's Profile")  *[Import products](/forum/4-how-to/28089-import-products#28089 "Hello! We have big tree of categories like this: Category 1 - Sub category 1 - - Sub category 2 Category 2 - Sub category 1 - - Sub category 2 Sub categories have same names for each top level of categories.  Need add products in &quot;sub category 2&quot; How we can paste this path of categories in CSV file?  Something like &quot;Category 1 - Sub category 1 - Sub category 2&quot;  Best regards, Alex, Beeldstudio")* was created by *[lensky84](/forum/user/3974-lensky84 "View lensky84's Profile")*

Hello!
We have big tree of categories like this:
Category 1
- Sub category 1
- - Sub category 2
Category 2
- Sub category 1
- - Sub category 2
Sub categories have same names for each top level of categories.

Need add products in "**sub category 2**"
How we can paste this path of categories in CSV file?

Something like "*Category 1 - Sub category 1 - Sub category 2*"

Best regards,
Alex, Beeldstudio

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQtaG93LXRvLzI4MDg5LWltcG9ydC1wcm9kdWN0cz90bXBsPW1hcmtkb3du) or [Create an account](/register) 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: 86323
- Thank you received: 14283
-
-

15 years 1 week ago [\#28106](#28106) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile")  Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Re: Import products](/forum/4-how-to/28089-import-products#28106 "Hello! We have big tree of categories like this: Category 1 - Sub category 1 - - Sub category 2 Category 2 - Sub category 1 - - Sub category 2 Sub categories have same names for each top level of categories.  Need add products in &quot;sub category 2&quot; How we can paste this path of categories in CSV file?  Something like &quot;Category 1 - Sub category 1 - Sub category 2&quot;  Best regards, Alex, Beeldstudio")*

Hi,

Usually, you can do like that:
product_code,categories
my_prod1,"category1;category2"

So you don't specify the parent categories as the system gets them automatically.
However, if several categories have the same name, you will have to use either the category id or the category namekey in your CSV. These are always unique so that way the system will be able to set them apart.

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQtaG93LXRvLzI4MDg5LWltcG9ydC1wcm9kdWN0cz90bXBsPW1hcmtkb3du) or [Create an account](/register) to join the conversation.

- **[lensky84](/forum/user/3974-lensky84 "View lensky84's Profile")**
- [![lensky84's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar3974.jpg)](/forum/user/3974-lensky84 "View lensky84's Profile") Topic Author
- [ Offline](/forum/user/3974-lensky84)

Less More

- Posts: 4
- Thank you received: 0
-
-
- [](http://www.beeldstudio.be)
-

15 years 1 week ago [\#28107](#28107) by [lensky84](/forum/user/3974-lensky84 "View lensky84's Profile")  Replied by *[lensky84](/forum/user/3974-lensky84 "View lensky84's Profile")* on topic *[Re: Import products](/forum/4-how-to/28089-import-products#28107 "Hello! We have big tree of categories like this: Category 1 - Sub category 1 - - Sub category 2 Category 2 - Sub category 1 - - Sub category 2 Sub categories have same names for each top level of categories.  Need add products in &quot;sub category 2&quot; How we can paste this path of categories in CSV file?  Something like &quot;Category 1 - Sub category 1 - Sub category 2&quot;  Best regards, Alex, Beeldstudio")*

Hello!
Thanks for your answer!

But maybe you have some another solution? Because we have more then 800 products and VERY big tree of categories.. and we don't want add all IDs of categories manualy in CSV.

Best regards,
Alex, Beeldstudio

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQtaG93LXRvLzI4MDg5LWltcG9ydC1wcm9kdWN0cz90bXBsPW1hcmtkb3du) or [Create an account](/register) 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: 86323
- Thank you received: 14283
-
-

15 years 1 week ago [\#28109](#28109) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile")  Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Re: Import products](/forum/4-how-to/28089-import-products#28109 "Hello! We have big tree of categories like this: Category 1 - Sub category 1 - - Sub category 2 Category 2 - Sub category 1 - - Sub category 2 Sub categories have same names for each top level of categories.  Need add products in &quot;sub category 2&quot; How we can paste this path of categories in CSV file?  Something like &quot;Category 1 - Sub category 1 - Sub category 2&quot;  Best regards, Alex, Beeldstudio")*

You can use the namekeys of the categories then.

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQtaG93LXRvLzI4MDg5LWltcG9ydC1wcm9kdWN0cz90bXBsPW1hcmtkb3du) or [Create an account](/register) to join the conversation.

- **[lensky84](/forum/user/3974-lensky84 "View lensky84's Profile")**
- [![lensky84's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar3974.jpg)](/forum/user/3974-lensky84 "View lensky84's Profile") Topic Author
- [ Offline](/forum/user/3974-lensky84)

Less More

- Posts: 4
- Thank you received: 0
-
-
- [](http://www.beeldstudio.be)
-

15 years 1 week ago [\#28111](#28111) by [lensky84](/forum/user/3974-lensky84 "View lensky84's Profile")  Replied by *[lensky84](/forum/user/3974-lensky84 "View lensky84's Profile")* on topic *[Re: Import products](/forum/4-how-to/28089-import-products#28111 "Hello! We have big tree of categories like this: Category 1 - Sub category 1 - - Sub category 2 Category 2 - Sub category 1 - - Sub category 2 Sub categories have same names for each top level of categories.  Need add products in &quot;sub category 2&quot; How we can paste this path of categories in CSV file?  Something like &quot;Category 1 - Sub category 1 - Sub category 2&quot;  Best regards, Alex, Beeldstudio")*

Thank you again!
But this is not a solution too ![:(](/media/kunena/emoticons/22.png ":(") Name key and ids need add in CSV by hand.. and we have more then 800 products

Best regards,
Alex, Beeldstudio

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQtaG93LXRvLzI4MDg5LWltcG9ydC1wcm9kdWN0cz90bXBsPW1hcmtkb3du) or [Create an account](/register) 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: 86323
- Thank you received: 14283
-
-

15 years 1 week ago [\#28113](#28113) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile")  Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Re: Import products](/forum/4-how-to/28089-import-products#28113 "Hello! We have big tree of categories like this: Category 1 - Sub category 1 - - Sub category 2 Category 2 - Sub category 1 - - Sub category 2 Sub categories have same names for each top level of categories.  Need add products in &quot;sub category 2&quot; How we can paste this path of categories in CSV file?  Something like &quot;Category 1 - Sub category 1 - Sub category 2&quot;  Best regards, Alex, Beeldstudio")*

Unfortunately, I don't have a magic solution here ![:/](/irritated.gif ":/")

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQtaG93LXRvLzI4MDg5LWltcG9ydC1wcm9kdWN0cz90bXBsPW1hcmtkb3du) or [Create an account](/register) to join the conversation.

Board Categories HikaShop Install &amp; Update Product &amp; Category Display Content Creation Sales and Orders Orders management Reports &amp; Statistics Customers Checkout Payment Methods Shipping Methods Import &amp; Export (CSV, XLS…) Specific Features Affilation Taxes Wishlist Vote Carousel &amp; Slider Mass Actions Filters &amp; Search Discount &amp; 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.109 seconds

[Powered by](/forum/credits) [Kunena Forum](https://www.kunena.org)
