[Skip to main content](#vessel-content) # Import Products "Related products" ## - **[argyweb](/forum/user/410-argyweb "View argyweb's Profile")** - [![argyweb's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/410-argyweb "View argyweb's Profile") Topic Author - [ Offline](/forum/user/410-argyweb) Less More - Posts: 9 - Thank you received: 0 - - 15 years 10 months ago [\#4477](#4477) by [argyweb](/forum/user/410-argyweb "View argyweb's Profile") *[Import Products "Related products"](/forum/3-bug-report/4477-import-products-related-products#4477 "Hello, I'm importing products to HikaShop Business Edition. I've tried through CSV and TextArea, and both times I'm having the same problem. Related products are not getting inside the database. The import is creating just one row on the database (hikashop_product_related) where product_related_id is 0. Example: images,product_code,product_name,categories,nombre,club,marca,posicion,related,dorsal,sleeve_shirt,tipo_pantalon,color_shirt,color_pant,sunglasses rieragaia00_00001.jpg,product1,Riera de Gaia 00_00001,14,DANI MENGUAL APARICIO,RUNNERSWORLD TARRAGONA M,0:33:29,2,"product2,product3",444,0,0,0,0,0 rieragaia00_00002.jpg,product2,Riera de Gaia 00_00002,14,FERRAN DE TORRES BURGOS,RUNNERSWORLD TARRAGONA M,0:33:51,3,"product3",401,0,0,0,0,0 rieragaia00_00003.jpg,product3,Riera de Gaia 00_00003,14,FERRAN DE TORRES BURGOS,RUNNERSWORLD TARRAGONA M,0:33:51,3,"product2",401,0,0,0,0,0 I've tried different options, and the result is always the same. Waiting for your answer")* was created by *[argyweb](/forum/user/410-argyweb "View argyweb's Profile")* Hello, I'm importing products to HikaShop Business Edition. I've tried through CSV and TextArea, and both times I'm having the same problem. Related products are not getting inside the database. The import is creating just one row on the database (hikashop_product_related) where product_related_id is 0. Example: images,product_code,product_name,categories,nombre,club,marca,posicion,related,dorsal,sleeve_shirt,tipo_pantalon,color_shirt,color_pant,sunglasses rieragaia00_00001.jpg,product1,Riera de Gaia 00_00001,14,DANI MENGUAL APARICIO,RUNNERSWORLD TARRAGONA M,0:33:29,2,"product2,product3",444,0,0,0,0,0 rieragaia00_00002.jpg,product2,Riera de Gaia 00_00002,14,FERRAN DE TORRES BURGOS,RUNNERSWORLD TARRAGONA M,0:33:51,3,"product3",401,0,0,0,0,0 rieragaia00_00003.jpg,product3,Riera de Gaia 00_00003,14,FERRAN DE TORRES BURGOS,RUNNERSWORLD TARRAGONA M,0:33:51,3,"product2",401,0,0,0,0,0 I've tried different options, and the result is always the same. Waiting for your answer Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzMtYnVnLXJlcG9ydC80NDc3LWltcG9ydC1wcm9kdWN0cy1yZWxhdGVkLXByb2R1Y3RzP3RtcGw9bWFya2Rvd24=) 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") - [ Away](/forum/user/63-nicolas) Less More - Posts: 86555 - Thank you received: 14304 - - 15 years 10 months ago [\#4481](#4481) 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 Products "Related products"](/forum/3-bug-report/4477-import-products-related-products#4481 "Hello, I'm importing products to HikaShop Business Edition. I've tried through CSV and TextArea, and both times I'm having the same problem. Related products are not getting inside the database. The import is creating just one row on the database (hikashop_product_related) where product_related_id is 0. Example: images,product_code,product_name,categories,nombre,club,marca,posicion,related,dorsal,sleeve_shirt,tipo_pantalon,color_shirt,color_pant,sunglasses rieragaia00_00001.jpg,product1,Riera de Gaia 00_00001,14,DANI MENGUAL APARICIO,RUNNERSWORLD TARRAGONA M,0:33:29,2,"product2,product3",444,0,0,0,0,0 rieragaia00_00002.jpg,product2,Riera de Gaia 00_00002,14,FERRAN DE TORRES BURGOS,RUNNERSWORLD TARRAGONA M,0:33:51,3,"product3",401,0,0,0,0,0 rieragaia00_00003.jpg,product3,Riera de Gaia 00_00003,14,FERRAN DE TORRES BURGOS,RUNNERSWORLD TARRAGONA M,0:33:51,3,"product2",401,0,0,0,0,0 I've tried different options, and the result is always the same. Waiting for your answer")* Hi, That is indeed the case with the current release. If you import the CSV a second time, the products will have their related products fixed (with version 1.4.1 you have an option to option the products' information using the CSV data). It's already fixed on our end and will be corrected for next release which is to come out today or tomorrow. I also recommand you to revert the order of your products. The referenced product should be first and only then the product using it as a related product. Otherwise, even with the fix, the related link won't be inserted properly in some special cases (we import the products per batches of 50 products, so if a referenced product is in a following batch the current product won't have the link made properly unless you import your file a second time). Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzMtYnVnLXJlcG9ydC80NDc3LWltcG9ydC1wcm9kdWN0cy1yZWxhdGVkLXByb2R1Y3RzP3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[argyweb](/forum/user/410-argyweb "View argyweb's Profile")** - [![argyweb's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/410-argyweb "View argyweb's Profile") Topic Author - [ Offline](/forum/user/410-argyweb) Less More - Posts: 9 - Thank you received: 0 - - 15 years 10 months ago [\#4487](#4487) by [argyweb](/forum/user/410-argyweb "View argyweb's Profile") Replied by *[argyweb](/forum/user/410-argyweb "View argyweb's Profile")* on topic *[Re: Import Products "Related products"](/forum/3-bug-report/4477-import-products-related-products#4487 "Hello, I'm importing products to HikaShop Business Edition. I've tried through CSV and TextArea, and both times I'm having the same problem. Related products are not getting inside the database. The import is creating just one row on the database (hikashop_product_related) where product_related_id is 0. Example: images,product_code,product_name,categories,nombre,club,marca,posicion,related,dorsal,sleeve_shirt,tipo_pantalon,color_shirt,color_pant,sunglasses rieragaia00_00001.jpg,product1,Riera de Gaia 00_00001,14,DANI MENGUAL APARICIO,RUNNERSWORLD TARRAGONA M,0:33:29,2,"product2,product3",444,0,0,0,0,0 rieragaia00_00002.jpg,product2,Riera de Gaia 00_00002,14,FERRAN DE TORRES BURGOS,RUNNERSWORLD TARRAGONA M,0:33:51,3,"product3",401,0,0,0,0,0 rieragaia00_00003.jpg,product3,Riera de Gaia 00_00003,14,FERRAN DE TORRES BURGOS,RUNNERSWORLD TARRAGONA M,0:33:51,3,"product2",401,0,0,0,0,0 I've tried different options, and the result is always the same. Waiting for your answer")* Thanks!!!! Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzMtYnVnLXJlcG9ydC80NDc3LWltcG9ydC1wcm9kdWN0cy1yZWxhdGVkLXByb2R1Y3RzP3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[rshenje](/forum/user/4439-rshenje "View rshenje's Profile")** - [![rshenje's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/4439-rshenje "View rshenje's Profile") - [ Offline](/forum/user/4439-rshenje) Less More - Posts: 21 - Thank you received: 0 - - 14 years 11 months ago [\#30076](#30076) by [rshenje](/forum/user/4439-rshenje "View rshenje's Profile") Replied by *[rshenje](/forum/user/4439-rshenje "View rshenje's Profile")* on topic *[Re: Import Products "Related products"](/forum/3-bug-report/4477-import-products-related-products#30076 "Hello, I'm importing products to HikaShop Business Edition. I've tried through CSV and TextArea, and both times I'm having the same problem. Related products are not getting inside the database. The import is creating just one row on the database (hikashop_product_related) where product_related_id is 0. Example: images,product_code,product_name,categories,nombre,club,marca,posicion,related,dorsal,sleeve_shirt,tipo_pantalon,color_shirt,color_pant,sunglasses rieragaia00_00001.jpg,product1,Riera de Gaia 00_00001,14,DANI MENGUAL APARICIO,RUNNERSWORLD TARRAGONA M,0:33:29,2,"product2,product3",444,0,0,0,0,0 rieragaia00_00002.jpg,product2,Riera de Gaia 00_00002,14,FERRAN DE TORRES BURGOS,RUNNERSWORLD TARRAGONA M,0:33:51,3,"product3",401,0,0,0,0,0 rieragaia00_00003.jpg,product3,Riera de Gaia 00_00003,14,FERRAN DE TORRES BURGOS,RUNNERSWORLD TARRAGONA M,0:33:51,3,"product2",401,0,0,0,0,0 I've tried different options, and the result is always the same. Waiting for your answer")* Preparing CSV for import. I want to complete the "related" column with a view to having related products showing up in seperate window on front end. What I really want is CDs from same artist appearing in related items window. There is no explanation anywhere as to how the "related" column is populated. Because that information is lacking, I am not even sure if this is the best way to relate the products. For example, there may just be a better way of filtering using artist field if I create one in Display>> custom fields? Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzMtYnVnLXJlcG9ydC80NDc3LWltcG9ydC1wcm9kdWN0cy1yZWxhdGVkLXByb2R1Y3RzP3RtcGw9bWFya2Rvd24=) 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") - [ Away](/forum/user/63-nicolas) Less More - Posts: 86555 - Thank you received: 14304 - - 14 years 11 months ago [\#30096](#30096) 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 Products "Related products"](/forum/3-bug-report/4477-import-products-related-products#30096 "Hello, I'm importing products to HikaShop Business Edition. I've tried through CSV and TextArea, and both times I'm having the same problem. Related products are not getting inside the database. The import is creating just one row on the database (hikashop_product_related) where product_related_id is 0. Example: images,product_code,product_name,categories,nombre,club,marca,posicion,related,dorsal,sleeve_shirt,tipo_pantalon,color_shirt,color_pant,sunglasses rieragaia00_00001.jpg,product1,Riera de Gaia 00_00001,14,DANI MENGUAL APARICIO,RUNNERSWORLD TARRAGONA M,0:33:29,2,"product2,product3",444,0,0,0,0,0 rieragaia00_00002.jpg,product2,Riera de Gaia 00_00002,14,FERRAN DE TORRES BURGOS,RUNNERSWORLD TARRAGONA M,0:33:51,3,"product3",401,0,0,0,0,0 rieragaia00_00003.jpg,product3,Riera de Gaia 00_00003,14,FERRAN DE TORRES BURGOS,RUNNERSWORLD TARRAGONA M,0:33:51,3,"product2",401,0,0,0,0,0 I've tried different options, and the result is always the same. Waiting for your answer")* If you don't know how to fill a field of a CSV, just try with a real example via the interface of the back end and then do an export to see how that column is filled. In the case of the related column, it's just the codes of the related products separated with commas. To display the related products on product pages, you can follow the documentation there: [ www.hikashop.com/en/support/documentatio...ct-form.html#related](http://www.hikashop.com/en/support/documentation/integrated-documentation/19-hikashop-product-form.html#related) They will be displayed directly at the bottom of the product page. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzMtYnVnLXJlcG9ydC80NDc3LWltcG9ydC1wcm9kdWN0cy1yZWxhdGVkLXByb2R1Y3RzP3RtcGw9bWFya2Rvd24=) 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)