"import"

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 extension. Next, 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 table. The last chapter of this Magento 2 MSI import/export guide describes how MSI source import/export works. 

Continue Reading

How to Import Data via REST API into Magento 2

- E-Commerce, Magento 2, Our extensions

Magento 2 REST API Import

Today, we’d like to draw your attention to the Magento 2 REST API Import. Depending on the edition of your Magento 2 installation, your built-in import and export tools may vary a little. However, the difference is not vast: you can create update schedules in Commerce while the Open Source edition doesn’t let you do that. The common thing is that neither of them lets you leverage the REST API import in Magento 2. Luckily, the missing functionality can be enabled with minimum effort. You only need to install the Improved Import & Export Magento 2 module. The extension offers all the features necessary to leverage the Magento 2 REST API import and export. 

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 the Magento 2 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 Magento 2 REST API import/export processes.
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. Because 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 – the Import & Export Tool for Shopify.

Below, you will learn about the basic data transfer capabilities of Shopify: product import, inventory import, customer import, etc. You will learn how to transfer products to your e-commerce website using the platform’s 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 for this process. Next, we explore how to import inventory, customers, and orders to Shopify. After that, you will learn how our Import & Export Tool enhances the default data transfers. Also, don’t forget to check our Ultimate Guide to Shopify Export.
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

Guide to Magento 2 Search Terms & Search Synonyms: Management, Import & Export Recomendations

- E-Commerce, Magento 2, Our extensions

Magento 2 Search Terms & Search Synonyms

Today, we are going to explore two tightly connected topics – Magento 2 search terms and Magento 2 search synonyms. The platform lets you optimize customer search queries by composing lists of search terms and search synonyms. While it is possible to manage them manually in your admin, you cannot import Magento search terms. And there is no way to import search synonyms to Magento 2 with the help of the platform’s built-in instruments. This limitation may negatively impact the productivity of backend administrators since they need to spend a considerable amount of time updating Magento 2 search terms and synonyms instead of transferring the necessary data within a few clicks.

However, there is a tool that unlocks the missing functionality. Meet the Improved Import & Export extension. This module empowers you to import and export search terms and search synonyms to Magento 2. Below, we explain how to use the tool to transfer the corresponding entities to and from your e-commerce website. You will learn how import and export processes work and what attributes are involved in the import and export of search terms and search synonyms. But before going any further, let’s see what Magento 2 search terms and search synonyms are. 
Continue Reading

Magento 2 Tax Configuration: How to Add Tax Classes, Rules & Rates, Tax Rates Import & Export

- E-Commerce, Magento 2

Magento 2 Tax Configuration

Today, we’d like to draw your attention to the Magento 2 tax configuration. You will learn what the Magento 2 estimate shipping and tax feature is and how it works. Next, we move to the Magento 2 tax class configuration. You will learn how to add new tax classes. Besides, this section describes Magento 2 tax rules and rates. You will learn how to add them.

After that, we proceed to the Magento 2 tax rate export and import. You will learn how to compose a CSV with tax rates suitable for Magento 2. Importing taxes can save time when moving to another store, or migrating from Magento 1. We also shed light on a third-party tool that can help you automate this process. 

Continue Reading

FPT Tax: How to Add and Import Fixed Product Tax in Magento 2

- E-Commerce, Magento 2

FPT tax in Magento 2: create, configure, import

Today, we are going to talk about the FPT tax. You will learn what FPT or Fixed Product Tax is and how it helps Magento 2 merchants sell products to different countries and different states adhering to local tax regulations. This tax is added in a bit of a peculiar way which may not be as obvious at first glance as it seems. In this post, we cover everything you need to know about the FPT tax and describe how to import fixed product tax to Magento 2.

Continue Reading

Guide to Magento 2 Static Blocks

- E-Commerce, Magento 2, Our extensions

Magento 2 Static Blocks: create, import, and export

Below, we are going to discuss Magento 2 static blocks. It is hard to overestimate the importance of Magento 2 CMS pages for an average e-commerce website. They play a pivotal role in creating a unique and attractive storefront. Homepage, news blocks, promotions, and other store sections may incorporate CMS pages to deliver a more abundant shopping experience. Also, pages composed within the Magento 2 Page Builder are always associated with various CMS elements. Despite such frequent appearances, Magento 2 doesn’t let you import-export CMS elements: pages, blocks, and widgets. However, you can do that with the Improved Import and Export extension. In this Magento static blocks tutorial, you will learn how to import CMS blocks. We focus on such aspects as a proper import table and an import job that simplifies your daily chores.

Along with the step-by-step instructions, the article provides explanations of every static block attribute. Also, you will find sample files that you can use as a reference for your Magento 2 static block imports. We describe prerequisites for importing/exporting statics blocks in Magento 2. After that, you will learn how to transfer CMS blocks between Magento 2 websites. Additionally, we touch upon the topic of composing and editing static block tables.

Continue Reading

How to Import & Export Product Attributes for Magento 2

- E-Commerce, Magento 2

import export product attributes for magento 2

Do you know how to import attributes in Magento 2? It’s a complex process that covers not only product attributes but also attribute groups and attribute sets. In the following article, you will learn how to import and export product attributes for Magento 2 in the most efficient way. We discuss how the attributes behave and which values from an import table Magento 2 understands. Why is this topic important? 

Well, it would be much easier if you could just import products, moving all the corresponding data in a single CSV. However, Magento doesn’t even support product positions in a category within a product CSV. 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. Note that it also supports the Magento 2 import of custom attributes. Below, we provide a table with product attributes and their descriptions to help you understand what’s going on in a CSV with attributes. Also, you will find a step-by-step guide to the import of attributes in Magento 2.  

Continue Reading