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

"Magento 2 export"

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.7.0 (released 20.09.2021)

Features

  • Added filter by product categories for product export jobs
  • 20-30% speed improvements for the import jobs with code refactoring
  • Added possibility to store job logs inside the database for multi-server Magento 2 setup

Bugfixes

  • Raised the version of “salsify/json-streaming-parser” module from ~6.0 to ~8.0
  • Fixed issue with the “Map Attributes” section mapping validation
  • Fixed issue with the validation strategy when importing a file with less rows than the maximum number of allowed errors
  • Fixed issue with the wrong order of options after importing attributes
  • Fixed issue when importing images with different roles for products when the role hasn’t been assigned
  • Fixed issue with updating the status and visibility of configurable products when using the ‘Custom logic for creation of configurable products’ setting
  • Fixed issue with ‘Disable products which are not in the file’ functionality when using the ‘MagMi’ platform for product import
  • Fixed issue with OneDrive permission problem and root slash
  • Fixed issue with the parallel launch of jobs not being executed properly
  • Fixed issue with export filter for product ‘quantity’ not working properly
  • Fixed issue with importing orders when the order isn’t correctly displayed at the store’s dashboard
  • Fixed issue with json serializer with malformed UTF-8 characters error
  • Fixed issue with CmsPage and CmsBlock export job filters not displaying relevant attributes
  • Fixed issue with Product export job filter by stock status
  • Fixed issue with import product category errors not allowing to rename categories
  • Fixed issue with updating the Salable Quantity of the product during import
  • Fixed issue with import configurable and simple products when using a Magento 1 platform

Improved Import Export Magento 2 Roadmap – vote for the most exciting features and we will implement them first. Leave your suggestions in the comments and we will add them to the poll.

Continue Reading

How to Import and Export Magento 2 Catalog Price Rules

- E-Commerce, Magento 2, Our extensions

Consider Magento 2 Catalog Price Rules a sales booster that allows running price-focused campaigns based on the discounts. You can apply them to products with particular attributes and their combinations to achieve the highest possible flexibility. Another good thing about catalog price rules in Magento 2 is that it is a platform’s native marketing tool. Also, Catalog Price Rules are extremely user-friendly to set up. However, there is one notable inconvenience associated with this entity. You cannot import Catalog Price Rules to Magento 2 by default. Luckily, there is an opportunity to get the missing functionality. You need the Improved Import and Export extension to transfer Catalog Price Rules between Magento 2 and external systems. The details are carefully noted in the article below. You will find a sample table for the Catalog Price Rule import. After that, we will explore the Catalog Price Rule attributes used in Magento 2. Also, there is a detailed description of how to prepare for and configure a Catalog Price Rule import process.

Continue Reading

How To Import/Export Categories to Magento 2

Magento 2 Development

Below, you will find a brief description of how to import/export categories between two Magento 2 websites. Unfortunately, this functionality is not available by default. Magento 2 leaves you alone with a huge category tree. You need to recreate it manually or rely on third parties. And we know for sure how to import and export Magento 2 categories most efficiently. This post was inspired by the Magento StackExchange discussion. Question by Rafael Corrêa Gomes; answer by KAndy. However, it is only a partial overview of the Magento 2 category import and export. A full-featured guide on how to import and export categories, with all attributes explained can be found here: Read full-featured Magento 2 Category import and export guide. Continue Reading

How to export Magento 2 data to Google Sheets

- E-Commerce, Magento 2, Our extensions

Transferring data between Magento 2 and Google Sheets seems a very efficient and time-saving way of synchronizing your e-commerce website with external platforms and other online storefronts. However, Magento 2 doesn’t let you do that if you rely on its default tools. If you need to import data, it is possible to create a CSV output of a corresponding Google Sheets table and then import it to your store. For the export purposes, you need to generate the output from your website and then open it in Google Sheets. Thus, instead of spending less time on daily duties, you have to perform a time-consuming routine. Luckily, there is a better way of synchronizing Magento 2 and Google Sheets.

FireBear keeps building up Improved Import and Export with powerful updates. Stay focused as with version 3.3.0 of the extension we introduce a long-awaited export of Magento 2 data to Google Sheets. The feature implementation marks the completion of the full-cycle Magento 2 and Google Sheets synchronization project. Now you are able to both import and export files from the source and arrange a highly manageable workflow.

How to do so? Follow this guide to learn more. Below, you will find an overview of the Magento 2 Google Sheets integration project as well as the most frequent use cases. Next, we describe Google API configuration, including such aspects as API library installation, API connection establishment, enabling Google Drive API, generating a Service Account Key, configuring a Service Account, and sharing the corresponding Google Drive folder. After that, we proceed to the Magento 2 Google Sheets export procedure. Continue Reading

How to Import Excel (XLS & XLSX) and OpenOffice (ODS) Files to Magento 2

- E-Commerce, Magento 2, Our extensions

Magento 2 Excel import export

We’ve already described hundreds of data import cases related to Magento 2 and many more are left to be mentioned in our blog. This time, we return to the topic of importing file standards the Magento 2 doesn’t support. Unfortunately, the system works with CSV files only and it is not the only requirement you should follow to be able to transfer an update to your database. You also have to edit third-party data and columns to make the file suitable, but let’s return to the unsupported formats.   

If you have an Excel (XLS or XLSX) or ODS file with data that should be imported to Magento 2, you’ve come to the right place. Although Magento 2 doesn’t let you do that by default, there is a reliable alternative solution at your service. Meet the Improved Import & Export extension – a tool that offers the most user-friendly way of Magento 2 Excel and ODS files import.

In the following article, we shed light on what to do with XLSX, XLS, and ODS files if you want to move them to Magento 2 via the default data transfer tools. After that, you will find a guide on how to import Excel and ODS files to Magento 2 in a way more user-friendly manner. Continue Reading

How to Import JSON Files to Magento 2

Magento 2 JSON Import

The default Magento 2 data import capabilities are enough for satisfying only basic data transfer demands, but what if a more complex task must be solved? For instance, you need to import JSON files to Magento 2, while the system supports only the CSV standard. Therefore, you need to convert your JSON files to the supported file type in order to move them to your e-commerce website. Luckily, there is a more user-friendly solution for importing JSON to Magento 2.

Meet the Improved Import & Export Magento 2 extension. This module supports JSON data import so that you can move all the necessary information to your e-commerce store without comforting it to CSV. You can effortlessly move data in this format in both directions: to and from your Magento 2 website.

In this article, we discuss JSON file requirements for importing data to Magento 2 and provide a list of supported entities (you can transfer all core entities now). Besides, there is a step-by-step guide to importing JSON data to Magento 2. And if you are not familiar with the JSON format, you will find its brief description below. Continue Reading

Wyomind Mass Order Export for Magento 2 and 1

Wyomind Order Export Magento 2 Extension Review; Wyomind Order Export Magento Module Overview

Third-party tools can essentially simplify the default Magento order export management. We’ve already gathered the best import/export modules in the appropriate posts here: Magento import/export extensions; Magento 2 import/export extensions. Today, we’d like to draw your attention to the Order Export extension by Wyomind. Below, we will introduce you to the module’s features and backend functionality.   Continue Reading

The Complete Guide to Magento 2 Bundle Products, and how to import them

- E-Commerce, Magento 2

Magento 2 delivers several types of complex products. While configurable items are the first thing that comes to mind in this case, you may also leverage product bundles. Magento 2 bundle products are designed to provide customers with an additional creativity level and exceptional freedom. With this product type, they can create their own item sets from the available options. And while buying bundled products is intuitive and doesn’t differ much from other e-commerce purchases, managing them in the Magento 2 admin is a quite complex routine that needs additional elucidation.  

In this guide, we show how to create bundle products and how to import such products to the Magento 2 catalog. The article guides you through the explanation of what bundle products are, focussing on various nuances of this product type. After that, the topic of the publication shifts to another vital aspect: we explain how to create bundle products in Magento 2. The last section of this blog post is dedicated to the bundle product import to Magento 2. It describes specific attributes associated with bundle products and sheds light upon other nuances of transferring items of this type to your e-commerce website. Also, we provide a separate chapter that describes how to import bundle products to Magento 2 from Google Sheets

Continue Reading

The Improved Import / Export Magento 2 Extension by Firebear

- Magento 2, Our extensions

The Improved Import Export Magento 2 Extension by Firebear

Below, you will see a brief description of our project aimed at improving the default Magento 2 import/export functionality. Although the basic processes are significantly refined now, they still lack some important features; therefore, we work on this Magento 2 extension with the aim to build a multi-purpose solution.

Improved Import extension for Magento 2 provides a possibility to transfer your CSV, XML, JSON, XLSX, ODS files with products data and product images to Magento 2 from a remote FTP server, Dropbox, Google Sheets, a direct URL of a source file, supports dedicated categories import, REST and SOAP APIs, on the fly import of product attribute values, import/export cron jobs, and many more features!

In the article below, you will find the extension’s shortened roadmap and brief description. We separately discuss the light version of the module and its entire stack as well as share use cases. Also, this blog post contains information on how to import data from Google Sheets, transfer categories to Magento 2, import product attributes, creating new attributes on the fly, etc. Other useful materials include Magento CLI import commands, import file samples, import fields mapping reference, etc. Continue Reading

How to import and export updates within Magento 2. Consecutive Export

- E-Commerce, Magento 2, Our extensions

Saving time is a priority when we deal with database updates. The most beneficial solution in the situation is to find an adequate method and tool that will reduce the number of backend actions and prevent errors and duplication.

In this guide, we will explore which processes can be used within Magento 2 to add new data to the one previously transferred without running countless imports and exports or recreating a whole new database. 

Continue Reading