"Our extensions"

How to Import JSON Files to Magento 2

- E-Commerce, Magento 2, Our extensions

Magento 2 JSON Import

The default Magento 2 data import capabilities are enough for satisfying only basic data transfer demands, but what if a more complex task must be solved? For instance, you need to import JSON files to Magento 2, while the system supports only the CSV standard. You need to convert your JSON files to the supported file type to move them to your e-commerce website. Luckily, there is a more user-friendly solution for importing JSON to Magento 2.

Meet the Improved Import & Export extension. This module supports the Magento 2 JSON import so that you can move all the necessary information to your e-commerce store without turning it into CSV. You can effortlessly move data in this format in both directions: to and from your Magento 2 website.

In this article, we discuss JSON file requirements for importing data to Magento 2 and provide a list of supported entities (you can transfer all core entities now). Besides, you will find a step-by-step guide that describes how to import JSON data to Magento 2. If you are unfamiliar with the JSON format, its brief description is below. 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 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 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

How to Import Data via REST API into Magento 2

- E-Commerce, Magento 2, Our extensions

Magento 2 REST API Import

Today, we’d like to draw your attention to the Magento 2 REST API Import. Depending on the edition of your Magento 2 installation, your built-in import and export tools may vary a little. However, the difference is not vast: you can create update schedules in Commerce while the Open Source edition doesn’t let you do that. The common thing is that neither of them lets you leverage the REST API import in Magento 2. Luckily, the missing functionality can be enabled with minimum effort. You only need to install the Improved Import & Export Magento 2 module. The extension offers all the features necessary to leverage the Magento 2 REST API import and export. 

The following article sheds light on how to import data into Magento 2 via REST API. We discuss how to enable the Magento 2 REST API import and what extra benefits you can get. If you are not familiar with what the Magento 2 REST API is, we’ve also prepared a chapter that describes this standard. Besides, there is an FAQ section that provides answers to frequently asked questions about Magento 2 REST API import/export processes.
Continue Reading

Magento 2 Import: How To Fix Value For Attribute Contains Incorrect Value Error

- E-Commerce, Magento 2, Our extensions

Magento 2 Development; Magento 2 tutorial

In the following article, you will discover a universal algorithm for solving Magento 2 errors associated with incorrect attribute values. We focus on the Magento 2 Value For Attribute Contains Incorrect Value issue to illustrate the entire scope of problems merchants usually face. 

Let’s assume that your import file contains multiple products with numerous attributes, each of which follows the strict Magento requirements. However, there is a record with invalid values. As a result, Magento’s Value For Attribute Contains Incorrect Value error displays. It doesn’t let you transfer the entire table with product data.

Below, you will find out how to address this problem. Furthermore, we also shed light on how to prevent it and avoid unpleasant situations with your future data updates with the Improved Import & Export module. Besides, we elucidate how to prevent other import issues with the help of our plugin. If you are looking for a more specific case of this issue, check this article: Value For Status Attribute Contains Incorrect Value: How To Fix Error During Magento 2 Import.
Continue Reading

Magento 2 Imported Resource (Image) Could Not Be Downloaded: How To Fix This Magento 2 Import Error

- E-Commerce, Magento 2, Our extensions

Magento 2 Development; Magento 2 tutorial

In the following article, we explore a problem that prevents Magento users from importing images. You may be familiar with the Magento 2 Imported resource (image) could not be downloaded from external resource issue. If not, we provide two StackExchange cases and a possible resolution below. Besides, our team developed a dramatically improved way of importing images into Magento 2 which is also described in this article. So, what is Magento’s ‘Imported resource (image) could not be downloaded from external resource’ error, and how to fix it? Continue Reading

Magento 2 General System Exception Happened: How To Fix Error During Magento 2 Import

- Magento 2, Our extensions

Magento 2 Development; Magento 2 tutorial

If you regularly deal with Magento 2 import processes, you might have faced the following message: General System Exception Happened. Like other import errors, it prevents you from transferring data to your e-commerce website. What are the causes of the Magento 2 General System Exception Happened issue? How do we fix this import problem? Magento users all over the globe regularly ask these questions. You’ve come to the right place if you are also looking for the corresponding answers.  

In the following post, we try to figure out Magento’s General System Exception Happened error and explain how to fix it. The issue is an inevitable part of the basic Magento 2 import processes associated with the platform’s default tools. Luckily, we know for sure how to address the problem. 

Below, we aggregated a short guide on how to fix the Magento 2 General System Exception Happened issue based on the StackExchange answers. Besides, you will discover a more user-friendly approach to the import that the Firebear team provides. Other useful Magentop 2 tips are gathered here: Developer’s Cookbook.
Continue Reading

How to Import & Export Product Attributes for Magento 2 (Along with Attribute Values & Sets)

- E-Commerce, Magento 2, Our extensions

import export product attributes for magento 2

Today, we are going to talk about the import and export of product attributes for Magento 2. Operating an e-commerce store is associated with numerous processes. Various management chores include a broad array of actions from creating a category tree to adding an FAQ section. Somewhere between these processes, attribute management is hidden. Magento 2 heavily relies on attributes, attribute sets, and attribute values. You may need to update them frequently to keep your catalog in order. Although the platform delivers all the tools necessary to manage your attributes and all the related data, your daily routine turns into an unbearable burden if you work with hundreds of records. However, there is a simple way to do so – import attributes to Magento 2 instead of applying all the necessary changes manually.

You can import and export attributes, attribute sets, and attribute values in Magento 2, replacing various manual tasks and automating your management routine. Below, we shed light on how to enable this functionality in your store even though Magento 2 lacks the corresponding features. A little spoiler: you need to install the Improved Import & Export Magento 2 extension. It will help you transfer Magento 2 attributes, values, and attribute sets to and from your e-commerce website. 

The article below focuses on the pros and cons of both manual attribute management and the corresponding import and export automation. After that, it sheds light on various aspects of the Magento 2 import-export of product attributes associated with our extension. You will learn how to manage attribute tables, edit attribute values, create new attributes on the fly during import, use multiple file formats and sources for the attribute import and export, as well as leverage alternative transfers.  Mapping and scheduling are also described in this post. These features will help you automate the Magento import of attributes from external sources. 
Continue Reading