In this tutorial, Today I will explain to you how to use the fetchOne() method with SQL Query in Magento 2. There are many times we need to require to perform operation on data by SQL Query. fetchOne() method is used to fetch first column of the first row of the SQL query output. You may also like this :…
In this tutorial, Today I will explain to you how to write SQL Query in Magento 2 with standard way. There are many times we need to require to perform operation on data by SQL Query. But, the developers are write direct that sql query in their code which is not proper way. It will caused security issue as well.…
In this Tutorial, Today I will explain you how to generate product url rewrites in Magento 2 Programmatically. Sometimes, product is created but URL is not generated. Hence, the product page URL will be return as 404 & it will be impact on SEO score. It will also down your website SEO as well. So, if you want to generate…
In this tutorial, Today I will explain to how to insert multiple records into database table in Magento 2. Generally, Using Model or Factory we add single records into database table. However, sometimes we require to insert multiple rows into database table. If you create factory model class and call into foreach loop to insert multiple records then it maybe…
In this tutorial, Today I will explain to how to create custom admin theme in Magento 2. Using custom admin theme, you can customize layout of admin dashboard. By Custom Admin Theme, You can customize backend panel with custom logo, custom fonts, change design of the panel etc. In this Magento 2 admin theme development article, we are going to…
In this tutorial, Today I will explain how to use extension attributes in Magento 2. Extension attributes are used to allow customize of the service contract. It will helpful to add additional data to the entities. For that, Every interface that extends \Magento\Framework\Api\ExtensibleDataInterface can be extended with the help of the extension attributes. In extension attributes, getExtensionAttributes method returns an…
In this tutorial, Today I will explain to how to set limit of query complexity and depth of graphql in Magento 2. Magento 2.3 has added GraphQL functionality. However, It will allow some queries that is not useful in your custom frontend query execution. To avoid that type execution, we can set limit of query complexity and depth level of…
In this tutorial, Today I will explain to how to change currency position in Magento 2. In many website, we need to change currency from left to right for whole website. By default, In Magento 2 it’s display left side. So, How to change currency position from left to right. Let’s follow the below steps for that. You may also…
In this tutorial, Today I will explain to how to specific product image resize using command line in Magento 2. In Magento 2, They’re provide default commad for product image resize. When, we execute command it will resize whole Magento’s product images. But, during development time if you need to check specific product image resize then, how you need to…
In this tutorial, Today I will explain to how to create a customer attribute using data patches in Magento 2. From Magento 2.3.x, Magento brings new features which is data patches. The Data Patch is class that contains data notification instruction. Previously, Magento 2 uses InstallData and UpgradeData file use add data in core table or custom table. From Magento…