Tutorial how to import/link product accessories from excel (dangrous)

[ctech]

ok make a excel file call it something but make sure you name the excel sheet (your table prefix)_accessory in my case ps_accessory.

id_product_1 will be you main product, id_product_2 is the related part that will show up in the accessories tab on the product detail page in the front office.
two columns, the first row is optional
id_product_1 id_product_2
10 9
10 58
10 41
10 38
10 13
10 17
10 14
10 27
9 22
9 58
9 21
9 52

now log into phpmyadmin. if hosting24 is your hosting provider point your browser http://ip:2082/3rdparty/phpMyAdmin/index.php
select your database on the left
select ps_accessory on the left
click on import, pick your file and select skip first line if you used column headers.
if everything goes well you now have related products in the accessories tab

[kikesainz]

Thanks, buddy!