To get all products that do not have custom options, simply run the following SQL query:
|
1 2 3 4 5 6 |
SELECT * FROM catalog_product_entity WHERE entity_id NOT IN (SELECT DISTINCT product_id FROM catalog_product_option); |
To get all products that do have custom options, remove the “NOT” from the above query.
The following MySQL query returns the status of every product in the Magento database.
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 |
SELECT cpe.sku, q.product_status FROM catalog_product_entity cpe JOIN (SELECT entity_id AS product_id, value AS product_status FROM catalog_product_entity_int WHERE entity_type_id = (SELECT entity_type_id FROM eav_entity_type WHERE entity_type_code = 'catalog_product') AND attribute_id = (SELECT attribute_id FROM eav_attribute WHERE attribute_code = 'status' AND entity_type_id = (SELECT entity_type_id FROM eav_entity_type WHERE entity_type_code = 'catalog_product'))) q ON cpe.entity_id = q.product_id; |
Status 1: active Status 2: not active
Open the category in the admin area (backend) and add the following xml to the layout update section.
|
1 2 3 |
<reference name="product_list"> <action method="setColumnCount"><count>4</count></action> </reference> |
Use the following code to get a Magento products URL and to display the image on a tempate page:
|
1 |
<img src="<?php echo $_product->getImageUrl(); ?>" alt="<?php echo $_product->getName();?>" /> |
Once saved, upsell products can not be removed again easily. Using the following MySQL script, you can delete Magento upsell products from the database.
|
1 2 3 |
DELETE link.* FROM catalog_product_link AS link LEFT JOIN catalog_product_link_type AS linktype ON (linktype.link_type_id = link.link_type_id) WHERE linktype.code = "up_sell" and product_id = 123; |
Use the following code to load a product by id:
|
1 2 |
$productId = 1234; $product = Mage::getModel('catalog/product')->load($productId); |