Cozmot, Author at Cozmot Inc

How to Import and Export Customer Data in Magento 2

by Cozmot | Nov 5, 2020 | Magento2

Magento 2 allows the merchant to import and export customers.

Steps to Import and Export Customer Data in Magento 2

First, let us understand how to export customers.

How to Export Customer Data in Magento 2

Log in to Magento 2 admin panel
Navigate to System > Data Transfer > Export
Under Export Settings, select Customers Main File in Entity Type
The Export File Format is CSV by default
In Entity Attribute, select choose the attribute that you want to exclude from CSV file
Click Continue
Here is CSV file having customer data.

How to Import Customer Data in Magento 2

How to Import and Export Customer Data in Magento 2 - CSV file

Now, let us add customer data in the CSV list and import the file.

Log in to Magento 2 admin panel
Navigate to System > Data Transfer > Import
In Entity Type, select Customer Main File
Select the Add/Update Complex Data in Import Behavior
Go to Choose File in Select File to Import
Click Check Data

That’s it. The customer data is imported. If you need more help regarding this blog, feel comfortable for asking in the Comment section below. I would be happy to solve your queries. Please do consider sharing this blog with Magento Community via social media. Thank you.]]>

How to Add Custom Layout to CMS Pages in Magento 2

by Cozmot | Nov 4, 2020 | Magento2

app/design/frontend/_YOUR_VENDOR_/_YOUR_THEME_/Magento_CMS/layout/cms_page_view.xml and Content:


<strong><page xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" layout="2columns-left" xsi:noNamespaceSchemaLocation="urn:magento:framework:View/Layout/etc/page_configuration.xsd"></strong>
<strong>    <head></strong>
<strong>        <!-- <css src="Vendor_Extension/css/aboutus.css"/> --></strong>
<strong>    </head></strong>
<strong>     <body></strong>
<strong>        <referenceContainer name="sidebar.main"></strong>
<strong>        <block class="Magento\LayeredNavigation\Block\Navigation\Category" name="catalog.leftnav" before="-" template="layer/view.phtml"></strong>
<strong>            <block class="Magento\LayeredNavigation\Block\Navigation\State" name="catalog.navigation.state" as="state" /></strong>
<strong>            <block class="Magento\LayeredNavigation\Block\Navigation\FilterRenderer" name="catalog.navigation.renderer" as="renderer" template="layer/filter.phtml"/></strong>
<strong>        </block></strong>
<strong>    </referenceContainer></strong>
<strong>    <referenceContainer name="content"></strong>
<strong>    <block class="Magento\Catalog\Block\Product\ListProduct" name="category.products.list" as="product_list" template="Magento_Catalog::product/list.phtml"></strong>
<strong>        <container name="category.product.list.additional" as="additional" /></strong>
<strong>        <block class="Magento\Framework\View\Element\RendererList" name="category.product.type.details.renderers" as="details.renderers"></strong>
<strong>            <block class="Magento\Framework\View\Element\Template" as="default"/></strong>
<strong>        </block></strong>
<strong>        <block class="Magento\Catalog\Block\Product\ProductList\Item\Container" name="category.product.addto" as="addto"></strong>
<strong>            <block class="Magento\Catalog\Block\Product\ProductList\Item\AddTo\Compare"</strong>
<strong>                   name="category.product.addto.compare" as="compare"</strong>
<strong>                   template="Magento_Catalog::product/list/addto/compare.phtml"/></strong>
<strong>        </block></strong>
<strong>        <block class="Magento\Catalog\Block\Product\ProductList\Toolbar" name="product_list_toolbar" before="-" template="Magento_Catalog::product/list/toolbar.phtml"></strong>
<strong>            <block class="Magento\Theme\Block\Html\Pager" name="product_list_toolbar_pager"/></strong>
<strong>        </block></strong>
<strong>        <action method="setToolbarBlockName"></strong>
<strong>            <argument name="name" xsi:type="string">product_list_toolbar</argument></strong>
<strong>        </action></strong>
<strong>    </block></strong>
<strong></referenceContainer></strong>
<strong>    </body></strong>
<strong></page>

</strong><span style="color: #000000;">We can addblocks, sidebar, custom code etc to this. for any help you can contact, our developers would be happy to assist.</span>

<head>

</head>

<body>

</block>

</referenceContainer>

</block>

<block class="Magento\Catalog\Block\Product\ProductList\Item\AddTo\Compare"

name="category.product.addto.compare" as="compare"

template="Magento_Catalog::product/list/addto/compare.phtml"/>

</block>

</block>

<argument name="name" xsi:type="string">product_list_toolbar</argument>

</action>

</block>

</referenceContainer>

</body>

</page>

We can addblocks, sidebar, custom code etc to this. for any help you can contact, our developers would be happy to assist.

]]>

Deprecated: pathinfo(): Passing null to parameter #1 ($path) of type string is deprecated in /var/www/html/wp-content/plugins/urvanov-syntax-highlighter/class-urvanov-syntax-highlighter-langs.php on line 86

Deprecated: pathinfo(): Passing null to parameter #1 ($path) of type string is deprecated in /var/www/html/wp-content/plugins/urvanov-syntax-highlighter/class-urvanov-syntax-highlighter-langs.php on line 86

How to Count Post Views in WordPress without Plugin

by Cozmot | Nov 3, 2020 | Wordpress


<strong><span class="hljs-function"><span class="hljs-keyword">function</span> <span class="hljs-title">gt_get_post_view</span><span class="hljs-params">()</span> </span>{
    $count = get_post_meta( get_the_ID(), <span class="hljs-string">'post_views_count'</span>, <span class="hljs-keyword">true</span> );
    <span class="hljs-keyword">return</span> <span class="hljs-string">"$count views"</span>;
}
<span class="hljs-function"><span class="hljs-keyword">function</span> <span class="hljs-title">gt_set_post_view</span><span class="hljs-params">()</span> </span>{
    $key = <span class="hljs-string">'post_views_count'</span>;
    $post_id = get_the_ID();
    $count = (int) get_post_meta( $post_id, $key, <span class="hljs-keyword">true</span> );
    $count++;
    update_post_meta( $post_id, $key, $count );
}
<span class="hljs-function"><span class="hljs-keyword">function</span> <span class="hljs-title">gt_posts_column_views</span><span class="hljs-params">( $columns )</span> </span>{
    $columns[<span class="hljs-string">'post_views'</span>] = <span class="hljs-string">'Views'</span>;
    <span class="hljs-keyword">return</span> $columns;
}
<span class="hljs-function"><span class="hljs-keyword">function</span> <span class="hljs-title">gt_posts_custom_column_views</span><span class="hljs-params">( $column )</span> </span>{
    <span class="hljs-keyword">if</span> ( $column === <span class="hljs-string">'post_views'</span>) {
        <span class="hljs-keyword">echo</span> gt_get_post_view();
    }
}
add_filter( <span class="hljs-string">'manage_posts_columns'</span>, <span class="hljs-string">'gt_posts_column_views'</span> );
add_action( <span class="hljs-string">'manage_posts_custom_column'</span>, <span class="hljs-string">'gt_posts_custom_column_views'</span> );</strong>

function gt_get_post_view() {

$count = get_post_meta( get_the_ID(), 'post_views_count', true );

return "$count views";

}

function gt_set_post_view() {

$key = 'post_views_count';

$post_id = get_the_ID();

$count = (int) get_post_meta( $post_id, $key, true );

$count++;

update_post_meta( $post_id, $key, $count );

}

function gt_posts_column_views( $columns ) {

$columns['post_views'] = 'Views';

return $columns;

}

function gt_posts_custom_column_views( $column ) {

if ( $column === 'post_views') {

echo gt_get_post_view();

}

add_filter( 'manage_posts_columns', 'gt_posts_column_views' );

add_action( 'manage_posts_custom_column', 'gt_posts_custom_column_views' );

2. Then, copy the code below and paste it into single.php file in the while loop.


<strong><span class="php"><span class="hljs-meta">
<?php</span> gt_set_post_view(); <span class="hljs-meta">?>
</span></span></strong>

<?php gt_set_post_view(); ?>

3. Next, copy the following code and paste it where you want to show the number of views

<div class=”densor” style=””><?= gt_get_post_view(); ?></div>

4. When it’s all done, you will see the post view like this:]]>

How to Fix Unique Constraint Violation Found in Magento 2

by Cozmot | Nov 3, 2020 | Magento2

You may have got integrity constraint violation error while creating an order from the backend in Magento 2 store. When you face this error, it means that a duplicate value is created in the database table. Here’s the solution to fix unique constraint violation in Magento 2 admin panel.

Steps to Fix Unique Constraint Violation Found in Magento 2:

Check the table “sequence_order_1” where 1 refers to the store id.

In the above table, the sequence_value column should be auto_increment to fix the integrity constraint violation in Magento 2. That’s it. Any doubts about the error and its solution can be mentioned in the Comments section below. I’d be happy to help. Do share the solution with the Magento Community via social media. Thank you.]]>

How to Create Block and Template in Magento 2

by Cozmot | Nov 3, 2020 | Magento2

create a block and template file in Magento 2. When we want to display content using an action method, we need to create a block and template file. Block file has functions that we use in a template file. Moreover, the template also includes the content that has code related to HTML and PHP. The XML file for layout demonstrates which block and which template file will be called. Another important thing to keep that in mind is that you have to create a layout file based on the action that you have developed. We will continue with the same example that we discussed in the previous tutorial. Therefore, we have to create a file having extension_index_index.xml name. You may have a question why the XML file is created with a name of extension_index_index.xml. It is because the action that we developed was extension/index/index.

Method to Create Block Template in Magento 2

1. Update Controller File:

Earlier, the message was just printed. Now, what we are doing is to print a message with a page. To do this, we have to update the code in a file app/code/Meetanshi/Extension/Controller/Index/Index.php

<?php

namespace Meetanshi\Extension\Controller\Index;

use Magento\Framework\App\Action\Context;

use Magento\Framework\View\Result\PageFactory;

use Magento\Framework\App\Action\Action;

class Index extends Action

{

protected $resultPageFactory;

public function __construct(Context $context, PageFactory $resultPageFactory)

{

parent::__construct($context);

$this->resultPageFactory = $resultPageFactory;

}

public function execute()

{

return $this->resultPageFactory->create();

}

2. Create a Block File:

For creating a block file, give the name Form.php and create this file in a given path. app\code\Meetanshi\Extension\Block\Form.php

<?php

namespace Meetanshi\Extension\Block;

use Magento\Framework\View\Element\Template;

use Magento\Backend\Block\Template\Context;

class Form extends Template

{

public function __construct(Context $context, array $data = [])

{

parent::__construct($context, $data);

}

3. Create a Template File:

Creating a template file is extremely simple. Save form.phtml with the given code below and use the path for creating the file. app\code\Meetanshi\Extension\view\frontend\templates\form.phtml

1	<h1><?php echo __(‘My First Extension’) ?></h1>

4. Create a Layout File:

The last and the final file that you need to create a block template is the layout file. Make sure, the name of your layout file has to be extension_index_index.xml. In the given path, use the code and save the file. app\code\Meetanshi\Extension\view\frontend\layout\extension_index_index.xml

<?xml version=“1.0”?>

<page layout=“1column-left” xmlns:xsi=“http://www.w3.org/2001/XMLSchema-instance”

xsi:noNamespaceSchemaLocation=“urn:magento:framework:View/Layout/etc/page_configuration.xsd”>

<body>

</referenceContainer>

</body>

</page>

You can check which block file and template file are being called.

Here is how the output looks on the frontend. As you can see in the below image, the output now shows header and footer. Also, Luma is a default theme of Magento 2. Therefore, you will see Luma theme for the output of your extension. That’s it. If you have questions, feel free to ask in the Comment section below. Do share this post to beginner and passionate who wants to learn Magento extension development. Thank you.]]>

How to Import and Export Customer Data in Magento 2

Steps to Import and Export Customer Data in Magento 2

How to Export Customer Data in Magento 2

How to Import Customer Data in Magento 2

How to Add Custom Layout to CMS Pages in Magento 2

How to Count Post Views in WordPress without Plugin

How to Fix Unique Constraint Violation Found in Magento 2

Steps to Fix Unique Constraint Violation Found in Magento 2:

How to Create Block and Template in Magento 2

Method to Create Block Template in Magento 2

1. Update Controller File:

2. Create a Block File:

3. Create a Template File:

4. Create a Layout File:

Recent Posts

Recent Comments

Join 150+ Clients

About Us

Company

Reach us