Related Products

[esterms]

Hi!

 

I'm working with prestashop in a project that connects two databases (MySQL and SQLSERVER), so I have to work with prestashop in database level. I've been successful with transfering products and categories, but I would like to  know how does prestashop save in MySQL the information of related products, in wich table, or, in default, where is it saved?

I'm talking about prestashop's default related products, not any extra module. In the product page in basic settings tab: add related product option.

Thank you and sorry for my english!

 

 

[s.kick]

Hi, 

I have a quite similar problem!

I would like to add several Products to a single Product using the related products function. So no additional Module is needed for it, because it does what I want! Except I want to import this data, but I don't find anything in the Database and without knowing the table I can't import it! The import function don't do it, either! 

What do I miss?
Where is this data saved and why is there no option to import it?

Is this data saved in some kind of json file and not in the database? Where can I find this file to edit it manually?

 

Any answers would be nice!

Edited October 12, 2017 by s.kick (see edit history)

[s.kick]

The table is called "prefix_accessory"      ... I finally found it out through google and searching in several Boards! Typically right after making my post here!   

May be "product_accessory" or "product_related_products" would be a better name!