Magento Solutions | The Magento Expert

Getting the current date and time (Magento 1)

Mex 20. November 2014 Magento Solutions

The following snippet returns the current date and time.

 $dateAndTime = date("Y-m-d H:i:s", Mage::getModel('core/date')->timestamp(time()));

1	$dateAndTime = date("Y-m-d H:i:s", Mage::getModel('core/date')->timestamp(time()));

View solution

Solving syntax error, unexpected ‘endif’ (T_ENDIF) problem (Magento 1)

Mex 18. November 2014 Magento Solutions

Sometimes, when opening a Magento product page, the following error is shown: Parse error: syntax error, unexpected ‘endif’ (T_ENDIF) in … The problem here is not with the Magento code itself. Its a problem with the Apache server configuration. To…

View solution

Solving “Cannot send headers; headers already sent” problem (Magento 1)

Mex 13. November 2014 Magento Solutions

Sometimes, when looking through your Magento log files, you might stumble upon the “Cannot send headers; headers already sent in …” message. One possible reason for that could be a space or a newline behind a closing PHP tag (?>).…

View solution

Adding a static block to a CMS page (Magento 1)

Mex 5. November 2014 Magento Solutions

Use the below code to add a Magento block to your CMS page.

{{block type="cms/block" block_id="block_id"}}

1	{{block type="cms/block" block_id="block_id"}}

View solution

Unlock customer programmatically (Magento 1)

Mex 22. Oktober 2014 Magento Solutions

Use the below code to unlock a customer programmatically.

$customer->setFailedLogins(0)->setLastFailedLogin(0)->save();

1	$customer->setFailedLogins(0)->setLastFailedLogin(0)->save();

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 a list of all countries (Magento 1)

Mex 14. Oktober 2014 Magento Solutions

Use the code below to get a list of all countries. It can be used to create a country dropdown list for example.

$countryList = Mage::getModel('directory/country')->getResourceCollection()->loadByStore()->toOptionArray(true);

1	$countryList = Mage::getModel('directory/country')->getResourceCollection()->loadByStore()->toOptionArray(true);

View solution

Loading a model without using IDs (Magento 1)

Mex 9. Oktober 2014 Magento Solutions

Sometimes there is no id available for loading a model. If thats the case, the following code might help out. It loads a collection by an attribute like name or sku.

$collectionData = Mage::getModel('modelname')->getCollection()->addFieldToFilter('attribute', 'attribute value');

1	$collectionData = Mage::getModel('modelname')->getCollection()->addFieldToFilter('attribute', 'attribute value');

Afterwards, it is possible to iterate over the…

View solution

Removing block from cache (Magento 1)

Mex 1. Oktober 2014 Magento Solutions

To remove a certain block from the Magento cache, use the below code.

<reference name="name.of.the.block">
    <action method="setCacheLifetime"><s>null</s></action>
</reference>

</reference>

View solution

Getting the status of every product in the database using MySQL (Magento 1)

Mex 30. September 2014 Magento Solutions

The following MySQL query returns the status of every product in the Magento database.

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;

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

View solution