--- classes/Product.php	2025-06-25 11:48:14.266714154 +0200
+++ classes/Product.php	2025-06-27 15:17:53.585910710 +0200

@@ -3057,7 +3063,7 @@
 
         $sql = new DbQuery();
         $sql->select(
-            'p.*, product_shop.*, stock.`out_of_stock`, IFNULL(stock.`quantity`, 0) as quantity,
+            'p.*, sup.name as supplier_name,product_shop.*, stock.`out_of_stock`, IFNULL(stock.`quantity`, 0) as quantity,
             pl.`description`, pl.`description_short`, pl.`link_rewrite`, pl.`meta_description`,
             pl.`meta_title`, pl.`name`, pl.`available_now`, pl.`available_later`,
             image_shop.`id_image` id_image, il.`legend`, m.`name` AS manufacturer_name,
@@ -3081,13 +3087,15 @@
             'image_shop.`id_image` = il.`id_image`
             AND il.`id_lang` = '.(int)$id_lang
         );
+        $sql->leftJoin('supplier', 'sup',
+            'p.`id_supplier` = sup.`id_supplier`');
         $sql->leftJoin('manufacturer', 'm',
             'm.`id_manufacturer` = p.`id_manufacturer`
         ');