Yearly Archives: 2021

Magento 2 Gift Card Extensions

- E-Commerce, Magento 2

Magento 2 Gift Card Modules

In the following post, you will find the best Magento 2 gift card extensions available in the ecosystem. Many vendors are offering this functionality in their modules. Below, you can check the most reliable tools. For each Magento gift certificates solution, we provide an overview of core features. For further information, check the full review or proceed right to the official extensions’ pages. Continue Reading

How to Import & Export Data Between Magento 2 & Google Drive

- E-Commerce, Magento 2, Our extensions

Magento 2 Google Drive Import Export

As long as we run this blog, more and more improvements to the default functionality of the Magento platform will be revealed. And today, we are going to describe how to enhance the standard import and export processes with the ability to synchronize your e-commerce website with any partners using Google Drive. Since everyone has access to the popular file storage, this improvement will be handy. The following article sheds light on how to import and export entities between Magento 2 and Google Drive. Of course, the enhancement is impossible if you use the default Magento 2 tools, but it is not an unsolvable problem. And below, we show how to synchronize and automate data exchanges on the basis of Google Drive.

In the following article, you will find a brief overview of the Magento 2 Google Drive integration. After that, we shed light on the general facts related to transferring data between our favorite e-commerce platform and the popular file storage. You will learn how to choose a proper import and export solution for your Magento 2 Google Drive data synchronization

Next, we proceed to the core steps of the integration preparation. You will discover how to install Google API libraries and get Google Drive API credentials. After that, the article focuses on establishing a connection between Magento 2 and Google Drive. We describe how to configure a Service Account and share a Google Drive folder. The next chapters are dedicated to the configuration of import and export jobs for Magento 2 and Google Sheets integration and exploring use cases. Since the integration incorporates Improved Import & Export, you will also find its features described below.

Continue Reading

MageWorx Gift Cards Extension for Magento 2 and 1

MageWorx Magento 2 Gift Card Extension

Offering gift cards on an online store is a great marketing solution that helps increase customer engagement and promote an ecommerce brand. Allowing online shoppers to buy and use gift cards and certificates will certainly generate extra profits, particularly during the holiday season.

With the help of the MageWorx Gift Cards Extension, you can make the gift-giving process more comfortable by introducing the ability to purchase gift cards right on your ecommerce website. The extension supports physical and online gift card types (we will describe them below), provides flexible pricing schemes & values, and offers full backend control. You can create an optimized and user-friendly gift-giving process on your Magento store by providing a wide choice of gift cards and pricing options.

The whole section of this post is dedicated to the module’s admin interface and sheds light on Magento 2 gift card configuration, but let’s have a look at the tool’s features first.

Continue Reading

How to Import Excel (XLS & XLSX) and OpenOffice (ODS) Files to Magento 2

- E-Commerce, Magento 2, Our extensions

Magento 2 Excel import export

We’ve already described hundreds of data import cases related to Magento 2 and many more are left to be mentioned in our blog. This time, we return to the topic of importing file standards the Magento 2 doesn’t support. Unfortunately, the system works with CSV files only and it is not the only requirement you should follow to be able to transfer an update to your database. You also have to edit third-party data and columns to make the file suitable, but let’s return to the unsupported formats.   

If you have an Excel (XLS or XLSX) or ODS file with data that should be imported to Magento 2, you’ve come to the right place. Although Magento 2 doesn’t let you do that by default, there is a reliable alternative solution at your service. Meet the Improved Import & Export extension – a tool that offers the most user-friendly way of Magento 2 Excel and ODS files import.

In the following article, we shed light on what to do with XLSX, XLS, and ODS files if you want to move them to Magento 2 via the default data transfer tools. After that, you will find a guide on how to import Excel and ODS files to Magento 2 in a way more user-friendly manner. Continue Reading

How to import XML to Magento 2

- Fire development, Magento 2

Magento 2 Development; Magento 2 tutorial

We all know that Magento 2 supports CSV import/export by default, but what if you need to transfer data via XML files? Although the default Magento 2 data import capabilities are enough for satisfying only basic data transfer demands, there is an opportunity to achieve the goal mentioned above. 

Since the system supports only the CSV standard, you need to convert your XML files to the supported file type. If you don’t want to do that, meet the Improved Import & Export Magento 2 extension. This module offers a more user-friendly solution for importing XML to Magento 2. With its help, you can move all the necessary information to your e-commerce store without converting it to CSV.

In the article below, we provide the description of how to import XML files using the default Magento 2 tools. Besides, you will find a step-by-step guide to Magento 2 XML import and export. More useful tips for Magento 2 users are gathered in our Magento 2 Developer’s Cookbook.
Continue Reading

How To Import Customer Passwords To Magento 2

Magento 2 import customer passwords

What if you need to transfer customer data to Magento 2? You can use the default import tool to do that. However, it doesn’t let you move all the prospect-related information to your database. For instance, it is impossible to migrate customer passwords from external systems. Attempts to address this problem have been made utilizing numerous approaches. Below, we describe two of them. 

You will find out how to import passwords to Magento 2 from external systems by manually editing your data files. Alternatively, we describe how to import the existing customer data including passwords to your e-commerce website on the basis of the Improved Import & Export extension

The problem is that the new platform version utilizes an updated algorithm for storing passwords. Hence, users claim that after migrating to Magento 2 from Magento 1, registered prospects have to re-enter their passwords on a new website. 

Continue Reading

How to import data from SAP ASE (Sybase) database to Magento 2

Magento 2 SAP ASE Sybase Data Import

What if a vital data update is stored within the SAP Adaptive Server database but you need to transfer it to your Magento 2 website? The default tools built into your e-commerce store are useless if you need to create a direct connection. The same is about most third-party tools. So, how to move the crucial information to your e-commerce store most efficiently? Below, you will find the answer. We describe a common way of importing SAP ASE bases into Magento 2 and then compare it with a more user-friendly approach.

The common way of moving SAP ASE tables into Magento 2 is a complex procedure that consists of several steps. First of all, you need to perform a CSV export from the Sybase SQL server. We describe this process in the dedicated step-by-step guide below. Next, you need to map third-party attributes to Magento 2 records. After that, it is possible to import an SAP ASE table into Magento 2. You will find the pros and cons of this approach below.

As for the easy way of moving Sybase SQL server bases into Magento 2, it is way more straightforward since it involves Improved Import & Export. You provide the connection parameters and configure other aspects of your data transfer. That’s it! Let’s explore each step of both procedures in more detail and compare two approaches side by side.
Continue Reading

How to fix the “URL key for specified store already exists” issue on Magento 2 import

- E-Commerce, Magento 2

Magento 2 export CLI

Let’s suppose that you need to import a product CSV file, that follows the Magento 2 requirements, to a new installation. What could go wrong? Unfortunately, several errors may occur when you do that, including “URL key for specified store already exists”. In the following article, we explore the issue on the example provided in a StackExchange discussion, where Zed Blackbeard argues that it is impossible to import products to Magento 2 due to the general system exception. Magento informs its administrator who runs the update that the URL key for the specified store already exists. After that, the system breaks the import

Below, you will discover the conditions that cause the problem. After that, the article provides several possible resolutions. To be more specific, we provide recommendations from the appropriate StackExchange discussion as well as deliver our approach that incorporates the Improved Import & Export extension. If you face other issues while using your Magento installation, you may try to find them described in this blog post: Magento 2 Cookbook.
Continue Reading

How to export a custom entity from Magento 2

- E-Commerce, Magento 2

Magento 2 export CLI

Let’s assume that you’ve created a custom entity in your Magento 2 backend. However, you cannot either import or export it using the default tools of your website. Furthermore, the built-in import and export solutions don’t let you transfer most default entities Magento 2 relies upon. So, is there any way to enable synchronization with third-party platforms and partners that ask for your newly-created custom record? 

As you’ve probably guessed already, you need a third-party import and export solution to import and export a custom entity in Magento 2. A reliable module lets you export a custom entity from Magento 2 as you do with products, orders, and other records. At the same time, you may try to implement one of the community-proposed solutions. But what way to choose? 

In the following article, we detailly describe a StackExchange discussion and the related data transfer case. Its author complains that it is impossible to export a custom entity from Magento 2. People in the thread propose different resolutions described below. Since they are aimed at tech-savvy users, most Magento merchants are not able to address the existing issue following these recommendations. However, the Firebear team provides a more user-friendly way to cover the existing gap between business needs and the default functionality of Magento 2. We explain how to export a custom entity from Magento 2 with the help of the Improved Import & Export extension. For more useful tips on import and export, follow this link: Magento 2 Cookbook.
Continue Reading

How to Import & Export Newsletter Subscribers in Magento 2

Let’s suppose that you run an online business with lots of newsletter subscribers but want to move them to a brand new Magento 2 website. Although Magento 2 doesn’t let you do that with the help of its default import and export tools, there is a solution that enables the desired functionality. Meet the Improved Import & Export extension. With its help, you will freely import and export newsletter subscribers in Magento 2.

In the following article, we focus on how to manage newsletter subscribers in Magento 2. You will also discover the conditions you should create prior to importing subscriber data to your e-commerce website. Besides, we explain how to create a table with attributes repeated to newsletter subscribers. And of course, there is a guide on how to move newsletter subscribers from Magento 1 to Magento 2. If you are going to migrate from your old e-commerce website to a brand new one, you’ve come to the right place. The general details about Magento 2 newsletter subscribers’ import and export are also gathered below.
Continue Reading