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

#   No Commas in Category Names in CSV Import

##

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

Less More

- Posts: 36
- Thank you received: 6
-
-

13 years 9 months ago [\#86244](#86244) by [mtense](/forum/user/10417-mtense "View mtense's Profile")  *[No Commas in Category Names in CSV Import](/forum/3-bug-report/77593-no-commas-in-category-names-in-csv-import#86244 "CSV import does not support commas and other separators category names when creating categories. The code splits the category fields on all the various separators. While I can understand why this is...")* was created by *[mtense](/forum/user/10417-mtense "View mtense's Profile")*

CSV import does not support commas and other separators category names when creating categories. The code splits the category fields on all the various separators. While I can understand why this is done, this can be a problem if the names have commas. In my case I defeated the split when I namekey was present as I create one category at a time. I think this is a good approach as there is no good reason to create multiple categories at one time, especially when assigning namekeys which are for getting around issues with category names.

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

- **[Jerome](/forum/user/80-jerome "View Jerome's Profile")**
- [![Jerome's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar80.png)](/forum/user/80-jerome "View Jerome's Profile")
- [ Offline](/forum/user/80-jerome)
- HikaShop core developer

Less More

- Posts: 26400
- Thank you received: 4080
-
- [](http://obsi.dev)
-

13 years 9 months ago [\#86246](#86246) by [Jerome](/forum/user/80-jerome "View Jerome's Profile")  Replied by *[Jerome](/forum/user/80-jerome "View Jerome's Profile")* on topic *[No Commas in Category Names in CSV Import](/forum/3-bug-report/77593-no-commas-in-category-names-in-csv-import#86246 "CSV import does not support commas and other separators category names when creating categories. The code splits the category fields on all the various separators. While I can understand why this is...")*

Hi,

Are you sure that your CSV file is right formatted ?
Text in CSV should be between quotes, it allow to "escape" his content and store special characters into.

Regards,

---

Jerome - Obsidev.com
HikaMarket &amp; HikaSerial developer / HikaShop core dev team.

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

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

Less More

- Posts: 36
- Thank you received: 6
-
-

13 years 9 months ago -  13 years 9 months ago [\#86248](#86248) by [mtense](/forum/user/10417-mtense "View mtense's Profile")  Replied by *[mtense](/forum/user/10417-mtense "View mtense's Profile")* on topic *[No Commas in Category Names in CSV Import](/forum/3-bug-report/77593-no-commas-in-category-names-in-csv-import#86248 "CSV import does not support commas and other separators category names when creating categories. The code splits the category fields on all the various separators. While I can understand why this is...")*

I did this a little while ago, but I am pretty sure that even when it is quoted it still splits the category names (within the quotes). I tried many variations until I finally disabled the split by testing for namekey. Anyway, I wanted to make you aware, so that you could check into it.

Last edit: 13 years 9 months ago by [mtense](/forum/user/10417-mtense "View mtense's Profile").

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

- **[Jerome](/forum/user/80-jerome "View Jerome's Profile")**
- [![Jerome's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar80.png)](/forum/user/80-jerome "View Jerome's Profile")
- [ Offline](/forum/user/80-jerome)
- HikaShop core developer

Less More

- Posts: 26400
- Thank you received: 4080
-
- [](http://obsi.dev)
-

13 years 9 months ago [\#86254](#86254) by [Jerome](/forum/user/80-jerome "View Jerome's Profile")  Replied by *[Jerome](/forum/user/80-jerome "View Jerome's Profile")* on topic *[No Commas in Category Names in CSV Import](/forum/3-bug-report/77593-no-commas-in-category-names-in-csv-import#86254 "CSV import does not support commas and other separators category names when creating categories. The code splits the category fields on all the various separators. While I can understand why this is...")*

Hi,

Thanks, we would make some tests.

Regards,

---

Jerome - Obsidev.com
HikaMarket &amp; HikaSerial developer / HikaShop core dev team.

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzMtYnVnLXJlcG9ydC83NzU5My1uby1jb21tYXMtaW4tY2F0ZWdvcnktbmFtZXMtaW4tY3N2LWltcG9ydD90bXBsPW1hcmtkb3du) 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: 86560
- Thank you received: 14307
-
-

13 years 9 months ago [\#87055](#87055) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile")  Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[No Commas in Category Names in CSV Import](/forum/3-bug-report/77593-no-commas-in-category-names-in-csv-import#87055 "CSV import does not support commas and other separators category names when creating categories. The code splits the category fields on all the various separators. While I can understand why this is...")*

Hi,

Jerome didn't understand the problematic. He was thinking about an issue with the parsing of rows.

But it's actually the intended behavior as many users want to associate more than one category with their products.

In your case, I would suggest to precreate the categories with commas via the interface and then import using their id or namekey instead of their name.

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

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