"import"

Import/Export cookbook: How to update Magento 2 product price and quantity using import and export. HINT: it’s fast and easy

Improved Import & Export Magento 2 extension documentation is huge! I know. It is aimed to cover every aspect of the extension.

However, you do not need to read it all, or understand each and every attribute of every entity. In this article, I will show you how to mass update Magento 2 product prices and quantity (stock) using import and export procedures.

Continue Reading

How to fix store ID-related issues on Magento 2 import

- E-Commerce, Magento 2

Magento 2 export CLI

StackExchange teems with interesting and useful tips related to Magento 2. This time, we’ve dug up a discussion where the author named Jackson complains about store ID-related issues that occur in Magento 2. Let’s take a look at the problem and provide several possible solutions. Jackson points to a particular script used to import data from a CSV file. However, the use of ->setStoreId(0) causes an issue – two values for the same field in the database table occur. As a result, it is necessary to delete second values to enable changes on the frontend but it often leads to the incorrect display. How to address the problem? You will find out how to fix store ID-related issues on Magento 2 import as it is portrayed in the discussion. At the same time, we provide a reliable alternative based on the Improved Import & Export. Also, you will discover other improvements associated with the module.
Continue Reading

How to update product price during Magento 2 import

- E-Commerce, Magento 2

Magento 2 lets you specify a new product price upon import, but what if you want to update category prices by $10? Or what if your supplier raised all prices by 10%? With the default data transfer tools, you have to apply such adjustments manually to every product in your catalog. The more products you have, the more time you will spend. Therefore, nobody wants to calculate and apply each new price manually. In this article, we will tell you how to automate the process. You will need the Improved Import and Export extension. The module dramatically extends the default data transfer capabilities of Magento 2 and introduces the ability to update product prices during Magento 2 import via Price Rules – a set of conditions that adjust the price of the imported products. 

Continue Reading

How to Automate Magento 2 Import & Export

- E-Commerce, Magento 2

improved import and export - Magento 2 extension

We have very good news for you: it’s no longer necessary to import/export files to/from Magento 2 manually. And below we explain how to automate Magento 2 import and export processes. Check this post and you will find out how to save tons of time and effort making your daily routine fully automated.

Of course, you need a third-party extension to achieve your goal. And we recommend you to use the Improved Import & Export Magento 2 extension, since the Magento 2 Open Source platform doesn’t add any automation to import/export processes. As a result, you have to perform each run manually, but before diving deep into the nature of our solution, let’s tell a few words about the automation itself. Continue Reading

The Best Improved Import/Export Extensions for Magento 2

- E-Commerce, Magento 2

Import Export Magento 2 Modules

Improved import & export Magento 2 extensions are designed to simplify some routine Magento tasks. They revamp the default abilities of the platform by adding convenient import/export options. Although, Magento 2 provides a lot of ecommerce possibilities in this area out-of-the-box, they are still not enough for seamless migration to/from other systems as well as for performing some daily tasks. Furthermore, in case you want to import products from Magento 1 to Magento 2, one of the following tools will essentially simplify this procedure. Besides, check our digest of the Magento 1 export tools here: The Best Improved Import/Export Extensions for Magento. They will be necessary for moving data out of your old store. And don’t forget about the Complete Guide to Magento 2 Product Import / Export. In that post, we describe core nuances of the default import/export process as well as provide Magento 2 import csv examples and description. But what bout popular Magento 2 import extensions and Magento 2 export modules?

Continue Reading

How to improve Magento 2 import and export speed?

- Magento 2

improved import and export - Magento 2 extension

Have you ever wondered why Magento 2 import and export processes are so slow? If you move data to and from your store on a regular basis, low import/export speed may become really annoying. But what is the reason for this problem and how to solve it? You will find the answer below.

Also, the article provides an alternative solution for the Magento 2 import and export performance issue. The default data transfer solution is associated not only with relatively low speed stats but also with a plethora of other hurdles that don’t let your admins manage data most efficiently. However, there is a universal solution that addresses all the issues associated with Magento’s built-in tools – the Improved Import & Export extension. You will also find its core features described below. 
Continue Reading

Firebear Improved Import & Export Plugin for Shopware

- E-Commerce, Our extensions

Firebear Improved Import & Export plugin for Shopware

Our Improved Import & Export module is one of the most fully featured and powerful data transfer solutions in the entire Magento ecosystem. The module offers lots of enhancements to the default import and export tools as well as propose features that make it unique in comparison to competitors. Improved Import & Export not only powers a straightforward way to connect several Magento websites but also goes far beyond the ecosystem. It introduces numerous integrations with other e-commerce platforms, tools, and service providers, including ERPs, CRMs, accounting systems, etc. In the article below, we briefly describe the extension’s key perks and then concentrate on how we implement them in another project – the Firebear Improved Import & Export Plugin for Shopware. You will find a detailed description of its core features and advantages below. Besides, we also focus on the existing import and export tools of Shopware. 

The article sheds light on the leading import and export solution for Magento 2 and then gradually proceeds to its Shopware counterpart. We explore import and export jobs, data transfer automation, mapping, and extended connectivity options of the Shopware 6 Improved Import & Export app. After that, you will find a small description of the existing import & export solutions available in the Shopware marketplace along with the default data transfer capabilities of the platform. Besides, we briefly describe how you can import & export data in Shopware 6 via API.

Continue Reading

How to fix the “URL key for specified store already exists” issue on Magento 2 import

- E-Commerce, Magento 2

Magento 2 export CLI

Let’s suppose that you need to import a product CSV file, that follows the Magento 2 requirements, to a new installation. What could go wrong? Unfortunately, several errors may occur when you do that, including “URL key for specified store already exists”. In the following article, we explore the issue on the example provided in a StackExchange discussion, where Zed Blackbeard argues that it is impossible to import products to Magento 2 due to the general system exception. Magento informs its administrator who runs the update that the URL key for the specified store already exists. After that, the system breaks the import

Below, you will discover the conditions that cause the problem. After that, the article provides several possible resolutions. To be more specific, we provide recommendations from the appropriate StackExchange discussion as well as deliver our approach that incorporates the Improved Import & Export extension. If you face other issues while using your Magento installation, you may try to find them described in this blog post: Magento 2 Cookbook.
Continue Reading

How to import data from external MySQL database to Magento 2

Magento 2 mysql data import

Often it is necessary to import products, customers, orders, or other data types to Magento 2 from a third-party MySQL database. However, Magento 2 doesn’t let you do that. Although the default tools don’t support such file sources as external databases, there are several ways to synchronize Magento 2 with external databases

In the following post, we shed light on how to achieve this goal in two different ways. Firstly, we describe a common approach that involves the default Magento 2 import solution. It requires tons of manual work and cannot be automated. You need to run a CSV export from your MySQL database, match third-party attributes to ones used in Magento 2, and import your MySQL table into your e-commerce website.

On the contrary, you will find out how to avoid numerous unnecessary chores while importing data to Magento 2 from a MySQL database. This approach involves the Improved Import & Export extension. The module combines MySQL database connection and other data import activities within a single interface right in your Magento 2 admin.

After that, we shed light on several MySQL facts as well as describe the core features of the Improved Import & Export extension. To make the long story short, let’s see how to import data from an external MySQL database to Magento 2.
Continue Reading