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

#   Error importing using CSV or text area

##

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

Less More

- Posts: 16
- Thank you received: 0
-
-
-
- [](http://www.creativeknitworks.com)
-

13 years 3 months ago -  13 years 3 months ago [\#115760](#115760) by [innocent92](/forum/user/25104-innocent92 "View innocent92's Profile")  *[Error importing using CSV or text area](/forum/3-bug-report/85774-error-importing-using-csv-or-text-area#115760 "The error message displayed is:  The column &quot;product&#95;name&quot; is twice in your CSV. Only the second column data will be taken into account. The column &quot;price&#95;value&quot; is twice in your CSV. Only the second column data will be taken into account. The column &quot;price&#95;currency&#95;id&quot; is twice in your CSV. Only the second column data will be taken into account.  2 products found : 2 new products imported, 0 invalid product code, 0 already existing products  Is this a real error or is there something wrong with my setup? :unsure:  Im using the free version 2.2.0")* was created by *[innocent92](/forum/user/25104-innocent92 "View innocent92's Profile")*

The error message displayed is:

The column "product_name" is twice in your CSV. Only the second column data will be taken into account.
The column "price_value" is twice in your CSV. Only the second column data will be taken into account.
The column "price_currency_id" is twice in your CSV. Only the second column data will be taken into account.

2 products found : 2 new products imported, 0 invalid product code, 0 already existing products

Is this a real error or is there something wrong with my setup? ![:unsure:](/media/kunena/emoticons/18.png ":unsure:")

Im using the free version 2.2.0

Last edit: 13 years 3 months ago by [innocent92](/forum/user/25104-innocent92 "View innocent92's Profile").

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzMtYnVnLXJlcG9ydC84NTc3NC1lcnJvci1pbXBvcnRpbmctdXNpbmctY3N2LW9yLXRleHQtYXJlYT90bXBsPW1hcmtkb3du) 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 3 months ago [\#115804](#115804) 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 *[Error importing using CSV or text area](/forum/3-bug-report/85774-error-importing-using-csv-or-text-area#115804 "The error message displayed is:  The column &quot;product&#95;name&quot; is twice in your CSV. Only the second column data will be taken into account. The column &quot;price&#95;value&quot; is twice in your CSV. Only the second column data will be taken into account. The column &quot;price&#95;currency&#95;id&quot; is twice in your CSV. Only the second column data will be taken into account.  2 products found : 2 new products imported, 0 invalid product code, 0 already existing products  Is this a real error or is there something wrong with my setup? :unsure:  Im using the free version 2.2.0")*

Hi,
I think that the best solution will probably be to :
- create **manually** some products and categories
- export them
- edit the exported CSV file with your values
- import it again.

Hope this will help you a little.

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

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

Less More

- Posts: 16
- Thank you received: 0
-
-
-
- [](http://www.creativeknitworks.com)
-

13 years 3 months ago [\#115919](#115919) by [innocent92](/forum/user/25104-innocent92 "View innocent92's Profile")  Replied by *[innocent92](/forum/user/25104-innocent92 "View innocent92's Profile")* on topic *[Error importing using CSV or text area](/forum/3-bug-report/85774-error-importing-using-csv-or-text-area#115919 "The error message displayed is:  The column &quot;product&#95;name&quot; is twice in your CSV. Only the second column data will be taken into account. The column &quot;price&#95;value&quot; is twice in your CSV. Only the second column data will be taken into account. The column &quot;price&#95;currency&#95;id&quot; is twice in your CSV. Only the second column data will be taken into account.  2 products found : 2 new products imported, 0 invalid product code, 0 already existing products  Is this a real error or is there something wrong with my setup? :unsure:  Im using the free version 2.2.0")*

i got the same error as displayed in the attachment. It said 4 products were created, but there were not. I am also attaching my input file. Thanks for any advice.

Sharon
*This attachment is hidden for guests.
Please log in or register to see it.*

*This attachment is hidden for guests.
Please log in or register to see it.*

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

13 years 3 months ago [\#115938](#115938) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile")  Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Error importing using CSV or text area](/forum/3-bug-report/85774-error-importing-using-csv-or-text-area#115938 "The error message displayed is:  The column &quot;product&#95;name&quot; is twice in your CSV. Only the second column data will be taken into account. The column &quot;price&#95;value&quot; is twice in your CSV. Only the second column data will be taken into account. The column &quot;price&#95;currency&#95;id&quot; is twice in your CSV. Only the second column data will be taken into account.  2 products found : 2 new products imported, 0 invalid product code, 0 already existing products  Is this a real error or is there something wrong with my setup? :unsure:  Im using the free version 2.2.0")*

It's not a real error. You can ignore the messages. It's on our todo list to fix it in a following release.

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

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