Iyngaran Iyathurai | Software Engineer | Web, Mobile, PHP, Java and Emerging Technology Application Developer

A few words about me

Useful direct SQL queries for Magento 2 developers

Select product default Attribute set id [crayon-5c44fb9e1830e736769288/] Select product Attribute Group Id by using attribute_group_code and Attribute Set ID [crayon-5c44fb9e1831a532078336/] Update attribute_group_id for product attribute [crayon-5c44fb9e1831f596169314/] Update sort_order for product attribute [crayon-5c44fb9e18323296293907/] 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 [...]

Oct. 21 2017

Build Multi-lingual application with the Zend Framework

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 [...]

Aug. 1 2017

Install Magento 2 with Sample Data

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. [...]

Jul. 8 2017

Configure PHP Remote Debugging in Vagrant box with Xdebug and PhpStorm

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. [crayon-5c44fb9e1e669706416839/] 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 [crayon-5c44fb9e1e66f104693647/] And the following lines at [...]

Apr. 1 2017

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

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 [...]

Mar. 31 2017

Installation And Upgrade Scripts in Magento

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/ [...]

Mar. 8 2017

Creating & Running Cron in Magento 2 Custom Module

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 [crayon-5c44fb9e44ea2518752838/] As you can see from above code, we have [...]

Mar. 2 2017

Create static blocks programmatically in Magento2

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: [crayon-5c44fb9e51078204618435/] That’s it!. Clear cache and upgrade magento. [crayon-5c44fb9e51086160423733/]

Mar. 2 2017

Create CMS pages programmatically in Magento2

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: [crayon-5c44fb9e5d6d3876731371/] That’s it!. Clear cache and upgrade magento. [crayon-5c44fb9e5d6de875153670/]

Mar. 2 2017

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

To update cms static block for particular store programmatically you can use following code. [crayon-5c44fb9e65761276199145/]