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

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

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.

 

Magento 2: Add a CMS Static Block via XML Updates in you homepage

March 2, 2017 Iyngaran Iyathurai 0

These are the steps to add a CMS Static block to your homepage using XML Updates in XML files. Go to the Admin Panel > Content > Blocks Click on “Add new Block” Create your custom block, make sure that the option “Enabled” is checked and save it. In the project code, go to app/design/frontend/[VendorName]/[themeName]/ and add the following file app/design/frontend/[VendorName]/[themeName]/Magento_Cms/layout/cms_index_index.xml

 NOTE: You can use “before” or “after” to place the block as you […]

Create Magento 2 admin user from shell/terminal

December 5, 2016 Iyngaran Iyathurai 0

Thankfully, Magento 2’s newly introduce CLI (command-line interface) allows you to do this without writing any code. Here is an example of how I would execute this command to create a new administrator. Go to your magento bin folder in terminal, Example – cd <your Magento install dir>/bin and run the following command.