[Skip to main content](#vessel-content) # Column is twice in the CSV File ## - **[piggybank](/forum/user/12049-piggybank "View piggybank's Profile")** - [![piggybank's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/12049-piggybank "View piggybank's Profile") Topic Author - [ Offline](/forum/user/12049-piggybank) Less More - Posts: 96 - Thank you received: 0 - - 13 years 2 months ago [\#118892](#118892) by [piggybank](/forum/user/12049-piggybank "View piggybank's Profile") *[Column is twice in the CSV File](/forum/37-import-export-csv-xls/861110-column-is-twice-in-the-csv-file#118892 "-- HikaShop version -- : 2.2.0 -- Joomla version -- : 3.1.5 -- PHP version -- : 5.3.8 I am trying to import a CSV file (attached) and I'm getting a series of errors like: The column "product_code" is twice in your CSV. Only the second column data will be taken into account. The column "product_parent_id" is twice in your CSV. Only the second column data will be taken into account. I have tried my CSV file in various combinations. My most recent has double quotes with a semi-colon delimiter, attached. Thanks, Scott")* was created by *[piggybank](/forum/user/12049-piggybank "View piggybank's Profile")* -- HikaShop version -- : 2.2.0 -- Joomla version -- : 3.1.5 -- PHP version -- : 5.3.8 I am trying to import a CSV file (attached) and I'm getting a series of errors like: The column "product_code" is twice in your CSV. Only the second column data will be taken into account. The column "product_parent_id" is twice in your CSV. Only the second column data will be taken into account. I have tried my CSV file in various combinations. My most recent has double quotes with a semi-colon delimiter, attached. Thanks, Scott Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtL2ltcG9ydC1leHBvcnQtY3N2LXhscy84NjExMTAtY29sdW1uLWlzLXR3aWNlLWluLXRoZS1jc3YtZmlsZT90bXBsPW1hcmtkb3du) 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: 26394 - Thank you received: 4078 - - [](http://obsi.dev) - 13 years 2 months ago [\#118908](#118908) by [Jerome](/forum/user/80-jerome "View Jerome's Profile") Replied by *[Jerome](/forum/user/80-jerome "View Jerome's Profile")* on topic *[Column is twice in the CSV File](/forum/37-import-export-csv-xls/861110-column-is-twice-in-the-csv-file#118908 "-- HikaShop version -- : 2.2.0 -- Joomla version -- : 3.1.5 -- PHP version -- : 5.3.8 I am trying to import a CSV file (attached) and I'm getting a series of errors like: The column "product_code" is twice in your CSV. Only the second column data will be taken into account. The column "product_parent_id" is twice in your CSV. Only the second column data will be taken into account. I have tried my CSV file in various combinations. My most recent has double quotes with a semi-colon delimiter, attached. Thanks, Scott")* Hi, CSV files are not allowed by our Kunena forum. Please put your CSV file in a zip. Your messages indicates that the columns "product_code" and "product_parent_id" are twice in the file. So I want to say that the problem is that the columns "product_code" and "product_parent_id" are twice in your CSV file. Please check the first line of your CSV file, checking the columns and remove the duplicates ones. Regards, --- Jerome - Obsidev.com HikaMarket & HikaSerial developer / HikaShop core dev team. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtL2ltcG9ydC1leHBvcnQtY3N2LXhscy84NjExMTAtY29sdW1uLWlzLXR3aWNlLWluLXRoZS1jc3YtZmlsZT90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[piggybank](/forum/user/12049-piggybank "View piggybank's Profile")** - [![piggybank's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/12049-piggybank "View piggybank's Profile") Topic Author - [ Offline](/forum/user/12049-piggybank) Less More - Posts: 96 - Thank you received: 0 - - 13 years 2 months ago [\#118910](#118910) by [piggybank](/forum/user/12049-piggybank "View piggybank's Profile") Replied by *[piggybank](/forum/user/12049-piggybank "View piggybank's Profile")* on topic *[Column is twice in the CSV File](/forum/37-import-export-csv-xls/861110-column-is-twice-in-the-csv-file#118910 "-- HikaShop version -- : 2.2.0 -- Joomla version -- : 3.1.5 -- PHP version -- : 5.3.8 I am trying to import a CSV file (attached) and I'm getting a series of errors like: The column "product_code" is twice in your CSV. Only the second column data will be taken into account. The column "product_parent_id" is twice in your CSV. Only the second column data will be taken into account. I have tried my CSV file in various combinations. My most recent has double quotes with a semi-colon delimiter, attached. Thanks, Scott")* Thank you. I've reattached the file...no duplicate first line/column names that I can see. Scott Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtL2ltcG9ydC1leHBvcnQtY3N2LXhscy84NjExMTAtY29sdW1uLWlzLXR3aWNlLWluLXRoZS1jc3YtZmlsZT90bXBsPW1hcmtkb3du) 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: 26394 - Thank you received: 4078 - - [](http://obsi.dev) - 13 years 2 months ago [\#118948](#118948) by [Jerome](/forum/user/80-jerome "View Jerome's Profile") Replied by *[Jerome](/forum/user/80-jerome "View Jerome's Profile")* on topic *[Column is twice in the CSV File](/forum/37-import-export-csv-xls/861110-column-is-twice-in-the-csv-file#118948 "-- HikaShop version -- : 2.2.0 -- Joomla version -- : 3.1.5 -- PHP version -- : 5.3.8 I am trying to import a CSV file (attached) and I'm getting a series of errors like: The column "product_code" is twice in your CSV. Only the second column data will be taken into account. The column "product_parent_id" is twice in your CSV. Only the second column data will be taken into account. I have tried my CSV file in various combinations. My most recent has double quotes with a semi-colon delimiter, attached. Thanks, Scott")* Hi, Please edit the file "administrator/components/com_hikashop/helper/import.php" and replace the code Code: foreach($this->columns as $otherColumn){ if($this->columns[$i] == strtolower($otherColumn)) { By: Code: foreach($this->columns as $k => $otherColumn){ if($i != $k && $this->columns[$i] == strtolower($otherColumn)) { It will solve your problem. After that, the import should work properly, the warning message is just a warning, it does not affect the rest of the import. Sorry for the inconvenient. --- Jerome - Obsidev.com HikaMarket & HikaSerial developer / HikaShop core dev team. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtL2ltcG9ydC1leHBvcnQtY3N2LXhscy84NjExMTAtY29sdW1uLWlzLXR3aWNlLWluLXRoZS1jc3YtZmlsZT90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[piggybank](/forum/user/12049-piggybank "View piggybank's Profile")** - [![piggybank's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/12049-piggybank "View piggybank's Profile") Topic Author - [ Offline](/forum/user/12049-piggybank) Less More - Posts: 96 - Thank you received: 0 - - 13 years 2 months ago [\#119739](#119739) by [piggybank](/forum/user/12049-piggybank "View piggybank's Profile") Replied by *[piggybank](/forum/user/12049-piggybank "View piggybank's Profile")* on topic *[Column is twice in the CSV File](/forum/37-import-export-csv-xls/861110-column-is-twice-in-the-csv-file#119739 "-- HikaShop version -- : 2.2.0 -- Joomla version -- : 3.1.5 -- PHP version -- : 5.3.8 I am trying to import a CSV file (attached) and I'm getting a series of errors like: The column "product_code" is twice in your CSV. Only the second column data will be taken into account. The column "product_parent_id" is twice in your CSV. Only the second column data will be taken into account. I have tried my CSV file in various combinations. My most recent has double quotes with a semi-colon delimiter, attached. Thanks, Scott")* Thank you...this deed indeed remove the error message. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtL2ltcG9ydC1leHBvcnQtY3N2LXhscy84NjExMTAtY29sdW1uLWlzLXR3aWNlLWluLXRoZS1jc3YtZmlsZT90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[lionel75](/forum/user/11856-lionel75 "View lionel75's Profile")** - [![lionel75's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/11856-lionel75 "View lionel75's Profile") - [ Offline](/forum/user/11856-lionel75) Less More - Posts: 846 - Thank you received: 92 - - 13 years 2 months ago [\#119949](#119949) by [lionel75](/forum/user/11856-lionel75 "View lionel75's Profile") Replied by *[lionel75](/forum/user/11856-lionel75 "View lionel75's Profile")* on topic *[Column is twice in the CSV File](/forum/37-import-export-csv-xls/861110-column-is-twice-in-the-csv-file#119949 "-- HikaShop version -- : 2.2.0 -- Joomla version -- : 3.1.5 -- PHP version -- : 5.3.8 I am trying to import a CSV file (attached) and I'm getting a series of errors like: The column "product_code" is twice in your CSV. Only the second column data will be taken into account. The column "product_parent_id" is twice in your CSV. Only the second column data will be taken into account. I have tried my CSV file in various combinations. My most recent has double quotes with a semi-colon delimiter, attached. Thanks, Scott")* piggybank, you say you have many mesage error but you don't say if the import of data is ok ? Do you succeed to import all the data locate in the csv file even when all this messages occurs ? Thank's Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtL2ltcG9ydC1leHBvcnQtY3N2LXhscy84NjExMTAtY29sdW1uLWlzLXR3aWNlLWluLXRoZS1jc3YtZmlsZT90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[mad-q](/forum/user/4784-mad-q "View mad-q's Profile")** - [![mad-q's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/4784-mad-q "View mad-q's Profile") - [ Offline](/forum/user/4784-mad-q) Less More - Posts: 234 - Thank you received: 4 - - 13 years 2 months ago [\#120026](#120026) by [mad-q](/forum/user/4784-mad-q "View mad-q's Profile") Replied by *[mad-q](/forum/user/4784-mad-q "View mad-q's Profile")* on topic *[Column is twice in the CSV File](/forum/37-import-export-csv-xls/861110-column-is-twice-in-the-csv-file#120026 "-- HikaShop version -- : 2.2.0 -- Joomla version -- : 3.1.5 -- PHP version -- : 5.3.8 I am trying to import a CSV file (attached) and I'm getting a series of errors like: The column "product_code" is twice in your CSV. Only the second column data will be taken into account. The column "product_parent_id" is twice in your CSV. Only the second column data will be taken into account. I have tried my CSV file in various combinations. My most recent has double quotes with a semi-colon delimiter, attached. Thanks, Scott")* Hello, I can not find the code you list in my file. Here is an example of my csv file. product_name,product_description,product_quantity,product_code,product_published,product_tax_id,categories,price_value,price_currency_id,images,related Tool box lock and keys N/A,"Sorry, no stock. If you order this we will put it on back order",-1,T2573,1,11,2,0,GBP,T2573.jpg, Cheers Iain Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtL2ltcG9ydC1leHBvcnQtY3N2LXhscy84NjExMTAtY29sdW1uLWlzLXR3aWNlLWluLXRoZS1jc3YtZmlsZT90bXBsPW1hcmtkb3du) 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 2 months ago [\#120048](#120048) by [Eliot](/forum/user/1824-eliot "View Eliot's Profile") Replied by *[Eliot](/forum/user/1824-eliot "View Eliot's Profile")* on topic *[Column is twice in the CSV File](/forum/37-import-export-csv-xls/861110-column-is-twice-in-the-csv-file#120048 "-- HikaShop version -- : 2.2.0 -- Joomla version -- : 3.1.5 -- PHP version -- : 5.3.8 I am trying to import a CSV file (attached) and I'm getting a series of errors like: The column "product_code" is twice in your CSV. Only the second column data will be taken into account. The column "product_parent_id" is twice in your CSV. Only the second column data will be taken into account. I have tried my CSV file in various combinations. My most recent has double quotes with a semi-colon delimiter, attached. Thanks, Scott")* Hi lain, If you don't have the code in your file you''re either editing the wrong file or using an older version. Try to download the last Hikashop version again an reinstall it. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtL2ltcG9ydC1leHBvcnQtY3N2LXhscy84NjExMTAtY29sdW1uLWlzLXR3aWNlLWluLXRoZS1jc3YtZmlsZT90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[mad-q](/forum/user/4784-mad-q "View mad-q's Profile")** - [![mad-q's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/4784-mad-q "View mad-q's Profile") - [ Offline](/forum/user/4784-mad-q) Less More - Posts: 234 - Thank you received: 4 - - 13 years 2 months ago [\#120109](#120109) by [mad-q](/forum/user/4784-mad-q "View mad-q's Profile") Replied by *[mad-q](/forum/user/4784-mad-q "View mad-q's Profile")* on topic *[Column is twice in the CSV File](/forum/37-import-export-csv-xls/861110-column-is-twice-in-the-csv-file#120109 "-- HikaShop version -- : 2.2.0 -- Joomla version -- : 3.1.5 -- PHP version -- : 5.3.8 I am trying to import a CSV file (attached) and I'm getting a series of errors like: The column "product_code" is twice in your CSV. Only the second column data will be taken into account. The column "product_parent_id" is twice in your CSV. Only the second column data will be taken into account. I have tried my CSV file in various combinations. My most recent has double quotes with a semi-colon delimiter, attached. Thanks, Scott")* Hello As per usual you are correct, many thanks. Iain Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtL2ltcG9ydC1leHBvcnQtY3N2LXhscy84NjExMTAtY29sdW1uLWlzLXR3aWNlLWluLXRoZS1jc3YtZmlsZT90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. Board Categories HikaShop- Install & Update- Product & Category Display- Content Creation- Sales and Orders- - Orders management- - Reports & Statistics- Customers- Checkout- Payment Methods- Shipping Methods- Import & Export (CSV, XLS…)- Specific Features- - Affilation- - Taxes- - Wishlist- - Vote- - Carousel & Slider- - Mass Actions- - Filters & Search- - Discount & 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.204 seconds [Powered by](/forum/credits) [Kunena Forum](https://www.kunena.org) [](#top)