Attributeset

Getting orders with items that have a certain attribute set (Magento 1)

Mex 2014/03/03 Magento Solutions

The following MySQL query returns all Magento orders that have at least one item with attribute set id 9.

/* 9 = attribute set Id */
select
	increment_id,
	created_at,
	entity_id 
from
	sales_flat_order 
where
	entity_id not in (
		SELECT
			o.entity_id      
		FROM
			sales_flat_order o      
		LEFT JOIN
			sales_flat_order_item i        
				ON o.entity_id = i.order_id      
		LEFT JOIN
			catalog_product_entity p        
				ON i.product_id = p.entity_id      
		WHERE
			p.attribute_set_id = 9
	)

/* 9 = attribute set Id */

select

increment_id,

created_at,

entity_id

from

sales_flat_order

where

entity_id not in (

SELECT

o.entity_id

FROM

sales_flat_order o

LEFT JOIN

sales_flat_order_item i

ON o.entity_id = i.order_id

LEFT JOIN

catalog_product_entity p

ON i.product_id = p.entity_id

WHERE

p.attribute_set_id = 9

)

Show solution

Getting the attribute set name of a product (Magento 1)

Mex 2014/01/20 Magento Solutions

Use the following code to get a products attribute set name.

$attributeSetModel = Mage::getModel("eav/entity_attribute_set");
$attributeSetModel->load($product->getAttributeSetId());
$attributeSetName  = $attributeSetModel->getAttributeSetName();

$attributeSetModel = Mage::getModel("eav/entity_attribute_set");

$attributeSetModel->load($product->getAttributeSetId());

$attributeSetName = $attributeSetModel->getAttributeSetName();

Show solution

★★★ The Magento Expert ★★★

Magento Professional with 29864 hours project experience

Getting orders with items that have a certain attribute set (Magento 1)

Getting the attribute set name of a product (Magento 1)

This site is archived and managed by
Vermonta.

This site is archived and managed byVermonta.

This site is archived and managed by
Vermonta.