[Skip to main content](#vessel-content) # Invalid Product codes on product CSV import ## - **[Day](/forum/user/45951-day "View Day's Profile")** - [![Day's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/45951-day "View Day's Profile") Topic Author - [ Offline](/forum/user/45951-day) Less More - Posts: 29 - Thank you received: 1 - - 5 years 6 months ago [\#331319](#331319) by [Day](/forum/user/45951-day "View Day's Profile") *[Invalid Product codes on product CSV import](/forum/37-import-export-csv-xls/902285-invalid-product-codes-on-product-csv-import#331319 "-- HikaShop version -- : 4.4.1 (build 21-03-24) -- Joomla version -- : 3.9.25 -- PHP version -- : 7.4.15 -- Browser(s) name and version -- : Firefox 86.01 After I import from CSV file I get an on-screen "Notice" and "Message" after the import that reports various things that either worked or failed. Is there any way of seeing in more detail what has failed? Like what are to 40 invalid product codes? --See attached pic. Which column in the import CSV file is the product code? The text in the 'product_code' column looks ok (but with lots of '_' inserted). Since I did not generate this text could I delete all this column text and import again? Thanks")* was created by *[Day](/forum/user/45951-day "View Day's Profile")* -- HikaShop version -- : 4.4.1 (build 21-03-24) -- Joomla version -- : 3.9.25 -- PHP version -- : 7.4.15 -- Browser(s) name and version -- : Firefox 86.01 After I import from CSV file I get an on-screen "Notice" and "Message" after the import that reports various things that either worked or failed. Is there any way of seeing in more detail what has failed? Like what are to 40 invalid product codes? --See attached pic. Which column in the import CSV file is the product code? The text in the 'product_code' column looks ok (but with lots of '_' inserted). Since I did not generate this text could I delete all this column text and import again? Thanks [ ![import-messages.jpeg](/forum/attachment/52403) ](/forum/attachment/52403 "...-messages.jpeg") - [ ![import-messages.jpeg](/forum/attachment/52403) ](/forum/attachment/52403 "...-messages.jpeg") [ ](/forum/attachment/52403?download=1 "...-messages.jpeg") Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM3LWltcG9ydC1leHBvcnQtY3N2LXhscy85MDIyODUtaW52YWxpZC1wcm9kdWN0LWNvZGVzLW9uLXByb2R1Y3QtY3N2LWltcG9ydD90bXBsPW1hcmtkb3du) 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)](/forum/user/63-nicolas "View nicolas's Profile") - [ Away](/forum/user/63-nicolas) Less More - Posts: 86289 - Thank you received: 14265 - - 5 years 6 months ago [\#331321](#331321) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Invalid Product codes on product CSV import](/forum/37-import-export-csv-xls/902285-invalid-product-codes-on-product-csv-import#331321 "-- HikaShop version -- : 4.4.1 (build 21-03-24) -- Joomla version -- : 3.9.25 -- PHP version -- : 7.4.15 -- Browser(s) name and version -- : Firefox 86.01 After I import from CSV file I get an on-screen "Notice" and "Message" after the import that reports various things that either worked or failed. Is there any way of seeing in more detail what has failed? Like what are to 40 invalid product codes? --See attached pic. Which column in the import CSV file is the product code? The text in the 'product_code' column looks ok (but with lots of '_' inserted). Since I did not generate this text could I delete all this column text and import again? Thanks")* Hi, These messages are for the category rows you have at the beginning of your CSV. So it's normal that no product code was found for them as only category data is mentioned. So you can just ignore these messages. The following user(s) said Thank You: [Day](/forum/user/45951-day "View Day's Profile") Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM3LWltcG9ydC1leHBvcnQtY3N2LXhscy85MDIyODUtaW52YWxpZC1wcm9kdWN0LWNvZGVzLW9uLXByb2R1Y3QtY3N2LWltcG9ydD90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[Day](/forum/user/45951-day "View Day's Profile")** - [![Day's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/45951-day "View Day's Profile") Topic Author - [ Offline](/forum/user/45951-day) Less More - Posts: 29 - Thank you received: 1 - - 5 years 6 months ago [\#331379](#331379) by [Day](/forum/user/45951-day "View Day's Profile") Replied by *[Day](/forum/user/45951-day "View Day's Profile")* on topic *[Invalid Product codes on product CSV import](/forum/37-import-export-csv-xls/902285-invalid-product-codes-on-product-csv-import#331379 "-- HikaShop version -- : 4.4.1 (build 21-03-24) -- Joomla version -- : 3.9.25 -- PHP version -- : 7.4.15 -- Browser(s) name and version -- : Firefox 86.01 After I import from CSV file I get an on-screen "Notice" and "Message" after the import that reports various things that either worked or failed. Is there any way of seeing in more detail what has failed? Like what are to 40 invalid product codes? --See attached pic. Which column in the import CSV file is the product code? The text in the 'product_code' column looks ok (but with lots of '_' inserted). Since I did not generate this text could I delete all this column text and import again? Thanks")* That's fine, the numbers work out. Do the columns in the import CSV need to be in the same order as outputted? I'd like to relocate a few columns to the row start for a 3rd party to update details easily without having to scroll around lots. Can I leave them in this changed order or do I have to return them to their original positions before importing? Also, what happens if there are some columns missing? Do they all need to be there? I know I can leave some blank. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM3LWltcG9ydC1leHBvcnQtY3N2LXhscy85MDIyODUtaW52YWxpZC1wcm9kdWN0LWNvZGVzLW9uLXByb2R1Y3QtY3N2LWltcG9ydD90bXBsPW1hcmtkb3du) 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)](/forum/user/63-nicolas "View nicolas's Profile") - [ Away](/forum/user/63-nicolas) Less More - Posts: 86289 - Thank you received: 14265 - - 5 years 6 months ago [\#331381](#331381) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Invalid Product codes on product CSV import](/forum/37-import-export-csv-xls/902285-invalid-product-codes-on-product-csv-import#331381 "-- HikaShop version -- : 4.4.1 (build 21-03-24) -- Joomla version -- : 3.9.25 -- PHP version -- : 7.4.15 -- Browser(s) name and version -- : Firefox 86.01 After I import from CSV file I get an on-screen "Notice" and "Message" after the import that reports various things that either worked or failed. Is there any way of seeing in more detail what has failed? Like what are to 40 invalid product codes? --See attached pic. Which column in the import CSV file is the product code? The text in the 'product_code' column looks ok (but with lots of '_' inserted). Since I did not generate this text could I delete all this column text and import again? Thanks")* Hi, The order of the columns in the CSV doesn't matter. You need to have the same number of columns for each row. However, you can remove columns you don't need provided you remove them for all the rows. The following user(s) said Thank You: [Day](/forum/user/45951-day "View Day's Profile") Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM3LWltcG9ydC1leHBvcnQtY3N2LXhscy85MDIyODUtaW52YWxpZC1wcm9kdWN0LWNvZGVzLW9uLXByb2R1Y3QtY3N2LWltcG9ydD90bXBsPW1hcmtkb3du) 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.149 seconds [Powered by](/forum/credits) [Kunena Forum](https://www.kunena.org) [](#top)