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

"improved import and export"

How to Import Custom CSV to Custom Table in Magento 2

Magento 2 import export debug log

Recently, we were surfing on the endless StackExchange surfaces and stumbled across an exciting topic that wasn’t highlighted in our Cookbook. The problem was easy to understand. Its probability for an average e-commerce business seemed to be high.  Therefore, we’ve decided to narrate it in our blog, adding several more vital facts. So, what is the issue we are going to discuss?

Bilal Usean asked the community how to import a custom CSV file to a custom table in Magento 2. Although forum members provided several ways to achieve this goal, we didn’t find any user-friendly solution aimed at people with less technical skills than required by the most rated answer. Variants discussed on StackExchange seem to be highly efficient but too complicated. However, there is one more way to import a custom CSV file to a custom table in Magento 2 with the minimum headache. Below, we provide the original answer as well as our alternative solution. Since the latter is based on the Improved Import & Export extension, we also share its core features after discussing the corresponding resolution.
Continue Reading

How To Import Customer Passwords To Magento 2

Magento 2 import customer passwords

What if you need to transfer customer data to Magento 2? You can use the default import tool to do that. However, it doesn’t let you move all the prospect-related information to your database. For instance, it is impossible to migrate customer passwords from external systems. Attempts to address this problem have been made utilizing numerous approaches. Below, we describe two of them. 

You will find out how to import passwords to Magento 2 from external systems by manually editing your data files. Alternatively, we describe how to import the existing customer data including passwords to your e-commerce website on the basis of the Improved Import & Export extension

The problem is that the new platform version utilizes an updated algorithm for storing passwords. Hence, users claim that after migrating to Magento 2 from Magento 1, registered prospects have to re-enter their passwords on a new website. 

Continue Reading

Magento 2 Page Hierarchy Exploration: Features, Configuration, Import & Export

Magento 2 page hierarchy import export

Although free and paid versions of our favorite e-commerce platform are very similar to some extent, the Commerce edition introduces multiple unique features. And today, we’d like to draw your attention to the Magento 2 page hierarchy. Below, we explore this functionality in more detail as well as shed light on how to import and export Magento 2 page hierarchy as an entity between two e-commerce stores.

In the introduction to Magento 2 page hierarchy, we provide several examples of this content type as well as explain what the Magento 2 page hierarchy node system is. After that, you will discover how to configure page hierarchy in Magento 2 in general and how to add a node to your page hierarchy in particular. We illustrate the page hierarchy node creation process, elucidate the way you add pages to the node, define the page hierarchy structure, account for page hierarchy pagination controls, and explain the corresponding menu layout. After that, the article switches to the data transfer section., where we show how to import & export Magento 2 page hierarchy data. Since this process incorporates the Improved Import & Export Magento 2 extension, you will also find its features defined.
Continue Reading

How to Import Disabled Products to Magento 2

- Fire development, Magento 2

Magento 2 import export debug log

If you cannot import disabled products to Magento 2, you’ve come to the right place. We will probably help you with that. Below, you will find two possible solutions. As usual, one of them is proposed by a StackExchange user, while another one is developed by Firebear specialists. In both cases, we deal with products that have the “disabled” status. As for the corresponding import file. It doesn’t contain the “status” column. If you add it, nothing changes. So, how to import disabled products to Magento 2? You will find the answer below. We also provide recommendations on how to import disabled products to Magento 2 automatically and via various file formats using Improved Import & Export. For more tips, proceed to our Magento 2 Cookbook.
Continue Reading

How to Export Products from Magento 2 via CLI

- E-Commerce, Magento 2

Magento 2 export CLI

Although most Magento 2 administrators prefer working with their e-commerce website strength in the admin area, there are still many people who require the same management opportunities to be implemented with the command line interface. However, the default data transfer solutions of Magento 2 don’t let you do that. Both import and export tools are useful only for basic purposes. If you want to export products from Magento 2 using the command-line interface, you need a third-party solution. In the following material, we describe how to transfer data via CLI from your e-commerce website with the help of Improved Import & Export. Besides, we shed light upon the corresponding data import processes. You can find more tips on how to work with Magento 2 in our Cookbook. To make the long story short, let’s focus on how to import and export products and other entities in Magento 2 via CLI.

Continue Reading

How to import and export position of the product in the category. Magento 2 visual merchandise

- E-Commerce, Magento 2

When you use native Magento 2 import and export tools to transfer products to your e-commerce website, it is impossible to manage product positions inside categories, meaning you have to assign them manually, which proves to be a tedious task. However, there is a solution that addresses the existing issue. Meet the Improved Import and Export extension for Magento 2. It lets you import and export product positions using CSV, XML, XLSX, ODS, and JSON files. In this article, you will learn how to import product category positions in Magento 2. Next, we discuss how the categories_position attribute works and what its peculiarities are. And of course, we unveil several interesting facts about the Improved Import & Export extension. But before going any further, let’s define what product category positions are and how to leverage them in Magento 2.

Continue Reading

How to create a custom import in Magento 2

Magento 2 import export debug log

Although the default import and export instruments of Magento 2 are enough to satisfy the basic data transfer needs, you may require some extra features to follow specific business demands. Sometimes the missing functionalities are available with third-party extensions but even the most robust modules often fail to deliver custom opportunities that satisfy particular business requirements. What’s to be done? 

Below, we shed light on how to create a custom import in Magento 2. You will find two different approaches. Firstly, we discuss a community-provided solution that requires technical skills and coding experience. It is not for every user, especially those who don’t belong to the group of tech-savvy Magento 2 managers. Secondly, we provide a more friendly way of creating a custom import in Magento 2. It is based on the Improved Import & Export extension and involves no coding on the side of the extension’s end user. Before we proceed, check more useful tips here: Magento 2 Cookbook
Continue Reading

How to Import Multiselect Attribute Values to Magento 2

Magento 2 import export debug log

The default data transfer capabilities of Magento 2 still need various improvements, especially if you use the Open Source version of the platform. However, numerous community-based initiatives that tend to improve the basic functionality are at your service. They vary between coding tricks and standalone extensions. Depending on the complexity of your business, your technical skills, or the faced issues, you can select one that perfectly suits your needs.  What to do if you cannot find the solutions? Ask the community for support. 

Recently, we came across an interesting issue on Stackexchange. The author was wondering whether it was possible to create values for a multiselect attribute when uploading a CSV file. Below, we share two solutions: the community-based algorithm of addressing the problem and the Firebear-proposed tool. While the first one requires additional coding experience and is almost unreal to implement for non-technical users, the extension we offer is admin-friendly and intuitive so that anyone can use it to cope with the difficulties described below. 

To make a long story short, let’s explore the issue and describe how to import multiselect attribute values to Magento 2. More tips are available here: Magento 2 Cookbook.
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 Products with Custom Attributes to Magento 2

- E-Commerce, Magento 2

Magento 2 import export debug log

When you import products to Magento 2, you may face various difficulties. If all items are suitable for the Magento 2 requirements, it is possible to transfer them to your website with no headaches. However, when custom product attributes enter the game, merchants usually experience difficulties. 

In the following article, we provide several tips on how to import products with custom attributes to Magento 2. Below, you will find various recommendations on how to streamline this process. First of all, we shed light upon how to enable the Magento 2 product import if you have to deal with custom attributes, avoiding the most common errors. After that, you will find a short guide on how to automate the procedure. Next, the article touches upon the topic of missing attributes. We explain how to create them on the fly automatically. And of course, products bound to third-party categories are also a topic of our discussion. We describe how to match them to the ones you use in your e-commerce catalog. More useful tips are available here: Developer’s Cookbook.
Continue Reading