Improved Import & Export major update - full Google Sheets & Drive integration. Fixed price Magento 1 > Magento 2 migration service! EXPLORE

"import"

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

Magento 2 search terms and synonyms, and how to import and export them

- E-Commerce, Magento 2, Our extensions

Magento 2 lets store admins optimize the customer search queries by composing lists of search terms and synonyms. While it is possible to manage this data type in your backend manually, Magento 2 prevents importing or exporting it. This limitation negatively impacts the productivity of your backend administrators since they cannot update Magento 2 search terms and synonyms within a few clicks. However, there is a tool that unlocks the missing ability. Meet the Improved Import & Export extension. This module empowers you to import and export search terms and synonyms in Magento 2

In this article, we describe Magento 2 search terms and synonyms as well as teach you how to manage them. Both search terms settings and search synonyms settings are described below. Besides, you will learn how to import lists of search synonyms and terms to your Magento 2, and how to export those for editing purposes. We shed light on how import and export works and what search terms and synonyms attributes are used.

Continue Reading

The Complete Guide to Magento 2 Related Products, Up-sells, and Cross-sells, and how to import them

- E-Commerce, Magento 2, Our extensions

To sell effectively one must learn to predict and analyze. What are people looking for at my store? How can I make their search fruitful? At what point do the results become satisfying? Will it be enough to improve customer lives? The answers to the questions lie within everyone’s reach — run through some behavior statistics and create the most relevant offers for your audience. The related product, up-sell, and cross-sell functionalities are the very tools that will help you understand the customers’ needs.

You can consider related products, up-sells, and cross-sells a promo engine for your e-commerce website. Each relation type is distinguished following the display location and specific marketing goals. However, the core idea of being a purchase stimulus is similar for all the triplet items. In this guide, we will cover how to enrich your store content by using related content. You will learn how to use, import, and export Magento 2 related products, up-sells, and cross-sells. Since this publication is another one in the series of educational posts dedicated to Magento 2 import and export processes, you may be interested in the Magento 2 Import/Export Guide list that contains other similar guides.

As for the following article, it sheds light upon what Magento 2 related products, up-sell products, and cross-sell products are. We explain how to assign them to product pages as well as describe the corresponding import processes. Thus, you will learn what attributes are available in a CSV table, how to use the native Magento 2 import & export tools to transfer related products, up-sells, and cross-sells. And of course, there is a chapter that portrays a more user-friendly way to move them with the help of the Improved Import & Export extension.

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 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

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

How to Export and Import Magento 2 Categories

- E-Commerce, Magento 2

Unfortunately, Magento 2 doesn’t let you import and export categories by default. Although the platform’s capabilities associated with data transfers are fairly limited, you can address the existing issues with ease. It is necessary to install a third-party module to import and export categories to Magento 2. In the following article, we shed light on how to transfer an existing category tree to/from your e-commerce website using the Improved Import & Export Magento 2 extension. After describing the Magento 2 category export, we peruse a sample import table that contains product categories. After that, our attention is focused on specific Magento 2 category attributes: we explore use cases and attribute mapping to let you transfer categories to Magento 2 from any external platforms. Next, there is a detailed step-by-step guide that depicts Magento 2 category import. Also, you will find out how to import product positions in categories (a part of the Visual Merchandiser functionality of Magento 2) and move Magento 2 categories per different store views.

Continue Reading