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

#   Import of CSV not working

##

- **[Andreas\_Sweden](/forum/user/1399-andreas-sweden "View Andreas&#95;Sweden's Profile")**
- [![Andreas&#95;Sweden's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/1399-andreas-sweden "View Andreas&#95;Sweden's Profile") Topic Author
- [ Offline](/forum/user/1399-andreas-sweden)

Less More

- Posts: 51
- Thank you received: 0
-
-

15 years 8 months ago -  15 years 8 months ago [\#10121](#10121) by [Andreas\_Sweden](/forum/user/1399-andreas-sweden "View Andreas&#95;Sweden's Profile")  *[Import of CSV not working](/forum/4-how-to/10121-import-of-csv-not-working#10121 "I just upgraded to Hikashop business from the free version. I was just testing the free version and upgraded yesterday and now the import isn't working.  My hikashop has no products but when I import it says &quot;12 products found : 0 new products imported, 0 invalid product code, 12 already existing products&quot; but the products does not exist.  What should I do? I have tried to import both through CSV and Textarea")* was created by *[Andreas\_Sweden](/forum/user/1399-andreas-sweden "View Andreas&#95;Sweden's Profile")*

I just upgraded to Hikashop business from the free version.
I was just testing the free version and upgraded yesterday and now the import isn't working.

My hikashop has no products but when I import it says "12 products found : 0 new products imported, 0 invalid product code, 12 already existing products" but the products does not exist.

What should I do? I have tried to import both through CSV and Textarea

Last edit: 15 years 8 months ago by [Andreas\_Sweden](/forum/user/1399-andreas-sweden "View Andreas&#95;Sweden's Profile").

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

15 years 8 months ago [\#10122](#10122) 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 of CSV not working](/forum/4-how-to/10121-import-of-csv-not-working#10122 "I just upgraded to Hikashop business from the free version. I was just testing the free version and upgraded yesterday and now the import isn't working.  My hikashop has no products but when I import it says &quot;12 products found : 0 new products imported, 0 invalid product code, 12 already existing products&quot; but the products does not exist.  What should I do? I have tried to import both through CSV and Textarea")*

If the import says that the products already exist, then they are already in the table hikashop_product. Even if they aren't linked to a category and thus you don't see them in the listing of products.

Could you give us your CSV so that we can check it ?

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

- **[Andreas\_Sweden](/forum/user/1399-andreas-sweden "View Andreas&#95;Sweden's Profile")**
- [![Andreas&#95;Sweden's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/1399-andreas-sweden "View Andreas&#95;Sweden's Profile") Topic Author
- [ Offline](/forum/user/1399-andreas-sweden)

Less More

- Posts: 51
- Thank you received: 0
-
-

15 years 8 months ago [\#10125](#10125) by [Andreas\_Sweden](/forum/user/1399-andreas-sweden "View Andreas&#95;Sweden's Profile")  Replied by *[Andreas\_Sweden](/forum/user/1399-andreas-sweden "View Andreas&#95;Sweden's Profile")* on topic *[Re: Import of CSV not working](/forum/4-how-to/10121-import-of-csv-not-working#10125 "I just upgraded to Hikashop business from the free version. I was just testing the free version and upgraded yesterday and now the import isn't working.  My hikashop has no products but when I import it says &quot;12 products found : 0 new products imported, 0 invalid product code, 12 already existing products&quot; but the products does not exist.  What should I do? I have tried to import both through CSV and Textarea")*

Here is an example

product_name;product_description;product_code;product_type;product_weight_unit;product_keywords;product_meta_description;price_quantity;storlek xs-l;images;categories
Victorias Secret Bikini;Snyggt skuren Victorias Secret-bikini;289375;Bikini;1;Bikini, Victorias Secret;Bikini, Victorias Secret;224;xs,s,m,l;289375.jpg;122,124,125;
Victorias Secret Bikini;Snyggt skuren Victorias Secret-bikini;289376;Bikini;1;Bikini, Victorias Secret;Bikini, Victorias Secret;224;xs,s,m,l;289376.jpg;122,124,125;
Victorias Secret Bikini;Snyggt skuren Victorias Secret-bikini;289377;Bikini;1;Bikini, Victorias Secret;Bikini, Victorias Secret;224;xs,s,m,l;289377.jpg;122,124,125;

Besides I have checked yes on Create automatically missing categories

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

15 years 8 months ago [\#10126](#10126) 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 of CSV not working](/forum/4-how-to/10121-import-of-csv-not-working#10126 "I just upgraded to Hikashop business from the free version. I was just testing the free version and upgraded yesterday and now the import isn't working.  My hikashop has no products but when I import it says &quot;12 products found : 0 new products imported, 0 invalid product code, 12 already existing products&quot; but the products does not exist.  What should I do? I have tried to import both through CSV and Textarea")*

The product_type column can only be main or variant
If you set it to something else the products won't be displayed.
We're going to add a check for that in next release... ![:)](/media/kunena/emoticons/3.png ":)")

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

- **[Andreas\_Sweden](/forum/user/1399-andreas-sweden "View Andreas&#95;Sweden's Profile")**
- [![Andreas&#95;Sweden's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/1399-andreas-sweden "View Andreas&#95;Sweden's Profile") Topic Author
- [ Offline](/forum/user/1399-andreas-sweden)

Less More

- Posts: 51
- Thank you received: 0
-
-

15 years 8 months ago [\#10127](#10127) by [Andreas\_Sweden](/forum/user/1399-andreas-sweden "View Andreas&#95;Sweden's Profile")  Replied by *[Andreas\_Sweden](/forum/user/1399-andreas-sweden "View Andreas&#95;Sweden's Profile")* on topic *[Re: Import of CSV not working](/forum/4-how-to/10121-import-of-csv-not-working#10127 "I just upgraded to Hikashop business from the free version. I was just testing the free version and upgraded yesterday and now the import isn't working.  My hikashop has no products but when I import it says &quot;12 products found : 0 new products imported, 0 invalid product code, 12 already existing products&quot; but the products does not exist.  What should I do? I have tried to import both through CSV and Textarea")*

Ok, thanks for the quick reply and great support, another question what file charset should i select for the letters å ä ö (Swedish) to be imported correctly?

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

15 years 8 months ago [\#10128](#10128) 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 of CSV not working](/forum/4-how-to/10121-import-of-csv-not-working#10128 "I just upgraded to Hikashop business from the free version. I was just testing the free version and upgraded yesterday and now the import isn't working.  My hikashop has no products but when I import it says &quot;12 products found : 0 new products imported, 0 invalid product code, 12 already existing products&quot; but the products does not exist.  What should I do? I have tried to import both through CSV and Textarea")*

It depends on how you create your CSV file. For example, when you create a text file (a CSV in our case) with notepad++, you have a menu to choose the format and select UTF8. Thus, if you import that file in HikaShop, you should select UTF8.
The format which to use will depend on the format of your file.
For swedish characters, both ISO-8859-1 and UTF-8 are possible.

For others, here is a list of charset with the language for which it was made: [ www.terena.org/activities/multiling/ml-docs/iso-8859.html](http://www.terena.org/activities/multiling/ml-docs/iso-8859.html)

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

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