Posted By

simsevu on 10/20/11

Tagged

Versions (?)

Last Edited at 10/20/11 07:20pm

Statistics

Viewed 736 times

Favorited by 0 user(s)

Related snippets

Average discount in magento 1.4.1

/ Published in: MySQL

Expand | Embed | Plain Text

Copy this code and paste it in your HTML

// AVERAGE SAVINGS ON SIMPLE PRODUCTS
SELECT (1-AVG(t1.final_price /t1.price))*100  
	FROM catalog_product_index_price AS t1
	JOIN catalog_product_entity AS t2
		ON t1.entity_id = t2.entity_id
	WHERE (t1.customer_group_id = 0 AND t1.website_id = 1)
		AND (t1.final_price > 0 AND t1.price > 0)
		AND t2.type_id = 'simple'
 
 
// AVERAGE PRICE ON SIMPLE PRODUCTS
SELECT AVG(t1.final_price) 
	FROM catalog_product_index_price AS t1
	JOIN catalog_product_entity AS t2
		ON t1.entity_id = t2.entity_id
	WHERE (t1.customer_group_id = 0 AND t1.website_id = 1)
		AND (t1.final_price > 0 AND t1.price > 0)
		AND t2.type_id = 'simple'
 
// AVERAGE PRICE ON BUNDLED PRODUCTS
SELECT AVG(t1.min_price) 
	FROM catalog_product_index_price AS t1
	JOIN catalog_product_entity AS t2
		ON t1.entity_id = t2.entity_id
	WHERE (t1.customer_group_id = 0 AND t1.website_id = 1)
		AND (t1.final_price > 0 AND t1.price > 0)
		AND t2.type_id = 'bundle'