What triggers products to appear in the specials block ?

[puffdade]

Hi Guys 

 

what actually triggers products to appear in the specials block ?

opening up the module just gives you 1 basic function  either show or don't show  Im using 1.5.4.1

 

Just curious as I have never seen a product in mine

[Paulito]

Good morning

 

Giving a product a price reduction should then send it to Price Drop and Specials module.

 

Paul

[vekia]

Product::getRandomSpecial with query:

$sql = 'SELECT product_shop.id_product, MAX(product_attribute_shop.id_product_attribute) id_product_attribute
					FROM `'._DB_PREFIX_.'product` p
					'.Shop::addSqlAssociation('product', 'p').'
					LEFT JOIN  `'._DB_PREFIX_.'product_attribute` pa ON (product_shop.id_product = pa.id_product)
					'.Shop::addSqlAssociation('product_attribute', 'pa', false, 'product_attribute_shop.default_on = 1').'
                    '.Product::sqlStock('p', 0).'
					WHERE product_shop.`active` = 1 AND stock.`quantity`>0
						'.(($ids_product) ? $ids_product : '').'
						AND p.`id_product` IN (
							SELECT cp.`id_product`
							FROM `'._DB_PREFIX_.'category_group` cg
							LEFT JOIN `'._DB_PREFIX_.'category_product` cp ON (cp.`id_category` = cg.`id_category`)
							WHERE cg.`id_group` '.$sql_groups.'
						)
					'.($front ? ' AND product_shop.`visibility` IN ("both", "catalog")' : '').'
					GROUP BY product_shop.id_product
					ORDER BY RAND()';

it mean that products from these modules / features are with special price (defined under prices tab in each product edit page)

[puffdade]

Thanks guys  always on the ball with an answer  wait until I fire up this afternoons question