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

"import"

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.1 (released 7.11.2022)

Features

  • Full compatibility with Magento 2.4.5
  • Added possibility to assign customer group to customers using the customer group name with “Customers Main” entity. The following fields have been added to the “Customers Main” export and import: _customer_group_code (name of the customer group), _tax_class_name (name of the tax assigned to the customer group), _tax_class_id (ID of the tax assigned to the customer group). The customer group can only be created if the tax class specified already exists at the store.
  • Added ability to use auto-increment for order increment_id. Meaning that if you do not have an increment_id – it will be generated and assigned automatically. Useful when importing orders from your CRM or ERP, or integrating with a marketplace.
  • Added feature “Update Products that are not in the import list” for product import. Which allows to set products inside your catalog, which are missing from the imported file as: out of stock, quantity=0, out of stock with quantity=0, disabled.
  • Added system events for import and export jobs which can be used as hooks during the integration.

Bugfixes

  • Fixed issue with importing downloadable product links
  • Fixed issue when the email notification on the failed job would not trigger
  • Fixed issue with importing product with ‘only update’ behavior with ‘Undefined index:sku’ exception
  • Fixed issue with importing YouTube/Vimeo videos a for a specific store view, when video data is not displayed for the default store view
  • Fixed issue with importing categories with the incorrect type of the “path” column
  • Fixed issue with filtering orders by invoice dates when exporting orders
  • Fixed issue with updating a category path when importing categories
  • Fixed issue with copying relates_skus, crossell_skus and upsell_skus from a simple product to a configurable product when ‘Custom logic for creation of configurable products’ is enabled
  • Fixed issue with copying category ids from a simple product to a configurable product when ‘Custom logic for creation of configurable products’ is enabled
  • Fixed issue with exporting orders, when an increment_id is specified for each row
  • Fixed issue with importing products with custom options
  • Fixed issue with updating a category path when importing categories when path has invalid value
  • Fixed issue where patches were not being applied
  • Fixed issue with URL rewrite generator for the configurable product
  • Fixed issue with incorrect category name in an export file after moving the category
  • Fixed issue with updating a salable qty when importing products

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

Matrixify Shopify App In-Depth Review: Is It That Powerful?

- Shopify

Matrixify app for Shopify

What is Matrixify? How to use Matrixify? What are its core features and goals? Below, we review the Matrixify Shopify app to let you know the answers. We aim to highlight the core features of this tool, illustrate how Matrixify works, and figure out whether is the number one import and export solution for the Shopify ecosystem or not. A brief Matrixify template tutorial is also available in this article, along with Matrixify pricing plans. 

The core goal of the Shopify Matrixify app is to help merchants bulk import and export human-readable Excel and CSV files. Although the default Shopify data transfer instruments are also capable of doing that, the third-party solution dramatically extends the platform’s basic abilities. For instance, it lets you import Shopify orders! But is it enough to cover all the data transfer demands? You will find out soon. If you want more information on the default instruments, read these two materials: The Ultimate Guide to Shopify Import & The Ultimate Guide to Shopify Export 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 Fix Error 1062 Upon Magento 2 Database Import

- E-Commerce, Magento 2

Magento 2 Development; Magento 2 tutorial

We recently came across another StackExchange topic related to database import. While moving a database to Magento 2, user104747 faced an obstacle – ERROR 1062. We explain the problem in the following article. Also, you will find the suggested fix to this Magento 2 database import error below. Since the system does not allow you to move a database directly to Magento 2, the process may become fairly complicated. An output file with a specific object must always be created. And this procedure should adhere to numerous strict requirements. For instance, it is vital to divide your file into two distinct tables if it contains multiple categories of data (for example, products and orders). All other nuances are described below.

Additionally, you must always modify imported file attributes to conform to Magento 2 specifications. Otherwise, no database may be imported into Magento 2. Also, note that regular data transfers from a database to an e-commerce website cannot be automated. But all of these problems can be resolved with a single instrument. It doesn’t matter whether you want to fix error 1062 upon Magento 2 database import or implement the lacking data transfer capabilities, we know a perfect solution designed to address all the most common import issues. Meet the Improved Import & Export Magento 2 extension. After we go through a solution offered in the StackExchange discussion, you will find out how this module addresses database import problems associated with Magento 2. Read our Cookbook for more guidance and suggestions. Continue Reading

The Ultimate Guide To Data Import & Onboarding Platforms

- E-Commerce

data onboarding platforms and data import

The last time you loaded a table, how annoyed were you? Thousands of merchants experience that when attempting to import data from external sources. Transferring spreadsheets and correcting formatting issues are everyone’s problems. All of the erratic data flowing from your clients or business partners is mostly entered by people. Sharing a templated CSV becomes difficult due to different file encodings and varied data formats. Unless you rely on a data onboarding platform, a tool that enables you to accept files from all of your clients and business partners just as they are while still providing a top-notch customer experience. What exactly is data onboarding then? In order to match digital identifiers with offline consumer data in the online environment, this technical method comes in handy. This vital capability is at the forefront as identity-driven marketing garners more attention nowadays.

Now since we know it, marketing is more than just getting conversions; it’s also about keeping conversations going. And the only way to achieve this is to be able to continuously identify and relate to clients across their journeys associated with your brand. Because of this, establishing consumer identity has turned into a number one marketing necessity, and data onboarding is essential in this process that leads to a brand’s strength and flourishing.

A brand’s data onboarding determines whether it delights customers with the experiences they want or irritates them with unimportant, overused messages they desire to ignore when deploying identity-based initiatives. Indeed, it may look like a straightforward and basic thing to understand. But it’s one that many marketers find difficult to start with. In this guide to data onboarding, we pave the way to a successful understanding of the topic. You will discover what data onboarding is and what data onboarding platforms are worth your attention. Continue Reading

Ultimate Guide To Shopware 6 Import

- E-Commerce, Shopware

Like every e-commerce system, Shopware 6 provides the ability to import and export information between your website and external data sources. This functionality dramatically simplifies various content management chores, such as data updates or product translations. Besides, you can easily move products to product comparison engines and marketplaces. In this Shopware 6 import guide, we generally describe the options you have, reviewing the basic import module and its individual profiles. You will learn how to import data to Shopware 6 and what entities are supported. Also, check our Ultimate Guide To Shopware 6 Export. Continue Reading

Import/Export cookbook: How to import product prices for Magento 2 Shared Catalogs

Shared Catalogs allow Magento 2 Commerce owners to create product categories for particular companies (Magento 2 B2B feature) with the individual prices, which are not available for general customers. In this article we will use Improved Import & Export extension to import and export prices for the Shared Catalogs.

Shared Catalogs feature the same exact products which are available in your product catalog, however the prices for such products may be adjusted for B2B company customer accounts. Now, how can you import these product prices inside your Magento 2? In this cookbook article I will explain that it is nothing new, and you already know how to do it, and have probably done it many times.

Continue Reading

Magento 2 import and export COOKBOOK index post. Use cases and instructions

This is an index blog post for Magento 2 import and export use cases. In this post you will find links with the description to the posts which describe how to use Improved Import & Export extension for Magento 2.

Each use case article comes with the step by step instructions and screenshots illustrating the extension setup process. Each article covers a particular use case/question, for example: how to map product attributes, how to update stock and price of the Magento 2 product.

  • Read and bookmark articles
  • Try out the instructions at our Magento 2 demo store
  • Check out Master Table which contains samples of every Magento 2 entity export and import file.

Continue Reading

Import/Export cookbook: How to import products to Magento 2 with VAT price included and deduct the VAT automatically to display regular price

When you import products to your Magento 2 store, often the ‘Price’ column from the file already includes VAT. However, if you want to sell products for their real price, how do you import such products?

Do you edit the imported table manually before the import? Ask your supplier to send you prices without VAT?

However, you sometimes cannot get prices without VAT. Your supplier sends you the file from their warehouse, and cannot control how the prices are printed. Or the ERP system sends a json file, which is hard to edit.

You can do it, specify VAT and have it deducted automatically with the Improved Import & Export extension for Magento 2. Below, I will tell you how to do it, in a few steps.

Continue Reading