PHP snippets Archives | Bravehartk2's Blog

Magento: change applied attribute product types

3 April 20183 April 2018 SheldonNo Comments

Sometimes it is necessary to change the product type(s) an attribute is applied to in Magento. A common example is, that you designed and implemented an attribute for a configurable product, because you thought its real world value is equal over all child manifestations. But after a while you realize, that there are differences that you […]

Magento change attribute scope in setup script

21 September 2017 SheldonNo Comments

This code snippet shows how to change attribute scope in a setup script:

<?php
/* @var $oInstaller Mage_Catalog_Model_Resource_Setup */
$oInstaller = $this;

$oInstaller->startSetup();

$oInstaller->updateAttribute(
    'catalog_product', 'abc_attribute', 'is_global',
    Mage_Catalog_Model_Resource_Eav_Attribute::SCOPE_STORE
);
$oInstaller->updateAttribute(
    'catalog_product', 'xyz_attribute', 'is_global',
    Mage_Catalog_Model_Resource_Eav_Attribute::SCOPE_STORE
);

$oInstaller->endSetup();

// mark index as "reindex required"
$aIndexerCodes = [
    'catalog_product_attribute',
    'catalog_product_flat',
    'catalogsearch_fulltext'
];

$oIndexer = Mage::getModel('index/process');
foreach ($aIndexerCodes as $sCode) {
    $oIndexer->load($sCode, 'indexer_code')
        ->changeStatus(Mage_Index_Model_Process::STATUS_REQUIRE_REINDEX);
}

//clear EAV Cache:
$oInstaller->cleanCache();

<?php

/* @var $oInstaller Mage_Catalog_Model_Resource_Setup */

$oInstaller = $this;

$oInstaller->startSetup();

$oInstaller->updateAttribute(

'catalog_product', 'abc_attribute', 'is_global',

Mage_Catalog_Model_Resource_Eav_Attribute::SCOPE_STORE

);

$oInstaller->updateAttribute(

'catalog_product', 'xyz_attribute', 'is_global',

Mage_Catalog_Model_Resource_Eav_Attribute::SCOPE_STORE

);

$oInstaller->endSetup();

// mark index as "reindex required"

$aIndexerCodes = [

'catalog_product_attribute',

'catalog_product_flat',

'catalogsearch_fulltext'

];

$oIndexer = Mage::getModel('index/process');

foreach ($aIndexerCodes as $sCode) {

$oIndexer->load($sCode, 'indexer_code')

->changeStatus(Mage_Index_Model_Process::STATUS_REQUIRE_REINDEX);

}

//clear EAV Cache:

$oInstaller->cleanCache();

And the config.xml:

<?xml version="1.0"?>
<config>
    <modules>
        <Sheldon_Catalog>
            <version>0.1.0</version>
        </Sheldon_Catalog>
    </modules>
    <global>
        <resources>
            <sheldon_catalog_setup>
                <setup>
                    <module>Sheldon_Catalog</module>
                    <class>Mage_Catalog_Model_Resource_Setup</class>
                </setup>
            </sheldon_catalog_setup>
        </resources>
    </global>
</config>

<?xml version="1.0"?>

<Sheldon_Catalog>

</Sheldon_Catalog>

</modules>

<sheldon_catalog_setup>

<setup>

<module>Sheldon_Catalog</module>

<class>Mage_Catalog_Model_Resource_Setup</class>

</setup>

</sheldon_catalog_setup>

</resources>

</global>

</config>

Associate products to all websites more performant

6 September 2016 SheldonNo Comments

Recently I had to associate all products of a shop to newly created websites in a setup shell script (Associate products to all websites). This could have been implemented like that:

<?php
/**
* Associates products to the newly created websites
*/
private function _associateProducts()
{
    $aWebsiteIDs = Mage::getModel('core/website')
                   ->getResourceCollection()
                   ->getAllIds();

    //remove default website
    array_shift($aWebsiteIDs);

    // bad way would have been:
        foreach (Mage::getModel('catalog/product')->getCollection() as 
                 $oProduct){
            $oProduct->setWebsiteIds($aWebsiteIDs)->save();
        }
        
}

<?php

/**

* Associates products to the newly created websites

private function _associateProducts()

{

$aWebsiteIDs = Mage::getModel('core/website')

->getResourceCollection()

->getAllIds();

//remove default website

array_shift($aWebsiteIDs);

// bad way would have been:

foreach (Mage::getModel('catalog/product')->getCollection() as

$oProduct){

$oProduct->setWebsiteIds($aWebsiteIDs)->save();

}

A much better approach was it to use class Mage_Catalog_Model_Product_Action like that:

<?php
/**
* Associates products to the newly created websites
*/
private function _associateProducts()
{
    $aWebsiteIDs = Mage::getModel('core/website')
                   ->getResourceCollection()
                   ->getAllIds();

    //remove default website
    array_shift($aWebsiteIDs);

    //getAllIds();
    $aProductIds = Mage::getModel('catalog/product')
                   ->getResourceCollection()
                   ->getAllIds();

    // good way (better performance) @see Mage_Catalog_Model_Product_Action
    $oProductActionModdel = Mage::getSingleton('catalog/product_action');
    $oProductActionModdel->updateWebsites(
        $aProductIds,
        $aWebsiteIDs,
        'add'
    );
}

<?php

/**

* Associates products to the newly created websites

private function _associateProducts()

{

$aWebsiteIDs = Mage::getModel('core/website')

->getResourceCollection()

->getAllIds();

//remove default website

array_shift($aWebsiteIDs);

//getAllIds();

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

->getResourceCollection()

->getAllIds();

// good way (better performance) @see Mage_Catalog_Model_Product_Action

$oProductActionModdel = Mage::getSingleton('catalog/product_action');

$oProductActionModdel->updateWebsites(

$aProductIds,

$aWebsiteIDs,

'add'

);

}

This was much more performant, than saving each product all the time. By the […]

Get all attribute options

9 June 201610 February 2018 SheldonNo Comments

To get all attribute options from a Magento dropdown attribute (select field) you can use the following snippet:

<?php
$oAttibute = Mage::getModel('eav/config')->getAttribute(Mage_Catalog_Model_Product::ENTITY, 'sheldon_special');
$aOptions = $oAttibute->getSource()->getAllOptions();
var_dump($aOptions);

<?php

$oAttibute = Mage::getModel('eav/config')->getAttribute(Mage_Catalog_Model_Product::ENTITY, 'sheldon_special');

$aOptions = $oAttibute->getSource()->getAllOptions();

var_dump($aOptions);

That gives you an array like that:

<?php
$aOptions = {array} [6]
 0 = {array} [2]
  label = ""
  value = ""
 1 = {array} [2]
  label = "best"
  value = "306"
 2 = {array} [2]
  label = "new"
  value = "305"
 3 = {array} [2]
  label = "no"
  value = "304"
 4 = {array} [2]
  label = "sale"
  value = "307"
 5 = {array} [2]
  label = "special"
  value = "632"

<?php

$aOptions = {array} [6]

0 = {array} [2]

label = ""

value = ""

1 = {array} [2]

label = "best"

value = "306"

2 = {array} [2]

label = "new"

value = "305"

3 = {array} [2]

label = "no"

value = "304"

4 = {array} [2]

label = "sale"

value = "307"

5 = {array} [2]

label = "special"

value = "632"

This can be used as source for a system config field for example. See my blogpost about Category dropdown element. To get a specific value by given label, you can […]

Load product attributes more performant

26 May 2016 SheldonNo Comments

Recently I had performance issues when importing several ten tausend products. The problem was, that I always used the “normal” product entity model to load attribute values. The following snippet shows, how to load product attributes directly instead. Therefore I use the product resource singleton.

<?php
$iProductId = $aChange['pid'];
$oItem = new Varien_Object;

/**
 * The old way: Baaaaaad and slow!!!
 **/
$oProduct = Mage::getModel('catalog/product')->load($iProductId); // loads all attributes and initializes model completely

# simple text attributes
$oItem->setName($oProduct->getName());
$oItem->getSku($oProduct->getSku());
$oItem->setSheldonArticlenbr($oProduct->getSheldonArticlenbr());
$oItem->setSheldonColor($oProduct->getSheldonColor());

# option value attributes (select boxes)
$oItem->setSheldonSize($oProduct->getAttributeText('sheldon_size'));

/**
 * The old way END
 **/

/**
 * The new way!!! Gooooood! Fast! Queries database directly and selects only necessary attributes
 **/
/* @var Mage_Catalog_Model_Resource_Product $rProduct */
$rProduct = Mage::getResourceSingleton('catalog/product');

# simple text attributes
$oItem->setName($rProduct->getAttributeRawValue($iProductId, 'name', Mage::app()->getStore()));
$oItem->getSku($rProduct->getAttributeRawValue($iProductId, 'sku', Mage::app()->getStore()));
$oItem->setSheldonArticlenbr($rProduct->getAttributeRawValue($iProductId, 'sheldon_articlenbr', Mage::app()->getStore()));
$oItem->setSheldonColor($rProduct->getAttributeRawValue($iProductId, 'sheldon_color', Mage::app()->getStore()));


# option value attributes (select boxes)
$iRawSize = $rProduct->getAttributeRawValue($iProductId, 'sns_size', Mage::app()->getStore());
$oItem->setSheldonSize($rProduct->getAttribute('sheldon_size')->getSource()->getOptionText($iRawSize));

<?php

$iProductId = $aChange['pid'];

$oItem = new Varien_Object;

/**

* The old way: Baaaaaad and slow!!!

**/

$oProduct = Mage::getModel('catalog/product')->load($iProductId); // loads all attributes and initializes model completely

# simple text attributes

$oItem->setName($oProduct->getName());

$oItem->getSku($oProduct->getSku());

$oItem->setSheldonArticlenbr($oProduct->getSheldonArticlenbr());

$oItem->setSheldonColor($oProduct->getSheldonColor());

# option value attributes (select boxes)

$oItem->setSheldonSize($oProduct->getAttributeText('sheldon_size'));

/**

* The old way END

**/

/**

* The new way!!! Gooooood! Fast! Queries database directly and selects only necessary attributes

**/

/* @var Mage_Catalog_Model_Resource_Product $rProduct */

$rProduct = Mage::getResourceSingleton('catalog/product');

# simple text attributes

$oItem->setName($rProduct->getAttributeRawValue($iProductId, 'name', Mage::app()->getStore()));

$oItem->getSku($rProduct->getAttributeRawValue($iProductId, 'sku', Mage::app()->getStore()));

$oItem->setSheldonArticlenbr($rProduct->getAttributeRawValue($iProductId, 'sheldon_articlenbr', Mage::app()->getStore()));

$oItem->setSheldonColor($rProduct->getAttributeRawValue($iProductId, 'sheldon_color', Mage::app()->getStore()));

# option value attributes (select boxes)

$iRawSize = $rProduct->getAttributeRawValue($iProductId, 'sns_size', Mage::app()->getStore());

$oItem->setSheldonSize($rProduct->getAttribute('sheldon_size')->getSource()->getOptionText($iRawSize));

Option value position (select value sort order)

20 May 2016 Sheldon1 Comment

This Magento shell script sorts the values of a given attribute after the order of values in a given CSV file (sets option value position).

<?php
/**
 *
 * Magento
 *
 * NOTICE OF LICENSE
 *
 * This source file is subject to the Open Software License (OSL 3.0)
 * It is  available through the world-wide-web at this URL:
 * http://opensource.org/licenses/osl-3.0.php
 *
 *
 * @category   AskSheldon
 * @package    AskSheldon_Misc
 * @copyright  Copyright (c) 2016 Marcel Lange (https://www.ask-sheldon.com)
 * @license    http://opensource.org/licenses/osl-3.0.php  Open Software License (OSL 3.0)
 * @author     Marcel Lange <info@ask-sheldon.com>)
 *
 * Changes the sorting of asksheldon_size attribute options (sets sort order)
 * call it with param 'iknowwhatido=yes' to make it work!
 *
 */
require_once('../AskSheldon_Shell_Abstract.php');

class AskSheldon_Misc_Attribute_Option_Sorter extends AskSheldon_Shell_Abstract
{
    const TARGET_ATTRIBUTE = 'asksheldon_size';
    const REFERENCESTORE = 2;

    private $_oWriteConnection = null;
    private $_sOptionTable = null;
    private $_sOptionLableTable = null;


    /*
     * Starter
     * */
    public function run()
    {
        error_reporting(E_ALL);
        ini_set('display_errors', 1);

        if (!$this->getArg('iknowwhatido') || $this->getArg('iknowwhatido') != 'yes') {
            echo $this->usageHelp();
            echo "\n DEACTIVATED (call it with param '-iknowwhatido yes' to make it work!) \n";
            return -1;
        }
        if (!$this->getArg('inputfile')) {
            echo $this->usageHelp();
            echo "\n You have to give me the right params master! \n";
            return -1;
        }

        $rFile = fopen($this->getArg('inputfile'), 'r');
        if ($rFile) {
            $iCount = 1;
            while (($aData = fgetcsv($rFile)) !== false) {
                $sSizeDE = $aData[0];
                $this->_setAttributeOptionSorting($sSizeDE, $iCount++);
            }
        }
    }

    /**
     * Retrieve Usage Help Message
     *
     */
    public function usageHelp()
    {
        return <<<USAGE
Usage:  php -f update_size_attribute_option_order.php -iknowwhatido [options]
  
  iknowwhatido      lifeguard flag
  inputfile         CSV-file with size sorting as the first and only column without header line!!!
  help              This help

USAGE;
    }

    private function _setAttributeOptionSorting($sSize, $iPosition)
    {

        $oSelect = new Varien_Db_Select($this->_getWriteConnection());
        $oSelect->from(
            ['eao' => $this->_getOptionTable()],
            ['option_id']
        )
            ->join(
                ['eaov' => $this->_getOptionLabelTable()],
                "eao.option_id = eaov.option_id AND eaov.store_id = " . self::REFERENCESTORE,
                ''
            )
            ->where('eao.attribute_id = ?', $this->_getAttibuteId())
            ->where('eaov.value = ?', $sSize);

        $aResult = $this->_getWriteConnection()->fetchCol($oSelect);
        foreach ($aResult as $iOptionId) {
            $this->_getWriteConnection()->update(
                $this->_getOptionTable(),
                ['sort_order' => $iPosition],
                $this->_getWriteConnection()->quoteInto('option_id = ?', $iOptionId)
            );
        }
    }

    /**
     * Returs a write connection
     * @return Varien_Db_Adapter_Pdo_Mysql
     */
    private function _getWriteConnection()
    {
        if (is_null($this->_oWriteConnection)) {
            $this->_oWriteConnection = Mage::getSingleton('core/resource')->getConnection('core_write');
        }
        return $this->_oWriteConnection;
    }

    /**
     * @return string table name
     */
    private function _getOptionTable()
    {
        if (is_null($this->_sOptionTable)) {
            $this->_sOptionTable = Mage::getSingleton('core/resource')->getTableName('eav/attribute_option');
        }
        return $this->_sOptionTable;
    }

    /**
     * @return string table name
     */
    private function _getOptionLabelTable()
    {
        if (is_null($this->_sOptionLableTable)) {
            $this->_sOptionLableTable = Mage::getSingleton('core/resource')->getTableName('eav/attribute_option_value');
        }
        return $this->_sOptionLableTable;
    }

    /**
     * @return int ID of product attribute asksheldon_size
     */
    private function _getAttibuteId()
    {
        return Mage::getSingleton('eav/config')->getAttribute(Mage_Catalog_Model_Product::ENTITY, self::TARGET_ATTRIBUTE)->getId();
    }
}

$oOptionSorter = new AskSheldon_Misc_Attribute_Option_Sorter();
$oOptionSorter->run();

100

101

102

103

104

105

106

107

108

109

110

111

112

113

114

115

116

117

118

119

120

121

122

123

124

125

126

127

128

129

130

131

132

133

134

135

136

137

138

139

140

141

142

143

144

145

146

147

148

149

150

<?php

/**

* Magento

* NOTICE OF LICENSE

* This source file is subject to the Open Software License (OSL 3.0)

* It is available through the world-wide-web at this URL:

* http://opensource.org/licenses/osl-3.0.php

* @category AskSheldon

* @package AskSheldon_Misc

* @license http://opensource.org/licenses/osl-3.0.php Open Software License (OSL 3.0)

* @author Marcel Lange <info@ask-sheldon.com>)

* Changes the sorting of asksheldon_size attribute options (sets sort order)

* call it with param 'iknowwhatido=yes' to make it work!

require_once('../AskSheldon_Shell_Abstract.php');

class AskSheldon_Misc_Attribute_Option_Sorter extends AskSheldon_Shell_Abstract

{

const TARGET_ATTRIBUTE = 'asksheldon_size';

const REFERENCESTORE = 2;

private $_oWriteConnection = null;

private $_sOptionTable = null;

private $_sOptionLableTable = null;

* Starter

* */

public function run()

{

error_reporting(E_ALL);

ini_set('display_errors', 1);

if (!$this->getArg('iknowwhatido') || $this->getArg('iknowwhatido') != 'yes') {

echo $this->usageHelp();

echo "\n DEACTIVATED (call it with param '-iknowwhatido yes' to make it work!) \n";

return -1;

}

if (!$this->getArg('inputfile')) {

echo $this->usageHelp();

echo "\n You have to give me the right params master! \n";

return -1;

}

$rFile = fopen($this->getArg('inputfile'), 'r');

if ($rFile) {

$iCount = 1;

while (($aData = fgetcsv($rFile)) !== false) {

$sSizeDE = $aData[0];

$this->_setAttributeOptionSorting($sSizeDE, $iCount++);

}

/**

* Retrieve Usage Help Message

public function usageHelp()

{

return <<<USAGE

Usage: php -f update_size_attribute_option_order.php -iknowwhatido [options]

iknowwhatido lifeguard flag

inputfile CSV-file with size sorting as the first and only column without header line!!!

help This help

USAGE;

}

private function _setAttributeOptionSorting($sSize, $iPosition)

{

$oSelect = new Varien_Db_Select($this->_getWriteConnection());

$oSelect->from(

['eao' => $this->_getOptionTable()],

['option_id']

)

->join(

['eaov' => $this->_getOptionLabelTable()],

"eao.option_id = eaov.option_id AND eaov.store_id = " . self::REFERENCESTORE,

)

->where('eao.attribute_id = ?', $this->_getAttibuteId())

->where('eaov.value = ?', $sSize);

$aResult = $this->_getWriteConnection()->fetchCol($oSelect);

foreach ($aResult as $iOptionId) {

$this->_getWriteConnection()->update(

$this->_getOptionTable(),

['sort_order' => $iPosition],

$this->_getWriteConnection()->quoteInto('option_id = ?', $iOptionId)

);

}

/**

* Returs a write connection

* @return Varien_Db_Adapter_Pdo_Mysql

private function _getWriteConnection()

{

if (is_null($this->_oWriteConnection)) {

$this->_oWriteConnection = Mage::getSingleton('core/resource')->getConnection('core_write');

}

return $this->_oWriteConnection;

}

/**

* @return string table name

private function _getOptionTable()

{

if (is_null($this->_sOptionTable)) {

$this->_sOptionTable = Mage::getSingleton('core/resource')->getTableName('eav/attribute_option');

}

return $this->_sOptionTable;

}

/**

* @return string table name

private function _getOptionLabelTable()

{

if (is_null($this->_sOptionLableTable)) {

$this->_sOptionLableTable = Mage::getSingleton('core/resource')->getTableName('eav/attribute_option_value');

}

return $this->_sOptionLableTable;

}

/**

* @return int ID of product attribute asksheldon_size

private function _getAttibuteId()

{

return Mage::getSingleton('eav/config')->getAttribute(Mage_Catalog_Model_Product::ENTITY, self::TARGET_ATTRIBUTE)->getId();

}

$oOptionSorter = new AskSheldon_Misc_Attribute_Option_Sorter();

$oOptionSorter->run();

So it is not necessary to set the values via BE-Interface. The value matching to find the respective option-id is done by using the value of the Storeview specified in REFERENCESTORE and the attribute […]

Query Magento database object oriented

20 May 201627 May 2016 SheldonNo Comments

Naturally you can query Magento database directly as described in my earlier post about querying Magento database. But a much smarter way is it, to use exiting Magento objects and constructs like that:

<?php
/**
 * Sets position (sort order) values for the given attribute for a given option value. Therefore the given store specific value is
 * used to lookup the necessary option id to identify the correct option
 * @param sting $sAttributeCode Magento attribute code for that option value position should be set
 * @param sting $sValue  option value in the given store
 * @param int $iPosition position (sort order) to set for given option value
 * @param int $iReferenceStoreId store to search for a option label
 * @throws Zend_Db_Adapter_Exception
 */
public function setAttributeOptionSorting($sAttributeCode, $sValue, $iPosition, $iReferenceStoreId)
{
    /* @var Varien_Db_Adapter_Pdo_Mysql $oWriteConnection */
    $oWriteConnection = Mage::getSingleton('core/resource')->getConnection('core_write');

    $sOptionTable = Mage::getSingleton('core/resource')->getTableName('eav/attribute_option');
    $sOptionLableTable = Mage::getSingleton('core/resource')->getTableName('eav/attribute_option_value');

    $iAttributeId = Mage::getSingleton('eav/config')->getAttribute(Mage_Catalog_Model_Product::ENTITY, $sAttributeCode)->getId();


    $oSelect = new Varien_Db_Select($oWriteConnection);
    $oSelect->from(
        ['eao' => $sOptionTable],
        ['option_id']
    )->join(
        ['eaov' => $sOptionLableTable],
        "eao.option_id = eaov.option_id AND eaov.store_id = " . $iReferenceStoreId,
        ''
    )->where(
        'eao.attribute_id = ?',
        $iAttributeId
    )->where(
        'eaov.value = ?',
        $sValue
    );

    $aResult = $oWriteConnection->fetchCol($oSelect);

    foreach ($aResult as $iOptionId) {
        $oWriteConnection->update(
            $sOptionTable,
            ['sort_order' => $iPosition],
            $oWriteConnection->quoteInto('option_id = ?', $iOptionId)
        );
    }
}

<?php

/**

* Sets position (sort order) values for the given attribute for a given option value. Therefore the given store specific value is

* used to lookup the necessary option id to identify the correct option

* @param sting $sAttributeCode Magento attribute code for that option value position should be set

* @param sting $sValue option value in the given store

* @param int $iPosition position (sort order) to set for given option value

* @param int $iReferenceStoreId store to search for a option label

* @throws Zend_Db_Adapter_Exception

public function setAttributeOptionSorting($sAttributeCode, $sValue, $iPosition, $iReferenceStoreId)

{

/* @var Varien_Db_Adapter_Pdo_Mysql $oWriteConnection */

$oWriteConnection = Mage::getSingleton('core/resource')->getConnection('core_write');

$sOptionTable = Mage::getSingleton('core/resource')->getTableName('eav/attribute_option');

$sOptionLableTable = Mage::getSingleton('core/resource')->getTableName('eav/attribute_option_value');

$iAttributeId = Mage::getSingleton('eav/config')->getAttribute(Mage_Catalog_Model_Product::ENTITY, $sAttributeCode)->getId();

$oSelect = new Varien_Db_Select($oWriteConnection);

$oSelect->from(

['eao' => $sOptionTable],

['option_id']

)->join(

['eaov' => $sOptionLableTable],

"eao.option_id = eaov.option_id AND eaov.store_id = " . $iReferenceStoreId,

)->where(

'eao.attribute_id = ?',

$iAttributeId

)->where(

'eaov.value = ?',

$sValue

);

$aResult = $oWriteConnection->fetchCol($oSelect);

foreach ($aResult as $iOptionId) {

$oWriteConnection->update(

$sOptionTable,

['sort_order' => $iPosition],

$oWriteConnection->quoteInto('option_id = ?', $iOptionId)

);

}

This is a simplified version of a function (better to say shell script class) that sets attribute value positions for a certain […]

Get product attribute ID in Magento

19 May 2016 SheldonNo Comments

This is how to get product EAV attribute ID without querying the database directly:

<?php
$iAttributeID = Mage::getSingleton('eav/config')->getAttribute(Mage_Catalog_Model_Product::ENTITY, self::TARGET_ATTRIBUTE)->getId()

1 2	<?php $iAttributeID = Mage::getSingleton('eav/config')->getAttribute(Mage_Catalog_Model_Product::ENTITY, self::TARGET_ATTRIBUTE)->getId()

Create database tables in setup scripts

11 May 201611 May 2016 SheldonNo Comments

The following snippet shows, how to create database tables in a setup script. It uses no direct queries against the database but the an object oriented way Magento does such things. (This snipped assumes that your resource setup model is derived from Mage_Core_Model_Resource_Setup)

<?php
/**
 *
 * Magento
 *
 * NOTICE OF LICENSE
 *
 * This source file is subject to the Open Software License (OSL 3.0)
 * It is  available through the world-wide-web at this URL:
 * http://opensource.org/licenses/osl-3.0.php
 *
 *
 * @category   AskSheldon
 * @package    AskSheldon_FeaturedProducts
 * @copyright  Copyright (c) 2016 Marcel Lange (https://www.ask-sheldon.com)
 * @license    http://opensource.org/licenses/osl-3.0.php  Open Software License (OSL 3.0)
 * @author     Marcel Lange <info@ask-sheldon.com>
 *
 * Date:       10.05.16
 * Time:       14:53
 *
 * Creates table structure for category -> featured product relation
 *
 * Mage_Core_Model_Resource_Setup
 *
 *  *
 * Created by IntelliJ IDEA.
 *
 */
/* @var $installer Mage_Core_Model_Resource_Setup */
$installer = $this;

$installer->startSetup();

/**
 * Create table 'asksheldon_featuredproducts/category_featuredproducts'
 */
$table = $installer->getConnection()
    ->newTable($installer->getTable('asksheldon_featuredproducts/category_product')) # returns instance of Varien_Db_Ddl_Table
    ->addColumn('category_id', Varien_Db_Ddl_Table::TYPE_INTEGER, null, array(
        'unsigned' => true,
        'nullable' => false,
        'primary' => true,
        'default' => '0',
    ), 'Category ID')
    ->addColumn('product_id', Varien_Db_Ddl_Table::TYPE_INTEGER, null, array(
        'unsigned' => true,
        'nullable' => false,
        'primary' => true,
        'default' => '0',
    ), 'Product ID')
    ->addColumn('position', Varien_Db_Ddl_Table::TYPE_INTEGER, null, array(
        'nullable' => false,
        'default' => '0',
    ), 'Position')
    ->addIndex(
        $installer->getIdxName(
            'asksheldon_featuredproducts/category_product',
            array('product_id')
        ),
        array('product_id'))
    ->addForeignKey(
        $installer->getFkName(
            'asksheldon_featuredproducts/category_product',
            'category_id', 'catalog/category',
            'entity_id'
        ),
        'category_id',
        $installer->getTable('catalog/category'),
        'entity_id',
        Varien_Db_Ddl_Table::ACTION_CASCADE,
        Varien_Db_Ddl_Table::ACTION_CASCADE
    )
    ->addForeignKey(
        $installer->getFkName(
            'asksheldon_featuredproducts/category_product',
            'product_id',
            'catalog/product',
            'entity_id'
        ),
        'product_id',
        $installer->getTable('catalog/product'),
        'entity_id',
        Varien_Db_Ddl_Table::ACTION_CASCADE,
        Varien_Db_Ddl_Table::ACTION_CASCADE
    )
    ->setComment('AskSheldon Features Product To Category Linkage Table');
$installer->getConnection()->createTable($table);

$installer->endSetup();

<?php

/**

* Magento

* NOTICE OF LICENSE

* This source file is subject to the Open Software License (OSL 3.0)

* It is available through the world-wide-web at this URL:

* http://opensource.org/licenses/osl-3.0.php

* @category AskSheldon

* @package AskSheldon_FeaturedProducts

* @license http://opensource.org/licenses/osl-3.0.php Open Software License (OSL 3.0)

* @author Marcel Lange <info@ask-sheldon.com>

* Date: 10.05.16

* Time: 14:53

* Creates table structure for category -> featured product relation

* Mage_Core_Model_Resource_Setup

* *

* Created by IntelliJ IDEA.

/* @var $installer Mage_Core_Model_Resource_Setup */

$installer = $this;

$installer->startSetup();

/**

* Create table 'asksheldon_featuredproducts/category_featuredproducts'

$table = $installer->getConnection()

->newTable($installer->getTable('asksheldon_featuredproducts/category_product')) # returns instance of Varien_Db_Ddl_Table

->addColumn('category_id', Varien_Db_Ddl_Table::TYPE_INTEGER, null, array(

'unsigned' => true,

'nullable' => false,

'primary' => true,

'default' => '0',

), 'Category ID')

->addColumn('product_id', Varien_Db_Ddl_Table::TYPE_INTEGER, null, array(

'unsigned' => true,

'nullable' => false,

'primary' => true,

'default' => '0',

), 'Product ID')

->addColumn('position', Varien_Db_Ddl_Table::TYPE_INTEGER, null, array(

'nullable' => false,

'default' => '0',

), 'Position')

->addIndex(

$installer->getIdxName(

'asksheldon_featuredproducts/category_product',

array('product_id')

array('product_id'))

->addForeignKey(

$installer->getFkName(

'asksheldon_featuredproducts/category_product',

'category_id', 'catalog/category',

'entity_id'

'category_id',

$installer->getTable('catalog/category'),

'entity_id',

Varien_Db_Ddl_Table::ACTION_CASCADE,

Varien_Db_Ddl_Table::ACTION_CASCADE

)

->addForeignKey(

$installer->getFkName(

'asksheldon_featuredproducts/category_product',

'product_id',

'catalog/product',

'entity_id'

'product_id',

$installer->getTable('catalog/product'),

'entity_id',

Varien_Db_Ddl_Table::ACTION_CASCADE,

Varien_Db_Ddl_Table::ACTION_CASCADE

)

->setComment('AskSheldon Features Product To Category Linkage Table');

$installer->getConnection()->createTable($table);

$installer->endSetup();

As you can see, it is also possible to add indexes and […]

Get all saleable simple products from configurable product

1 April 2016 SheldonNo Comments

The following function just gets all saleable (if saleable check is enabled in the Magento configuration) child products from a configurable product:

/**
 * Get saleable simple products from configurable parent product
 *
 * @var Mage_Catalog_Model_Product_Type_Configurable $oParentProduct
 * @return array of Mage_Catalog_Model_Product(Mage_Catalog_Model_Product_Type_Simple)
 */
public function getAllowedProducts($oParentProduct)
{
    $aProducts = [];
    $bSkipSaleableCheck = Mage::helper('catalog/product')->getSkipSaleableCheck();
    $oAllProducts = $oParentProduct
        ->getTypeInstance(true)
        ->getUsedProducts(null, $oParentProduct);
    foreach ($oAllProducts as $oProduct) {
        if ($oProduct->isSaleable() || $bSkipSaleableCheck) {
            $aProducts[] = $oProduct;
        }
    }

    return $aProducts;

}

/**

* Get saleable simple products from configurable parent product

* @var Mage_Catalog_Model_Product_Type_Configurable $oParentProduct

* @return array of Mage_Catalog_Model_Product(Mage_Catalog_Model_Product_Type_Simple)

public function getAllowedProducts($oParentProduct)

{

$aProducts = [];

$bSkipSaleableCheck = Mage::helper('catalog/product')->getSkipSaleableCheck();

$oAllProducts = $oParentProduct

->getTypeInstance(true)

->getUsedProducts(null, $oParentProduct);

foreach ($oAllProducts as $oProduct) {

if ($oProduct->isSaleable() || $bSkipSaleableCheck) {

$aProducts[] = $oProduct;

}

return $aProducts;

}

Bravehartk2's Blog

- next level braining -

Category: PHP snippets

Magento: change applied attribute product types

Magento change attribute scope in setup script

Associate products to all websites more performant

Get all attribute options

Load product attributes more performant

Option value position (select value sort order)

Query Magento database object oriented

Get product attribute ID in Magento

Create database tables in setup scripts

Get all saleable simple products from configurable product

Share this:

Share this:

Share this:

Share this:

Share this:

Share this:

Share this:

Share this:

Share this:

Share this: