Monthly Archives: March 2024

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 Import Product Images into Magento 2 in Bulk

- Fire development, Magento 2

magento 2 import product images

Below, we describe how to import product images in Magento 2 using CSV. Since it is a part of a product import routine, you will only need to learn a couple of aspects.

Of course, you can add images to product pages one by one but what if there are thousands of items on your storefront? In this case, manual upload doesn’t seem to be a good idea. However, there are two methods described in the official documentation that dramatically simplify the Magento bulk image import. First of all, you can leverage a local server to upload product images to Magento 2 in bulk.

Secondly, the system lets you use a remote server for this purpose. However, both methods incorporate the default data transfer instruments of Magento 2. Since they are a little bit limited, you can use the Improved Import & Export extension to import product images to Magento 2. Let’s see how the default methods look and what benefits our module offers. Visit our Magento 2 Developer’s Cookbook to discover other useful tips.
Continue Reading

Magento 2 Bulk API & Asynchronous Import

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

Magento 2 B2B Requisition List Guide: How to Manage & Import Requisition Lists in Magento 2

Magento 2 B2B Requisition List Import guide

In the following article, we explain what a requisition list of Magento 2 is – a feature exclusively available in Adobe Commerce with B2B extension only. Besides, we describe the Magento 2 requisition list functionality and provide several small tutorials on managing this type of content. Next, we shed light on how to import and export Magento 2 B2B requisition list data. Since you cannot freely transfer B2B entities in Magento with its default tools, you need a third-party tool and a CSV file prepared according to specific requirements. We offer a solution that works best for the requisition list import to Magento 2. You will also find a sample CSV with all the necessary attributes and a table that defines all the Magento 2 B2B requisition list columns below, but let’s define Magento 2 requisition lists first and then gradually proceed to other sections of this guide. Continue Reading

Shopware 6 Advanced Pricing Guide + Import Tutorial

- Shopware

Below, we focus on the advanced prices of Shopware 6, focussing on tier prices and their import. Pricing tiers are a powerful marketing instrument that adds a new layer of complexity to the product’s default price, and Shopware 6 lets you define multiple pricing tiers per product. Let’s see what core features the platform offers to tame prices and leverage advanced prices. After that, you will learn how to configure tier prices in Shopware 6. The last chapter of this guide is dedicated to the Shopware 6 tier prices import.  Continue Reading

Magento 2 Shared Catalog Guide: How to Import and Export Shared Catalogs in Magento 2

- E-Commerce, Magento 2

Magento 2 Shared Catalogs Import and Export

The following article explores Magento 2 shared catalogs – a B2B entity exclusively available to Adobe Commerce users. You will learn what a Magento 2 shared catalog is, how to create a shared catalog in Magento 2, what the nuances of sharing are, and how to import and export shared catalogs. Note that full-featured shared catalog data transfers are possible only with the Improved Import & Export extension and its B2B Add-on. The other features are available right out of the box.

The entity has huge potential for B2B merchants, and we will help you leverage it below. So arm yourself with patience and peruse this guide. If you don’t know how to import or export shared catalogs between your Magento 2 store and an external e-commerce website, you’ve come to the right place. But let’s first define what shared catalogs are.
Continue Reading

Magento 2 B2B Company Guide: Revealing Company Structure & Import

- Magento 2

 

magento 2 b2b company import guide

If you want to migrate from the existing Magento B2B website, you may face a problem when companies cannot be moved with the help of the default Magento 2 tools. Neither can you synchronize the existing Magento 2 B2B company structure between several websites.  Thus, you should run the transfer manually, recreating the entire storefront section manually. But what if there is a more user-friendly way of importing and exporting Magento 2 B2B companies? In the following article, we shed light on what a Magento B2B company account is. You will learn the nuances of the Magento 2 company structure; and after that, we will guide you through the corresponding data import process. You will learn the attributes used in the import of B2B company accounts to Magento 2. We also explain the meaning of a CSV file for importing company roles. After that, you will find out how to run the Magento 2 B2B company import. Continue Reading