"magento 2"

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

- E-Commerce, Magento 2, Our extensions

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

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

How to Import & Export Magento 2 Gift Cards

- E-Commerce, Magento 2, Our extensions

magento 2 gift card import export

Gift cards are a useful addition to every e-commerce website. They are frequently used on e-commerce websites with any assortment: online grocery stores, fashion outlets, sporting equipment websites, etc. Most e-commerce platforms let you use gift cards, and Magento is no exception. In the following article, we explore Magento 2 gift cards. You will learn the platform’s gift card workflow. We focus on the available Magento gift card types, shed light on the Magento 2 gift card product, and explore the import and export nuances associated with this entity. You will learn how to import gift cards to Magento 2 using the platform’s default instruments. After that, we provide a more user-friendly and flexible solution to the Magento 2 gift card import and export. Of course, all the Magento gift card attributes are explained below. And if you think that the default gift card functionality is not enough, please, check our list of top Magento 2 gift card extensions. Continue Reading

Magento 2 Product Reviews Import & Export Guide

- E-Commerce, Magento 2, Our extensions

Magento 2 Product Reviews Import Export

Today, we are going to talk about product reviews in Magento 2. Although the main focus of our discussion is the import of reviews, you will also learn how to export them. And, of course, there is a section that describes attributes and values available in a Magento 2 product reviews import CSV.

Please, note that you cannot import and export product reviews to/from Magento 2 with its built-in tools. Therefore, we explain how the Magento 2 import of product reviews looks with the Improved Import & Export Magento 2 extension. You will discover a sample import and export table for product reviews with all its attributes explained.

After that, we dive deep into the nuances of the Magento 2 product reviews import & export. You will learn how to import product reviews to Magento 2 automatically. The corresponding export processes are described too. But before going any further, let’s see how to enable Magento 2 product reviews. 
Continue Reading

How to Import and Export URL Rewrites in Magento 2

- E-Commerce, Magento 2, Our extensions

Magento 2 import URL Rewrites

This article discusses a significant point of every migration between e-commerce stores – the Magento 2 import of URL rewrites. Below, we describe how to import and export URL rewrites in Magento 2. Unfortunately, your e-commerce storefront doesn’t let you perform this data exchange by default. The import and export capabilities of Magento 2 are fairly limited and lack support for numerous entities, including Magento 2 URL rewrites. However, you can address the existing data sync problems with the help of third-party services, such as the Improved Import & Export Magento 2 extension. In the blog post below, you will learn how to use the extension to import and export URL rewrites between Magento 2 websites or from beyond the ecosystem. At the same time, we shed light on the URL Rewrites Magento 2 sample import and export table, explaining its attributes. You will also find a detailed description of the Improved Import & Export solution since it delivers lots of opportunities, in addition, to support for URL rewrites. 
Continue Reading

Magento 2 CMS Page Hierarchy Exploration: Features, Configuration, Import & Export

- E-Commerce, Magento 2, Our extensions

magento 2 cms page hierarchy

Today, we are going to introduce you to the Magento 2 CMS page hierarchy feature. Although free and paid versions of our favorite e-commerce platform are very similar to some extent, the Commerce edition introduces multiple unique features. Below, we’d like to draw your attention to the Magento CSM page hierarchy. Below, we explore this functionality in more detail as well as shed light on how to import and export Magento 2 page hierarchy data.

In the introduction to Magento page hierarchy, we provide several examples of this content type as well as explain what the Magento 2 page hierarchy node system is. After that, you will discover how to configure page hierarchy in Magento 2 in general and how to add a node to your page hierarchy in particular. We illustrate the page hierarchy node creation process, elucidate the way you add pages to the node, define the page hierarchy structure, account for page hierarchy pagination controls, and explain the corresponding menu layout. After that, the article switches to the data transfer section, where we show how to import & export Magento 2 CMS page hierarchy data. Since this process incorporates the Improved Import & Export Magento 2 extension, you will also find its features defined.
Continue Reading

Magento 2 Product Position in Category: Import Guide

- E-Commerce, Magento 2

magento 2 product position in category

Today, we’d like to introduce you to the Magento 2 product positions in categories. You will learn what a product position in a category means and how to import this data to Magento 2.

When you use native Magento 2 import and export tools to transfer products to your e-commerce website, it is impossible to manage product positions inside categories, meaning you have to assign them manually, which proves to be a tedious task. However, there is a solution that addresses the existing issue. Meet the Improved Import and Export extension for Magento 2. It lets you import and export product positions using CSV, XML, XLSX, ODS, and JSON files.

In this article, you will learn how to import a product position in a category to Magento 2. We also describe the categories_position attribute, introducing you to its peculiarities. And of course, we unveil several interesting facts about the Improved Import & Export extension. But before going any further, let’s define what a Magento 2 product position in a category means.

Continue Reading

Guide to Magento 2 Search Terms & Search Synonyms: Management, Import & Export Recomendations

- E-Commerce, Magento 2, Our extensions

Magento 2 Search Terms & Search Synonyms

Today, we are going to explore two tightly connected topics – Magento 2 search terms and Magento 2 search synonyms. The platform lets you optimize customer search queries by composing lists of search terms and search synonyms. While it is possible to manage them manually in your admin, you cannot import Magento search terms. And there is no way to import search synonyms to Magento 2 with the help of the platform’s built-in instruments. This limitation may negatively impact the productivity of backend administrators since they need to spend a considerable amount of time updating Magento 2 search terms and synonyms instead of transferring the necessary data within a few clicks.

However, there is a tool that unlocks the missing functionality. Meet the Improved Import & Export extension. This module empowers you to import and export search terms and search synonyms to Magento 2. Below, we explain how to use the tool to transfer the corresponding entities to and from your e-commerce website. You will learn how import and export processes work and what attributes are involved in the import and export of search terms and search synonyms. But before going any further, let’s see what Magento 2 search terms and search synonyms are. 
Continue Reading