[Skip to main content](#vessel-content) # Problems with Import ## - **[Hans987](/forum/user/5119-hans987 "View Hans987's Profile")** - [![Hans987's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/5119-hans987 "View Hans987's Profile") Topic Author - [ Offline](/forum/user/5119-hans987) Less More - Posts: 57 - Thank you received: 2 - - 14 years 10 months ago [\#35489](#35489) by [Hans987](/forum/user/5119-hans987 "View Hans987's Profile") *[Problems with Import](/forum/3-bug-report/35489-problems-with-import#35489 "Hi, I have some problems with the import products from csv (file and window). I have exported a bunch of products and changed the name and the product_code (only one glyph has been changed BC1120ACFFP01 -> BC1120BCFFP01 ) with TextWrangler. After that I tried to import the file to add new products. But Hika shop always told me, he has updated existing ones. Most times the products only were updated, but sometimes s o m e products were added. Chaning the ID did not change anything Is there something wrong with my way of adding products. Or is the produtc code invalid? Cheers! [file]")* was created by *[Hans987](/forum/user/5119-hans987 "View Hans987's Profile")* Hi, I have some problems with the import products from csv (file and window). I have exported a bunch of products and changed the name and the product_code (only one glyph has been changed BC1120ACFFP01 -> BC1120BCFFP01 ) with TextWrangler. After that I tried to import the file to add new products. But Hika shop always told me, he has updated existing ones. Most times the products only were updated, but sometimes s o m e products were added. Chaning the ID did not change anything Is there something wrong with my way of adding products. Or is the produtc code invalid? Cheers! #### *This attachment is hidden for guests. Please log in or register to see it.* Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzMtYnVnLXJlcG9ydC8zNTQ4OS1wcm9ibGVtcy13aXRoLWltcG9ydD90bXBsPW1hcmtkb3du) 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: 86541 - Thank you received: 14304 - - 14 years 9 months ago [\#35527](#35527) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Re: Problems with Import](/forum/3-bug-report/35489-problems-with-import#35527 "Hi, I have some problems with the import products from csv (file and window). I have exported a bunch of products and changed the name and the product_code (only one glyph has been changed BC1120ACFFP01 -> BC1120BCFFP01 ) with TextWrangler. After that I tried to import the file to add new products. But Hika shop always told me, he has updated existing ones. Most times the products only were updated, but sometimes s o m e products were added. Chaning the ID did not change anything Is there something wrong with my way of adding products. Or is the produtc code invalid? Cheers! [file]")* Hi, Your CSV is OK. When a product is already in the database with the same code as in the CSV, the information of the product will be updated with the one from the CSV. When a product is not in the database for a product code in the CSV, a new product will be created in the database from the CSV information. That's all there is to it. The product_id column is always discarded during the import and it's the code which is used to match the products. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzMtYnVnLXJlcG9ydC8zNTQ4OS1wcm9ibGVtcy13aXRoLWltcG9ydD90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[Hans987](/forum/user/5119-hans987 "View Hans987's Profile")** - [![Hans987's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/5119-hans987 "View Hans987's Profile") Topic Author - [ Offline](/forum/user/5119-hans987) Less More - Posts: 57 - Thank you received: 2 - - 14 years 9 months ago [\#35651](#35651) by [Hans987](/forum/user/5119-hans987 "View Hans987's Profile") Replied by *[Hans987](/forum/user/5119-hans987 "View Hans987's Profile")* on topic *[Re: Problems with Import](/forum/3-bug-report/35489-problems-with-import#35651 "Hi, I have some problems with the import products from csv (file and window). I have exported a bunch of products and changed the name and the product_code (only one glyph has been changed BC1120ACFFP01 -> BC1120BCFFP01 ) with TextWrangler. After that I tried to import the file to add new products. But Hika shop always told me, he has updated existing ones. Most times the products only were updated, but sometimes s o m e products were added. Chaning the ID did not change anything Is there something wrong with my way of adding products. Or is the produtc code invalid? Cheers! [file]")* Hi, Then something is going wrong here. When I import the cvs with changed names and changed Product_code, there is always the same message and result: 28 products found : 0 new products imported, 7 invalid product code, 21 already existing products, and no matter if "Update products information if the product_code already exists" is set to yes or no, the previously exported products will be updated. Thats why I thought the update process relies on something else than the product_code field. Cheers. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzMtYnVnLXJlcG9ydC8zNTQ4OS1wcm9ibGVtcy13aXRoLWltcG9ydD90bXBsPW1hcmtkb3du) 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: 86541 - Thank you received: 14304 - - 14 years 9 months ago [\#35688](#35688) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Re: Problems with Import](/forum/3-bug-report/35489-problems-with-import#35688 "Hi, I have some problems with the import products from csv (file and window). I have exported a bunch of products and changed the name and the product_code (only one glyph has been changed BC1120ACFFP01 -> BC1120BCFFP01 ) with TextWrangler. After that I tried to import the file to add new products. But Hika shop always told me, he has updated existing ones. Most times the products only were updated, but sometimes s o m e products were added. Chaning the ID did not change anything Is there something wrong with my way of adding products. Or is the produtc code invalid? Cheers! [file]")* If you change the product code in the CSV, I don't see how the system would be able to update the previous products which have different product codes. There must be something else and it's not in HikaShop as that is working fine for everyone else. Also, I see that you have invalid product codes. Did you use that CSV to produce this message ? If you try to import the CSV via the textarea instead of uploading it (you need to open it via notepad++, and copy/paste the content in the textarea), do you have the same problem? Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzMtYnVnLXJlcG9ydC8zNTQ4OS1wcm9ibGVtcy13aXRoLWltcG9ydD90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[Hans987](/forum/user/5119-hans987 "View Hans987's Profile")** - [![Hans987's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/5119-hans987 "View Hans987's Profile") Topic Author - [ Offline](/forum/user/5119-hans987) Less More - Posts: 57 - Thank you received: 2 - - 14 years 9 months ago [\#35707](#35707) by [Hans987](/forum/user/5119-hans987 "View Hans987's Profile") Replied by *[Hans987](/forum/user/5119-hans987 "View Hans987's Profile")* on topic *[Re: Problems with Import](/forum/3-bug-report/35489-problems-with-import#35707 "Hi, I have some problems with the import products from csv (file and window). I have exported a bunch of products and changed the name and the product_code (only one glyph has been changed BC1120ACFFP01 -> BC1120BCFFP01 ) with TextWrangler. After that I tried to import the file to add new products. But Hika shop always told me, he has updated existing ones. Most times the products only were updated, but sometimes s o m e products were added. Chaning the ID did not change anything Is there something wrong with my way of adding products. Or is the produtc code invalid? Cheers! [file]")* Hi, Yes, I used that CSV. The invalid product codes are depended on the categories, but this seems not to change anything. And yes, it's the same behaviour from the textarea. I have checked it all again and found out, that it is related to the product_id - unlike what I wrote first. If I leave the id untouched, products are updated and if I set it to "0", new ones are added. The radio "Update products information if the product_code already exists" does not change anything. Cheers. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzMtYnVnLXJlcG9ydC8zNTQ4OS1wcm9ibGVtcy13aXRoLWltcG9ydD90bXBsPW1hcmtkb3du) 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: 86541 - Thank you received: 14304 - - 14 years 9 months ago [\#35770](#35770) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Re: Problems with Import](/forum/3-bug-report/35489-problems-with-import#35770 "Hi, I have some problems with the import products from csv (file and window). I have exported a bunch of products and changed the name and the product_code (only one glyph has been changed BC1120ACFFP01 -> BC1120BCFFP01 ) with TextWrangler. After that I tried to import the file to add new products. But Hika shop always told me, he has updated existing ones. Most times the products only were updated, but sometimes s o m e products were added. Chaning the ID did not change anything Is there something wrong with my way of adding products. Or is the produtc code invalid? Cheers! [file]")* Hi, Yes you're right. I checked on our end and looked at the code and indeed, we changed the way the import works in a previous version so that it handles the product_id column if specified, overriding the "Update products information if the product_code already exists" option. So you should delete the product_id column in your CSV if you want to create new products. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzMtYnVnLXJlcG9ydC8zNTQ4OS1wcm9ibGVtcy13aXRoLWltcG9ydD90bXBsPW1hcmtkb3du) 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.053 seconds [Powered by](/forum/credits) [Kunena Forum](https://www.kunena.org)