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

#   Defining categories on product imports.

##

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

Less More

- Posts: 298
- Thank you received: 5
-
-
-
- [](https://brainforge.co.uk)
-

15 years 10 months ago [\#4320](#4320) by [brainforge](/forum/user/423-brainforge "View brainforge's Profile")  *[Defining categories on product imports.](/forum/4-how-to/4320-defining-categories-on-product-imports#4320 "I have a CSV file like this:  It puts the product into all 3 categories.  What I want is for the product to go into 'grandchild&#95;cat3', but for categories 'parent&#95;cat1', 'child&#95;cat2' to be automatically created if they do not alreday exist.  So after import I have this:")* was created by *[brainforge](/forum/user/423-brainforge "View brainforge's Profile")*

I have a CSV file like this:

> product\_code,categories
> TEST123,"parent\_cat1,child\_cat2,grandchild\_cat3"

It puts the product into all 3 categories.

What I want is for the product to go into 'grandchild_cat3', but for categories 'parent_cat1', 'child_cat2' to be automatically created if they do not alreday exist.

So after import I have this:

> parent\_cat1
> &amp;nbsp;&amp;nbsp;child\_cat2
> &amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;grandchild\_cat3
> &amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;the product

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQtaG93LXRvLzQzMjAtZGVmaW5pbmctY2F0ZWdvcmllcy1vbi1wcm9kdWN0LWltcG9ydHM/dG1wbD1tYXJrZG93bg==) 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")
- [ Away](/forum/user/63-nicolas)

Less More

- Posts: 86561
- Thank you received: 14307
-
-

15 years 10 months ago [\#4328](#4328) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile")  Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Re: Defining categories on product imports.](/forum/4-how-to/4320-defining-categories-on-product-imports#4328 "I have a CSV file like this:  It puts the product into all 3 categories.  What I want is for the product to go into 'grandchild&#95;cat3', but for categories 'parent&#95;cat1', 'child&#95;cat2' to be automatically created if they do not alreday exist.  So after import I have this:")*

you should do like this:
product_code,parent_category,categories
,parent_cat1,child_cat2
TEST123,child_cat2,grandchild_cat3

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQtaG93LXRvLzQzMjAtZGVmaW5pbmctY2F0ZWdvcmllcy1vbi1wcm9kdWN0LWltcG9ydHM/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) 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.042 seconds

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