Now compatible with Magento 2.4.4 PHP 8.1 Check new release of Improved Import & Export

"import"

How to Import Magento 2 Advanced Pricing

- E-Commerce, Magento 2

Although setting up tier prices in Magento 2 is an exhausting task, you can dramatically simplify the related chores. But why is it so time-consuming? Setting up advanced pricing in Magento 2 requires going through the products one by one, submitting values in a dedicated window, and then saving. The more products you have, the more actions you need to apply. However, the Magento 2 import procedure lets you save hours of manual management time. In this article, we describe how to import advanced pricing to Magento 2. Below, you will find a sample advanced pricing import table described. Next, we provide advanced pricing attributes used in Magento 2. With this information in mind, you can proceed to importing Magento 2 tier prices

Unfortunately, the default Magento 2 import tools only let you import products and advanced prices separately. It means that you need to upload one file with product data except for tier prices which are provided via another spreadsheet. You must admit that it is not very convenient, especially when you move the entire catalog. 

To address this issue, we describe another procedure, involving the Improved Import and Export extension. With this tool, you can import both products and tier prices in a single file. Importing Magento 2 products with tier prices in a single file is based on the following steps. Firstly, prepare an import table, following our recommendations. After that, create a new import job as described in this blog post.

Continue Reading

How to import data from external MySQL database to Magento 2

Magento 2 mysql data import

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

In the following post, we shed light on how to achieve this goal 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 importing data to Magento 2 from a MySQL database. 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

How to Export and Import Magento 2 Categories

- E-Commerce, Magento 2

Unfortunately, Magento 2 doesn’t let you import and export categories by default. Although the platform’s capabilities associated with data transfers are fairly limited, you can address the existing issues with ease. It is necessary to install a third-party module to import and export categories to Magento 2. In the following article, we shed light on how to transfer an existing category tree to/from your e-commerce website using the Improved Import & Export Magento 2 extension. After describing the Magento 2 category export, we peruse a sample import table that contains product categories. After that, our attention is focused on specific Magento 2 category attributes: we explore use cases and attribute mapping to let you transfer categories to Magento 2 from any external platforms. Next, there is a detailed step-by-step guide that depicts Magento 2 category import. Also, you will find out how to import product positions in categories (a part of the Visual Merchandiser functionality of Magento 2) and move Magento 2 categories per different store views.

Continue Reading

How to import and export Magento 2 MSI and how it works. Magento 2 multi source inventory (MSI) import guide and manual

- E-Commerce, Magento 2

Magento version 2.3 came out with the long-awaited Multi-Source Inventory (MSI) support. The feature is available right after you install the MSI extension. Although the module dramatically improves the basic experience associated with inventory management, it still lacks various vital functionalities, especially in the area of data synchronization. Luckily, you can always address the existing issues with the help of third-party solutions. When it comes to 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. We describe what the MSI module is and how to install it. After that, you will find out what to do with the MSI add-on of the Improved Import & Export extension. All the existing requirements associated with Magento 2 MSI import and export processes are also listed in the article.

Besides, we focus on the table formatting of MSI entities. You will learn how the stock sources MSI table works and what to do with the stock sources qty MSI table. Next, the blog post sheds light upon how to import and export Magento 2 products with multiple MSI warehouses.

The last chapter of this Magento 2 MSI import/export guide describes how MSI source import/export works. We put emphasis on how to export and import Magento 2 stock sources. You will find out how to edit an import table and import it to your website.

Continue Reading

The Ultimate Guide to Shopify Import

- Our extensions, Shopify

Shopify import products, customers, inventory, orders

Every decent e-commerce platform offers built-in import and export tools. However, they are usually far from being an omnipotent solution that can cope with any business requirement. In view of this, agencies create third-party solutions that close the existing gaps between the platform’s objective reality and the merchants’ subjective needs. What about Shopify? What data transfer solutions does it offer? What reliable alternatives are currently available in the ecosystem?  

In this Shopify import guide, you will find out what import functionality is hidden behind the platform and how to enhance it in the most user-friendly and, at the same time, powerful way. Let’s explore the system’s native capabilities first and then proceed to the most powerful third-party solution that copes with any data transfer challenges and enables any Shopify import customizations – Firebear Improved Import & Export App for Shopify.

Below, you will learn about the basic import capabilities of Shopify. We describe how to transfer products to your e-commerce website using its built-in functionality. The article examines two different cases: importing products from another website and reimporting them within the borders of your store. In addition to that, we provide a CSV file structure required in the ecosystem. The same tutorials are available for other entities: we teach how to import inventory, customers, and orders to Shopify. Also, don’t forget to check our Ultimate Guide to Shopify Export.
Continue Reading

How to Import Data via REST API into Magento 2

How to Import REST API data to Magento 2

Depending on the edition of your Magento 2 installation, your built-in import and export tools may vary a little bit. However, the difference is not very vast: with the Commerce edition, you can create schedules of updates while the Open Source edition doesn’t let you do that. At the same time, neither of them lets you leverage REST API import processes. Luckily, the missing functionality can be enabled at any moment with minimum effort. You only need to install the Improved Import & Export Magento 2 module to leverage the Magento 2 REST API import and export processes. 

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 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 REST and Magento 2 import/export processes.
Continue Reading

How to Import Database in Magento 2

- Fire development, Magento 2

Magento 2 import export debug log

Recently, we’ve spotted a question on StackExchange regarding 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 the Magento 2 database import. 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, no database import to Magento 2 is possible. And it is impossible to automate regular data transfers from a 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

How to import Magento 2 product and custom attributes

- E-Commerce, Magento 2

In this article, we talk about how to import product attributes, attribute groups, and attribute sets to a Magento 2 store. Besides, we discuss how the attributes behave and which values Magento 2 understands in the import tables. The topic is extremely important since transferring products to Magento 2 is impossible without product attributes. They dictate which values the products have and which options and variations exist. That’s why having the ability to import product attributes is a must. Since Magento 2 doesn’t let you import product attributes by default, we use the Improved Import & Export extension to manage all the processes. Below, you will find how the module works when it comes to the Magento 2 product attribute import. We provide a table with product attributes, offer tips on importing attributes to your e-commerce website, and highlight several more important aspects. 

Continue Reading

The complete guide to Magento 2 simple product customizable options (custom options)

- Magento 2, Our extensions

The guide is dedicated to the customizable options — the extra settings available for simple, downloadable, and virtual products in Magento 2 that enable the creation of product variations. Products with custom options resemble configurable products staying a unique system element at the same time. Throughout the text, we’ll discover the peculiarities of custom options, learn how to use them properly, and how to import them to your Magento 2 store.

Read Magento 2 Import and Export Guide List

Continue Reading