"Magento 2 import"

The Complete Guide to Magento 2 Related Products, Up-sells, and Cross-sells, and how to import them

August 18, 2021 - E-Commerce, Magento 2, Our extensions

To sell effectively one must learn to predict and analyze. What are people looking for at my store? How can I make their search fruitful? At what point do the results become satisfying? Will it be enough to improve customer lives? The answers to the questions lie within everyone’s reach — run through some behavior statistics and create the most relevant offers for your audience. The related product, up-sell, and cross-sell functionalities are the very tools that will help you understand the customers’ needs.

You can consider related products, up-sells, and cross-sells a promo engine for your e-commerce website. Each relation type is distinguished following the display location and specific marketing goals. However, the core idea of being a purchase stimulus is similar for all the triplet items. In this guide, we will cover how to enrich your store content by using related content. You will learn how to use, import, and export Magento 2 related products, up-sells, and cross-sells. Since this publication is another one in the series of educational posts dedicated to Magento 2 import and export processes, you may be interested in the Magento 2 Import/Export Guide list that contains other similar guides.

As for the following article, it sheds light upon what Magento 2 related products, up-sell products, and cross-sell products are. We explain how to assign them to product pages as well as describe the corresponding import processes. Thus, you will learn what attributes are available in a CSV table, how to use the native Magento 2 import & export tools to transfer related products, up-sells, and cross-sells. And of course, there is a chapter that portrays a more user-friendly way to move them with the help of the Improved Import & Export extension.

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

August 11, 2021 - 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

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

August 10, 2021 - 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.

How to Import Magento 2 Advanced Pricing

August 3, 2021 - E-Commerce, Magento 2

Although setting up tier prices in Magento 2 is an exhausting task, you can dramatically simplify the related chores. But why is it so time-consuming? Setting up advanced pricing in Magento 2 requires going through the products one by one, submitting values in a dedicated window, and then saving. The more products you have, the more actions you need to apply. However, the Magento 2 import procedure lets you save hours of manual management time. In this article, we describe how to import advanced pricing to Magento 2. Below, you will find a sample advanced pricing import table described. Next, we provide advanced pricing attributes used in Magento 2. With this information in mind, you can proceed to importing Magento 2 tier prices.

Unfortunately, the default Magento 2 import tools only let you import products and advanced prices separately. It means that you need to upload one file with product data except for tier prices which are provided via another spreadsheet. You must admit that it is not very convenient, especially when you move the entire catalog.

To address this issue, we describe another procedure, involving the Improved Import and Export extension. With this tool, you can import both products and tier prices in a single file. Importing Magento 2 products with tier prices in a single file is based on the following steps. Firstly, prepare an import table, following our recommendations. After that, create a new import job as described in this blog post.

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

June 24, 2021 - E-Commerce, Magento 2

Magento 2 delivers several types of complex products. While configurable items are the first thing that comes to mind in this case, you may also leverage product bundles. Magento 2 bundle products are designed to provide customers with an additional creativity level and exceptional freedom. With this product type, they can create their own item sets from the available options. And while buying bundled products is intuitive and doesn’t differ much from other e-commerce purchases, managing them in the Magento 2 admin is a quite complex routine that needs additional elucidation.

In this guide, we show how to create bundle products and how to import such products to the Magento 2 catalog. The article guides you through the explanation of what bundle products are, focussing on various nuances of this product type. After that, the topic of the publication shifts to another vital aspect: we explain how to create bundle products in Magento 2. The last section of this blog post is dedicated to the bundle product import to Magento 2. It describes specific attributes associated with bundle products and sheds light upon other nuances of transferring items of this type to your e-commerce website. Also, we provide a separate chapter that describes how to import bundle products to Magento 2 from Google Sheets.

How to import Magento 2 product and custom attributes

June 4, 2021 - E-Commerce, Magento 2

In this article, we talk about how to import product attributes, attribute groups, and attribute sets to a Magento 2 store. Besides, we discuss how the attributes behave and which values Magento 2 understands in the import tables. The topic is extremely important since transferring products to Magento 2 is impossible without product attributes. They dictate which values the products have and which options and variations exist. That’s why having the ability to import product attributes is a must. Since Magento 2 doesn’t let you import product attributes by default, we use the Improved Import & Export extension to manage all the processes. Below, you will find how the module works when it comes to the Magento 2 product attribute import. We provide a table with product attributes, offer tips on importing attributes to your e-commerce website, and highlight several more important aspects.

How to solve Specified URL key already exists error during Magento 2 import

June 2, 2021 - E-Commerce, Magento 2

When creating or importing categories and products some may encounter Magento 2 error message ‘URL key for specified store already exists’. It may be the URL rewrites, database issue, or other things not considered.

Anyways, if there is an error there will also be a solution. In this article, we will talk about how to solve Magento 2 ‘URL key for specified store already exists’ error when importing products and categories to your store.

Below, we describe when the error occurs, exploring specific conditions that cause it. This article mentions three different cases that usually lead to ‘URL key for specified store already exists’. Next, we focus on the most frequent reason – duplicate URLs. You will find out how to get rid of duplicate URLs when importing data to Magento 2. The article provides separate examples for products and categories. After that, we put an emphasis on other features related to the Improved Import & Export extension – the solution that we use to address the ‘URL key for specified store already exists’ issue.

Magento 2 import and export guide list

May 26, 2021 - E-Commerce, Magento 2, Uncategorized

Since Magento 2 import and export are complex processes that require additional knowledge and skills, it is hard to cover all their nuances in a single article. Therefore, you can find dozens of materials dedicated to Magento 2 data transfers in our blog. To simplify your interactions with all these publications, we’ve gathered them in this guide list. Below, you will find articles related to Magento 2 import and export processes divided into the following groups: General import instructions, Magento 2 product import, Additional import entities, other articles. We describe the native data transfer solutions as well as shed light upon the core alternatives. You will find out how to automate import/export processes, transfer data from external systems, use Google Sheets and other platforms to move data files from, leverage APIs in import and export processes, etc. By default, Magento 2 offers quite scarce data transfer solutions, especially when it comes to the Open Source version. However, you can easily enhance the basic functionality. Read the corresponding materials listed below to discover the most reliable ways to get fully featured import/export instruments.

The complete guide to Magento 2 simple product customizable options (custom options)

March 1, 2021 - Magento 2, Our extensions

The guide is dedicated to the customizable options — the extra settings available for simple, downloadable, and virtual products in Magento 2 that enable the creation of product variations. Products with custom options resemble configurable products staying a unique system element at the same time. Throughout the text, we’ll discover the peculiarities of custom options, learn how to use them properly, and how to import them to your Magento 2 store.

Read Magento 2 Import and Export Guide List

The Improved Import / Export Magento 2 Extension by Firebear

February 20, 2020 - Magento 2, Our extensions

Below, you will see a brief description of our project aimed at improving the default Magento 2 import/export functionality. Although the basic processes are significantly refined now, they still lack some important features; therefore, we work on this Magento 2 extension with the aim to build a multi-purpose solution.

Improved Import extension for Magento 2 provides a possibility to transfer your CSV, XML, JSON, XLSX, ODS files with products data and product images to Magento 2 from a remote FTP server, Dropbox, Google Sheets, a direct URL of a source file, supports dedicated categories import, REST and SOAP APIs, on the fly import of product attribute values, import/export cron jobs, and many more features!

In the article below, you will find the extension’s shortened roadmap and brief description. We separately discuss the light version of the module and its entire stack as well as share use cases. Also, this blog post contains information on how to import data from Google Sheets, transfer categories to Magento 2, import product attributes, creating new attributes on the fly, etc. Other useful materials include Magento CLI import commands, import file samples, import fields mapping reference, etc. Continue Reading