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

#   Importing categories

##

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

Less More

- Posts: 299
- Thank you received: 2
-
-

11 years 9 months ago -  11 years 9 months ago [\#190632](#190632) by [LAMF](/forum/user/8669-lamf "View LAMF's Profile")  *[Importing categories](/forum/37-import-export-csv-xls/874965-importing-categories#190632 "-- url of the page with the problem -- :   www.bil-filtertjanst.se  -- HikaShop version -- : 2.3.5 -- Joomla version -- : 3.3.6 -- PHP version -- : 5.3.29 -- Browser(s) name and version -- : Chrome v 40.0.2214.93 m (64-bit) -- Error-message(debug-mod must be tuned on) -- : no error message just blank page  HI, I am about to start a webshop selling filters for cars and other trucks and machines. THere are a lot of different products as their catalog are around 800 pages of products. All to be in HikaShop webshop. Only the categories has to be hundreds... Now I want to import all categories from an excel file that is saved as a semi colon separated csv file UTF-8. There are one main category Volvo BM and then the rest is sub categories on the second level. Just wanted to try two levels first. The end will be like thre levels of categories and then products in the third category level. Like this: Machine / Machine model / Motor type The files looks like this:  etc etc.  But I can't get it working... Is the file set up the wrong way or what can be wrong? I have tried both with loading the csv file and to copy all in the txt file and pasting it into the text import field... Still no go... Any help is appreciated.  Thanks Micke")* was created by *[LAMF](/forum/user/8669-lamf "View LAMF's Profile")*

-- url of the page with the problem -- : [ www.bil-filtertjanst.se](http://www.bil-filtertjanst.se)
-- HikaShop version -- : 2.3.5
-- Joomla version -- : 3.3.6
-- PHP version -- : 5.3.29
-- Browser(s) name and version -- : Chrome v 40.0.2214.93 m (64-bit)
-- Error-message(debug-mod must be tuned on) -- : no error message just blank page

HI,
I am about to start a webshop selling filters for cars and other trucks and machines.
THere are a lot of different products as their catalog are around 800 pages of products.
All to be in HikaShop webshop.
Only the categories has to be hundreds...
Now I want to import all categories from an excel file that is saved as a semi colon separated csv file UTF-8.
There are one main category Volvo BM and then the rest is sub categories on the second level.
Just wanted to try two levels first. The end will be like thre levels of categories and then products in the third category level.
Like this:
Machine / Machine model / Motor type
The files looks like this: Code:

categories Volvo BM;24 Volvo BM;25 Volvo BM;35 Volvo BM;36 Volvo BM;55 Volvo BM;320 Volvo BM;400 Volvo BM;430

etc etc.

But I can't get it working...
Is the file set up the wrong way or what can be wrong?
I have tried both with loading the csv file and to copy all in the txt file and pasting it into the text import field...
Still no go...
Any help is appreciated.

Thanks
Micke

Last edit: 11 years 9 months ago by [LAMF](/forum/user/8669-lamf "View LAMF's Profile").

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

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

Less More

- Posts: 193
- Thank you received: 76
-
-

11 years 9 months ago -  11 years 9 months ago [\#190675](#190675) by [korzo](/forum/user/34428-korzo "View korzo's Profile")  Replied by *[korzo](/forum/user/34428-korzo "View korzo's Profile")* on topic *[Importing categories](/forum/37-import-export-csv-xls/874965-importing-categories#190675 "-- url of the page with the problem -- :   www.bil-filtertjanst.se  -- HikaShop version -- : 2.3.5 -- Joomla version -- : 3.3.6 -- PHP version -- : 5.3.29 -- Browser(s) name and version -- : Chrome v 40.0.2214.93 m (64-bit) -- Error-message(debug-mod must be tuned on) -- : no error message just blank page  HI, I am about to start a webshop selling filters for cars and other trucks and machines. THere are a lot of different products as their catalog are around 800 pages of products. All to be in HikaShop webshop. Only the categories has to be hundreds... Now I want to import all categories from an excel file that is saved as a semi colon separated csv file UTF-8. There are one main category Volvo BM and then the rest is sub categories on the second level. Just wanted to try two levels first. The end will be like thre levels of categories and then products in the third category level. Like this: Machine / Machine model / Motor type The files looks like this:  etc etc.  But I can't get it working... Is the file set up the wrong way or what can be wrong? I have tried both with loading the csv file and to copy all in the txt file and pasting it into the text import field... Still no go... Any help is appreciated.  Thanks Micke")*

Create csv file with 2 columns:
parent_category and categories

For example if your categories looks like
Volvo BM &gt; 430 &gt; Diesel,
your csv file will looks like:
Code:

"parent_category";"categories" "product_category";"Volvo BM" "Volvo BM";"430" "430";"Diesel"

Last edit: 11 years 9 months ago by [korzo](/forum/user/34428-korzo "View korzo's Profile").

The following user(s) said Thank You: [LAMF](/forum/user/8669-lamf "View LAMF's Profile")

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

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

Less More

- Posts: 299
- Thank you received: 2
-
-

11 years 9 months ago [\#190740](#190740) by [LAMF](/forum/user/8669-lamf "View LAMF's Profile")  Replied by *[LAMF](/forum/user/8669-lamf "View LAMF's Profile")* on topic *[Importing categories](/forum/37-import-export-csv-xls/874965-importing-categories#190740 "-- url of the page with the problem -- :   www.bil-filtertjanst.se  -- HikaShop version -- : 2.3.5 -- Joomla version -- : 3.3.6 -- PHP version -- : 5.3.29 -- Browser(s) name and version -- : Chrome v 40.0.2214.93 m (64-bit) -- Error-message(debug-mod must be tuned on) -- : no error message just blank page  HI, I am about to start a webshop selling filters for cars and other trucks and machines. THere are a lot of different products as their catalog are around 800 pages of products. All to be in HikaShop webshop. Only the categories has to be hundreds... Now I want to import all categories from an excel file that is saved as a semi colon separated csv file UTF-8. There are one main category Volvo BM and then the rest is sub categories on the second level. Just wanted to try two levels first. The end will be like thre levels of categories and then products in the third category level. Like this: Machine / Machine model / Motor type The files looks like this:  etc etc.  But I can't get it working... Is the file set up the wrong way or what can be wrong? I have tried both with loading the csv file and to copy all in the txt file and pasting it into the text import field... Still no go... Any help is appreciated.  Thanks Micke")*

Ok, thanks!

I think I get it.I have set it up like this: Code:

parent_category;categories product_category;Volvo BM Volvo BM;24 Volvo BM;25 Volvo BM;35

This would give me categories like:
Volvo BM &gt; 24
&gt; 25
&gt; 35
Or am I wrong?
I have like at least 100 categories under Volvo BM (models of Volvo BM) then I will start adding different filters and oils under each model.
So primary I will just need Volvo BM &gt; 24, Volvo BM 25 etc...
So if I want to add a new Machine category after Volvo BM I just set the csv file up like: Code:

parent_category;categories product_category;Valmet Valtra Valmet Valtra;20 Valmet Valtra;35 Valmet Valtra;359 ....

and so on....?

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

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

Less More

- Posts: 299
- Thank you received: 2
-
-

11 years 9 months ago [\#190742](#190742) by [LAMF](/forum/user/8669-lamf "View LAMF's Profile")  Replied by *[LAMF](/forum/user/8669-lamf "View LAMF's Profile")* on topic *[Importing categories](/forum/37-import-export-csv-xls/874965-importing-categories#190742 "-- url of the page with the problem -- :   www.bil-filtertjanst.se  -- HikaShop version -- : 2.3.5 -- Joomla version -- : 3.3.6 -- PHP version -- : 5.3.29 -- Browser(s) name and version -- : Chrome v 40.0.2214.93 m (64-bit) -- Error-message(debug-mod must be tuned on) -- : no error message just blank page  HI, I am about to start a webshop selling filters for cars and other trucks and machines. THere are a lot of different products as their catalog are around 800 pages of products. All to be in HikaShop webshop. Only the categories has to be hundreds... Now I want to import all categories from an excel file that is saved as a semi colon separated csv file UTF-8. There are one main category Volvo BM and then the rest is sub categories on the second level. Just wanted to try two levels first. The end will be like thre levels of categories and then products in the third category level. Like this: Machine / Machine model / Motor type The files looks like this:  etc etc.  But I can't get it working... Is the file set up the wrong way or what can be wrong? I have tried both with loading the csv file and to copy all in the txt file and pasting it into the text import field... Still no go... Any help is appreciated.  Thanks Micke")*

Hi again,
I tried to set it up like this: Code:

parent_category;categories product_category;Volvo BM Volvo BM;24 Volvo BM;25 Volvo BM;35 Volvo BM;36 Volvo BM;55 Volvo BM;320 Volvo BM;400 Volvo BM;430 Volvo BM;350 Boxer Volvo BM;470 Bison

MAde th file in notepad and saved as UTF-8 and csv.
IMported it n HikaShop and the categories was indeed created but only Volvo BM &gt; 350 Boxer and Volvo BM &gt; 470 BisonWhy wasn't the subcategories 24,25,35 etc created?

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

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

Less More

- Posts: 193
- Thank you received: 76
-
-

11 years 9 months ago [\#190744](#190744) by [korzo](/forum/user/34428-korzo "View korzo's Profile")  Replied by *[korzo](/forum/user/34428-korzo "View korzo's Profile")* on topic *[Importing categories](/forum/37-import-export-csv-xls/874965-importing-categories#190744 "-- url of the page with the problem -- :   www.bil-filtertjanst.se  -- HikaShop version -- : 2.3.5 -- Joomla version -- : 3.3.6 -- PHP version -- : 5.3.29 -- Browser(s) name and version -- : Chrome v 40.0.2214.93 m (64-bit) -- Error-message(debug-mod must be tuned on) -- : no error message just blank page  HI, I am about to start a webshop selling filters for cars and other trucks and machines. THere are a lot of different products as their catalog are around 800 pages of products. All to be in HikaShop webshop. Only the categories has to be hundreds... Now I want to import all categories from an excel file that is saved as a semi colon separated csv file UTF-8. There are one main category Volvo BM and then the rest is sub categories on the second level. Just wanted to try two levels first. The end will be like thre levels of categories and then products in the third category level. Like this: Machine / Machine model / Motor type The files looks like this:  etc etc.  But I can't get it working... Is the file set up the wrong way or what can be wrong? I have tried both with loading the csv file and to copy all in the txt file and pasting it into the text import field... Still no go... Any help is appreciated.  Thanks Micke")*

You are right.
Categories with only numbers in name are ignored.
Looks like a bug. I will take a look and let you know.

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

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

Less More

- Posts: 299
- Thank you received: 2
-
-

11 years 9 months ago [\#190748](#190748) by [LAMF](/forum/user/8669-lamf "View LAMF's Profile")  Replied by *[LAMF](/forum/user/8669-lamf "View LAMF's Profile")* on topic *[Importing categories](/forum/37-import-export-csv-xls/874965-importing-categories#190748 "-- url of the page with the problem -- :   www.bil-filtertjanst.se  -- HikaShop version -- : 2.3.5 -- Joomla version -- : 3.3.6 -- PHP version -- : 5.3.29 -- Browser(s) name and version -- : Chrome v 40.0.2214.93 m (64-bit) -- Error-message(debug-mod must be tuned on) -- : no error message just blank page  HI, I am about to start a webshop selling filters for cars and other trucks and machines. THere are a lot of different products as their catalog are around 800 pages of products. All to be in HikaShop webshop. Only the categories has to be hundreds... Now I want to import all categories from an excel file that is saved as a semi colon separated csv file UTF-8. There are one main category Volvo BM and then the rest is sub categories on the second level. Just wanted to try two levels first. The end will be like thre levels of categories and then products in the third category level. Like this: Machine / Machine model / Motor type The files looks like this:  etc etc.  But I can't get it working... Is the file set up the wrong way or what can be wrong? I have tried both with loading the csv file and to copy all in the txt file and pasting it into the text import field... Still no go... Any help is appreciated.  Thanks Micke")*

I added a space after the ones with only numbers and now they weren't ignored but when I did my first attempt like this: Code:

parent_category;categories product_category;Volvo BM Volvo BM;24 Volvo BM;25 Volvo BM;35 Volvo BM;36 Volvo BM;55 Volvo BM;320 Volvo BM;400 Volvo BM;430 Volvo BM;350 Boxer Volvo BM;470 Bison

it turned out like this in the categories listing with double Volvo BM categories, see image:
[ ![450](http://duosmart.se/categories.png) ](http://duosmart.se/categories.png "450")

So maybe I should not add the product_category;Volvo BM line....

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

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

Less More

- Posts: 193
- Thank you received: 76
-
-

11 years 9 months ago [\#190749](#190749) by [korzo](/forum/user/34428-korzo "View korzo's Profile")  Replied by *[korzo](/forum/user/34428-korzo "View korzo's Profile")* on topic *[Importing categories](/forum/37-import-export-csv-xls/874965-importing-categories#190749 "-- url of the page with the problem -- :   www.bil-filtertjanst.se  -- HikaShop version -- : 2.3.5 -- Joomla version -- : 3.3.6 -- PHP version -- : 5.3.29 -- Browser(s) name and version -- : Chrome v 40.0.2214.93 m (64-bit) -- Error-message(debug-mod must be tuned on) -- : no error message just blank page  HI, I am about to start a webshop selling filters for cars and other trucks and machines. THere are a lot of different products as their catalog are around 800 pages of products. All to be in HikaShop webshop. Only the categories has to be hundreds... Now I want to import all categories from an excel file that is saved as a semi colon separated csv file UTF-8. There are one main category Volvo BM and then the rest is sub categories on the second level. Just wanted to try two levels first. The end will be like thre levels of categories and then products in the third category level. Like this: Machine / Machine model / Motor type The files looks like this:  etc etc.  But I can't get it working... Is the file set up the wrong way or what can be wrong? I have tried both with loading the csv file and to copy all in the txt file and pasting it into the text import field... Still no go... Any help is appreciated.  Thanks Micke")*

It turns out you can't import categories with numeric names.

In administrator\components\com_hikashop\helpers\import.php on line 831
Code:

if(!is_numeric($v) &#124;&#124; !empty($product-&gt;categories_namekey)){

where $v is category name.

Change line 831 to Code:

if(!empty($v) &#124;&#124; !empty($product-&gt;categories_namekey)){

for categories import, than change it back.
I'm not sure about implications of this change for products import.

The following user(s) said Thank You: [LAMF](/forum/user/8669-lamf "View LAMF's Profile")

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

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

Less More

- Posts: 299
- Thank you received: 2
-
-

11 years 9 months ago -  11 years 9 months ago [\#190750](#190750) by [LAMF](/forum/user/8669-lamf "View LAMF's Profile")  Replied by *[LAMF](/forum/user/8669-lamf "View LAMF's Profile")* on topic *[Importing categories](/forum/37-import-export-csv-xls/874965-importing-categories#190750 "-- url of the page with the problem -- :   www.bil-filtertjanst.se  -- HikaShop version -- : 2.3.5 -- Joomla version -- : 3.3.6 -- PHP version -- : 5.3.29 -- Browser(s) name and version -- : Chrome v 40.0.2214.93 m (64-bit) -- Error-message(debug-mod must be tuned on) -- : no error message just blank page  HI, I am about to start a webshop selling filters for cars and other trucks and machines. THere are a lot of different products as their catalog are around 800 pages of products. All to be in HikaShop webshop. Only the categories has to be hundreds... Now I want to import all categories from an excel file that is saved as a semi colon separated csv file UTF-8. There are one main category Volvo BM and then the rest is sub categories on the second level. Just wanted to try two levels first. The end will be like thre levels of categories and then products in the third category level. Like this: Machine / Machine model / Motor type The files looks like this:  etc etc.  But I can't get it working... Is the file set up the wrong way or what can be wrong? I have tried both with loading the csv file and to copy all in the txt file and pasting it into the text import field... Still no go... Any help is appreciated.  Thanks Micke")*

Ok thanks a lot!

Last edit: 11 years 9 months ago by [LAMF](/forum/user/8669-lamf "View LAMF's Profile").

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

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

Less More

- Posts: 29
- Thank you received: 0
-
-

11 years 9 months ago [\#190781](#190781) by [Pajerchin](/forum/user/20592-pajerchin "View Pajerchin's Profile")  Replied by *[Pajerchin](/forum/user/20592-pajerchin "View Pajerchin's Profile")* on topic *[Importing categories](/forum/37-import-export-csv-xls/874965-importing-categories#190781 "-- url of the page with the problem -- :   www.bil-filtertjanst.se  -- HikaShop version -- : 2.3.5 -- Joomla version -- : 3.3.6 -- PHP version -- : 5.3.29 -- Browser(s) name and version -- : Chrome v 40.0.2214.93 m (64-bit) -- Error-message(debug-mod must be tuned on) -- : no error message just blank page  HI, I am about to start a webshop selling filters for cars and other trucks and machines. THere are a lot of different products as their catalog are around 800 pages of products. All to be in HikaShop webshop. Only the categories has to be hundreds... Now I want to import all categories from an excel file that is saved as a semi colon separated csv file UTF-8. There are one main category Volvo BM and then the rest is sub categories on the second level. Just wanted to try two levels first. The end will be like thre levels of categories and then products in the third category level. Like this: Machine / Machine model / Motor type The files looks like this:  etc etc.  But I can't get it working... Is the file set up the wrong way or what can be wrong? I have tried both with loading the csv file and to copy all in the txt file and pasting it into the text import field... Still no go... Any help is appreciated.  Thanks Micke")*

Hi,
...is there any way to import Category Description ?

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

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

Less More

- Posts: 299
- Thank you received: 2
-
-

11 years 9 months ago -  11 years 9 months ago [\#190810](#190810) by [LAMF](/forum/user/8669-lamf "View LAMF's Profile")  Replied by *[LAMF](/forum/user/8669-lamf "View LAMF's Profile")* on topic *[Importing categories](/forum/37-import-export-csv-xls/874965-importing-categories#190810 "-- url of the page with the problem -- :   www.bil-filtertjanst.se  -- HikaShop version -- : 2.3.5 -- Joomla version -- : 3.3.6 -- PHP version -- : 5.3.29 -- Browser(s) name and version -- : Chrome v 40.0.2214.93 m (64-bit) -- Error-message(debug-mod must be tuned on) -- : no error message just blank page  HI, I am about to start a webshop selling filters for cars and other trucks and machines. THere are a lot of different products as their catalog are around 800 pages of products. All to be in HikaShop webshop. Only the categories has to be hundreds... Now I want to import all categories from an excel file that is saved as a semi colon separated csv file UTF-8. There are one main category Volvo BM and then the rest is sub categories on the second level. Just wanted to try two levels first. The end will be like thre levels of categories and then products in the third category level. Like this: Machine / Machine model / Motor type The files looks like this:  etc etc.  But I can't get it working... Is the file set up the wrong way or what can be wrong? I have tried both with loading the csv file and to copy all in the txt file and pasting it into the text import field... Still no go... Any help is appreciated.  Thanks Micke")*

Yes that would be very good to know.
Also I don't quite get it.
First I imported catgories on three levels
Volvo BM &gt; A-Serien &gt; A20
Volvo BM &gt; A-Serien &gt; A20C
etc.
Like this: Code:

parent_category;categories Volvo BM;A-Serien A-Serien;A20 A-Serien;A20C A-Serien;A25 A-Serien;A25B

It works fine.
Then just to try I wanted to add some products like this: Code:

product_code;product_name;product_manufacturer_id;product_weight;product_weight_unit;price_value;price_currency_id;parent_category;categories 18002;Transmissionsfilter;12;0.39;kg;356.00;SEK;Volvo BM;A-Serien;A20 18003;Transmissionsfilter;12;0.37;kg;396.00;SEK;Volvo BM;A-Serien;A20C 18004;Fuelfilter;12;0.30;kg;256.00;SEK;Volvo BM;A-Serien;A25 18005;Transmissionsfilter;12;2.35;kg;796.00;SEK;Volvo BM;A-Serien;A43

But what happens is that only the first product 18002 Transmissionsfilter.... is added and directly under the Volovo BM &gt; A-Serien category. The other 3 products are ignored and an error message comes up like this:

> You need 9 'arguments' per line

What have I done wrong?
Isn't it possible to add a product under a third level category?

Last edit: 11 years 9 months ago by [LAMF](/forum/user/8669-lamf "View LAMF's Profile"). Reason: more info added

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

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

Less More

- Posts: 193
- Thank you received: 76
-
-

11 years 9 months ago -  11 years 9 months ago [\#190812](#190812) by [korzo](/forum/user/34428-korzo "View korzo's Profile")  Replied by *[korzo](/forum/user/34428-korzo "View korzo's Profile")* on topic *[Importing categories](/forum/37-import-export-csv-xls/874965-importing-categories#190812 "-- url of the page with the problem -- :   www.bil-filtertjanst.se  -- HikaShop version -- : 2.3.5 -- Joomla version -- : 3.3.6 -- PHP version -- : 5.3.29 -- Browser(s) name and version -- : Chrome v 40.0.2214.93 m (64-bit) -- Error-message(debug-mod must be tuned on) -- : no error message just blank page  HI, I am about to start a webshop selling filters for cars and other trucks and machines. THere are a lot of different products as their catalog are around 800 pages of products. All to be in HikaShop webshop. Only the categories has to be hundreds... Now I want to import all categories from an excel file that is saved as a semi colon separated csv file UTF-8. There are one main category Volvo BM and then the rest is sub categories on the second level. Just wanted to try two levels first. The end will be like thre levels of categories and then products in the third category level. Like this: Machine / Machine model / Motor type The files looks like this:  etc etc.  But I can't get it working... Is the file set up the wrong way or what can be wrong? I have tried both with loading the csv file and to copy all in the txt file and pasting it into the text import field... Still no go... Any help is appreciated.  Thanks Micke")*

Products in your CSV have one more column than header.
If your categories have unique names(e.g. you don't have several A20 categories), you don't have to set parent_category if category already exists.
Values should be enclosed in quotes, otherwise semicolon is as column separator.

Your last 3 values in each line are wrong. Code:

"Volvo BM";"A-Serien;A20"

Will create 2 categories:
Volvo BM &gt; A-Serien
Volvo BM &gt; A20
If you want to create/add product to category A20 under A-Serien category, it should be Code:

"parent_category";"categories" "A-Serien";"A20"

Last edit: 11 years 9 months ago by [korzo](/forum/user/34428-korzo "View korzo's Profile").

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

Less More

- Posts: 86564
- Thank you received: 14311
-
-

11 years 9 months ago [\#190824](#190824) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile")  Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Importing categories](/forum/37-import-export-csv-xls/874965-importing-categories#190824 "-- url of the page with the problem -- :   www.bil-filtertjanst.se  -- HikaShop version -- : 2.3.5 -- Joomla version -- : 3.3.6 -- PHP version -- : 5.3.29 -- Browser(s) name and version -- : Chrome v 40.0.2214.93 m (64-bit) -- Error-message(debug-mod must be tuned on) -- : no error message just blank page  HI, I am about to start a webshop selling filters for cars and other trucks and machines. THere are a lot of different products as their catalog are around 800 pages of products. All to be in HikaShop webshop. Only the categories has to be hundreds... Now I want to import all categories from an excel file that is saved as a semi colon separated csv file UTF-8. There are one main category Volvo BM and then the rest is sub categories on the second level. Just wanted to try two levels first. The end will be like thre levels of categories and then products in the third category level. Like this: Machine / Machine model / Motor type The files looks like this:  etc etc.  But I can't get it working... Is the file set up the wrong way or what can be wrong? I have tried both with loading the csv file and to copy all in the txt file and pasting it into the text import field... Still no go... Any help is appreciated.  Thanks Micke")*

@korzo : thx for the explanations

@Pajerchin:
Not via the interface of HikaShop.
What you can do is export the data of the hikashop_category table of your database via phpmyadmin and fill in the descriptions in that CSV and then import back the CSV in your database via phpmyadmin.
Please open a new thread for new questions.

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

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