Cozmot, Author at Cozmot Inc

How to Import Italian States in Magento

by Cozmot | Nov 5, 2020 | Magento2

Magento 2 store owners do not get the default dropdown option that contains all the states of Italy. In online stores when forms are used, asking customers to type the name of their respective state contributes to poor user experience. On the other hand, if the developers have to write code for each registration form and include dropdown list, it is a time-consuming and tedious task. To give better user experience and easing the developer’s task, importing states to display in dropdown option is the best thing to implement. I have prepared an SQL script to import Italian states in Magento.

SQL Script to the Import Italian States in Magento:

1

2

3

4

5

6

7

8

9

10

11

12

13

14

15

16

17

18

19

20

21

22

23

24

25

26

INSERT INTO directory_country_region (region_id, country_id, code, default_name) VALUES

(NULL, ‘IT’, ‘AG’, ‘Sicilia’),

(NULL, ‘IT’, ‘AL’, ‘Piemonte’),

(NULL, ‘IT’, ‘AN’, ‘Marche’),

(NULL, ‘IT’, ‘AO’, ‘Valle d Aosta’),

(NULL, ‘IT’, ‘AQ’, ‘Abruzzo’),

(NULL, ‘IT’, ‘AR’, ‘Toscana’),

(NULL, ‘IT’, ‘AP’, ‘Marche’),

(NULL, ‘IT’, ‘AT’, ‘Piemonte’),

(NULL, ‘IT’, ‘AV’, ‘Campania’),

(NULL, ‘IT’, ‘BA’, ‘Puglia’),

(NULL, ‘IT’, ‘BT’, ‘Punglia’),

(NULL, ‘IT’, ‘BL’, ‘Veneto’),

(NULL, ‘IT’, ‘PM’, ‘Piedmont’),

(NULL, ‘IT’, ‘SD’, ‘Sardinia’),

(NULL, ‘IT’, ‘SC’, ‘Sicily’),

(NULL, ‘IT’, ‘TT’, ‘Trentino-Alto Adige’),

(NULL, ‘IT’, ‘TC’, ‘Tuscany’),

(NULL, ‘IT’, ‘UM’, ‘Umbria’),

(NULL, ‘IT’, ‘VC’, ‘Valle d’Aosta‘),

(NULL, ‘IT‘, ‘VN‘, ‘Veneto‘);

INSERT INTO directory_country_region_name( locale, region_id, name )

SELECT ‘en_US‘ AS “language”, region_id, default_name

FROM directory_country_region

WHERE country_id = ‘IT‘

That’s it. Feel free to use the above script to import Italian states in Magento 1 or Magento 2 development. Share this programmatic solution with the Italian store owners via social media. Buona Giornata. 😉 Thank you.]]>

How to Prevent Auto Logout When Uploading Zip File for Downloadable Product in Magento 1

by Cozmot | Nov 5, 2020 | Magento2

prevent auto logout when uploading zip file for downloadable product in Magento 1. If you have recently upgraded your Magento 1 version, you might face this issue. While uploading the zip file for downloadable product type, you get the “uploading….” message but nothing happens. Eventually, you are returned to the admin login screen automatically. Resolve this issue using the below method:

Solution to prevent auto logout when uploading zip file for downloadable product in Magento 1:

Run the below query in database:

1	INSERT INTO `core_config_data` (`config_id`, `scope`, `scope_id`, `path`, `value`, `updated_at`) VALUES (NULL, ‘default’, ‘0’, ‘web/session/use_admin_sid’, ‘1’, CURRENT_TIMESTAMP);

That’s it. Any doubts about the solution can be mentioned in the Comments section below. I’d be happy to help. Also, do share the solution with Magento 1 store owners via social media. Thank you.]]>

Blog Posts How to Create Module in Magento 2

by Cozmot | Nov 5, 2020 | Magento2

Magento 2 CMS is an excellent option to develop an online store. However, it may not be enough for modern business requirements. To overcome the default limitations, there are Magento 2 extensions available in the market that extend the functionality of Magento 2. You can also opt to create module in Magento 2 rather than approaching any third party extension providers. However, you may have tons of questions regarding Magento 2 module development such as how one can develop Magento 2 module that helps the Magento 2 store to increase store facility, what are the most important things for the development of a module and so on. Well, don’t worry. Here we have prepared a comprehensive guide on creating your first Magento 2 module. To create a module or extension in Magento 2, you need to create these important files.

module.xml
registration.php

But, before getting started, let’s discuss some of the basic things that you need to know. The extension is built under app/code. When you go through this path, the first folder name demonstrates the name of the extension provider company. The second folder shows the name of the extension. For easy explanation, we are here giving the name of extension “Extension” and the name of a company “Meetanshi”. Alright. So coming back to the important files. What you need to do is create a file having a specific path.

Steps to create a module in Magento 2:

1. Create module.xml at app/code/Cozmot/Extension/etc In module.xml file, copy and paste this code.

1

2

3

4

5

6

<?xml version=“1.0”?>

<config xmlns:xsi=“http://www.w3.org/2001/XMLSchema-instance”

xsi:noNamespaceSchemaLocation=“../../../../../lib/internal/Magento/Framework/Module/etc/module.xsd”>

</module>

</config>

Now, you also need to create a file that is registration.php. 2. Create registration.php at app/code/Cozmot/Extension

1

2

3

4

5

6

7

<?php

use Magento\Framework\Component\ComponentRegistrar;

ComponentRegistrar::register(

ComponentRegistrar::MODULE,

‘Cozmot_Extension’,

__DIR__

);

These two files are mandatory to create and get started with extension development. After creating module.xml and registration.php files, the next step is to execute commands in the command line.

1

2

3

php bin/magento setup:upgrade

php bin/magento setup:static–content:deploy –f

php bin/magento cache:flush

Run these three commands and your extension will appear in app/etc/config.php. If the command gives output ‘0’, that indicates the extension is disabled. On the other hand, if the command shows output ‘1″, it explains that the extension is enabled and all the functionalities of the extension are working smoothly.

The image explains that the name of the extension “Meetanshi_Extension” is enabled. That’s it. In the next tutorial, you will learn how to display a message on the frontend. However, if you do not want the hassle of creating an extension on your own, you can visit COZMOT for top-notch extensions developed by certified Magento developers! Do not forget to share the series of Magento 2 module development tutorials with the beginners via social media. Thank you.]]>

How to Display Table Data in Magento 2

by Cozmot | Nov 5, 2020 | Magento2

previous tutorial, you learned how to save form data to the custom table. Continuing with the same, we will This tutorial demonstrates how to display table data in Magento 2. As we have already learned how to save data to the table, let us understand how to display the saved data. All the data which you have stored can be displayed on the frontend. To do that, we need to create action so that we can display data on the frontend. The given path is an example: http://example.com/extension/index/showdata

Programmatic Method to Display Table Data in Magento 2

1. Create a controller Showdata.php at app\code\Cozmot\Extension\Controller\Index\

1

2

3

4

5

6

7

8

9

10

11

12

13

14

15

16

17

18

19

20

21

22

23

<?php

namespace Cozmot\Extension\Controller\Index;

use Magento\Framework\App\Action\Context;

use Magento\Framework\View\Result\PageFactory;

use Magento\Framework\App\Action\Action;

class Showdata 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 extension_index_showdata.xml at app\code\Cozmot\Extension\view\frontend\layout\

1

2

3

4

5

6

7

8

9

10

<?xml version=“1.0”?>

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

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

<body>

<block class=“Cozmot\Extension\Block\Showdata” name=“showdata”

template=“Cozmot_Extension::showdata.phtml” cacheable=“false”/>

</referenceContainer>

</body>

</page>

3. Create Showdata.php at app\code\Cozmot\Extension\Block\

1

2

3

4

5

6

7

8

9

10

11

12

13

14

15

16

17

18

19

20

21

22

23

24

25

<?php

namespace Cozmot\Extension\Block;

use Magento\Framework\View\Element\Template;

use Magento\Backend\Block\Template\Context;

use Cozmot\Extension\Model\ResourceModel\Extension\CollectionFactory;

class Showdata extends Template

{

public $collection;

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

{

$this->collection = $collectionFactory;

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

}

public function getCollection()

{

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

}

4. Create showdata.phtml file at app\code\Cozmot\Extension\view\frontend\templates\

1

2

3

4

5

6

7

8

9

10

11

12

13

14

15

16

17

18

19

20

21

22

23

24

25

26

27

28

29

30

31

32

33

34

35

36

37

38

39

40

41

42

<?php

$collection = $block->getCollection();

if ($collection->count()) {

?>

<thead>

<tr>

</tr>

</thead>

<tbody>

<?php

foreach ($collection as $item): ?>

<tr>

<td data–th=“<?= $block->escapeHtml(__(‘ID’)) ?>“ class=“col id”>

<?php echo $item->getId() ?>

</td>

<td data–th=“<?= $block->escapeHtml(__(‘Name’)) ?>“ class=“col name”>

<?php echo $item->getName() ?>

</td>

<td data–th=“<?= $block->escapeHtml(__(‘Email’)) ?>“ class=“col email”>

<?php echo $item->getEmail() ?>

</td>

<td data–th=“<?= $block->escapeHtml(__(‘Telephone’)) ?>“ class=“col telephone”>

<?php echo $item->getTelephone() ?>

</td>

<td data–th=“<?= $block->escapeHtml(__(‘Created At’)) ?>“

class=“col title”><?php echo date(‘Y-m-d’, strtotime($item->getCreatedAt())); ?></td>

</tr>

<?php endforeach; ?>

</tbody>

</table>

</div>

<?php

}

?>

After following these four steps, you will be able to display table data.

Done! If you have queries regarding this blog, feel free to ask in the Comment section below. I would be happy to help you. Consider sharing this post novice Magento developer. Thank you.]]>

How to Save Form Data to the Custom Table in Magento 2

by Cozmot | Nov 5, 2020 | Magento2

save form data to the custom table in Magento 2. When you fill out details in a form and click on a Submit button, the data has to be stored in a table. To do that, you will need to create Submit.php file. For instance, if you want to collect name, email addresses and telephone number of customers for sending newsletters, the data should be stored in a database. If the data is not stored in the database, we simply cannot access and send newsletters. Learn the programmatic method as shown below:

Method to Save Form Data to the Custom Table in Magento 2:

Create a file app\code\Extension\Controller\Index\Submit.php

1

2

3

4

5

6

7

8

9

10

11

12

13

14

15

16

17

18

19

20

21

22

23

24

25

26

27

28

29

30

31

32

33

34

35

36

37

38

39

40

41

42

43

44

<?php

namespace Cozmot\Extension\Controller\Index;

use Magento\Framework\App\Action\Context;

use Magento\Framework\View\Result\PageFactory;

use Meetanshi\Extension\Model\ExtensionFactory;

use Magento\Framework\Controller\ResultFactory;

use Magento\Framework\App\Action\Action;

class Submit extends Action

{

protected $resultPageFactory;

protected $extensionFactory;

public function __construct(

Context $context,

PageFactory $resultPageFactory,

ExtensionFactory $extensionFactory

)

{

$this->resultPageFactory = $resultPageFactory;

$this->extensionFactory = $extensionFactory;

parent::__construct($context);

}

public function execute()

{

try {

$data = (array)$this->getRequest()->getPost();

if ($data) {

$model = $this->extensionFactory->create();

$model->setData($data)->save();

$this->messageManager->addSuccessMessage(__(“Data Saved Successfully.”));

}

} catch (\Exception $e) {

$this->messageManager->addErrorMessage($e, __(“We can\’t submit your request, Please try again.”));

}

$resultRedirect = $this->resultFactory->create(ResultFactory::TYPE_REDIRECT);

$resultRedirect->setUrl($this->_redirect->getRefererUrl());

return $resultRedirect;

}

Implement the code and you will be able to save data in the database. As we have written the message “Data Saved Successfully” to display while submitting the data, the same message will appear when the data is being saved.

That’s it. If you have queries regarding this blog, feel free to ask in the Comment section below. I will try my level best to solve your problem. Do consider sharing this blog post with the beginners who are willing to learn Magento extension development. Thank you.]]>

How to Import Italian States in Magento

SQL Script to the Import Italian States in Magento:

How to Prevent Auto Logout When Uploading Zip File for Downloadable Product in Magento 1

Solution to prevent auto logout when uploading zip file for downloadable product in Magento 1:

Blog Posts How to Create Module in Magento 2

Steps to create a module in Magento 2:

How to Display Table Data in Magento 2

Programmatic Method to Display Table Data in Magento 2

How to Save Form Data to the Custom Table in Magento 2

Method to Save Form Data to the Custom Table in Magento 2:

Recent Posts

Recent Comments

Join 150+ Clients

About Us

Company

Reach us