Skip to content

Day: January 12, 2016

Published January 12, 2016

Magento : Get product collection has tier price only

here my script get product collection who has tier price only!!!!!!!!!!!!!!!!!! of course also in stock :p

$prefix = Mage::getConfig()->getTablePrefix();

$sql = 'select distinct  entity_id from '.$prefix.'catalog_product_entity_tier_price';
		
$resource = Mage::getSingleton('core/resource');
$readConnection = $resource->getConnection('core_read');
$results = $readConnection->fetchCol($sql);
		
/* base collection */
		
$mod = Mage::getModel('catalog/product')
		      ->getCollection()
		      ->addAttributeToFilter('entity_id',array('in'=>$results))
				
				;
$mod->joinField('is_in_stock', 'cataloginventory/stock_item', 'is_in_stock', 'product_id=entity_id', '{{table}}.stock_id=1', 'left');
$mod->addAttributeToFilter('is_in_stock', array('eq' => 1));
		
print_r($mod->getData());

1

2

3

4

5

6

7

8

9

10

11

12

13

14

15

16

17

18

19

$prefix = Mage::getConfig()->getTablePrefix();

$sql = 'select distinct entity_id from '.$prefix.'catalog_product_entity_tier_price';

$resource = Mage::getSingleton('core/resource');

$readConnection = $resource->getConnection('core_read');

$results = $readConnection->fetchCol($sql);

/* base collection */

$mod = Mage::getModel('catalog/product')

->getCollection()

->addAttributeToFilter('entity_id',array('in'=>$results))

;

$mod->joinField('is_in_stock', 'cataloginventory/stock_item', 'is_in_stock', 'product_id=entity_id', '{{table}}.stock_id=1', 'left');

$mod->addAttributeToFilter('is_in_stock', array('eq' => 1));

print_r($mod->getData());

Continue reading Magento : Get product collection has tier price only

Comments closed

Published January 12, 2016

Filter Payment & Shipping Method on Checkout Page

To filter Payment Method Options we can use observer, i assume you have knowledge of Magento module development, anyway let’s begin on config.xml, register an event…

Continue reading Filter Payment & Shipping Method on Checkout Page

Comments closed