"magento 2"

How to Apply Filters to Magento 2 Import and Export

- E-Commerce, Magento 2, Our extensions

magento 2 filter: Export

Imagine a situation when there is a massive data file with thousands of SKUs, but you need to import items with a price lower than $100 or products from a specific category. Or let’s assume that you need to create an export file that contains products that are enabled, have a price higher than 0, are in stock, and are visible in Catalog and Search or just in Catalog. How to do that? You need to apply filters to Magento 2 import and export or create import and export conditions. The following Magento filter guide sheds light on various details of both processes.

It’s not a secret the functionality of Magento 2 has lots of limitations. Of course, the platform offers much broader opportunities in comparison to its predecessor, but there is still room for improvement, especially in the area of data filtering. Thus, you can neither apply Magento 2 import and export filters nor create import/export conditions to narrow down the output or transfer only the necessary information into the system. However, it is not all that bad.

We firmly believe that Magento wouldn’t be cool without its community and a vast ecosystem of third-party extensions. Both factors provide a positive impact on the platform dramatically extending its borders concerning productivity and functionality. As you might have already guessed, the ability to apply Magento 2 import/export filters and create import/export conditions is entirely based on a third-party solution, so meet the Improved Import & Export Magento 2 extension.

The module provides the ability to create highly configurable and flexible import and export profiles (jobs), where you can specify the most precise conditions regarding each process. Thus, even the most demanding business requirements are satisfied. Let’s take a look at filtering opportunities offered by the Improved Import & Export Magento 2 extension and then proceed to other features. Continue Reading

How to Run Product Import on Daily Basis in Magento 2

- E-Commerce, Magento 2

Magento 2 Development

Welcome to our Magento 2 scheduled import guide. Below, we shed light on how to run Magento 2 import processes daily and automatically following a schedule. You can do that either in your admin interface or via CLI. While Magento 2 Open Source doesn’t let you automate data transfer processes and there is no way to use CLI to control imports and exports, you can enable the missing functionality with the help of third-party solutions. In the article below, we explain how to run scheduled imports in Magento 2 and use CLI to control them with the help of Improved Import & Export.

Also, we look for an alternative point of view on Magento StackExchange in the question by Massimo Camoni and the answer by Khoa TruongDinh. Since we leverage the advanced import functionality of the Improved Import & Export extension to address the issues mentioned in the discussion, you will also find a section that describes other possibilities the module provides.

So, how do we run product import in Magento 2 daily and automatically? And how do we use CLI in this process? The question has two answers since everything depends on your platform version. As we all know, the difference between Magento 2 Open Source and Adobe Commerce is huge, therefore, the same goals on both platforms can be achieved in a slightly different manner. Let’s see. Continue Reading

Magento 2 Backend Exploration: Invoices

- E-Commerce, Magento 2

Magento 2 invoices generate import export

This Magento invoice guide provides a detailed description of the Invoices screen situated in the depths of the Magento 2 admin. We shed light on how to work with the corresponding grid and individual invoice pages. Besides, you will discover how to import and export invoices in Magento 2 most efficiently. 

The Magento 2 Invoices Screen chapter unveils various control elements associated with the corresponding admin page and describes the default Magento 2 Invoices grid. After that, we proceed to an individual invoice view associated with Magento 2. You will also learn how to create Magento 2 invoices, invoice orders, and print invoices. Besides, the article sheds light on the Magento 2 invoice import and export with the help of the Improved Import & Export extension.
Continue Reading

How To Fix Invalid Option Value Magento 2 Import Error

- E-Commerce, Magento 2, Our extensions

Magento 2 Development; Magento 2 tutorial

Below, we explore another common problem that prevents Magento 2 import processes. No matter whether you’ve faced the Invalid Option Value Error or not, it may occur when you import a Magento 2 configurable product with many options. Below, we study two cases and provide several resolutions to the issue.

Firstly, we explain a situation when it is impossible to save changes in a configurable product due to its custom options.

Secondly, you will peruse a case when a user cannot import a configurable product from a CSV file.

After that, the article sheds light on a time-consuming resolution provided in a StackExchange discussion. Since we also know how to address the issue, you will find several tips on how to manage configurable products with numerous custom options. Besides, we describe an enhanced import procedure that incorporates the Improved Import & Export Magento 2 extension.
Continue Reading

Magento Shipping Tracking: How to Import Shipping Tracking Numbers to Magento 2

- E-Commerce, Magento 2, Our extensions

Magento 2 Tracking Number Import

Today, we are going to discuss the Magento shipping tracking. It is essential to provide customers with all the information about the goods and services you sell. While displaying all product details is an obvious and easy-to-implement task, managing Magento 2 tracking numbers is way more sophisticated. For instance, your e-commerce website doesn’t let you transfer them from an external system. Consequently, you cannot automate the integration between Magento 2 and shipping providers. However, there is a tool that addresses the existing issues and enables seamless synchronization of your e-commerce website and third-party platforms.

In the following post, we shed light on how to import shipping tracking numbers to Magento 2 with the Improved Import & Export extension. This reliable solution enables rich import functionality, provides robust export capabilities, and offers tons of other features that dramatically enhance your daily routine, including Magento 2 shipment tracking. Let’s figure out how to seamlessly import shipping information to Magento 2.

Below, you will learn about Magento 2 tracking number import. We provide a list of all features that Improved Import & Export delivers in this dimension. After that, you will figure out how to import and export Magento 2 tracking/shipping codes. The last chapter of this article described other features associated with our extension. Continue Reading

Magento 2 Import: Field Separator & Multiple Value Separator

- E-Commerce, Magento 2, Our extensions

Magento 2 Import Field Separator Multiple Value Separator

From the very beginning of our history, data transfers with all their aspects and related processes have been the main focus of our company. We’ve explored lots of topics that describe Magento 2 import and export. Along with that, we’ve expanded our interest to other areas of Magento 2 and went far beyond the ecosystem. However, in the following article,  you will find several basic nuances of moving information to your e-commerce website.

Below, we continue exploring Magento 2 import and export processes and explain their two components: field separator and multiple-value separator. What is the purpose of both? What separator types are supported? Are there any alternatives? You will find the answers below.

The following blog post touches upon the topic of different separator types that you can use in Magento 2. After that, we proceed to a guide on how to configure a multiple-value separator in Magento 2. Also, you will find out what to do with field separators in your data files. Various multiple value separator and field separator improvements associated with the Improved Import & Export extension are also mentioned in the article below.
Continue Reading

Magento CLI Commands: How to Run Product Import in Magento 2 from CLI

- Fire development, Magento 2

Magento 2 Development; Magento 2 tutorial

Welcome to our guide to Magento CLI commands. If you want to optimize your daily routine related to Magento 2 product import, you’ve come to the right place. Below, we shed light on several data transfer optimizations that will help you save tons of time spent on daily chores. Many merchants look for tips on importing products to Magento 2 using the command line interface. Below, you will find the easiest way to do so.

The following article is based on the StackExchange question by Massimo Camoni and the answer by Khoa TruongDinh. However, it extends the solution provided in the discussion. So, let’s see how to run Magento 2 product import via CLI. You will find the Magento 2 CLI commands list for importing and exporting products and other entities on your e-commerce website.
Continue Reading

Magento 2 GraphQL Tutorial: How to Import Data via GraphQL API into Magento 2

- E-Commerce, Magento 2, Our extensions

Magento 2 graphql import export

The following Magento 2 GraphQL tutorial describes how to import and export data into/from Magento 2 with the help of GraphQL API. This connection type is yet impossible out of the box, but the community is working hard to introduce it as a replacement for REST API. At the same time, some tools enable Magento 2 GraphQL API import and export right now. For instance, you can leverage the Magento 2 GraphQL 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 GraphQL API with the help of our extension. You will find out how to enable the Magento 2 GraphQL API import and what extra benefits it is associated with. If you are not familiar with what GraphQL API is, we’ve also prepared a chapter that describes this standard and its benefits over REST and SOAP. Besides, an FAQ section provides answers to frequently asked questions about GraphQL Magento 2 import and export processes.
Continue Reading

How to Import Multiselect Attribute Values to Magento 2

- E-Commerce, Fire development, Magento 2

Magento 2 import export debug log

In the following article, we explain how to get multiselect attribute values in Magento 2 via import and export processes. But how it it possible if the default data transfer tools don’t offer the desired functionality?

The default data transfer capabilities of Magento 2 still need various improvements, especially if you use the Open Source version of the platform. However, numerous community-based initiatives that tend to improve the basic functionality are at your service. They vary between coding tricks and standalone extensions. Depending on the complexity of your business, your technical skills, or the faced issues, you can select one that perfectly suits your needs. What to do if you cannot find the solutions? Ask the community for support. 

Recently, we came across an interesting issue on Stackexchange. The author was wondering whether it was possible to create values for a multiselect attribute when uploading a CSV file. Below, we share two solutions: the community-based algorithm for addressing the problem and the Firebear-proposed tool. While the first one requires additional coding experience and is almost unreal to implement for non-technical users, the extension we offer is admin-friendly and intuitive so that anyone can use it to cope with the difficulties described below. 

To make a long story short, let’s explore the issue and describe how Magento lets you get product multiselect attribute values. More tips are available here: Magento 2 Cookbook.
Continue Reading

How to import data from external MySQL database to Magento 2

- E-Commerce, Magento 2, Our extensions

magento mysql direct update table

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. 

Welcome to our MySQL Magento guide. In the following post, we shed light on how to export and import database tables between MySQL and Magento 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 performing a Magento MySQL direct update of tables. 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