Improved Import & Export major update - full Google Sheets & Drive integration. Fixed price Magento 1 > Magento 2 migration service! EXPLORE

Monthly Archives: August 2021

Exploring Shopware: Sitemap in Shopware 6 Settings

- Uncategorized

By default, Shopware generates a standard sitemap, compresses it, and then caches it in the file system. Furthermore, your e-commerce website offers advanced support for shops with many products and categories when it comes to the sitemap. Shopware splits the corresponding file into several parts and lets you generate them in the background. Although there is no way to create a visitor sitemap, the index file is generated for SEO purposes. In the article below, we describe how to find Sitemap settings in Shopware 6. After that, you will discover several ways of managing your Shopware 6 sitemap. For more tech-savvy users, we provide a brief description of how to add custom sitemap entries in Shopware 6. 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

How to Import Custom CSV to Custom Table in Magento 2

Magento 2 import export debug log

Recently, we were surfing on the endless StackExchange surfaces and stumbled across an exciting topic that wasn’t highlighted in our Cookbook. The problem was easy to understand. Its probability for an average e-commerce business seemed to be high.  Therefore, we’ve decided to narrate it in our blog, adding several more vital facts. So, what is the issue we are going to discuss?

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 a custom table in Magento 2 with the minimum headache. Below, we provide the original answer as well as our alternative solution. Since the latter is based on the Improved Import & Export extension, we also share its core features after discussing the corresponding resolution.
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

Magento 2 Release Notes

- Magento 2

Release Notes Magento 2

In the following post, we will gather all Magento 2 release notes starting from 1.0.0-beta. Since every release includes a plethora of improvements and changes, we’ve divided them into several subcategories, such as performance, payment methods, checkout, CMS, etc. These are the latest Magento 2 Release notes from the official repo. 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

The Complete Guide to Magento 2 Grouped Products, and how to import them

- E-Commerce, Magento 2

Magento 2 grouped products are one of the three complex product types represented in Magento 2. Why do we call them complex, you will ask? Because a group of products, that is often called a parent product, consists of several simple products, that are called child products. Thus, you get an unusual structure with its own rules and laws that are quite hard to manage. 

In the article below, we will show you what Magento 2 grouped products are and how they work. Besides, there is a small guide to creating grouped products in Magento 2. In addition to that, you will find out how to import grouped products to Magento 2. We will explore a corresponding import table with the required columns. Besides, you will learn how to remove product associations. At the end of this blog post, there is an FAQ section with other general facts about Magento 2 grouped product import.

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

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. Therefore, you need to convert your JSON files to the supported file type in order 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 Magento 2 extension. This module supports JSON data import so that you can move all the necessary information to your e-commerce store without comforting it to 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, there is a step-by-step guide to importing JSON data to Magento 2. And if you are not familiar with the JSON format, you will find its brief description below. Continue Reading