"E-Commerce"

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 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 JSON Files to Magento 2

- E-Commerce, Magento 2, Our extensions

Magento 2 JSON Import

The default Magento 2 data import capabilities are enough for satisfying only basic data transfer demands, but what if a more complex task must be solved? For instance, you need to import JSON files to Magento 2, while the system supports only the CSV standard. You need to convert your JSON files to the supported file type to move them to your e-commerce website. Luckily, there is a more user-friendly solution for importing JSON to Magento 2.

Meet the Improved Import & Export extension. This module supports the Magento 2 JSON import so that you can move all the necessary information to your e-commerce store without turning it into CSV. You can effortlessly move data in this format in both directions: to and from your Magento 2 website.

In this article, we discuss JSON file requirements for importing data to Magento 2 and provide a list of supported entities (you can transfer all core entities now). Besides, you will find a step-by-step guide that describes how to import JSON data to Magento 2. If you are unfamiliar with the JSON format, its brief description is below. 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

Ultimate Guide To Shopware 6 Import

- E-Commerce, Shopware

Welcome to the world of Shopware import! Like every e-commerce system, Shopware 6 provides the ability to import and export information between your website and external data sources. This functionality simplifies content management chores, such as data updates or product translations. Besides, the Shopware 6 import lets you easily move products to product comparison engines and marketplaces. In this Shopware import guide, we generally describe the available options, reviewing the basic import plugin of Shopware 6 along with its profiles. You will learn how to import data to Shopware 6 and what entities are supported. Also, check our Ultimate Guide To Shopware 6 Export. Continue Reading

Magento 2 Google Sheets Integration Guide

- E-Commerce, Magento 2, Our extensions

Magento Google Sheets Integration

Have you ever known that importing data to Magento 2 from Google Sheets is possible? It is not a joke, and we will explore the Magento Google Sheets integration below.

Although you will never find the corresponding option in your Magento 2 administration, a robust third-party Magento 2 importer can do the job. The default import and export tools of your e-commerce website are scarce. You can perform only several basic data transfers with them. Therefore, it is necessary to leverage a third-party extension that replaces the default import and export functionality. So meet the Improved Import & Export module for Magento 2. This tool dramatically enhances the basic features associated with moving tables to and from your website. And, of course, it delivers the Magento 2 Google Sheets integration to the platform. 

In the following article, we shed light on the basic features of the Improved Import & Export extension that can help you with the Magento 2 Google Sheets integration. After that, you will find a link to our Master Import Table for the Magento 2 Google Sheets import along with detailed descriptions.

With this information, we proceed to the use cases associated with the Magento 2 Google Sheets import. You will learn to import data from a spreadsheet with multiple tabs, automate the corresponding transfers, move configurable products to your store, work with tier prices, save category positions, copy the existing reviews to your new website, etc. 

Continue Reading

Magento 2 Page Builder Import & Export

- E-Commerce, Magento 2, Our extensions

Magento 2 Page Builder Data Import Export

In the following article, we shed light on Magento 2 Page Builder. You will learn its core features. After that, we will focus on the Magento 2 Page Builder import and export. Since you cannot transfer anything to/from the tool via the platform’s default instruments, it is necessary to install a third-party extension. Below, we explore the most intuitive and easy-to-use solution aimed at recreating the missing functionality. Meet the Improved Import & Export extension. With its help, you can most efficiently import and export the data associated with Page Builder in Magento 2.

The blog post below unveils the most important facts about Magento Page Builder. You will learn about its drag-and-drop functionality, grid system, visual effects, flexible integrations, products, instant previews, schedules, etc. Besides, there is a technical introduction to the tool and a brief description of Bluefoot CMS as the foundation of the Page Builder in Magento. After that, the article switches to its key part – you will learn how to import and export data to/from Magento 2 Page Builder. Since the process incorporates the Improved Import & Export extension, you will also find its features described below.
Continue Reading

How to Import Custom CSV to Magento 2 Programmatically

- E-Commerce, Fire development, Magento 2

magento 2 import custom csv programmatically

Let’s discuss the Magento 2 import of custom CSV files. Recently, we’ve been surfing across endless StackExchange discussions and stumbled upon an exciting topic that wasn’t highlighted in our Cookbook. The problem was easy to understand: there was a custom CSV and a user had to import it to Magento 2. The probability of a similar situation for an average e-commerce business is quite high.  Therefore, we’ve decided to narrate it in our blog, adding several more vital facts. So, what is the issue?

Bilal Usean asked the community how to import a custom CSV file to a custom table in Magento 2. Although forum members provided several ways to achieve this goal, we didn’t find any user-friendly solution aimed at people with less technical skills than required by the most rated answer. Variants discussed on StackExchange seem to be highly efficient but too complicated. However, there is one more way to import a custom CSV file to Magento 2 with the minimum headache. Below, we provide the original answer as well as our alternative solution. You will also learn how to import a custom CSV to Magento 2 programmatically. Since some of the provided solutions incorporate the Improved Import & Export extension, we also share its core features after discussing the initial resolution.
Continue Reading