[Skip to main content](#vessel-content) # Problems linking related products ## - **[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 9 months ago [\#36018](#36018) by [PhilP](/forum/user/5076-philp "View PhilP's Profile") *[Problems linking related products](/forum/4-how-to/36018-problems-linking-related-products#36018 "Hi, I am experiencing problems linking newly defined products with products that already exist within my Hikashop database. The two example datasets below illustrate the problem: product_name,product_code,related testprod1,testprod1-ABCD,"" testprod2,testprod2,testprod1-ABCD The dataset above creates the two new products and links testprod1 to the second product testprod2 product_name,product_code,related testprod1,testprod1-ABCD,"" testprod2,testprod2,2214419;testprod1-ABCD The second dataset above also creates testprod1 and testprod2 OK. It also links creates the link so that testprod1 becomes related to testprod2. However, it refuses to link the other product (2214419, which exists elsewhere within my Hikashop database) to successfully with testprod2. Help appreciated. PhilP Hikashop Business 1.5.4 user")* was created by *[PhilP](/forum/user/5076-philp "View PhilP's Profile")* Hi, I am experiencing problems linking newly defined products with products that already exist within my Hikashop database. The two example datasets below illustrate the problem: product_name,product_code,related testprod1,testprod1-ABCD,"" testprod2,testprod2,testprod1-ABCD The dataset above creates the two new products and links testprod1 to the second product testprod2 product_name,product_code,related testprod1,testprod1-ABCD,"" testprod2,testprod2,2214419;testprod1-ABCD The second dataset above also creates testprod1 and testprod2 OK. It also links creates the link so that testprod1 becomes related to testprod2. However, it refuses to link the other product (2214419, which exists elsewhere within my Hikashop database) to successfully with testprod2. Help appreciated. PhilP Hikashop Business 1.5.4 user Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQtaG93LXRvLzM2MDE4LXByb2JsZW1zLWxpbmtpbmctcmVsYXRlZC1wcm9kdWN0cz90bXBsPW1hcmtkb3du) 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: 86283 - Thank you received: 14262 - - 14 years 9 months ago [\#36052](#36052) 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 linking related products](/forum/4-how-to/36018-problems-linking-related-products#36052 "Hi, I am experiencing problems linking newly defined products with products that already exist within my Hikashop database. The two example datasets below illustrate the problem: product_name,product_code,related testprod1,testprod1-ABCD,"" testprod2,testprod2,testprod1-ABCD The dataset above creates the two new products and links testprod1 to the second product testprod2 product_name,product_code,related testprod1,testprod1-ABCD,"" testprod2,testprod2,2214419;testprod1-ABCD The second dataset above also creates testprod1 and testprod2 OK. It also links creates the link so that testprod1 becomes related to testprod2. However, it refuses to link the other product (2214419, which exists elsewhere within my Hikashop database) to successfully with testprod2. Help appreciated. PhilP Hikashop Business 1.5.4 user")* Hi, You shouldn't use 2214419 but the product code of your already existing product. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQtaG93LXRvLzM2MDE4LXByb2JsZW1zLWxpbmtpbmctcmVsYXRlZC1wcm9kdWN0cz90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) 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 9 months ago [\#36098](#36098) by [PhilP](/forum/user/5076-philp "View PhilP's Profile") Replied by *[PhilP](/forum/user/5076-philp "View PhilP's Profile")* on topic *[Re: Problems linking related products](/forum/4-how-to/36018-problems-linking-related-products#36098 "Hi, I am experiencing problems linking newly defined products with products that already exist within my Hikashop database. The two example datasets below illustrate the problem: product_name,product_code,related testprod1,testprod1-ABCD,"" testprod2,testprod2,testprod1-ABCD The dataset above creates the two new products and links testprod1 to the second product testprod2 product_name,product_code,related testprod1,testprod1-ABCD,"" testprod2,testprod2,2214419;testprod1-ABCD The second dataset above also creates testprod1 and testprod2 OK. It also links creates the link so that testprod1 becomes related to testprod2. However, it refuses to link the other product (2214419, which exists elsewhere within my Hikashop database) to successfully with testprod2. Help appreciated. PhilP Hikashop Business 1.5.4 user")* Yes, the product code 2214419 does already exist in Hikashop. It was created earlier. I have just spent 1/2 hour testing this more fully and attach a file showing what I found. It seems that Hikashop does not like numeric values only when looking for related products. It will link a product name, an alpha-only product code, an alphanumeric product code and a numeric value which matches a product ID (i.e. a Joomla entity ID) However it does not seem to find a product code which is numeric only. Hope that helps Regards PhilP #### *This attachment is hidden for guests. Please log in or register to see it.* Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQtaG93LXRvLzM2MDE4LXByb2JsZW1zLWxpbmtpbmctcmVsYXRlZC1wcm9kdWN0cz90bXBsPW1hcmtkb3du) 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: 86283 - Thank you received: 14262 - - 14 years 9 months ago [\#36100](#36100) 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 linking related products](/forum/4-how-to/36018-problems-linking-related-products#36100 "Hi, I am experiencing problems linking newly defined products with products that already exist within my Hikashop database. The two example datasets below illustrate the problem: product_name,product_code,related testprod1,testprod1-ABCD,"" testprod2,testprod2,testprod1-ABCD The dataset above creates the two new products and links testprod1 to the second product testprod2 product_name,product_code,related testprod1,testprod1-ABCD,"" testprod2,testprod2,2214419;testprod1-ABCD The second dataset above also creates testprod1 and testprod2 OK. It also links creates the link so that testprod1 becomes related to testprod2. However, it refuses to link the other product (2214419, which exists elsewhere within my Hikashop database) to successfully with testprod2. Help appreciated. PhilP Hikashop Business 1.5.4 user")* Yes, if you use a numeric value for a product code in related, options column, the system will assume that you're referring to a product id and not a product code. So you should refrain from using only numbers in product codes if you plan to use them in a CSV import. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQtaG93LXRvLzM2MDE4LXByb2JsZW1zLWxpbmtpbmctcmVsYXRlZC1wcm9kdWN0cz90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) 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 9 months ago [\#36101](#36101) by [PhilP](/forum/user/5076-philp "View PhilP's Profile") Replied by *[PhilP](/forum/user/5076-philp "View PhilP's Profile")* on topic *[Re: Problems linking related products](/forum/4-how-to/36018-problems-linking-related-products#36101 "Hi, I am experiencing problems linking newly defined products with products that already exist within my Hikashop database. The two example datasets below illustrate the problem: product_name,product_code,related testprod1,testprod1-ABCD,"" testprod2,testprod2,testprod1-ABCD The dataset above creates the two new products and links testprod1 to the second product testprod2 product_name,product_code,related testprod1,testprod1-ABCD,"" testprod2,testprod2,2214419;testprod1-ABCD The second dataset above also creates testprod1 and testprod2 OK. It also links creates the link so that testprod1 becomes related to testprod2. However, it refuses to link the other product (2214419, which exists elsewhere within my Hikashop database) to successfully with testprod2. Help appreciated. PhilP Hikashop Business 1.5.4 user")* Ok - thanks. All of our products have numeric-only product codes and there is no problem in doing the initial import with them. I will use the product names to link the related products rather than the product codes. It would be good to see Hikashop help updated to clarify this restriction. Also, perhaps add the use of numeric-only product codes to link related products to the development wish list? ![:)](/media/kunena/emoticons/8.png ":)") Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQtaG93LXRvLzM2MDE4LXByb2JsZW1zLWxpbmtpbmctcmVsYXRlZC1wcm9kdWN0cz90bXBsPW1hcmtkb3du) 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: 86283 - Thank you received: 14262 - - 14 years 9 months ago [\#36151](#36151) 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 linking related products](/forum/4-how-to/36018-problems-linking-related-products#36151 "Hi, I am experiencing problems linking newly defined products with products that already exist within my Hikashop database. The two example datasets below illustrate the problem: product_name,product_code,related testprod1,testprod1-ABCD,"" testprod2,testprod2,testprod1-ABCD The dataset above creates the two new products and links testprod1 to the second product testprod2 product_name,product_code,related testprod1,testprod1-ABCD,"" testprod2,testprod2,2214419;testprod1-ABCD The second dataset above also creates testprod1 and testprod2 OK. It also links creates the link so that testprod1 becomes related to testprod2. However, it refuses to link the other product (2214419, which exists elsewhere within my Hikashop database) to successfully with testprod2. Help appreciated. PhilP Hikashop Business 1.5.4 user")* There is nothing to do unfortunately. It's not only for related items but for everything else too. If you create a category called 111 and that you try to assign a product of your CSV to that category, it won't work too because the system will consider that you're giving a category id. That allows the products import to be a lot more efficient as it doesn't have to check in the database to know if a category (or a product) already exists with that id or with that name as it assumes that if an integer is given, it's an id. Because of that, we don't plan to change the way it's done for now. The following user(s) said Thank You: [PhilP](/forum/user/5076-philp "View PhilP's Profile") Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQtaG93LXRvLzM2MDE4LXByb2JsZW1zLWxpbmtpbmctcmVsYXRlZC1wcm9kdWN0cz90bXBsPW1hcmtkb3du) 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.165 seconds [Powered by](/forum/credits) [Kunena Forum](https://www.kunena.org) [](#top)