Magento17 August 201617 April 2019

ambigous column in where clause

$collection = Mage::getResourceModel($this->_getCollectionClass()); //join field from order $collection->getSelect()->join(‘sales_flat_order’, ‘main_table.entity_id = sales_flat_order.entity_id’,array(‘is_partner’)); // baypass ambigous column in where clause $collection->addFilterToMap(‘is_virtual’, ‘main_table.is_virtual’); $collection->addFilterToMap(‘status’, ‘main_table.status’); $collection->addFilterToMap(‘created_at’, ‘main_table.created_at’); $collection->addFilterToMap(‘base_grand_total’,…

Magento10 July 201417 April 2019

Fastest way to add custom category attribute to frontend menu category tree model

The simplest way to add this attribute is use XML. This sample part of code displayed below, should be inserted in Your own module in…

Magento21 January 201417 April 2019

Magento custom filter on column in admin grid filter_condition_callback

Magento Grid Block has useful function for advanced filtering of a collection. It is called ‘filter_condition_callback’, and it is used in declaring a column. It…

Magento21 December 201317 April 2019

Zend Server with XDEBUG and PHPSTORM

1. Change timeouts file: Zend\ZendServer\etc\ZendEnablerConf.xml change line with timeouts tag to: Timeouts connectionTimeout=”120″ requestTimeout=”1200″ file: Zend\ZendServer\etc\php.ini change: max_execution_time=30 to: max_execution_time=600 2. Enable vhosts file: Zend\Apache2\conf\httpd.conf…

Magento13 December 201317 April 2019

Magento: List of available types column in adminhtml widget grid

date adminhtml/widget_grid_column_renderer_date datetime adminhtml/widget_grid_column_renderer_datetime number adminhtml/widget_grid_column_renderer_number currency adminhtml/widget_grid_column_renderer_currency price adminhtml/widget_grid_column_renderer_price country adminhtml/widget_grid_column_renderer_country concat adminhtml/widget_grid_column_renderer_concat action adminhtml/widget_grid_column_renderer_action options adminhtml/widget_grid_column_renderer_options date adminhtml/widget_grid_column_renderer_date checkbox adminhtml/widget_grid_column_renderer_checkbox massaction adminhtml/widget_grid_column_renderer_massaction radio…

Magento6 November 201317 April 2019

Magento can’t login to admin Warning: Header may not contain more than a single header, new line detected

The first step that you should do to resolve this bug is check your system.log file. In my case error looks like this: Warning: Header…

Magento10 October 201317 April 2019

Magento after upgrade, the new template does not show up

Sometimes, after upgrade Magento, and introducing a new template, You may not see it. Why? Because each product can have a changed template to ‘default/default’.…

Magento3 October 201317 April 2019

Remove wrapper from customer account

Edit app\design\frontend\theme\default\layout\customer.xml add action : 0 to wrapper block, like this: My Account Wrapper my-account 0

Magento3 October 201317 April 2019

The JVM could not be started. The maximum heap size (-Xmx) might be too large or an antivirus or firewall tool could block the execution.

To resolve this problem, set up new system variable in windows: Variable name: JAVA_OPTS. Variable value -Xms256m -Xmx512m Or just edit file : PhpStorm_Install\bin\PhpStorm.exe.vmoptions by…

Magento1 October 201317 April 2019

Delete magento attribute with options and values

$attribute_code = ‘some_attribute_code’; $attribute = Mage::getModel(‘eav/config’)->getAttribute(‘customer_address’,$attribute_code); $options = $attribute->getSource()->getAllOptions(); foreach ($options as $option) { if ($option[‘label’] === ” && $option[‘value’]) { $newOptions[‘value’][$option[‘value’]][] = $option[‘label’]; $newOptions[‘delete’][$option[‘value’]]…