Now compatible with Magento 2.4.4 PHP 8.1 Check new release of Improved Import & Export

"Magento 2 import"

How to import CSV files from /var/import/ folder to Magento 2 automatically

- Magento 2, Our extensions

Magento 2 Development; Magento 2 tutorial

Today, we explain how to import CSV files from the /var/import/ folder to Magento 2 automatically. As usual, you will need Improved Import & Export to overcome the default platform’s limitations, such as the inability to create update schedules. Configure the extension as we describe below, and it will do all the daily data transfer tasks for you. For more tips like this one, follow our Magento 2 Developer’s Cookbook Continue Reading

How to import default attribute values for products via API in Magento 2

- Magento 2, Our extensions

Magento 2 Development; Magento 2 tutorial

Recently, we’ve discovered a discussion on Stack Exchange about Magento 2 API import. The author asks whether it is possible to import default attribute values for products via API in Magento 2. Although you cannot establish API transfers using the default import interface, the Improved Import & Export extension lets you obtain the desired functionality within a couple of clicks. Let’s explore the issue in more detail and then proceed to the solution. And don’t forget to follow our Magento 2 Cookbook for more information on how to run your e-commerce website smoothly.  Continue Reading

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.3 (released 03.04.2023)

This release adds support for Magento 2.4.6 (including M2 Open Source, Commerce, Adobe Commerce and Mage OS) and PHP 8.2.

Bugfixes:

  • Zend_Validate_Regex is replaced with Laminas\Validator\Regex.
  • Zend_Mime is replaced with Magento\Framework\HTTP\Mime.
  • Zend_Validate is replaced with Firebear\ImportExport\Model\ValidatorChain.
  • Zend_Uri dependency is removed.
    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

How to Import Magento 2 Cart Price Rules

- E-Commerce, Magento 2

Magento 2 cart price rules are an invaluable tool for running promotions. They work perfectly along with catalog price rules. And while Magento 2 lets you easily configure both, it is impossible to import cart price rules unless you use a third-party instrument. Thus, having migrated from Magento 1 or other ecommerce platform to Magento 2, you can find yourself in need of the solution to import cart price rules and coupon codes.

In this post, we will show you how to import coupon codes and cart price rules to Magento 2 with the help of the Improved Import & Export extension. You will discover how a sample cart price rule import table looks, what cart price rule attributes are used, and how to import Magento 2 cart price rules.

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 update product price during Magento 2 import

- E-Commerce, Magento 2

Magento 2 lets you specify a new product price upon import, but what if you want to update category prices by $10? Or what if your supplier raised all prices by 10%? With the default data transfer tools, you have to apply such adjustments manually to every product in your catalog. The more products you have, the more time you will spend. Therefore, nobody wants to calculate and apply each new price manually. In this article, we will tell you how to automate the process. You will need the Improved Import and Export extension. The module dramatically extends the default data transfer capabilities of Magento 2 and introduces the ability to update product prices during Magento 2 import via Price Rules – a set of conditions that adjust the price of the imported products. 

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

The Complete Guide to Magento 2 Related Products, Up-sells, and Cross-sells, and how to import them

- E-Commerce, Magento 2, Our extensions

To sell effectively one must learn to predict and analyze. What are people looking for at my store? How can I make their search fruitful? At what point do the results become satisfying? Will it be enough to improve customer lives? The answers to the questions lie within everyone’s reach — run through some behavior statistics and create the most relevant offers for your audience. The related product, up-sell, and cross-sell functionalities are the very tools that will help you understand the customers’ needs.

You can consider related products, up-sells, and cross-sells a promo engine for your e-commerce website. Each relation type is distinguished following the display location and specific marketing goals. However, the core idea of being a purchase stimulus is similar for all the triplet items. In this guide, we will cover how to enrich your store content by using related content. You will learn how to use, import, and export Magento 2 related products, up-sells, and cross-sells. Since this publication is another one in the series of educational posts dedicated to Magento 2 import and export processes, you may be interested in the Magento 2 Import/Export Guide list that contains other similar guides.

As for the following article, it sheds light upon what Magento 2 related products, up-sell products, and cross-sell products are. We explain how to assign them to product pages as well as describe the corresponding import processes. Thus, you will learn what attributes are available in a CSV table, how to use the native Magento 2 import & export tools to transfer related products, up-sells, and cross-sells. And of course, there is a chapter that portrays a more user-friendly way to move them with the help of the Improved Import & Export extension.

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