Link to product list belonging to a specific Cart Rule

[dformica2]

Is there a way to link to a list of products that belong to a specific cart rule?
I'm looking to create home page advertisements to certain promotions that I'm running.

 

[rocky]

You can use something like this to get the products related to a cart rule:

$result = Db::getInstance()->ExecuteS(
    'SELECT `id_item`
    FROM `'._DB_PREFIX_.'cart_rule_product_rule_value`
    WHERE `id_product_rule` = 1'
);

Change 1 to the ID of the product rule inside your cart rule. You can check the ps_cart_product_rule_value table in your database using phpMyAdmin to try to find the right ID.