"Our extensions"

How to Run Magento 2 Import if Required Columns Are Missed

- E-Commerce, Magento 2, Our extensions

Magento 2 Import without Required Columns

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. There are lots of different entities that can be transferred into Magento 2, so you have to deal with different 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 add the necessary columns manually or automate the addition of the missing data 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 ‘General System Exception Happened’ Error and eliminate it as fast as possible and with the 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 export Magento 2 data to Google Sheets

- E-Commerce, Magento 2, Our extensions

Transferring data between Magento 2 and Google Sheets seems a very efficient and time-saving way of synchronizing your e-commerce website with external platforms and other online storefronts. However, Magento 2 doesn’t let you do that if you rely on its default tools. If you need to import data, it is possible to create a CSV output of a corresponding Google Sheets table and then import it to your store. For the export purposes, you need to generate the output from your website and then open it in Google Sheets. Thus, instead of spending less time on daily duties, you have to perform a time-consuming routine. Luckily, there is a better way of synchronizing Magento 2 and Google Sheets.

FireBear keeps building up Improved Import and Export with powerful updates. Stay focused as with version 3.3.0 of the extension we introduce a long-awaited export of Magento 2 data to Google Sheets. The feature implementation marks the completion of the full-cycle Magento 2 and Google Sheets synchronization project. Now you are able to both import and export files from the source and arrange a highly manageable workflow.

How to do so? Follow this guide to learn more. Below, you will find an overview of the Magento 2 Google Sheets integration project as well as the most frequent use cases. Next, we describe Google API configuration, including such aspects as API library installation, API connection establishment, enabling Google Drive API, generating a Service Account Key, configuring a Service Account, and sharing the corresponding Google Drive folder. After that, we proceed to the Magento 2 Google Sheets export procedure. Continue Reading

Magento 2 Import: Field Separator & Multiple Value Separator

- E-Commerce, Magento 2, Our extensions

Magento 2 Import Field Separator Multiple Value Separator

From the very beginning of our history, data transfers with all their aspects and related processes have been the main focus in our company. We’ve explored lots of topics that describe Magento 2 import and export. Along with that, we’ve expanded our interest to other areas of Magento 2 and went far beyond the ecosystem. However, in the following article,  you will find several basic nuances of moving information to your e-commerce website.

Below, we continue exploring Magento 2 import and export processes and explain their two components: field separator and multiple value separator. What is the purpose of both? What separator types are supported? Are there any alternatives? You will find the answers below.

The following blog post touches upon the topic of different separator types that you can use in Magento 2. After that, we proceed to a guide on how to configure a multiple value separator in Magento 2. Also, you will find out what to do with field separators in your data files. Various multiple value separator and field separator improvements associated with the Improved Import & Export extension are also mentioned in the article below.
Continue Reading

How to Import & Export Data Between Magento 2 & Google Drive

- E-Commerce, Magento 2, Our extensions

Magento 2 Google Drive Import Export

As long as we run this blog, more and more improvements to the default functionality of the Magento platform will be revealed. And today, we are going to describe how to enhance the standard import and export processes with the ability to synchronize your e-commerce website with any partners using Google Drive. Since everyone has access to the popular file storage, this improvement will be handy. The following article sheds light on how to import and export entities between Magento 2 and Google Drive. Of course, the enhancement is impossible if you use the default Magento 2 tools, but it is not an unsolvable problem. And below, we show how to synchronize and automate data exchanges on the basis of Google Drive.

In the following article, you will find a brief overview of the Magento 2 Google Drive integration. After that, we shed light on the general facts related to transferring data between our favorite e-commerce platform and the popular file storage. You will learn how to choose a proper import and export solution for your Magento 2 Google Drive data synchronization. 

Next, we proceed to the core steps of the integration preparation. You will discover how to install Google API libraries and get Google Drive API credentials. After that, the article focuses on establishing a connection between Magento 2 and Google Drive. We describe how to configure a Service Account and share a Google Drive folder. The next chapters are dedicated to the configuration of import and export jobs for Magento 2 and Google Sheets integration and exploring use cases. Since the integration incorporates Improved Import & Export, you will also find its features described below.

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

How to import data from SAP ASE (Sybase) database to Magento 2

- E-Commerce, Magento 2, Our extensions

Magento 2 SAP ASE Sybase Data Import

What if a vital data update is stored within the SAP Adaptive Server database but you need to transfer it to your Magento 2 website? The default tools built into your e-commerce store are useless if you need to create a direct connection. The same is about most third-party tools. So, how to move the crucial information to your e-commerce store most efficiently? Below, you will find the answer. We describe a common way of importing SAP ASE bases into Magento 2 and then compare it with a more user-friendly approach.

The common way of moving SAP ASE tables into Magento 2 is a complex procedure that consists of several steps. First of all, you need to perform a CSV export from the Sybase SQL server. We describe this process in the dedicated step-by-step guide below. Next, you need to map third-party attributes to Magento 2 records. After that, it is possible to import an SAP ASE table into Magento 2. You will find the pros and cons of this approach below.

As for the easy way of moving Sybase SQL server bases into Magento 2, it is way more straightforward since it involves Improved Import & Export. You provide the connection parameters and configure other aspects of your data transfer. That’s it! Let’s explore each step of both procedures in more detail and compare two approaches side by side.
Continue Reading

How to Import & Export Newsletter Subscribers in Magento 2

- E-Commerce, Magento 2, Our extensions

Let’s suppose that you run an online business with lots of newsletter subscribers but want to move them to a brand new Magento 2 website. Although Magento 2 doesn’t let you do that with the help of its default import and export tools, there is a solution that enables the desired functionality. Meet the Improved Import & Export extension. With its help, you will freely import and export newsletter subscribers in Magento 2.

In the following article, we focus on how to manage newsletter subscribers in Magento 2. You will also discover the conditions you should create prior to importing subscriber data to your e-commerce website. Besides, we explain how to create a table with attributes repeated to newsletter subscribers. And of course, there is a guide on how to move newsletter subscribers from Magento 1 to Magento 2. If you are going to migrate from your old e-commerce website to a brand new one, you’ve come to the right place. The general details about Magento 2 newsletter subscribers’ import and export are also gathered below.
Continue Reading

Invalid Option Value: How To Fix 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 but it may occur when you import a 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

How to Import Shipping Tracking Numbers to Magento 2

- E-Commerce, Magento 2, Our extensions

Magento 2 Tracking Number Import

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 tracking numbers in Magento 2 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. Since you cannot do that with the default Magento platform, it is necessary to leverage 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 every integration. Let’s figure out how to import shipping information to Magento 2 seamlessly.

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