Magento 2 import and export guide list

- E-Commerce, Magento 2, Uncategorized

Magento 2 import is a complex process that you can’t dive into without proper briefing. In this blog post, we have gathered all useful links and guides that will help you master import and export procedures.

Bookmark this article as it will be updating often.

General import instructions

The Complete Guide to Magento 2 product import/export

This is the first and the foremost article you may want to get acquainted with if you plan to introduce yourself to Magento 2 import and export processes.

In this guide, you will find import and export process basics, such as: what file types can be imported, how to format import table, what attributes Magento 2 uses to import products, what attribute values are available, and much more.

Magento 2 Google Sheet Import

This post describes how can a store owner import products to Magento 2 directly from the Google Sheets.

Here, you can also find necessary information on how to compose the import table and links to the Google Sheet sample import tables.

Moreover, this post is an introduction to the Master Table – the Google Sheet where we have gathered all possible import entities and transcribed every possible attribute.


Magento 2 product import

The Complete Guide to Magento 2 Configurable Products, and how to import them

In this guide, we will talk about Magento 2 configurable products. What is configurable product type, how to create and manage it? And of course how this product type can be imported.

Additionally, we will provide you with the instructions on how to improve configurable product functionality and how to add configurable product matrix to allow adding items to the cart in bulk.

The Complete Guide to Magento 2 Grouped Products, and how to import them

As the title suggests, in this blog post you can find everything about Magento grouped product type. What is grouped product type, how to create and manage it, and what steps are required to import such products?


The Complete Guide to Magento 2 Bundle Products, and how to import them

This blog post will introduce you to Magento 2 bundle products. It will teach you basics of bundle product and demonstrate how to compose the import table.

In this post, you will learn what product attributes are used to assign simple products to bundles, and what attributes are bundle product specific.

How to update product price during Magento 2 import. And how to update price of the products in the catalog in bulk

In this blog post we explain how can one update product prices. Not by just submitting a new value, rather adding or subtracting flat or percent values to the prices of the products in the catalog, and imported products.


Additional Magento 2 import entities

How to Export and Import Magento 2 Categories

Categories are one of the main parts of Magento 2 product catalog. This post will provide you with the instructions on how to get the sample import table and which values you are expected to submit in the table. How to export categories from your Magento 2 and how to import new categories and category paths to the store.

How To Import Customers & Customer Addresses To Magento 2

Customers are an integral part of your Magento 2 store. If you are using a CRM system, or want to import customers from another store, you will find all the answers in this article.

Here you will learn what types of customers import exist in Magento 2, what customer attributes can be imported and how to compose the import table.

How to import Magento 2 Advanced Pricing

Advanced pricing allows you to discount product price if a customer purchases a particular quantity of the product. This entity can also be imported and exported from your Magento 2 store.

Whether you want to import advanced pricing separately or in the same table with products, this article will provide you with the sample import tables, teach you how to compose a custom table, and what values are expected for every advanced pricing attribute.

How to Import CMS Pages to Magento 2

If you are interested in importing additional pages to your Magento 2 store or migrating from Magento 1, a CMS pages import can become a handy tool.

In this blog article, you will learn what tools will be required to import CMS pages to your Magento 2 store, how the import process goes and what you are, as the store administrator, expected to do.

How to import Magento 2 cart price rules

Discounts and coupon codes can also be imported to your Magento 2 store. To do this, you need to have Improved Import and Export extension installed.

This blog article helps you get understanding of the Improved Import and Export extension functionality, and how cart price rules can be imported.

How to Add and Import Magento 2 Fixed Product Tax

Here you will find all the information about Magento 2 fixed product tax. What is the tax, how to add it, manage it, and how can one import fixed product tax to Magento 2?

The article also explains how to compose an import table and what values are expected for every fixed product tax attribute.

How to Add, Export and Import Magento 2 Taxes

Taxes is another entity that you can import into your Magento 2 store. The tax import process can be complicated because of the country and state codes you may need to use where applicable.

This article provides you with comprehensive instructions and import table examples. To complement the instructions, you are also given a link to the Master Table where you can find all the country and state codes.

How To Import Orders to Magento 2

Magento 2 Orders ImportThere is an opportunity to automate Magento 2 orders import in the most user-friendly manner. This article describes an extension that not only enables the necessary features but also helps to automate data updates and solve issues caused by different order attribute standards.



Useful Magento 2 import articles

How to solve Specified URL key already exists error during Magento 2 import

In this article, you will learn how to get rid of ‘Specified URL key already exists’ during the import process. It tells about the main reasons for the error and how you can avoid it using Improved Import and Export extension.


Magento 2 product import – category mapping

In this article, you will learn how to map product categories during the import process. This is particularly useful if you are importing products from another store, or from the file the supplier provided you.

Category mapping is the process of routing old category path to the new one. The process is pretty simple; however, if you are new to the import procedure, it may take some time.

As always, if you are looking for latest Magento 2 news and updates – subscribe to FireBear blog updates. Every week we publish several articles on the most recent events in the world of Magento.

How to Import JSON Files to Magento 2

Magento 2 JSON ImportThis article describes the ability to import JSON files to Magento 2. This functionality is not available by default, but you can easily enable it with the help of the Improved Import & Export Magento 2 extension. Install the module and seamlessly move all data in the JSON format to your e-commerce website. Check the post for further details.

JSON format is an open-standard file format with several advantages over other formats. Firstly, it is entirely based on human-readable text to transmit data. Consequently, you can easily understand what’s written in a JSON file. To represent data objects, the format uses attribute-value pairs and array data types. Other serializable values can be used as an alternative solution.


How to Import Excel (XLS & XLSX) Files to Magento 2

Magento 2 Excel import exportThis short tutorial covers such important topic as Magento 2 data import with the help of native Excel files. The situation is similar to the described above: you cannot import either XLS or XLSX files to Magento 2 by default. It is necessary to use a third-party extension to enable the desired functionality. Check the article for the most reliable and fully-featured solution.

The Microsoft Excel native file formats include both XLS and XLSX. Excel used an XLS format as a standard file format until 2007 version. Then, the use of new XML-based formats became prevalent but XLS is still utilized.  As for the XLSX format, it replaces XLS in Excel 2007. Being a ZIP compressed archive with a directory structure of XML text documents, it provides broader opportunities that the predecessor.

Magento 2 import XSLT transformation – how to import any XML to Magento 2

This blog post tells about how to import any XML file to your Magento 2 store using XSLT transformation available withing Improved Import and Export extension. And how to export any entity from your Magento 2 into the custom-formatted XML file.

The transformation is done right before the XML file imported/exported from Magento 2. In the job, the store administrator pastes the XSLT template that dictates how the XML file should be interpreted.

How to Import Data via REST API into Magento 2

How to Import REST API data to Magento 2Check this article if you are looking for an opportunity to import data into Magento 2 via REST API. The blog post describes how to enable the missing functionality with the help of the Improved Import & Export Magento 2 extension. Besides, you will discover other features provided by the module that essentially simplify the Magento 2 REST API import.

There is also a section that briefly described REST API and illustrates its core principles used by the Improved Import & Export Magento 2 plugin.

How to Import Compressed Data (ZIP, TAR, TGZ) to Magento 2

Magento 2 Compressed Data ZIP TAR TGZ Import

The title of this article is quite self-explanatory. It provides a brief description of a standard import procedure f0r compressed data and then compares it to the improved solution that offers multiple benefits. For instance, you don’t need to extract data files to run the update. Furthermore, the proposed solution allows automating data updates.