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

"Improved Import"

How to Import & Export OpenOffice Spreadsheet (ODS) Files in Magento 2

Magento 2 ODS Integration

The following article describes how to import and export OpenOffice Spreadsheet (ODS) Files to/from Magento 2. Unfortunately, you cannot do that with either the default Magento tools or most third-party extensions, but we know the cure for pain. Besides, the following article discusses why Apache OpenOffice is an excellent replacement for similar solutions. Continue Reading

How to import data from DB2 to Magento 2

Magento 2 DB2 datya import

The following article sheds light on how to import data from a remote DB2 table to Magento 2. Unfortunately, the database doesn’t provide any direct ways to do that. But below, you will find two approaches to migrating data from DB2 to Magento 2: the traditional one and the user-friendly one. Let’s take a look at the traditional approach to data import from DB2 to Magento 2. Continue Reading

How to import data from MongoDB to Magento 2

Magento 2 MongoDB Data Import

Let’s imagine a situation when you have a remote MongoDB table that should be used for updating your Magento 2 store. Unfortunately, the document store won’t let you move the information to your e-commerce website directly, but there is no reason to panic since there are at least two ways to achieve your goal: traditional and user-friendly. Below, we compare both of them to figure out the most efficient solution. Let’s take a look at the traditional approach to importing data from MongoDB to Magento 2. Continue Reading

How to import data from PostgreSQL to Magento 2

Magento 2 PostgreSQL data import

While there are dozens of various databases, none of them offers a direct import of data to Magento. At the same time, you can leverage multiple community-proven ways to achieve this goal. Below, we compare a traditional approach to importing data from a remote PostgreSQL table to Magento 2 with a user-friendly one. If you are tired of a complicated import procedure – you’ve come to the right place: below, we explain how to import data from PostgreSQL to Magento 2 in the most seamless manner. Continue Reading

How to import data from external Oracle database to Magento 2

As it turns out, neither Oracle nor most databases provide any utilities for exporting data to Magento 2. Furthermore, they don’t even have user-friendly tools for exporting proper CSV files. But how to import data from an external Oracle database to Magento 2? Good question; below, we’ve described two different approaches that will help you achieve this goal. Let’s start with community-proven practices that consume tons of time and effort and then proceed to a more user-friendly way. Continue Reading

How to improve Magento 2 Commerce/Cloud import and export procedures, import XML and Json

- E-Commerce, Magento 2

It is not a secret that Magento 2 Commerce/Cloud edition import and export procedures can be automated and offer an enhanced functionality compared to Magento 2 Open Source (Community) edition.

Still, there is some functionality lacking. In this post, we have gathered the suggestions on how to improve Magento 2 Commerce/Cloud import and export, how to import XML and Json file, import categories and other entities.

Magento 2 Commerce/Cloud in comparison with Open Source (ex. Community) version comes with improved Import and Export procedures. The main difference with Open Source comes from the possibility to schedule the import and export. Let’s break down the process and look at the features available. Continue Reading

Magento 2 import XSLT transformation – how to import any XML to Magento 2

- E-Commerce, Magento 2

When working with the suppliers, you often come across custom XML table formatting. Such tables cannot be imported to Magento 2 without giving all product attributes particular names.

Same applies to the export. Your CRM system probably accepts a set format of XML files. So as other software you might be using.

That’s why we are introducing XSLT support for Improved Import and Export extension. To help you get the required XML formatting for any needs you might have.

Continue Reading