Custom Options | The Magento Expert

Getting products with or without custom options using SQL (Magento 1)

15. Januar 2016 Magento Solutions

To get all products that do not have custom options, simply run the following SQL query: 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…

View solution

Finding products with and without custom options using SQL (Magento 1)

Mex 15. Januar 2016 Magento Solutions

To find all products that have keine no custom options, run this query:

SELECT
  *
FROM catalog_product_entity
WHERE entity_id NOT IN (SELECT DISTINCT
    product_id
  FROM catalog_product_option);

SELECT

FROM catalog_product_entity

WHERE entity_id NOT IN (SELECT DISTINCT

product_id

FROM catalog_product_option);

To find all products that do have custom options, simply remove “NOT” from the query above.

View solution

Creating order including custom options programmatically (Magento 1)

Mex 15. Oktober 2014 Magento Solutions

Using the following code, you can create an order including custom options programmatically.

$quote = Mage::getModel('sales/quote')->setStoreId(Mage::app()->getStore('default')->getId());
$quote->setCustomerEmail($mail);
$product = Mage::getModel('catalog/product')->load($productId);
$buyInfo = array(
                    'qty' => 1,
                     'options' => array($optionId => $optionValue)
                );
$quote->addProduct($product, new Varien_Object($buyInfo));
         
$addressData = array(
                'firstname' => $firstName,
                'lastname' => $lastName,
                'street' => $street,
                'city' => $city,
                'postcode' => $postCode,
                'telephone' => '-',
                'country_id' => $country,
                'region_id' => $regionId, 
        );
         
$billingAddress = $quote->getBillingAddress()->addData($addressData);
$shippingAddress = $quote->getShippingAddress()->addData($addressData);
$shippingAddress->setCollectShippingRates(true)->collectShippingRates()
                        ->setShippingMethod('flatrate_flatrate')
                        ->setPaymentMethod('bankpayment');
         
$quote->getPayment()->importData(array('method' => 'bankpayment'));
$quote->collectTotals()->save();
         
$service = Mage::getModel('sales/service_quote', $quote);
$service->submitAll();

$order = $service->getOrder();
// ...

$quote = Mage::getModel('sales/quote')->setStoreId(Mage::app()->getStore('default')->getId());

$quote->setCustomerEmail($mail);

$product = Mage::getModel('catalog/product')->load($productId);

$buyInfo = array(

'qty' => 1,

'options' => array($optionId => $optionValue)

);

$quote->addProduct($product, new Varien_Object($buyInfo));

$addressData = array(

'firstname' => $firstName,

'lastname' => $lastName,

'street' => $street,

'city' => $city,

'postcode' => $postCode,

'telephone' => '-',

'country_id' => $country,

'region_id' => $regionId,

);

$billingAddress = $quote->getBillingAddress()->addData($addressData);

$shippingAddress = $quote->getShippingAddress()->addData($addressData);

$shippingAddress->setCollectShippingRates(true)->collectShippingRates()

->setShippingMethod('flatrate_flatrate')

->setPaymentMethod('bankpayment');

$quote->getPayment()->importData(array('method' => 'bankpayment'));

$quote->collectTotals()->save();

$service = Mage::getModel('sales/service_quote', $quote);

$service->submitAll();

$order = $service->getOrder();

// ...

View solution

Getting custom options of ordered items on success page (success.phtml) (Magento 1)

Mex 9. August 2013 Magento Solutions

Using the folowing code you can get the custom options of the ordered items on the Magento success page.

$order = Mage::getModel('sales/order')->loadByIncrementId($this->getOrderId());
$items = $order->getAllItems();
foreach($items as $item) {
    $options = $item->getProductOptions();
    foreach ($options['options'] as $itemOption) {
        $optionTitle = $itemOption['title'];
        $optionValue = $itemOption['value'];
        //...                   
    }
}

$order = Mage::getModel('sales/order')->loadByIncrementId($this->getOrderId());

$items = $order->getAllItems();

foreach($items as $item) {

$options = $item->getProductOptions();

foreach ($options['options'] as $itemOption) {

$optionTitle = $itemOption['title'];

$optionValue = $itemOption['value'];

//...

}

View solution

Getting custom options of an order item (Magento 1)

Mex 30. April 2013 Magento Solutions

Using the following code, you can get the custom options from a Magento order item:

$items = $order->getAllItems();
foreach ($items as $item) {
    $options = $item->getProductOptions();
    $options = $options['options'];
    $optionLabel = $option['label'];
    // ...
}

$items = $order->getAllItems();

foreach ($items as $item) {

$options = $item->getProductOptions();

$options = $options['options'];

$optionLabel = $option['label'];

// ...

}

View solution

Making custom options available in quote in admin area (Magento 1)

Mex 25. März 2013 Magento Solutions

Sometimes, when adding custom options to a quote in ther admin area, the custom options are not available. To avoid that problem, simply add the custom options to your modules config.xml, like this:

<global>
    <sales>
        <quote>
            <item>
                <product_attributes>
                    <custom_product_attribute1/>
                    <custom_product_attribute2/>
                </product_attributes>
            </item>
        </quote>
    </sales>
</global>

<sales>

<quote>

<item>

<product_attributes>

<custom_product_attribute1/>

<custom_product_attribute2/>

</product_attributes>

</item>

</quote>

</sales>

</global>

View solution

Getting selected custom options of a cart item (Magento 1)

Mex 25. März 2013 Magento Solutions

Use the below code to figure out what custom option was selected by the customer for a cart item:

$productOptions = $item->getProduct()->getTypeInstance(true)->getOrderOptions($item->getProduct());

foreach($productOptions as $option) {
    ....
}

$productOptions = $item->getProduct()->getTypeInstance(true)->getOrderOptions($item->getProduct());

foreach($productOptions as $option) {

....

}

View solution