PS 1.7.6.1 - associated supplier and default supplier

[Autostore]

Hi everyone,

Here is my situation:  I have 2765 products in my shop. Want to assigned them to the supplier X. I have found where the default supplier is located in the database - psdy_product column id_supplier. But I did not fine where the "Choose the suppliers associated with this product" and that is what I want to change, because I am about to import some 1000 products from another supplier Y and want to have them separated accordingly. 

Q1: how do I assign multiple products to supplier X, so that I can also see them in BO. Right now I do not, even with the default supplier set to X (id_supplier=1 in my case) ?

Q2: is the "default supplier" considered default for my shop, or just the default supplier for that specific product?

Thank you in advance

[Autostore]

Anybody? 

[Tintai]

On 11/4/2019 at 6:59 PM, Autostore said:

Anybody? 

Hi, did you found the solution?

[rrataj]

There is a table called `id_product_supplier`, where you need to add new row per product to link product with a supplier. This should work.