"Improved Import"

How to Run Magento 2 Import if Required Columns Are Missing

- E-Commerce, Magento 2, Our extensions

Magento 2 Import without Required Columns

Welcome to our guide on how to import data to Magento 2 if something is missing in a table. 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. Many different entities can be transferred into Magento 2, so you have to deal with various 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 manually add the necessary columns or automate the missed data addition 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

Value For Status Attribute Contains Incorrect Value: How To Fix Error During Magento 2 Import

- E-Commerce, Magento 2, Our extensions

Magento 2 Development; Magento 2 tutorial

When you try to manage a standard import process in Magento 2, you may face lots of issues and inconveniences caused by the platform’s requirements and limitations. For instance, we’ve already described how to fix the ‘General System Exception Happened’ Error and eliminate it as fast as possible and with minimum effort. Today, we’d like to draw your attention to another problem that often occurs during Magento 2 import. Meet the ‘Value For Status Attribute Contains Incorrect Value’ error. The following article sheds light on how to fix it, prevent multiple import issues, and make data transfers more user-friendly. Note that we use the Improved Import & Export Magento 2 extension to solve the problem and prevent other inconveniences. Therefore, you will also find its features described in the following material. Continue Reading

How to Apply Filters to Magento 2 Import and Export

- E-Commerce, Magento 2, Our extensions

magento 2 filter: Export

Imagine a situation when there is a massive data file with thousands of SKUs, but you need to import items with a price lower than $100 or products from a specific category. Or let’s assume that you need to create an export file that contains products that are enabled, have a price higher than 0, are in stock, and are visible in Catalog and Search or just in Catalog. How to do that? You need to apply filters to Magento 2 import and export or create import and export conditions. The following Magento filter guide sheds light on various details of both processes.

It’s not a secret the functionality of Magento 2 has lots of limitations. Of course, the platform offers much broader opportunities in comparison to its predecessor, but there is still room for improvement, especially in the area of data filtering. Thus, you can neither apply Magento 2 import and export filters nor create import/export conditions to narrow down the output or transfer only the necessary information into the system. However, it is not all that bad.

We firmly believe that Magento wouldn’t be cool without its community and a vast ecosystem of third-party extensions. Both factors provide a positive impact on the platform dramatically extending its borders concerning productivity and functionality. As you might have already guessed, the ability to apply Magento 2 import/export filters and create import/export conditions is entirely based on a third-party solution, so meet the Improved Import & Export Magento 2 extension.

The module provides the ability to create highly configurable and flexible import and export profiles (jobs), where you can specify the most precise conditions regarding each process. Thus, even the most demanding business requirements are satisfied. Let’s take a look at filtering opportunities offered by the Improved Import & Export Magento 2 extension and then proceed to other features. Continue Reading

How To Fix Invalid Option Value Magento 2 Import Error

- E-Commerce, Magento 2, Our extensions

Magento 2 Development; Magento 2 tutorial

Below, we explore another common problem that prevents Magento 2 import processes. No matter whether you’ve faced the Invalid Option Value Error or not, it may occur when you import a Magento 2 configurable product with many options. Below, we study two cases and provide several resolutions to the issue.

Firstly, we explain a situation when it is impossible to save changes in a configurable product due to its custom options.

Secondly, you will peruse a case when a user cannot import a configurable product from a CSV file.

After that, the article sheds light on a time-consuming resolution provided in a StackExchange discussion. Since we also know how to address the issue, you will find several tips on how to manage configurable products with numerous custom options. Besides, we describe an enhanced import procedure that incorporates the Improved Import & Export Magento 2 extension.
Continue Reading

Magento Shipping Tracking: How to Import Shipping Tracking Numbers to Magento 2

- E-Commerce, Magento 2, Our extensions

Magento 2 Tracking Number Import

Today, we are going to discuss the Magento shipping tracking. It is essential to provide customers with all the information about the goods and services you sell. While displaying all product details is an obvious and easy-to-implement task, managing Magento 2 tracking numbers is way more sophisticated. For instance, your e-commerce website doesn’t let you transfer them from an external system. Consequently, you cannot automate the integration between Magento 2 and shipping providers. However, there is a tool that addresses the existing issues and enables seamless synchronization of your e-commerce website and third-party platforms.

In the following post, we shed light on how to import shipping tracking numbers to Magento 2 with the Improved Import & Export extension. This reliable solution enables rich import functionality, provides robust export capabilities, and offers tons of other features that dramatically enhance your daily routine, including Magento 2 shipment tracking. Let’s figure out how to seamlessly import shipping information to Magento 2.

Below, you will learn about Magento 2 tracking number import. We provide a list of all features that Improved Import & Export delivers in this dimension. After that, you will figure out how to import and export Magento 2 tracking/shipping codes. The last chapter of this article described other features associated with our extension. Continue Reading

Magento 2 GraphQL Tutorial: How to Import Data via GraphQL API into Magento 2

- E-Commerce, Magento 2, Our extensions

Magento 2 graphql import export

The following Magento 2 GraphQL tutorial describes how to import and export data into/from Magento 2 with the help of GraphQL API. This connection type is yet impossible out of the box, but the community is working hard to introduce it as a replacement for REST API. At the same time, some tools enable Magento 2 GraphQL API import and export right now. For instance, you can leverage the Magento 2 GraphQL API import and export processes with the Improved Import & Export Magento 2 module.

The following article sheds light on how to import data into Magento 2 via GraphQL API with the help of our extension. You will find out how to enable the Magento 2 GraphQL API import and what extra benefits it is associated with. If you are not familiar with what GraphQL API is, we’ve also prepared a chapter that describes this standard and its benefits over REST and SOAP. Besides, an FAQ section provides answers to frequently asked questions about GraphQL Magento 2 import and export processes.
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 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, 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.7 (released 17.04.2024)

Features:

  • Magento 2.4.7. Support. The latest version of the extension supports Magento 2.4.7.
  • Customer Import. Support for separate street columns “_address_street_1”, “_address_street_2”, “_address_street_3”, “_address_street_4” when importing customer & addresses.
  • Improved Consecutive Export. Now, it is possible to export also last updated entities.
  • Export Mapping. The “salable_qty” column has been added to the export mapping section when exporting products with MSI data.
  • Order Export. A new event, “sales_order_save_commit_after,” to run order export jobs has been added.
  • Customer Import. A new customer import attribute has been added – “allowed_assistance.” It can enable/disable the Allow Remote Shopping Assistant feature.
  • Order History Import. Now order comments can be imported by the order’s “increment_id”. “status_history:entity_id” and “status_history:parent_id” are not required anymore.
  • Custom Options Price Import. It is now possible to import store-specific custom option prices.
  • Export Filters. Export filters support the following conditions: “=” “!=” “>” “<=” “contains” “not contains.”
  • Image Import. Additional logging has been added for deferred image import.
  • Performance. Customer import has improved memory consumption.
  • Data Storage. The DB’s “mapping” column type has been changed to “mediumblob” in the “firebear_import_jobs” table to allow the storage of more data.
  • Product Import. The ability to unassign products from the category has been added.
  •  Order Export. It is now possible to export order data in one line to XML and JSON formats.

Continue Reading

Magento 2 Page Builder Import & Export

- E-Commerce, Magento 2, Our extensions

Magento 2 Page Builder Data Import Export

In the following article, we shed light on Magento 2 Page Builder. You will learn its core features. After that, we will focus on the Magento 2 Page Builder import and export. Since you cannot transfer anything to/from the tool via the platform’s default instruments, it is necessary to install a third-party extension. Below, we explore the most intuitive and easy-to-use solution aimed at recreating the missing functionality. Meet the Improved Import & Export extension. With its help, you can most efficiently import and export the data associated with Page Builder in Magento 2.

The blog post below unveils the most important facts about Magento Page Builder. You will learn about its drag-and-drop functionality, grid system, visual effects, flexible integrations, products, instant previews, schedules, etc. Besides, there is a technical introduction to the tool and a brief description of Bluefoot CMS as the foundation of the Page Builder in Magento. After that, the article switches to its key part – you will learn how to import and export data to/from Magento 2 Page Builder. Since the process incorporates the Improved Import & Export extension, you will also find its features described below.
Continue Reading

How to Import Magento 2 Product by Store View?

- Fire development, Magento 2, Our extensions

Magento 2 product by store view import

You’ve come to the right place if you run a multilingual storefront or use several different store views. Below, we explore a situation when you need to import Magento 2 product data by store view. While this procedure may seem quite exhausting when you use the default import tools, you may rely on several other ways to simplify these data management chores. Below, we provide community-based recommendations on Magento 2 product import per store view for both Magento 1 and Magento 2. At the same time, you will find a solution proposed by the Firebear team. 

The article incorporates materials from the StackExchange question by ruuter. Once we came across it, we thought it was good to share our experience in this area. Thus, if you don’t know how to import individual product data per store view in Magento 2, we will teach you below. 

Also, note that the article compares the traditional approach that works for Magento 1.x with the new way introduced in Magento 2. As for the improved solution, we shed light on the associated product import automation, product data transfers per store view from external sources, and the use of alternative data sources, such as Google Sheets or API connections. Continue Reading

Magento Error Log to Debug Magento 2 Import & Export

- E-Commerce, Magento 2, Our extensions

magento error log

Today, we are going to discuss the Magento error log for import and export processes. Since Magento 2 doesn’t have any import and export logs, debugging becomes way more difficult than most users expect. It is still possible but you need to spend way more time and effort than in the case of third-party solutions. In the following article, we shed light on how to debug and log the Magento 2 import and export processes and errors with the help of the Improved Import & Export Magento 2 extension.

Below, you will discover a Magento 2 debug log for import and export processes available in our extension. We describe how to view and manage them. Besides, the article touches upon the topic of debugging the Magento 2 import and export process and errors, mostly focussing on how to avoid the existing problems. Other useful tips are available here: Magento 2 Developer’s Cookbook.
Continue Reading