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

"Improved Import"

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 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 And Export Magento 2 Page Builder Data

Magento 2 Page Builder Data Import Export

In the following article, we shed light on what Magento 2 Page Builder is and how to import/export all Page Builder data. Since you cannot transfer anything to/from the tool via default Magento 2 instruments, it is necessary to install a third-party extension. Below, we shed light on the most intuitive and easy-to-use solution aimed at recreating the missing functionality. Meet the Improved Import & Export extension. With its help, you will be able to import and export Page Builder-related information to and from Magento 2 most efficiently.

As for the blog post below, it unveils the most important facts about Magento 2 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 Magento 2 Page Builder. After that, the article focuses on 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 in the blog post.
Continue Reading

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

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

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

Magento 2 Import: How To Fix ‘Value For Attribute Contains Incorrect Value’ Error

Magento 2 Development; Magento 2 tutorial

In the following article, you will discover a universal algorithm for solving Magento 2 errors caused by incorrect attribute values. We focus on the ‘Value For Attribute Contains Incorrect Value’ issue to illustrate the entire scope of problems merchants usually face. 

Let’s assume that your import file contains multiple products with numerous attributes, each of which follows the strict Magento requirements. However, there is a record with invalid values. As a result, the error mentioned above displays. It doesn’t let you transfer the entire table with product data.

Below, you will find out how to address this problem. Furthermore, we also shed light on how to prevent it and avoid unpleasant situations with your future data updates. Since our solution incorporates the Improved Import & Export module, you will discover its features below. Besides, we elucidate how to prevent other import issues with the help of our plugin. If you are looking for a more specific case of this issue, check this article: Value For Status Attribute Contains Incorrect Value: How To Fix Error During Magento 2 Import.
Continue Reading

Invalid Option Value: How To Fix Magento 2 Import Error

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

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

How to import and export CMS/Static Blocks to Magento 2

It is hard to overestimate the importance of Magento 2 CMS pages for an average e-commerce website. They play a pivotal role in creating a unique and attractive storefront. Homepage, news blocks, promotions, and other store sections may incorporate CMS pages to deliver a more abundant shopping experience. Also, pages composed within the Magento 2 Page Builder are always associated with various CMS elements. Despite such frequent appearances, Magento 2 doesn’t let you import-export CMS pages. However, with the Improved Import and Export extension, you are no longer bound to the store’s backend for editing purposes. You can now import multiple CMS pages to your store with a single click. In this post, we will tell you how to do that. You will learn how to import Magento 2 CMS pages. We focus on such aspects as a proper import table and an import job that simplifies your daily chores.

Along with the step-by-step instructions, the article provides explanations on every static block attribute. Also, you will find sample files that you can use as a reference. We describe prerequisites for importing/exporting statics blocks in Magento 2. After that, you will learn how to transfer CMS blocks between Magento 2 websites. Additionally, we touch upon the topic of composing and editing static blocks tables.

Continue Reading

How to Import Magento 2 Advanced Pricing

- E-Commerce, Magento 2

Although setting up tier prices in Magento 2 is an exhausting task, you can dramatically simplify the related chores. But why is it so time-consuming? Setting up advanced pricing in Magento 2 requires going through the products one by one, submitting values in a dedicated window, and then saving. The more products you have, the more actions you need to apply. However, the Magento 2 import procedure lets you save hours of manual management time. In this article, we describe how to import advanced pricing to Magento 2. Below, you will find a sample advanced pricing import table described. Next, we provide advanced pricing attributes used in Magento 2. With this information in mind, you can proceed to importing Magento 2 tier prices

Unfortunately, the default Magento 2 import tools only let you import products and advanced prices separately. It means that you need to upload one file with product data except for tier prices which are provided via another spreadsheet. You must admit that it is not very convenient, especially when you move the entire catalog. 

To address this issue, we describe another procedure, involving the Improved Import and Export extension. With this tool, you can import both products and tier prices in a single file. Importing Magento 2 products with tier prices in a single file is based on the following steps. Firstly, prepare an import table, following our recommendations. After that, create a new import job as described in this blog post.

Continue Reading