Magento upgrade to 2.3.5

To upgrade Magento version 2.3.4to 2.3.5 follow this steps: Step 1 – enable mainenance mode Step 2 – composer require Step 3 – update composer Step 4 – cleanup before upgrade magento Step 5 – upgrade and static content deploy Step 6 – compile, reindex and clean cache After above, check your Magento version typing […]

Read more

Shopware 6 – docker + vagrant

To run the project in docker version on a vagrant, you need to take a few steps Step 1. Please go through the basic installation process: https://github.com/shopware/platform#quickstart–installation Step 2. Make changes in by removing ip from entire file, e.g.: Step 3. Run command and Step 4. Add hostname maping in system hosts file e.g. 192.168.33.100 […]

Read more

Missing shipping methods: “Sorry, no quotes are available for this order at this time.”

This message may appear in a specific case, which is:1. Available shipping methods are limited to specific countries.2. The default country for tax settlement is not on the list above (Admin Panel> Stores> Configuration> Sales> Tax> Default Tax Destination Calculation> Default Country).3. Going to the shopping path without specifying the delivery address. Solution is quite […]

Read more

Clear database from tables

SET FOREIGN_KEY_CHECKS = 0; SET GROUP_CONCAT_MAX_LEN=32768; SET @tables = NULL; SELECT GROUP_CONCAT(table_name) INTO @tables FROM information_schema.tables WHERE table_schema = (SELECT DATABASE()); SELECT IFNULL(@tables,’dummy’) INTO @tables; SET @tables = CONCAT(‘DROP TABLE IF EXISTS ‘, @tables); PREPARE stmt FROM @tables; EXECUTE stmt; DEALLOCATE PREPARE stmt; SET FOREIGN_KEY_CHECKS = 1;

Read more

$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’, ‘main_table.base_grand_total’); $collection->addFilterToMap(‘grand_total’, ‘main_table.grand_total’); $collection->addFilterToMap(‘increment_id’, ‘main_table.increment_id’);

Read more

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 config.xml file <frontend> <category> <collection> <attributes> <custom_attribute_code/> </attributes> </collection> </category> </frontend> After that You can use this attribute, in rendering method _renderCategoryMenuItemHtml defined in Mage_Catalog_Block_Navigation. Like that: $category->getCustomAttributeCode() Please remember to rewrite […]

Read more

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 takes actual collection, and callback function as parameters. Major elements: ‘filter_condition_callback’ => array($this, ‘filter_special_price’), and: public function filter_special_price($collection, $column) { if (!$value = $column->getFilter()->getValue()) { return $this; } $dateToday = […]

Read more

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 uncomment Include conf/extra/httpd-vhosts.conf 3. Create new vhost file : Zend\Apache2\conf\extra\httpd-vhosts.conf You can base on exist one in this file. 4. Add new created local domain name for vhost in file: […]

Read more

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 adminhtml/widget_grid_column_renderer_radio input adminhtml/widget_grid_column_renderer_input select adminhtml/widget_grid_column_renderer_select text adminhtml/widget_grid_column_renderer_longtext store adminhtml/widget_grid_column_renderer_store wrapline adminhtml/widget_grid_column_renderer_wrapline theme adminhtml/widget_grid_column_renderer_theme default type adminhtml/widget_grid_column_renderer_text

Read more

How to cheat history back

Simple just like this:

Read more