"Magento 2 import"

How to import default attribute values for products via API in Magento 2

April 26, 2023 - Magento 2, Our extensions

Magento 2 Development; Magento 2 tutorial

Recently, we’ve discovered a discussion on Stack Exchange about Magento 2 API import. The author asks whether it is possible to import default attribute values for products via API in Magento 2. Although you cannot establish API transfers using the default import interface, the Improved Import & Export extension lets you obtain the desired functionality within a couple of clicks. Let’s explore the issue in more detail and then proceed to the solution. And don’t forget to follow our Magento 2 Cookbook for more information on how to run your e-commerce website smoothly. Continue Reading

How to Import JSON Files to Magento 2

March 28, 2023 - 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. 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

How to update product price during Magento 2 import

August 26, 2021 - E-Commerce, Magento 2

Magento 2 lets you specify a new product price upon import, but what if you want to update category prices by $10? Or what if your supplier raised all prices by 10%? With the default data transfer tools, you have to apply such adjustments manually to every product in your catalog. The more products you have, the more time you will spend. Therefore, nobody wants to calculate and apply each new price manually. In this article, we will tell you how to automate the process. You will need the Improved Import and Export extension. The module dramatically extends the default data transfer capabilities of Magento 2 and introduces the ability to update product prices during Magento 2 import via Price Rules – a set of conditions that adjust the price of the imported products.

How To Import/Export Categories to Magento 2

August 25, 2021 - E-Commerce, Fire development, Magento 2

Magento 2 Development

Below, you will find a brief description of how to import/export categories between two Magento 2 websites. Unfortunately, this functionality is not available by default. Magento 2 leaves you alone with a huge category tree. You need to recreate it manually or rely on third parties. And we know for sure how to import and export Magento 2 categories most efficiently. This post was inspired by the Magento StackExchange discussion. Question by Rafael Corrêa Gomes; answer by KAndy. However, it is only a partial overview of the Magento 2 category import and export. A full-featured guide on how to import and export categories, with all attributes explained can be found here: Read full-featured Magento 2 Category import and export guide. Continue Reading

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

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 Related Products, Upsell Products & Cross-Sell Products

February 21, 2021 - E-Commerce, Magento 2, Our extensions

Guide to magento 2 related products, magento 2 cross sell products, magento 2 upsell products

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?

The answers to the questions lie within everyone’s reach — run through some behavior statistics and create the most relevant offers for your audience. And your Magento website is ready to help. By default, it offers lots of marketing tools that can dramatically improve sales. Today, we are going to discuss Magento 2 related products. Of course, it is impossible to talk about them without entering the territory of Magento 2 upsell products. And to complete the picture, we also shed light on Magento 2 cross-sell products. These are the very tools that can help you follow your customers’ needs, providing them with extended offers.

In this guide, we explain how to enrich a customer experience by using related items. You will find out what Magento related products are. Next, we define Magento upsells. And, of course, you will learn what Magento cross-sell items are and what makes them unique in comparison to other relation types.

You will learn how to use all these marketing tools. We explain how to associate particular products with related products, upsells, and cross-sells in Magento 2. The article sheds light on assigning them to product and cart pages.

Next, we describe the corresponding import and export processes. You will learn what attributes to add to a CSV table to import Magento 2 related products, upsells, and cross-sells in a single file. We quickly go through the native Magento 2 import and then focus on the extended procedure that Involves the Improved Import & Export extension.

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

How to import and export updates within Magento 2. Consecutive Export

December 13, 2019 - E-Commerce, Magento 2, Our extensions

Saving time is a priority when we deal with database updates. The most beneficial solution in the situation is to find an adequate method and tool that will reduce the number of backend actions and prevent errors and duplication.

In this guide, we will explore which processes can be used within Magento 2 to add new data to the one previously transferred without running countless imports and exports or recreating a whole new database.

Magento 2 import XSLT transformation – how to import any XML to Magento 2

May 8, 2018 - E-Commerce, Magento 2

When working with the suppliers, you often come across custom XML table formatting. Such tables cannot be imported to Magento 2 without giving all product attributes particular names.

Same applies to the export. Your CRM system probably accepts a set format of XML files. So as other software you might be using.

That’s why we are introducing XSLT support for Improved Import and Export extension. To help you get the required XML formatting for any needs you might have.