Useful direct SQL queries for Magento 2 developers

February 14, 2018 Iyngaran Iyathurai 0

Select product default Attribute set id

  Select product Attribute Group Id by using attribute_group_code and Attribute Set ID

  Update attribute_group_id for product attribute

  Update sort_order for product attribute

  Delete a custom attribute using entity_type_id and attribute_code. Delete a custom attribute using entity_type_id and attribute_code.  For this example, I am going to delete a product attribute, which has  attribute_code as ‘iyn_product_option’. To delete a custom attribute, we need to […]

Build Multi-lingual application with the Zend Framework

October 21, 2017 Iyngaran Iyathurai 0

We can not imagine a modern web application without a multi language support. I will show you how easy it is to setup usage of multiple languages in Zend Framework and how to setup some basic language routes (handy for SEO stuff). The Zend Framework offers many ways for you to store your translated strings. It could be an array, a CSV or XML file or you could use gettext which we will be using […]

Install Magento 2 with Sample Data

August 1, 2017 Iyngaran Iyathurai 0

You can install Magento in different ways. In this article, I will show you how to install Magento via GitHub. Before continuing, make sure you have all the prerequisites, required for running Magento 2. Step 1: Clone Magento repository First we must clone Magento repo from here: https://github.com/magento/magento2 or you can download releases on https://github.com/magento/magento2/releases. My document root folder location is  – /home/vagrant/learning.portal/apps/magento2.blog.dev/public_html/src/web So let’s clone the Magento repository in to the document root folder. […]

Configure PHP Remote Debugging in Vagrant box with Xdebug and PhpStorm

July 8, 2017 Iyngaran Iyathurai 0

Note: This article concerns PHP 7.0,PhpStorm 2017.2 (EAP) and Vagrant box bento/centos-7.2. Step1: Install Xdebug on your Vagrant virtual machine You need to have Xdebug installed on your virtual machine to benefit from its services.

Then, we need configure it: We need enable the remote debug and add IDEKEY on XDEBUG. To do that, we need modify the php-xdebug configuration file (xdebug.ini). Lets modify the php-xdebug configuration file

And the following lines at […]

Magento 2: Override/Rewrite Block, Model, Controller, Helper

April 1, 2017 Iyngaran Iyathurai 3

In most cases, when work with Magento, you will have to change the core functionality of block, model, controller and helper. It is not good if you modify the core files, that may have certain influence on another program. Therefore, today, I highly recommend the great way to rewrite all files in a convenient way. This article shows how you can override / rewrite Block, Controller, Model and Helper using plugin and preference in Magento […]

Installation And Upgrade Scripts in Magento

March 31, 2017 Iyngaran Iyathurai 0

A Magento install and upgrade script is a part of module development. In this article, we will find out how to install and upgrade sql script for module in Magento 2. When you install or upgrade a module, you may need to change the database structure or add some new data for current table. To do this, Magento 2 provide you some classes which you can do all of them. For example, here – app/code/Magento/Catalog/Setup/ […]

Creating & Running Cron in Magento 2 Custom Module

March 8, 2017 Iyngaran Iyathurai 2

This article shows how to create and run cronjob in a custom module in Magento 2. Here, we will focus on creating / setting up / running cron for a custom Magento 2 module. Let us suppose, we are developing a custom module named Iyngaran_DemoModule (app/code/Iyngaran/DemoModule). To define the cron settings for your custom module, you need to write the following code in app/code/Iyngaran/DemoModule/etc/crontab.xml. app/code/Iyngaran/DemoModule/etc/crontab.xml

As you can see from above code, we have […]

Create static blocks programmatically in Magento2

March 2, 2017 Iyngaran Iyathurai 0

Creating a static blocks in Magento is simple as navigate to Admin Panel -> CMS -> Static Blocks. But while you developing your extension you might need to create a Magento static blocks programmatically. Here is the way how you can achieve it:

  That’s it!. Clear cache and upgrade magento.

 

Create CMS pages programmatically in Magento2

March 2, 2017 Iyngaran Iyathurai 0

Creating a CMS pages in Magento is simple as navigate to Admin Panel -> CMS -> Pages. But while you developing your extension you might need to create a Magento CMS Page programmatically. Here is the way how you can achieve it:  

That’s it!. Clear cache and upgrade magento.

   

Magento 2.x. Update/add cms static block programmatically.

March 2, 2017 Iyngaran Iyathurai 0

To update cms static block for particular store programmatically you can use following code.