Improved Import & Export major update - full Google Sheets & Drive integration. Fixed price Magento 1 > Magento 2 migration service! EXPLORE

"import"

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.
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

Improved Import / Export Magento 2 Extension Manual

- Magento 2, Our extensions

In this article, we’d like to draw your attention to the Improved Import & Export Magento 2 extensions. The following blog post contains all the information about the data transfer module. Below, you will find the Improved Import & Export Extension manual that sheds light upon all the key aspects associated with the plugin. We describe its installation, configuration, and import/export transfers, teach you how to add a new import and export job, talk about import and export processes associated with different entities. You will also discover various nuances of running data transfers via CLI, automating processes, using extension customization endpoints, and performing troubleshooting. Various use cases and specific features are also described in the manual.

Improved Import and Export extension allows importing and exporting CSV/XML/JSON files with product data and product images to Magento 2. The files can be imported from a remote FTP/SFTP server, Dropbox, direct URL of a source CSV fileGoogle Sheets, etc.  In addition, the extension offers a dedicated category import from CSV files, import of attribute values and new attributes on the fly, import job scheduling with cron jobs, and other features.

Besides, you get advanced export capabilities, including order export and export jobs, with attribute and table field mapping.

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

How To Import and Export Orders to Magento 2

Magento 2 Orders Import

The following article sheds light on how to import orders to Magento 2. Merchants usually do that when they migrate to Magento 2 or synchronize their business with external marketplaces. However, you cannot do that within the admin’s default tools. Therefore, a third-party extension is necessary to maintain this process. 

Besides, the blog post explains how to export orders from Magento 2. This procedure comes in handy in similar cases: when the migration from Magento 2 is required or orders are processed in external systems. Unlike the Magento 2 order import, the corresponding export process is available in the administration right on the order page. Although you can transfer orders from your website with the help of the default tools, we describe a more fully featured but at the same time natural way of doing that. 

In the article below, you will discover how the order import works. We explore the Magento 2 order file structure and generate invoices and shipments while importing tracking numbers. You will also see how to export orders from Magento 2. The last chapter of the article reveals other features of the tool that we use to run data transfers.
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

How to Import Custom Files to Shopify

- E-Commerce, Shopify

 shopify import & export app

Fail to import custom files to Shopify? You’ve come to the right place. Although you cannot do that with the platform’s default tools, an alternative solution is suitable for this procedure. In the following article, we describe where the issue comes from and how to address it.  Continue Reading

Exploring Magento 2 Backend: Import/Export Tax Rates

- E-Commerce, Magento 2

magento 2 tax rates import export

Tax rate management in Magento 2 is quite a straightforward process if you conduct business locally. However, when you expand and start operating in several states with different legislation, not to mention international operations, manual tax rates entering becomes hugely time-consuming. What alternative opportunity does Magento 2 offer? By default, the platform has a separate screen where you can import all the necessary tax rates, preliminarily downloading them by ZIP code. In the following material, we explore how to transfer a set of tax rates back and forth and talk about an alternative solution.  Continue Reading