How to associate a supplier to all products in the store

[bacardi-rum]

Hi there,

 

I have a problem, I imported products without adding a default supplier. Now how can I associate a supplier that I have created in the shop through a query? I notice that ps_product_shop does not have a column for id_supplier but ps_product table has it. 

 

How to assign a supplier to all the products and make it default?

[bellini13]

You can execute the following SQL statement using phpmyadmin.  This will update every product to use supplier ID 1.  So before you execute this statement, make sure you know what supplier ID you want to use, and then replace '1' with that ID.

UPDATE `ps_product` SET `id_supplier` = '1';

Note: Since id_supplier is store in ps_product and not ps_product_shop, this means that when using multi-store, a product can only be defined to a single supplier for all stores in multi-store

[bacardi-rum]

Hi Belini, 

 

I ran your query but the problem is that the supplier shows up but is not set as the default. See the screen shot. 

 

The supplier is supposed to be selected as the default supplier. How would I achieve that?

Edited February 9, 2015 by bacardi-rum (see edit history)

[bellini13]

check if you have records in the ps_product_supplier table

 

if you do, then you likely need to update that table as well

[Autostore]

I have this issue, but the other way around: I have set id_supplier in psdy_product to 1. Now supplier with id=1 is default supplier for 2765 products, but, it is not set as Selected supplier. Have to do that manually, and when I do, the check-box for default supplier appears instantly. If I go to psdy_product_supplier I can only see 4 items there, the 4 products for which I have set manually selected supplier. Using Prestashop 1.7 can anybody help me also add all the products in the psdy_product_supplier ? Thanks