How to Import Data via REST API into Magento 2

- E-Commerce, Magento 2, Our extensions

Magento 2 REST API Import

Today, we’d like to draw your attention to the Magento 2 REST API Import. Depending on the edition of your Magento 2 installation, your built-in import and export tools may vary a little. However, the difference is not vast: you can create update schedules in Commerce while the Open Source edition doesn’t let you do that. The common thing is that neither of them lets you leverage the REST API import in Magento 2. Luckily, the missing functionality can be enabled with minimum effort. You only need to install the Improved Import & Export Magento 2 module. The extension offers all the features necessary to leverage the Magento 2 REST API import and export. 

The following article sheds light on how to import data into Magento 2 via REST API. We discuss how to enable the Magento 2 REST API import and what extra benefits you can get. If you are not familiar with what the Magento 2 REST 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 Magento 2 REST API import/export processes.
Continue Reading

How to Create a Custom Import in Magento 2

- E-Commerce, Fire development, Magento 2

magento 2 custom import

Although the default import and export instruments of Magento 2 are enough to satisfy the basic data transfer needs, you may require some extra features to follow specific business demands. Sometimes the missing functionalities are available with third-party extensions but even the most robust modules often fail to deliver custom opportunities that satisfy particular business requirements. What’s to be done? 

Below, we shed light on how to create a custom import in Magento 2. You will find two different approaches to the Magento 2 custom import. Firstly, we discuss a community-provided solution that requires technical skills and coding experience. It is not for every user, especially those who don’t belong to the group of tech-savvy Magento 2 managers. Secondly, we provide a more friendly way of creating a custom import in Magento 2. It is based on the Improved Import & Export extension and involves no coding on the side of the extension’s end user. Before we proceed, check more useful tips here: Magento 2 Cookbook. 
Continue Reading

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

- E-Commerce, Magento 2, Our extensions

Magento 2 Development; Magento 2 tutorial

In the following article, you will discover a universal algorithm for solving Magento 2 errors associated with incorrect attribute values. We focus on the Magento 2 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, Magento’s Value For Attribute Contains Incorrect Value error 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 with the Improved Import & Export module. 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

Magento 2 Imported Resource (Image) Could Not Be Downloaded: How To Fix This Magento 2 Import Error

- E-Commerce, Magento 2, Our extensions

Magento 2 Development; Magento 2 tutorial

In the following article, we explore a problem that prevents Magento users from importing images. You may be familiar with the Magento 2 Imported resource (image) could not be downloaded from external resource issue. If not, we provide two StackExchange cases and a possible resolution below. Besides, our team developed a dramatically improved way of importing images into Magento 2 which is also described in this article. So, what is Magento’s ‘Imported resource (image) could not be downloaded from external resource’ error, and how to fix it? Continue Reading

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)

- E-Commerce, Magento 2, Our extensions

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 transfers.  Mapping and scheduling are also described in this post. These features will help you automate the Magento import of attributes from external sources. 
Continue Reading

Magento 2 Bulk API & Asynchronous Import

- E-Commerce, Fire development, Magento 2

Magento 2 Bulk API

Below, we discuss the Magento 2 bulk API and the corresponding asynchronous import processes. After a short introduction to the topic, we shed light on the preconditions and history of the asynchronous Magento bulk API. You will find out what new endpoints are used, how asynchronous responses work, what role bulk APIs play in system processes, what status endpoints are utilized, why Swagger is important, etc. After that, we discuss the performance of bulk APIs in Magento 2 as well as the corresponding endpoints and the repeated features, including routes, payloads, responses, delete requests, store scopes, and object update/generation. Finally, the article switches to asynchronous import processes and product creation via bulk APIs.  Continue Reading

The Ultimate Guide to Shopify Import

- Our extensions, Shopify

Shopify import products, customers, inventory, orders

Every decent e-commerce platform offers built-in import and export tools. However, they are usually far from being an omnipotent solution that can cope with any business requirement. Because of this, agencies create third-party solutions that close the existing gaps between the platform’s objective reality and the merchants’ subjective needs. What about Shopify? What data transfer solutions does it offer? What reliable alternatives are currently available in the ecosystem?  

In this Shopify import guide, you will find out what import functionality is hidden behind the platform and how to enhance it in the most user-friendly and, at the same time, powerful way. Let’s explore the system’s native capabilities first and then proceed to the most powerful third-party solution that copes with any data transfer challenges and enables any Shopify import customizations – the Import & Export Tool for Shopify.

Below, you will learn about the basic data transfer capabilities of Shopify: product import, inventory import, customer import, etc. You will learn how to transfer products to your e-commerce website using the platform’s built-in functionality. The article examines two different cases: importing products from another website and reimporting them within the borders of your store. In addition to that, we provide a CSV file structure required for this process. Next, we explore how to import inventory, customers, and orders to Shopify. After that, you will learn how our Import & Export Tool enhances the default data transfers. Also, don’t forget to check our Ultimate Guide to Shopify Export.
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 Import Database in Magento 2

- Fire development, Magento 2

magento 2 import database command line

Recently, we’ve spotted a question on StackExchange regarding the Magento 2 database import. David Duong faced problems while transferring a database on Magento 2.3.3. Below, we shed light on the issue and the provided solution for Magento 2 to import a database via the command line. However, it is quite a complex process since the system doesn’t let you transfer a database to Magento 2 directly. You always need to create an output file that contains a particular entity. If your file incorporates several types of data (e.g., products and orders), it is necessary to split it into two separate tables.

Furthermore, you always have to edit attributes in the imported file to make them suitable for the Magento 2 requirements. Otherwise, the Magento import of a database becomes questionable. It is impossible to automate regular data transfers from a remote database to your e-commerce website. However, there is a tool that solves all these issues. After we describe a method provided in the StackExchange discussion, you will find out how to achieve the missing functionality with the help of the Improved Import & Export Magento 2 extension. For more tips and advice, read our Cookbook. Continue Reading