how to get variable product_supplier_reference in HelperList.php file

[easymar]

Hello.

I want to create products links dynamically in back office product list with product_supplier_reference variable.

 

It works for product_id ($id) but if I want to get product_supplier_reference its is empty.

 

To do this I change HelperList.php file and this is the last issue - get the product_supplier_reference.

 

 

Can someone give me an advice how to do this?

[easymar]

Solution is:

 

 $ref = (int)Db::getInstance()->getValue('

               SELECT reference

               FROM `'._DB_PREFIX_.'product`

                WHERE `id_product` = '.$id

               );

 

 

$ref - gives supplier_reference