[Skip to main content](#vessel-content) # Import of related products data ## - **[PhilP](/forum/user/5076-philp "View PhilP's Profile")** - [![PhilP's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/5076-philp "View PhilP's Profile") Topic Author - [ Offline](/forum/user/5076-philp) Less More - Posts: 44 - Thank you received: 1 - - 14 years 6 months ago [\#48737](#48737) by [PhilP](/forum/user/5076-philp "View PhilP's Profile") *[Import of related products data](/forum/3-bug-report/48737-import-of-related-products-data#48737 "Hi, I have just been updating our site, in particular with new 'related products'. We several hundred of these to do so I created an import file and, just for convenience, organised it with a format similar to the simplified one below: product_code,related xxTest_Product_Top2,TD_2180058 xxTest_Product_Top2,TD_2214419 Although the above import correctly attaches both related products to the main product, it completely erases pretty much everything else, including: The product name The product description The product category The product image etc etc However,the following format works fine, keeping all the other product information intact: product_code,related xxTest_Product_Top2,TD_2180058;TD_2214419 I have used related product imports before but each line has started with a new product code, not a repeat of the same product code. That type of import also works fine. The problem seems to be where the product code is a repeat of the line that precedes it. It behaves the same whether the import is from CSV or from the text area. Regards PhilP")* was created by *[PhilP](/forum/user/5076-philp "View PhilP's Profile")* Hi, I have just been updating our site, in particular with new 'related products'. We several hundred of these to do so I created an import file and, just for convenience, organised it with a format similar to the simplified one below: product_code,related xxTest_Product_Top2,TD_2180058 xxTest_Product_Top2,TD_2214419 Although the above import correctly attaches both related products to the main product, it completely erases pretty much everything else, including: The product name The product description The product category The product image etc etc However,the following format works fine, keeping all the other product information intact: product_code,related xxTest_Product_Top2,TD_2180058;TD_2214419 I have used related product imports before but each line has started with a new product code, not a repeat of the same product code. That type of import also works fine. The problem seems to be where the product code is a repeat of the line that precedes it. It behaves the same whether the import is from CSV or from the text area. Regards PhilP Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzMtYnVnLXJlcG9ydC80ODczNy1pbXBvcnQtb2YtcmVsYXRlZC1wcm9kdWN0cy1kYXRhP3RtcGw9bWFya2Rvd24=) or [Create an account](/register) 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: 86322 - Thank you received: 14281 - - 14 years 6 months ago [\#48777](#48777) 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 related products data](/forum/3-bug-report/48737-import-of-related-products-data#48777 "Hi, I have just been updating our site, in particular with new 'related products'. We several hundred of these to do so I created an import file and, just for convenience, organised it with a format similar to the simplified one below: product_code,related xxTest_Product_Top2,TD_2180058 xxTest_Product_Top2,TD_2214419 Although the above import correctly attaches both related products to the main product, it completely erases pretty much everything else, including: The product name The product description The product category The product image etc etc However,the following format works fine, keeping all the other product information intact: product_code,related xxTest_Product_Top2,TD_2180058;TD_2214419 I have used related product imports before but each line has started with a new product code, not a repeat of the same product code. That type of import also works fine. The problem seems to be where the product code is a repeat of the line that precedes it. It behaves the same whether the import is from CSV or from the text area. Regards PhilP")* Yes, you should not have several times the same product in your CSV. Otherwise, it won't work properly, regardless of what you're trying to import. You never need or should have more than one line of information per product in your CSV. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzMtYnVnLXJlcG9ydC80ODczNy1pbXBvcnQtb2YtcmVsYXRlZC1wcm9kdWN0cy1kYXRhP3RtcGw9bWFya2Rvd24=) or [Create an account](/register) to join the conversation. - **[PhilP](/forum/user/5076-philp "View PhilP's Profile")** - [![PhilP's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/5076-philp "View PhilP's Profile") Topic Author - [ Offline](/forum/user/5076-philp) Less More - Posts: 44 - Thank you received: 1 - - 14 years 6 months ago [\#48879](#48879) by [PhilP](/forum/user/5076-philp "View PhilP's Profile") Replied by *[PhilP](/forum/user/5076-philp "View PhilP's Profile")* on topic *[Re: Import of related products data](/forum/3-bug-report/48737-import-of-related-products-data#48879 "Hi, I have just been updating our site, in particular with new 'related products'. We several hundred of these to do so I created an import file and, just for convenience, organised it with a format similar to the simplified one below: product_code,related xxTest_Product_Top2,TD_2180058 xxTest_Product_Top2,TD_2214419 Although the above import correctly attaches both related products to the main product, it completely erases pretty much everything else, including: The product name The product description The product category The product image etc etc However,the following format works fine, keeping all the other product information intact: product_code,related xxTest_Product_Top2,TD_2180058;TD_2214419 I have used related product imports before but each line has started with a new product code, not a repeat of the same product code. That type of import also works fine. The problem seems to be where the product code is a repeat of the line that precedes it. It behaves the same whether the import is from CSV or from the text area. Regards PhilP")* OK Nicolas - thanks. Now I know, I can work with it. It would be useful to have a warning about this in the user documentation the next time you update it. Regards PhilP Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzMtYnVnLXJlcG9ydC80ODczNy1pbXBvcnQtb2YtcmVsYXRlZC1wcm9kdWN0cy1kYXRhP3RtcGw9bWFya2Rvd24=) or [Create an account](/register) 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: 86322 - Thank you received: 14281 - - 14 years 6 months ago [\#48898](#48898) 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 related products data](/forum/3-bug-report/48737-import-of-related-products-data#48898 "Hi, I have just been updating our site, in particular with new 'related products'. We several hundred of these to do so I created an import file and, just for convenience, organised it with a format similar to the simplified one below: product_code,related xxTest_Product_Top2,TD_2180058 xxTest_Product_Top2,TD_2214419 Although the above import correctly attaches both related products to the main product, it completely erases pretty much everything else, including: The product name The product description The product category The product image etc etc However,the following format works fine, keeping all the other product information intact: product_code,related xxTest_Product_Top2,TD_2180058;TD_2214419 I have used related product imports before but each line has started with a new product code, not a repeat of the same product code. That type of import also works fine. The problem seems to be where the product code is a repeat of the line that precedes it. It behaves the same whether the import is from CSV or from the text area. Regards PhilP")* Yes. We'll add that warning. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzMtYnVnLXJlcG9ydC80ODczNy1pbXBvcnQtb2YtcmVsYXRlZC1wcm9kdWN0cy1kYXRhP3RtcGw9bWFya2Rvd24=) or [Create an account](/register) 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.081 seconds [Powered by](/forum/credits) [Kunena Forum](https://www.kunena.org)