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.
Table of contents
- 1 General import instructions
- 2 Magento 2 product import
- 2.1 The Complete Guide to Magento 2 Configurable Products, and how to import them
- 2.2 The Complete Guide to Magento 2 Grouped Products, and how to import them
- 2.3 The Complete Guide to Magento 2 Bundle Products, and how to import them
- 2.4 How to update product price during Magento 2 import. And how to update price of the products in the catalog in bulk
- 3 Additional Magento 2 import entities
- 3.1 How to Export and Import Magento 2 Categories
- 3.2 How To Import Customers & Customer Addresses To Magento 2
- 3.3 How to import Magento 2 Advanced Pricing
- 3.4 How to Import CMS Pages to Magento 2
- 3.5 How to import Magento 2 cart price rules
- 3.6 How to Add and Import Magento 2 Fixed Product Tax
- 3.7 How to Add, Export and Import Magento 2 Taxes
- 3.8 How To Import Orders to Magento 2
- 4 Useful Magento 2 import articles
- 4.1 How to solve Specified URL key already exists error during Magento 2 import
- 4.2 Magento 2 product import – category mapping
- 4.3 How to Import JSON Files to Magento 2
- 4.4 How to Import Excel (XLS & XLSX) Files to Magento 2
- 4.5 Magento 2 import XSLT transformation – how to import any XML to Magento 2
- 4.6 How to Import Data via REST API into Magento 2
General import instructions
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.
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
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.
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?
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
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.
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.
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.
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.
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.
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.
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.
There 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
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.
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.
This 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.
This 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.
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.
Check 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.