"Improved Import"

Magento 2 General System Exception Happened: How To Fix Error During Magento 2 Import

- Magento 2, Our extensions

Magento 2 Development; Magento 2 tutorial

If you regularly deal with Magento 2 import processes, you might have faced the following message: General System Exception Happened. Like other import errors, it prevents you from transferring data to your e-commerce website. What are the causes of the Magento 2 General System Exception Happened issue? How do we fix this import problem? Magento users all over the globe regularly ask these questions. You’ve come to the right place if you are also looking for the corresponding answers.  

In the following post, we try to figure out Magento’s General System Exception Happened error and explain how to fix it. The issue is an inevitable part of the basic Magento 2 import processes associated with the platform’s default tools. Luckily, we know for sure how to address the problem. 

Below, we aggregated a short guide on how to fix the Magento 2 General System Exception Happened issue based on the StackExchange answers. Besides, you will discover a more user-friendly approach to the import that the Firebear team provides. Other useful Magentop 2 tips are gathered here: Developer’s Cookbook.
Continue Reading

How to Import & Export Product Attributes for Magento 2 (Along with Attribute Values & Sets)

import export product attributes for magento 2

Today, we are going to talk about the import and export of product attributes for Magento 2. Operating an e-commerce store is associated with numerous processes. Various management chores include a broad array of actions from creating a category tree to adding an FAQ section. Somewhere between these processes, attribute management is hidden. Magento 2 heavily relies on attributes, attribute sets, and attribute values. You may need to update them frequently to keep your catalog in order. Although the platform delivers all the tools necessary to manage your attributes and all the related data, your daily routine turns into an unbearable burden if you work with hundreds of records. However, there is a simple way to do so – import attributes to Magento 2 instead of applying all the necessary changes manually.

You can import and export attributes, attribute sets, and attribute values in Magento 2, replacing various manual tasks and automating your management routine. Below, we shed light on how to enable this functionality in your store even though Magento 2 lacks the corresponding features. A little spoiler: you need to install the Improved Import & Export Magento 2 extension. It will help you transfer Magento 2 attributes, values, and attribute sets to and from your e-commerce website. 

The article below focuses on the pros and cons of both manual attribute management and the corresponding import and export automation. After that, it sheds light on various aspects of the Magento 2 import-export of product attributes associated with our extension. You will learn how to manage attribute tables, edit attribute values, create new attributes on the fly during import, use multiple file formats and sources for the attribute import and export, as well as leverage alternative transfersMapping and scheduling are also described in this post. These features will help you automate the Magento import of attributes from external sources. 
Continue Reading

How to Solve The Magento 2 “URL Key for Specified Store Already Exists” Error

- E-Commerce, Magento 2

 

magento 2 url key for specified store already exists error

When creating or importing categories and products some may encounter the Magento 2 “URL key for specified store already exists” error message. It may be the URL rewrites, database issues, or other things not considered.

Anyways, if there is an error there will also be a solution. In this article, we talk about how to solve the Magento 2 “URL key for specified store already exists” error when importing products and categories to your store.

You will learn when the error occurs, exploring specific conditions that cause it. This article mentions three different cases that usually lead to the “URL key for specified store already exists.” Next, we focus on the most frequent reason – duplicate URLs. The value specified in the URL key field would generate a URL that already exists in Magento 2. You will find out how to get rid of duplicate URLs when importing data to Magento 2. The article provides separate examples for products and categories. After that, we emphasize other features related to the Improved Import & Export extension – the solution that we use to address the “URL key for specified store already exists” issue.

Continue Reading

How to disable products not available in an import file for specific Magento 2 websites

- Magento 2, Our extensions

Magento 2 Development; Magento 2 tutorial

We’ve already explained how to update Magento 2 products that are not available in an import file. Today, we explain a more specific case: you will learn how to disable products that are not available in an import file. Moreover, there is a possibility to disable the on specific Magento 2 websites. Of course, you won’t be able to do that with the default Magento 2 import tool. You will need the Improved Import & Export extension to transfer the update as intended.  Continue Reading

Improved Import / Export Magento 2 Extension Manual

- Magento 2, Our extensions

In this article, we’d like to draw your attention to the Improved Import & Export Magento 2 extensions. The following blog post contains all the information about the data transfer module. Below, you will find the Improved Import & Export Extension manual that sheds light upon all the key aspects associated with the plugin. We describe its installation, configuration, and import/export transfers, teach you how to add a new import and export job, talk about import and export processes associated with different entities. You will also discover various nuances of running data transfers via CLI, automating processes, using extension customization endpoints, and performing troubleshooting. Various use cases and specific features are also described in the manual.

Improved Import and Export extension allows importing and exporting CSV/XML/JSON files with product data and product images to Magento 2. The files can be imported from a remote FTP/SFTP server, Dropbox, direct URL of a source CSV fileGoogle Sheets, etc.  In addition, the extension offers a dedicated category import from CSV files, import of attribute values and new attributes on the fly, import job scheduling with cron jobs, and other features.

Besides, you get advanced export capabilities, including order export and export jobs, with attribute and table field mapping.

Continue Reading

How to Import Data via SOAP API into Magento 2

Magento 2 SOAP API Data Import

Below, we shed light on how to enable Magento 2 SOAP API import. Unfortunately, this functionality is not possible by default, but you can add the missing feature to your e-commerce store with the help of a third-party extension. The following article sheds light on SOAP, compares it with REST, and offers a reliable tool for enabling the corresponding functionality for Magento 2. You can leverage the Magento 2 SOAP API import and export processes with the Improved Import & Export Magento 2 module

The following article sheds light on how to import data into Magento 2 via SOAP API with the help of our extension. We discuss how to enable the Magento 2 SOAP API import and what extra benefits you can get. If you are not familiar with what SOAP API is, we’ve also prepared a chapter that describes this standard. Besides, there is an FAQ section that provides answers to frequently asked questions about SOAP and Magento 2 import/export processes.
Continue Reading

How to Import Compressed Data (ZIP, TAR, TGZ) to Magento 2

- E-Commerce, Magento 2, Our extensions

Magento 2 Compressed Data ZIP TAR TGZ Import

What if your partner provides a vital data update in a compressed file? Prior to importing it to Magento 2, you need to unpack the archive. Next, if a file stored there is not CSV, you need to run the conversion. Furthermore, if it contains unsupported attributes, you need to replace them with the ones used in Magento 2. All these actions consume tons of time. However, it is possible to automate them. 

The following article discusses two ways of importing compressed data to Magento 2. Firstly, we shed light on a common approach that slightly simplifies the algorithm described above. Secondly, you will discover an alternative solution that dramatically improves the corresponding admin experience. It not only enables the import of archives to Magento 2 but also supports many more file types and enables the import of third-party data to Magento 2. Below, you will find out how to import ZIP and TAR to Magento 2 with the help of the Improved Import & Export extension.

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

Magento 2 Order Export Extensions Comparison (Amasty, Xtento, Wyomind, Commerce Extensions)

- E-Commerce, Magento 2

Magento 2 Order Export Extensions Comparison (Amasty, Xtento, Wyomind, Commerce Extensions)

Chances are, you are going to connect your Magento 2 store to an external platform that works with order data. It can be any service that simplifies the default ecommerce routine or adds some new possibilities. ERPs, CRMs, warehouses, dropshipping systems, or carriers may require this information. Unfortunately, it is hard to provide it unless you use a third-party Magento 2 module. Below, we compare four different Magento 2 order export extensions: Amasty Export Orders, Xtento Order Export, Wyomind Mass Order Export, and Commerce Extensions Import Export Bulk Orders. Besides, you can check our Improved Import Export for Magento 2, which also helps to achieve the same goal and provides dozens of features that are not available with the solutions mentioned above. Continue Reading

How to Import & Export Data from Office 365 Excel Online to Magento 2

Magento 2 Import Export Office 365 Excel Online

Do you use Office 365? Perhaps, your e-commerce partners do that? Anyhow, we have some good news for you: it is possible to connect Magento 2 to Office 365 Excel Online directly. By default, Magento 2 doesn’t provide this opportunity. Furthermore, it doesn’t offer support for native Excel files, but we know a reliable solution that enables the data import and export from Office 365 Excel Online in Magento 2.

In the following article, we briefly describe what Microsoft Office 365 Excel is. Consider it a reliable alternative to Google Sheets! After that, you will learn how to import and export data from Office 365 Excel Online into Magento 2. We describe the features of the Magento 2 Office 365 Excel integration and provide a step-by-step guide on how to import data from the popular service into your e-commerce website. In addition, there is a chapter that describes the benefits of this integration. 

The last section of the article is dedicated to the Improved Import & Export extension since it is the foundation of the integration. We describe such features as cron-based automation, mapping, supported file formats, and sources, as well as alternative ways to exchange data between Magento 2 and other systems.
Continue Reading