"magento 2"

Magento CLI Commands: How to Run Product Import in Magento 2 from CLI

- Fire development, Magento 2

Magento 2 Development; Magento 2 tutorial

Welcome to our guide to Magento CLI commands. If you want to optimize your daily routine related to Magento 2 product import, you’ve come to the right place. Below, we shed light on several data transfer optimizations that will help you save tons of time spent on daily chores. Many merchants look for tips on importing products to Magento 2 using the command line interface. Below, you will find the easiest way to do so.

The following article is based on the StackExchange question by Massimo Camoni and the answer by Khoa TruongDinh. However, it extends the solution provided in the discussion. So, let’s see how to run Magento 2 product import via CLI. You will find the Magento 2 CLI commands list for importing and exporting products and other entities on your e-commerce website.
Continue Reading

Magento 2 GraphQL Tutorial: How to Import Data via GraphQL API into Magento 2

- E-Commerce, Magento 2, Our extensions

Magento 2 graphql import export

The following Magento 2 GraphQL tutorial describes how to import and export data into/from Magento 2 with the help of GraphQL API. This connection type is yet impossible out of the box, but the community is working hard to introduce it as a replacement for REST API. At the same time, some tools enable Magento 2 GraphQL API import and export right now. For instance, you can leverage the Magento 2 GraphQL API import and export processes with the Improved Import & Export Magento 2 module.

The following article sheds light on how to import data into Magento 2 via GraphQL API with the help of our extension. You will find out how to enable the Magento 2 GraphQL API import and what extra benefits it is associated with. If you are not familiar with what GraphQL API is, we’ve also prepared a chapter that describes this standard and its benefits over REST and SOAP. Besides, an FAQ section provides answers to frequently asked questions about GraphQL Magento 2 import and export processes.
Continue Reading

How to Import Multiselect Attribute Values to Magento 2

- E-Commerce, Fire development, Magento 2

Magento 2 import export debug log

In the following article, we explain how to get multiselect attribute values in Magento 2 via import and export processes. But how it it possible if the default data transfer tools don’t offer the desired functionality?

The default data transfer capabilities of Magento 2 still need various improvements, especially if you use the Open Source version of the platform. However, numerous community-based initiatives that tend to improve the basic functionality are at your service. They vary between coding tricks and standalone extensions. Depending on the complexity of your business, your technical skills, or the faced issues, you can select one that perfectly suits your needs. What to do if you cannot find the solutions? Ask the community for support. 

Recently, we came across an interesting issue on Stackexchange. The author was wondering whether it was possible to create values for a multiselect attribute when uploading a CSV file. Below, we share two solutions: the community-based algorithm for addressing the problem and the Firebear-proposed tool. While the first one requires additional coding experience and is almost unreal to implement for non-technical users, the extension we offer is admin-friendly and intuitive so that anyone can use it to cope with the difficulties described below. 

To make a long story short, let’s explore the issue and describe how Magento lets you get product multiselect attribute values. More tips are available here: Magento 2 Cookbook.
Continue Reading

How to import data from external MySQL database to Magento 2

- E-Commerce, Magento 2, Our extensions

magento mysql direct update table

Often it is necessary to import products, customers, orders, or other data types to Magento 2 from a third-party MySQL database. However, Magento 2 doesn’t let you do that. Although the default tools don’t support such file sources as external databases, there are several ways to synchronize Magento 2 with external databases. 

Welcome to our MySQL Magento guide. In the following post, we shed light on how to export and import database tables between MySQL and Magento in two different ways. Firstly, we describe a common approach that involves the default Magento 2 import solution. It requires tons of manual work and cannot be automated. You need to run a CSV export from your MySQL database, match third-party attributes to ones used in Magento 2, and import your MySQL table into your e-commerce website.

On the contrary, you will find out how to avoid numerous unnecessary chores while performing a Magento MySQL direct update of tables. This approach involves the Improved Import & Export extension. The module combines MySQL database connection and other data import activities within a single interface right in your Magento 2 admin.

After that, we shed light on several MySQL facts as well as describe the core features of the Improved Import & Export extension. To make the long story short, let’s see how to import data from an external MySQL database to Magento 2.
Continue Reading

Magento CSV Import: How to Configure CSV File Size in Magento 2

- Fire development, Magento 2

Magento 2 Development; Magento 2 tutorial

While importing a CSV file into Magento 2, you may face the following restriction: the size of your file is more than allowed. Below, we shed light on how to change the file size limit in Magento 2. You will find a step-by-step guide on how to apply a new value to the existing restriction. Besides, we shed light on how to avoid the timeout issue in Magento 2. If you are interested in more tips related to Magento CSV import, view our Developer’s Cookbook. Continue Reading

Magento 2 Page Builder Import & Export

- E-Commerce, Magento 2, Our extensions

Magento 2 Page Builder Data Import Export

In the following article, we shed light on Magento 2 Page Builder. You will learn its core features. After that, we will focus on the Magento 2 Page Builder import and export. Since you cannot transfer anything to/from the tool via the platform’s default instruments, it is necessary to install a third-party extension. Below, we explore the most intuitive and easy-to-use solution aimed at recreating the missing functionality. Meet the Improved Import & Export extension. With its help, you can most efficiently import and export the data associated with Page Builder in Magento 2.

The blog post below unveils the most important facts about Magento Page Builder. You will learn about its drag-and-drop functionality, grid system, visual effects, flexible integrations, products, instant previews, schedules, etc. Besides, there is a technical introduction to the tool and a brief description of Bluefoot CMS as the foundation of the Page Builder in Magento. After that, the article switches to its key part – you will learn how to import and export data to/from Magento 2 Page Builder. Since the process incorporates the Improved Import & Export extension, you will also find its features described below.
Continue Reading

How to Import Custom CSV to Magento 2 Programmatically

- E-Commerce, Fire development, Magento 2

magento 2 import custom csv programmatically

Let’s discuss the Magento 2 import of custom CSV files. Recently, we’ve been surfing across endless StackExchange discussions and stumbled upon an exciting topic that wasn’t highlighted in our Cookbook. The problem was easy to understand: there was a custom CSV and a user had to import it to Magento 2. The probability of a similar situation for an average e-commerce business is quite high.  Therefore, we’ve decided to narrate it in our blog, adding several more vital facts. So, what is the issue?

Bilal Usean asked the community how to import a custom CSV file to a custom table in Magento 2. Although forum members provided several ways to achieve this goal, we didn’t find any user-friendly solution aimed at people with less technical skills than required by the most rated answer. Variants discussed on StackExchange seem to be highly efficient but too complicated. However, there is one more way to import a custom CSV file to Magento 2 with the minimum headache. Below, we provide the original answer as well as our alternative solution. You will also learn how to import a custom CSV to Magento 2 programmatically. Since some of the provided solutions incorporate the Improved Import & Export extension, we also share its core features after discussing the initial resolution.
Continue Reading

How to Import Magento 2 Product by Store View?

- Fire development, Magento 2, Our extensions

Magento 2 product by store view import

You’ve come to the right place if you run a multilingual storefront or use several different store views. Below, we explore a situation when you need to import Magento 2 product data by store view. While this procedure may seem quite exhausting when you use the default import tools, you may rely on several other ways to simplify these data management chores. Below, we provide community-based recommendations on Magento 2 product import per store view for both Magento 1 and Magento 2. At the same time, you will find a solution proposed by the Firebear team. 

The article incorporates materials from the StackExchange question by ruuter. Once we came across it, we thought it was good to share our experience in this area. Thus, if you don’t know how to import individual product data per store view in Magento 2, we will teach you below. 

Also, note that the article compares the traditional approach that works for Magento 1.x with the new way introduced in Magento 2. As for the improved solution, we shed light on the associated product import automation, product data transfers per store view from external sources, and the use of alternative data sources, such as Google Sheets or API connections. Continue Reading

Magento Error Log to Debug Magento 2 Import & Export

- E-Commerce, Magento 2, Our extensions

magento error log

Today, we are going to discuss the Magento error log for import and export processes. Since Magento 2 doesn’t have any import and export logs, debugging becomes way more difficult than most users expect. It is still possible but you need to spend way more time and effort than in the case of third-party solutions. In the following article, we shed light on how to debug and log the Magento 2 import and export processes and errors with the help of the Improved Import & Export Magento 2 extension.

Below, you will discover a Magento 2 debug log for import and export processes available in our extension. We describe how to view and manage them. Besides, the article touches upon the topic of debugging the Magento 2 import and export process and errors, mostly focussing on how to avoid the existing problems. Other useful tips are available here: Magento 2 Developer’s Cookbook.
Continue Reading

Magento 2 Import of Custom Attributes: How to Import Products with Custom Attributes to Magento 2

- E-Commerce, Magento 2

magento 2 import custom attributes

When you import products to Magento 2, you may face various difficulties. Transferring them to your website without headaches is possible if all items suit the Magento 2 requirements. However, when Magento 2 custom attributes enter the game, merchants usually experience difficulties. So, let’s talk about the Magento 2 import of custom attributes. The following article provides several tips on importing products with custom attributes to Magento 2.

Below, you will find various recommendations on how to streamline this process. First of all, we shed light upon how to enable the Magento 2 product import if you have to deal with custom attributes, avoiding the most common errors. After that, you will find a short guide on how to automate the procedure. Next, the article touches upon the topic of missing attributes. We explain how to create them on the fly automatically. And of course, products bound to third-party categories are also a topic of our discussion. We describe how to match them to the ones you use in your e-commerce catalog. More useful tips are available here: Developer’s Cookbook.
Continue Reading