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

#   Import Categories Exel &gt; CSV(?) &gt; HikaShop

##

- **[Feauteau](/forum/user/24032-feauteau "View Feauteau's Profile")**
- [![Feauteau's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/24032-feauteau "View Feauteau's Profile") Topic Author
- [ Offline](/forum/user/24032-feauteau)

Less More

- Posts: 3
- Thank you received: 0
-
-

13 years 4 months ago [\#112606](#112606) by [Feauteau](/forum/user/24032-feauteau "View Feauteau's Profile")  *[Import Categories Exel &gt; CSV(?) &gt; HikaShop](/forum/4-how-to/84752-import-categories-exel-csv-hikashop#112606 "For a client I need to import an Exel file containing brands, models, and some more info into categories.  He wants a kind of a tree-structure. Brand &gt; Model &gt; Specific Model Info &gt; Year into categories. On the last one, the products ('articles') will be coupled.  The format of the exel is:  BRAND MODEL SPECIFICINFO YEAR SPECINFO1 SPECINFO2  Every thing is listed in a separate column. The last 2 things doesn't have to be imported.  How do I convert this to the correct CSV format (if even needed?) and import it?  This is what I've tried:  But that didn't work. I guess there will be a more optimal method than entering +/-5000 records manually?")* was created by *[Feauteau](/forum/user/24032-feauteau "View Feauteau's Profile")*

For a client I need to import an Exel file containing brands, models, and some more info into categories.

He wants a kind of a tree-structure. Brand &gt; Model &gt; Specific Model Info &gt; Year into categories. On the last one, the products ('articles') will be coupled.

The format of the exel is:

BRAND MODEL SPECIFICINFO YEAR SPECINFO1 SPECINFO2

Every thing is listed in a separate column. The last 2 things doesn't have to be imported.

How do I convert this to the correct CSV format (if even needed?) and import it?

This is what I've tried:
Code:

"parent_category","categories"; BRAND,MODEL,SPECINFO,09/94-01/97,SPECINFO1,SPECINFO,,

But that didn't work. I guess there will be a more optimal method than entering +/-5000 records manually?

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQtaG93LXRvLzg0NzUyLWltcG9ydC1jYXRlZ29yaWVzLWV4ZWwtY3N2LWhpa2FzaG9wP3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation.

- **[Mohamed Thelji](/forum/user/6861-mohamed-thelji "View Mohamed Thelji's Profile")**
- [![Mohamed Thelji's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar6861.png)](/forum/user/6861-mohamed-thelji "View Mohamed Thelji's Profile")
- [ Offline](/forum/user/6861-mohamed-thelji)

Less More

- Posts: 12953
- Thank you received: 1778
-
-
-

13 years 4 months ago [\#112609](#112609) by [Mohamed Thelji](/forum/user/6861-mohamed-thelji "View Mohamed Thelji's Profile")  Replied by *[Mohamed Thelji](/forum/user/6861-mohamed-thelji "View Mohamed Thelji's Profile")* on topic *[Import Categories Exel &gt; CSV(?) &gt; HikaShop](/forum/4-how-to/84752-import-categories-exel-csv-hikashop#112609 "For a client I need to import an Exel file containing brands, models, and some more info into categories.  He wants a kind of a tree-structure. Brand &gt; Model &gt; Specific Model Info &gt; Year into categories. On the last one, the products ('articles') will be coupled.  The format of the exel is:  BRAND MODEL SPECIFICINFO YEAR SPECINFO1 SPECINFO2  Every thing is listed in a separate column. The last 2 things doesn't have to be imported.  How do I convert this to the correct CSV format (if even needed?) and import it?  This is what I've tried:  But that didn't work. I guess there will be a more optimal method than entering +/-5000 records manually?")*

Hi,

I think that the best method will be to :
- do it manually just for 1 example
- then exporting it through a CSV file
- filling your CSV file with your other values
- and finally importing it.

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQtaG93LXRvLzg0NzUyLWltcG9ydC1jYXRlZ29yaWVzLWV4ZWwtY3N2LWhpa2FzaG9wP3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation.

- **[Feauteau](/forum/user/24032-feauteau "View Feauteau's Profile")**
- [![Feauteau's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/24032-feauteau "View Feauteau's Profile") Topic Author
- [ Offline](/forum/user/24032-feauteau)

Less More

- Posts: 3
- Thank you received: 0
-
-

13 years 4 months ago -  13 years 4 months ago [\#112615](#112615) by [Feauteau](/forum/user/24032-feauteau "View Feauteau's Profile")  Replied by *[Feauteau](/forum/user/24032-feauteau "View Feauteau's Profile")* on topic *[Import Categories Exel &gt; CSV(?) &gt; HikaShop](/forum/4-how-to/84752-import-categories-exel-csv-hikashop#112615 "For a client I need to import an Exel file containing brands, models, and some more info into categories.  He wants a kind of a tree-structure. Brand &gt; Model &gt; Specific Model Info &gt; Year into categories. On the last one, the products ('articles') will be coupled.  The format of the exel is:  BRAND MODEL SPECIFICINFO YEAR SPECINFO1 SPECINFO2  Every thing is listed in a separate column. The last 2 things doesn't have to be imported.  How do I convert this to the correct CSV format (if even needed?) and import it?  This is what I've tried:  But that didn't work. I guess there will be a more optimal method than entering +/-5000 records manually?")*

This:
Code:

categories Brand,Model,Info1,09/94-01/97,

Doesn't work to create categorie, subcat1, subcat2 respectively.

What am I doing wrong?

This:
Code:

categories,categories_image "Brand,Model,Info1,09/94-01/97",

Throws me: Invalid Products: 1.

Is there even a way to do a categorie only import?

Edit: Got it to import.

The current categorie tree-structure is:

On Use &gt; Type &gt; Brand &gt; Subcats I need to import
Code:

product_code,parent_category,categories ,"On use","Type,Brand,Model,Subcat2,Year",

However, this imports the categorie within On Use. So On Use contains Brand, Model, Subcat 2, and Year.

I need to import it like On Use &gt; Brand &gt; Model &gt; Subcat 2 &gt; Year, each within the previous categorie.

Any hints will be very welcome!

Last edit: 13 years 4 months ago by [Feauteau](/forum/user/24032-feauteau "View Feauteau's Profile").

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQtaG93LXRvLzg0NzUyLWltcG9ydC1jYXRlZ29yaWVzLWV4ZWwtY3N2LWhpa2FzaG9wP3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation.

- **[Eliot](/forum/user/1824-eliot "View Eliot's Profile")**
- [![Eliot's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar1824.png)](/forum/user/1824-eliot "View Eliot's Profile")
- [ Offline](/forum/user/1824-eliot)

Less More

- Posts: 2334
- Thank you received: 403
-
-

13 years 4 months ago [\#112624](#112624) by [Eliot](/forum/user/1824-eliot "View Eliot's Profile")  Replied by *[Eliot](/forum/user/1824-eliot "View Eliot's Profile")* on topic *[Import Categories Exel &gt; CSV(?) &gt; HikaShop](/forum/4-how-to/84752-import-categories-exel-csv-hikashop#112624 "For a client I need to import an Exel file containing brands, models, and some more info into categories.  He wants a kind of a tree-structure. Brand &gt; Model &gt; Specific Model Info &gt; Year into categories. On the last one, the products ('articles') will be coupled.  The format of the exel is:  BRAND MODEL SPECIFICINFO YEAR SPECINFO1 SPECINFO2  Every thing is listed in a separate column. The last 2 things doesn't have to be imported.  How do I convert this to the correct CSV format (if even needed?) and import it?  This is what I've tried:  But that didn't work. I guess there will be a more optimal method than entering +/-5000 records manually?")*

Hi there,

As Mohamed said, the best to do is to create few categories with one or two product and some categories then export it.
It will give you a great overview of how csv import is working.

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQtaG93LXRvLzg0NzUyLWltcG9ydC1jYXRlZ29yaWVzLWV4ZWwtY3N2LWhpa2FzaG9wP3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation.

- **[Feauteau](/forum/user/24032-feauteau "View Feauteau's Profile")**
- [![Feauteau's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/24032-feauteau "View Feauteau's Profile") Topic Author
- [ Offline](/forum/user/24032-feauteau)

Less More

- Posts: 3
- Thank you received: 0
-
-

13 years 4 months ago [\#112631](#112631) by [Feauteau](/forum/user/24032-feauteau "View Feauteau's Profile")  Replied by *[Feauteau](/forum/user/24032-feauteau "View Feauteau's Profile")* on topic *[Import Categories Exel &gt; CSV(?) &gt; HikaShop](/forum/4-how-to/84752-import-categories-exel-csv-hikashop#112631 "For a client I need to import an Exel file containing brands, models, and some more info into categories.  He wants a kind of a tree-structure. Brand &gt; Model &gt; Specific Model Info &gt; Year into categories. On the last one, the products ('articles') will be coupled.  The format of the exel is:  BRAND MODEL SPECIFICINFO YEAR SPECINFO1 SPECINFO2  Every thing is listed in a separate column. The last 2 things doesn't have to be imported.  How do I convert this to the correct CSV format (if even needed?) and import it?  This is what I've tried:  But that didn't work. I guess there will be a more optimal method than entering +/-5000 records manually?")*

Yes, I did so.
Code:

"product_id";"product_parent_id";"product_name";"product_description";"product_quantity";"product_code";"product_published";"product_hit";"product_created";"product_sale_start";"product_sale_end";"product_delay_id";"product_tax_id";"product_type";"product_vendor_id";"product_manufacturer_id";"product_url";"product_weight";"product_keywords";"product_weight_unit";"product_modified";"product_meta_description";"product_dimension_unit";"product_width";"product_length";"product_height";"product_max_per_order";"product_access";"product_group_after_purchase";"product_min_per_order";"product_contact";"product_last_seen_date";"product_sales";"product_waitlist";"product_layout";"product_average_score";"product_total_vote";"product_page_title";"product_alias";"product_price_percentage";"product_canonical";"product_msrp";"categories_ordering";"parent_category";"categories_image";"categories";"price_value";"price_currency_id";"price_min_quantity";"price_access";"files";"images";"related";"options"; 273;0;"Product";"";-1;"Product";1;0;1373272929;0;0;0;0;"main";0;0;"";0.000;"";"kg";1373272929;"";"m";0.000;0.000;0.000;0;"all";"";0;0;0;0;0;"";0;0;"";"";0.0000000;"";0.0000000;0;"";"";"Brand";"";"";"";"";"";"";"";"";

It throws this out. As you might see, it doesn't help me how the categories are created by CSV.

Like posted before, the current categorie tree-structure is in this way:

On Use &gt; Type &gt; Brand &gt; Subcats I need to import
Code:

product_code,parent_category,categories ,"On use","Type,Brand,Model,Subcat2,Year",

However, this imports the categorie within On Use. So On Use contains Brand, Model, Subcat 2, and Year.

I need to import it like On Use &gt; Brand &gt; Model &gt; Subcat 2 &gt; Year, each within the previous categorie.

Any hints will be very welcome!

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQtaG93LXRvLzg0NzUyLWltcG9ydC1jYXRlZ29yaWVzLWV4ZWwtY3N2LWhpa2FzaG9wP3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation.

- **[Eliot](/forum/user/1824-eliot "View Eliot's Profile")**
- [![Eliot's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar1824.png)](/forum/user/1824-eliot "View Eliot's Profile")
- [ Offline](/forum/user/1824-eliot)

Less More

- Posts: 2334
- Thank you received: 403
-
-

13 years 4 months ago [\#112690](#112690) by [Eliot](/forum/user/1824-eliot "View Eliot's Profile")  Replied by *[Eliot](/forum/user/1824-eliot "View Eliot's Profile")* on topic *[Import Categories Exel &gt; CSV(?) &gt; HikaShop](/forum/4-how-to/84752-import-categories-exel-csv-hikashop#112690 "For a client I need to import an Exel file containing brands, models, and some more info into categories.  He wants a kind of a tree-structure. Brand &gt; Model &gt; Specific Model Info &gt; Year into categories. On the last one, the products ('articles') will be coupled.  The format of the exel is:  BRAND MODEL SPECIFICINFO YEAR SPECINFO1 SPECINFO2  Every thing is listed in a separate column. The last 2 things doesn't have to be imported.  How do I convert this to the correct CSV format (if even needed?) and import it?  This is what I've tried:  But that didn't work. I guess there will be a more optimal method than entering +/-5000 records manually?")*

You just have to use the "parent_category" column for your subcategories, it will place the category inside the parent one ![:)](/media/kunena/emoticons/3.png ":)")

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQtaG93LXRvLzg0NzUyLWltcG9ydC1jYXRlZ29yaWVzLWV4ZWwtY3N2LWhpa2FzaG9wP3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation.

- **[silaroo](/forum/user/27925-silaroo "View silaroo's Profile")**
- [![silaroo's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/27925-silaroo "View silaroo's Profile")
- [ Offline](/forum/user/27925-silaroo)

Less More

- Posts: 8
- Thank you received: 0
-
-

13 years 2 weeks ago [\#130021](#130021) by [silaroo](/forum/user/27925-silaroo "View silaroo's Profile")  Replied by *[silaroo](/forum/user/27925-silaroo "View silaroo's Profile")* on topic *[Import Categories Exel &gt; CSV(?) &gt; HikaShop](/forum/4-how-to/84752-import-categories-exel-csv-hikashop#130021 "For a client I need to import an Exel file containing brands, models, and some more info into categories.  He wants a kind of a tree-structure. Brand &gt; Model &gt; Specific Model Info &gt; Year into categories. On the last one, the products ('articles') will be coupled.  The format of the exel is:  BRAND MODEL SPECIFICINFO YEAR SPECINFO1 SPECINFO2  Every thing is listed in a separate column. The last 2 things doesn't have to be imported.  How do I convert this to the correct CSV format (if even needed?) and import it?  This is what I've tried:  But that didn't work. I guess there will be a more optimal method than entering +/-5000 records manually?")*

hi, i do have the same question, how can i import more than one subcategory?

ERA ist tha parentcategory, CARBON the next level and inside of Carbon there ist ANATAL contained.

how must the csv look like?

There is only parent_category categories to use. i do not need many categories on the same level. but more subcategories.

thank you!
sila

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQtaG93LXRvLzg0NzUyLWltcG9ydC1jYXRlZ29yaWVzLWV4ZWwtY3N2LWhpa2FzaG9wP3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation.

- **[Xavier](/forum/user/4105-xavier "View Xavier's Profile")**
- [![Xavier's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar4105.png)](/forum/user/4105-xavier "View Xavier's Profile")
- [ Offline](/forum/user/4105-xavier)

Less More

- Posts: 13201
- Thank you received: 2322
-
-
-
- [](http://www.kidiweb.fr)
-

13 years 2 weeks ago -  13 years 2 weeks ago [\#130069](#130069) by [Xavier](/forum/user/4105-xavier "View Xavier's Profile")  Replied by *[Xavier](/forum/user/4105-xavier "View Xavier's Profile")* on topic *[Import Categories Exel &gt; CSV(?) &gt; HikaShop](/forum/4-how-to/84752-import-categories-exel-csv-hikashop#130069 "For a client I need to import an Exel file containing brands, models, and some more info into categories.  He wants a kind of a tree-structure. Brand &gt; Model &gt; Specific Model Info &gt; Year into categories. On the last one, the products ('articles') will be coupled.  The format of the exel is:  BRAND MODEL SPECIFICINFO YEAR SPECINFO1 SPECINFO2  Every thing is listed in a separate column. The last 2 things doesn't have to be imported.  How do I convert this to the correct CSV format (if even needed?) and import it?  This is what I've tried:  But that didn't work. I guess there will be a more optimal method than entering +/-5000 records manually?")*

Hi,

This is explained in our Documentation:
[ www.hikashop.com/support/2013-08-08-00-1...shop-import.html#csv](http://www.hikashop.com/support/2013-08-08-00-18-51/integrated-documentation/20-hikashop/tutorials/73-hikashop-import.html#csv)

> This will add one product with 2 categories attached: the category with the id 2 and the one with the id 13. You can find ids of categories on the category listing in the column called ID on the right of the listing.
>
> Since version 1.4.1, you can import a tree of categories which will be created if they don't exist already in HikaShop with the option "Create automatically missing categories" set to "yes". For example, you could have something like:
>
> parent\_category,categories
>
> product category,main category 1;main category 2;main category 3
>
> main category 1,sub category 1;sub category 2

In you case, you need:

> parent\_category,categories
> ,ERA
> ERA,CARBON
> CARBON,ANATAL

Last edit: 13 years 2 weeks ago by [Xavier](/forum/user/4105-xavier "View Xavier's Profile").

The following user(s) said Thank You: [silaroo](/forum/user/27925-silaroo "View silaroo's Profile")

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQtaG93LXRvLzg0NzUyLWltcG9ydC1jYXRlZ29yaWVzLWV4ZWwtY3N2LWhpa2FzaG9wP3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation.

- **[silaroo](/forum/user/27925-silaroo "View silaroo's Profile")**
- [![silaroo's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/27925-silaroo "View silaroo's Profile")
- [ Offline](/forum/user/27925-silaroo)

Less More

- Posts: 8
- Thank you received: 0
-
-

13 years 2 weeks ago -  13 years 2 weeks ago [\#130070](#130070) by [silaroo](/forum/user/27925-silaroo "View silaroo's Profile")  Replied by *[silaroo](/forum/user/27925-silaroo "View silaroo's Profile")* on topic *[Import Categories Exel &gt; CSV(?) &gt; HikaShop](/forum/4-how-to/84752-import-categories-exel-csv-hikashop#130070 "For a client I need to import an Exel file containing brands, models, and some more info into categories.  He wants a kind of a tree-structure. Brand &gt; Model &gt; Specific Model Info &gt; Year into categories. On the last one, the products ('articles') will be coupled.  The format of the exel is:  BRAND MODEL SPECIFICINFO YEAR SPECINFO1 SPECINFO2  Every thing is listed in a separate column. The last 2 things doesn't have to be imported.  How do I convert this to the correct CSV format (if even needed?) and import it?  This is what I've tried:  But that didn't work. I guess there will be a more optimal method than entering +/-5000 records manually?")*

you worte exact in this moment. thank you

Last edit: 13 years 2 weeks ago by [silaroo](/forum/user/27925-silaroo "View silaroo's Profile").

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQtaG93LXRvLzg0NzUyLWltcG9ydC1jYXRlZ29yaWVzLWV4ZWwtY3N2LWhpa2FzaG9wP3RtcGw9bWFya2Rvd24=) 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.079 seconds

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