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
In the following post, we explore how to create a progress bar for importing files into Magento 2. The article is based on the StackExchange question by Manish Goswami as well as our developing practices. Let’s take a look at the solution proposed on StackExchange and then explore an alternative way. Continue Reading
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
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
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
We hate to say it, but there is no way to import data from Microsoft SQL Server to Magento 2 by default. There are two ways of achieving this goal. The traditional approach requires much time and effort to complete the procedure, while a user-friendly one is based on the use of a third-party tool. Let’s pay more close attention to each one. Continue Reading
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
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