"csv"

FireBear Improved Import & Export for Magento 2 – Extension Change Log

- Magento 2, Our extensions
improved import and export - Magento 2 extension

The following blog post will help you retrace the evolution of the Improved Import & Export Magento 2 module. The article gathers updates associated with the extension’s each new version from the very beginning. At the time of 1.0.0, it was a basic import solution with an existing import jobs architecture and import cron automation. With the next few versions, the module got such enhancements as product attribute import on the fly, transfers from FTP, SFTP, URL, and Dropbox, custom mapping, etc. Each new release made the Improved Import stronger and stronger. However, it was still an import-only tool until 1.5.0 was released. With this version, our extension became capable of both import and export processes. You can peruse the detailed evolution of the module and see its latest features below. 

Extension Manual | FAQ | Demo | Sample Files

3.8.6 (released 20.09.2023)

Features:

  • Log Files Management Automation. The latest version provides the ability to clear import/export log files automatically. Two options are available: “Clear import/export logs by cron” and “Days Saved in Log”. 
  • Developer Improvement. The “categoriesMapping” method is now public. 
  • Product Online Import. The extension does not disable products when the “product_online” field is empty in the import file.
  • Image Import. The following improvements to the image import process were introduced in 3.8.6:
    • A new product import option called “Keep original image name” is available. When enabled, it keeps the original image name when importing images by URL. 
    • Import images by URL when the URL contains a port number.
    • Import images by URL when the URL contains spaces.
  • Products not in Import List. The “Update Products that are not in the import list” feature now has the following new options:
    • Set products to “Out of stock” status
    • Set products qty to 0
    • Set products to “Out of stock” status and set products qty to 0
  • Google Drive Import. The extension now replaces the existing export file on Google Drive instead of creating a new file with a duplicated name.
  • Order Import. Support for one-line addresses when importing orders.

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 Update Order Status Via CSV In Magento 2

- E-Commerce, Magento 2

Magento 2 export CLI

In the following article, we shed light on how to update orders in Magento 2 with the help of CSV files. Since this procedure is impossible if you use the platform’s default import tools, many merchants try to find the most reliable and flexible solution. We will describe such an instrument below. In this article, you will learn how to update the order status in Magento 2 via CSV and files of other formats. As you might have already guessed, there is no need to reinvent the bicycle. It is only necessary to choose one of the available solutions. So, let’s see what Magento 2 extension lets you update orders in Magento 2 in the most flexible manner. Please, check our cookbook for more similar articles. Continue Reading

How to Run Magento 2 Import if Required Columns Are Missed

- E-Commerce, Magento 2, Our extensions

Magento 2 Import without Required Columns

Below, we shed light on a very important aspect of every import process – columns (attributes) of an import file. What if your data table doesn’t contain one? By default, you face the inability to transfer the update to your Magento 2 website. There are lots of different entities that can be transferred into Magento 2, so you have to deal with different data depending on your particular business case. However, the absence of the smallest detail can ruin all your data transfer efforts. Especially if you use the default data transfer solutions. 

Luckily, we know how to prevent such issues. Meet the Improved Import & Export Magento 2 extension. With the help of this plugin, you can import data to Magento 2 if some required columns are missed. The following article describes this process. You can either add the necessary columns manually or automate the addition of the missing data using the module’s functionality. Besides, you will discover the required CSV file structure as well as core features of the Improved Import & Export Magento 2 extension
Continue Reading

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

Amasty Export Orders Extension for Magento 2 and 1

Amasty Magento 2 Order Export module review

If you are looking for the most powerful migration tool for Magento 2 or Magento 1, check out our Improved Import Magento 2 Extension and Improved Import Magento Module.

The Magento marketplace also offers alternative solutions for improving the default Magento import/export process. In this post, we shed light on the Magento 2 Export Orders extension by Amasty. This tool offers only export features but does everything quite well. Also, note that we’ve compared the Amasty Magento 2 export orders module with other similar extensions here: Magento 2 Order Export Extensions Comparison.

The best Magento 2 extensions | The best Magento extensions

Continue Reading

How to migrate from Magento 1 to Magento 2 with Improved Import and Export extension

Migrating from Magento 1 to Magento 2 is not an ordinary routine. Using the standard Magento data import tool for that may be a difficult task if you are not familiar with coding and working from the command line. Even Magento 2 developers rarely rely on the standard instruments since the migration may prove difficult because of the difference between entities stored in M1 and M2.

MIGRATION ADD-ON IS NO LONGER SUPPORTED

That’s why having a tool that simplifies the procedure and leaves you with only mechanical tasks is a great time savior. In this article, we will talk about how to migrate to Magento 2 using the Improved Import and Export extension. Firstly, we will introduce you to the module. After that, you will find out how to import products, customers, and orders to your ecommerce website when you migrate from Magento 1 to Magento 2. The article sheds light on such nuances as getting an export table with a corresponding entity, preparing attributes for import, and transferring everything into your brand new storefront.

Continue Reading

The Complete Guide to Magento 2 Product Import / Export

- Magento 2

Magento 2 Product Import Export Tutorial

Let’s talk about Magento 2 product import and export. Chances are, you already have an e-commerce website and want to import the existing products to your brand new Magento 2 storefront or need to move product data from a dropshipping platform – you’ve come to the right place. Perhaps, you want to transfer products and their prices to price comparison engines – you will also find out how to do that below.

This blog post peruses the Magento 2 import and export processes from the very beginning, starting with the native Magento 2 guidelines for CSV files and then guiding you through the default Magento 2 import of products and various product data updates. The detailed description of a CSV file structure will help you master such nuances as Magento 2 tier price import and advanced pricing transfersBesides, you will find a thorough guide on importing configurable products to Magento 2 along with other product typesAfter that, the article proceeds to another essential topic: Magento 2 import of product custom options. You will also learn how to update product stock and import product attributes in Magento 2.

While exploring the default Magento 2 product transfers, you will discover that they lack various features, such as automation, robust mapping, and support for some popular formats and sources, to name a few. However, you can easily attain the missing functionalities with the Improved Import & Export for Magento 2. Particular attention is given to it as well.  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

How to add a custom import adapter in Magento 2

Magento 2 export CLI

StackExchange is always a good source of answers to all possible questions, including ones related to Magento 2. Therefore, we monitor the platform to provide you with the most useful solutions posted there. This time our attention is captured by Mir, who asks about a custom import adapter for Magento 2. The author of the question is not satisfied with the default import opportunities of the platform (and we know why), so let’s find out how to solve the current issue. Find more tips in our Cookbook. Continue Reading