[Skip to main content](#vessel-content) # related products issue ## - **[plumbingdeals](/forum/user/3607-plumbingdeals "View plumbingdeals's Profile")** - [![plumbingdeals's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/3607-plumbingdeals "View plumbingdeals's Profile") Topic Author - [ Offline](/forum/user/3607-plumbingdeals) Less More - Posts: 223 - Thank you received: 1 - - 14 years 8 months ago [\#40321](#40321) by [plumbingdeals](/forum/user/3607-plumbingdeals "View plumbingdeals's Profile") *[related products issue](/forum/3-bug-report/40321-related-products-issue#40321 "we have about 50 sku's that when we try to update via csv file with related products, the relateds are not taking. if we relate these by hand through the admin it is fine. when we do an export of the product file, the sku's in question simply show an ";", no quotes, in the related column. these are 50 out of several hundred, all uploaded the same, and i can't seem to find the error. any ideas? thanks")* was created by *[plumbingdeals](/forum/user/3607-plumbingdeals "View plumbingdeals's Profile")* we have about 50 sku's that when we try to update via csv file with related products, the relateds are not taking. if we relate these by hand through the admin it is fine. when we do an export of the product file, the sku's in question simply show an ";", no quotes, in the related column. these are 50 out of several hundred, all uploaded the same, and i can't seem to find the error. any ideas? thanks Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzMtYnVnLXJlcG9ydC80MDMyMS1yZWxhdGVkLXByb2R1Y3RzLWlzc3VlP3RtcGw9bWFya2Rvd24=) 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 8 months ago [\#40524](#40524) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Re: related products issue](/forum/3-bug-report/40321-related-products-issue#40524 "we have about 50 sku's that when we try to update via csv file with related products, the relateds are not taking. if we relate these by hand through the admin it is fine. when we do an export of the product file, the sku's in question simply show an ";", no quotes, in the related column. these are 50 out of several hundred, all uploaded the same, and i can't seem to find the error. any ideas? thanks")* Hi, It's working fine on our end. Could you give some sample of your CSVs so that we can see what you have ? Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzMtYnVnLXJlcG9ydC80MDMyMS1yZWxhdGVkLXByb2R1Y3RzLWlzc3VlP3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[plumbingdeals](/forum/user/3607-plumbingdeals "View plumbingdeals's Profile")** - [![plumbingdeals's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/3607-plumbingdeals "View plumbingdeals's Profile") Topic Author - [ Offline](/forum/user/3607-plumbingdeals) Less More - Posts: 223 - Thank you received: 1 - - 14 years 8 months ago [\#40822](#40822) by [plumbingdeals](/forum/user/3607-plumbingdeals "View plumbingdeals's Profile") Replied by *[plumbingdeals](/forum/user/3607-plumbingdeals "View plumbingdeals's Profile")* on topic *[Re: related products issue](/forum/3-bug-report/40321-related-products-issue#40822 "we have about 50 sku's that when we try to update via csv file with related products, the relateds are not taking. if we relate these by hand through the admin it is fine. when we do an export of the product file, the sku's in question simply show an ";", no quotes, in the related column. these are 50 out of several hundred, all uploaded the same, and i can't seem to find the error. any ideas? thanks")* i have attached file with examples. *This attachment is hidden for guests. Please log in or register to see it.* [ ![20069.png](/forum/attachment/2883) ](/forum/attachment/2883 "20069.png") also, here is a shot of how one of the items looks in the admin: - [ ![20069.png](/forum/attachment/2883) ](/forum/attachment/2883 "20069.png") [ ](/forum/attachment/2883?download=1 "20069.png") Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzMtYnVnLXJlcG9ydC80MDMyMS1yZWxhdGVkLXByb2R1Y3RzLWlzc3VlP3RtcGw9bWFya2Rvd24=) 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 8 months ago [\#41031](#41031) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Re: related products issue](/forum/3-bug-report/40321-related-products-issue#41031 "we have about 50 sku's that when we try to update via csv file with related products, the relateds are not taking. if we relate these by hand through the admin it is fine. when we do an export of the product file, the sku's in question simply show an ";", no quotes, in the related column. these are 50 out of several hundred, all uploaded the same, and i can't seem to find the error. any ideas? thanks")* The problem is that your SKU is an integer. So when HikaShop import the related products, it thinks that you're giving him the product id and not the product code. That's why you get the blank line in the related products listing. You should either use product ids for the related option or use not use integers for SKUs. Next version of HikaShop, we'll improve the import to allow the import of related products with integers for product codes. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzMtYnVnLXJlcG9ydC80MDMyMS1yZWxhdGVkLXByb2R1Y3RzLWlzc3VlP3RtcGw9bWFya2Rvd24=) 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.062 seconds [Powered by](/forum/credits) [Kunena Forum](https://www.kunena.org)