"Magento 2 Developer’s Cookbook"

How to Import Custom CSV to Magento 2 Programmatically

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?

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 2 MSI User Guide: How to Import & Export Magento 2 MSI (Multi Source Inventory)

- E-Commerce, Magento 2

Magento 2 MSI User Guide

This Magento 2 MSI user guide briefly explains the platform’s multi-source inventory functionality and then focuses on the Magento 2 MSI import and export. Magento 2.3 came out with the long-awaited Multi-Source Inventory (MSI) support. The feature is available right after you install the Magento 2 MSI module. Although the extension dramatically improves the basic experience associated with inventory management, it still lacks various vital functionalities, especially in data synchronization. Luckily, you can always address the existing issues with the help of third-party solutions. Regarding the Magento 2 MSI module and data transfers, the Improved Import & Export extension and its MSI add-on are at your service. 

In this blog post, you will learn how to import and export all Magento 2 MSI entities: sources and quantity of the products per source. Firstly, we describe the MSI module and explain how to install it. After that, you will find out what to do with the MSI add-on of the Improved Import & Export extensionNext, we focus on the Magento 2 MSI import. The article explores the CSV formatting of MSI entities used in Magento 2. You will learn how the stock sources MSI table works and what to do with the stock sources qty MSI tableThe last chapter of this Magento 2 MSI import/export guide describes how MSI source import/export works

Continue Reading

Magento Error Log to Debug Magento 2 Import & Export

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

How to Create a Custom Import in Magento 2

magento 2 custom import

Although the default import and export instruments of Magento 2 are enough to satisfy the basic data transfer needs, you may require some extra features to follow specific business demands. Sometimes the missing functionalities are available with third-party extensions but even the most robust modules often fail to deliver custom opportunities that satisfy particular business requirements. What’s to be done? 

Below, we shed light on how to create a custom import in Magento 2. You will find two different approaches to the Magento 2 custom import. Firstly, we discuss a community-provided solution that requires technical skills and coding experience. It is not for every user, especially those who don’t belong to the group of tech-savvy Magento 2 managers. Secondly, we provide a more friendly way of creating a custom import in Magento 2. It is based on the Improved Import & Export extension and involves no coding on the side of the extension’s end user. Before we proceed, check more useful tips here: Magento 2 Cookbook
Continue Reading

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

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 Product Images into Magento 2 in Bulk

- Fire development, Magento 2

magento 2 import product images

Below, we describe how to import product images in Magento 2 using CSV. Since it is a part of a product import routine, you will only need to learn a couple of aspects.

Of course, you can add images to product pages one by one but what if there are thousands of items on your storefront? In this case, manual upload doesn’t seem to be a good idea. However, there are two methods described in the official documentation that dramatically simplify the Magento bulk image import. First of all, you can leverage a local server to upload product images to Magento 2 in bulk.

Secondly, the system lets you use a remote server for this purpose. However, both methods incorporate the default data transfer instruments of Magento 2. Since they are a little bit limited, you can use the Improved Import & Export extension to import product images to Magento 2. Let’s see how the default methods look and what benefits our module offers. Visit our Magento 2 Developer’s Cookbook to discover other useful tips.
Continue Reading

How to Import Database in Magento 2

- Fire development, Magento 2

magento 2 import database command line

Recently, we’ve spotted a question on StackExchange regarding the Magento 2 database import. David Duong faced problems while transferring a database on Magento 2.3.3. Below, we shed light on the issue and the provided solution for Magento 2 to import a database via the command line. However, it is quite a complex process since the system doesn’t let you transfer a database to Magento 2 directly. You always need to create an output file that contains a particular entity. If your file incorporates several types of data (e.g., products and orders), it is necessary to split it into two separate tables.

Furthermore, you always have to edit attributes in the imported file to make them suitable for the Magento 2 requirements. Otherwise, the Magento import of a database becomes questionable. It is impossible to automate regular data transfers from a remote database to your e-commerce website. However, there is a tool that solves all these issues. After we describe a method provided in the StackExchange discussion, you will find out how to achieve the missing functionality with the help of the Improved Import & Export Magento 2 extension. For more tips and advice, read our Cookbook. Continue Reading