[Solved] Insert manufacturers for existing product in database

[sweszler]

First, sorry for my english. One part of my module that I create is importing manufacturers for existing products. I use:

Db::getInstance()->insert('manufacturer', array(
            'name' => $producent,
            'date_add' => date("Y-m-d H:i:s"),
            'active' => 1
        ));

 $id_manufacturer = $this->get_id_manu_by_name($producent);

 

        Db::getInstance()->insert('manufacturer_lang', array(

            'id_manufacturer' => $id_manufacturer,

            'id_lang' => 1,

        ));

 

        Db::getInstance()->insert('manufacturer_shop', array(

            'id_manufacturer' => $id_manufacturer,

            'id_shop' => 1,

        ));

and after that I update the product table:

Db::getInstance()->update('product', array(
            'id_manufacturer' => intval($id_manufacturer),
                ), 'id_product = "' . (int) $id_product . '"');

I have right id_manufacturer in product table. When i edit product in back office, manufacturer is set, but in front office I can't see this product on my manufacturer page. This works properly only after save again product in back office.

How can I fix it?

Edited April 22, 2015 by sweszler (see edit history)

[sandipchandela]

What you want do exactly?

1) Want to create manufacturers 

2) Want to associate/assign manufacturers with products. ?

 

which PS Version u r using?

[sweszler]

Thanks for response.

I want to associate/assign manufacturers with product exactly. I'm using PS 1.5.6.2.

[sandipchandela]

$id_product=10;
//product id will be 10 

$id_manufacturer=5;
//manufacturer id will be 5
Db::getInstance()->update('product', array(
'id_manufacturer' => intval($id_manufacturer),
), 'id_product = "' . (int) $id_product . '"');

Fire this query.

[sweszler]

OK, I got it, successfully updated. I have in database in my product table id_manufacturer = 5. What next must be updated to display this product on manufacturer page in front office ?

[tuk66]

You should use object approach instead of database one. Try:

$product = new Product($id_product);
$product->id_manufacturer = (int)$id_manufacturer;
$product->save();

[sweszler]

Great, It works! Thank you tuk66.

Edited April 22, 2015 by sweszler (see edit history)