"Magento 2 export"

Magento 2 Catalog Price Rules Explained: The Ultimate Guide to Management, Import & Automation

- E-Commerce, Magento 2

Illustrative image for the Magento 2 Catalog Price Rules guide with emojis, magento logo, and text on orange background

Magento 2 Catalog Price Rules are one of the most effective ways to run promotions and automate discounts across your store catalog. Whether you want to offer seasonal sales, bulk discounts, or customer group-specific pricing, Magento catalog price rules give you the flexibility to create dynamic campaigns that update prices automatically. Unlike cart price rules that apply at checkout, catalog price rules in Magento 2 display discounted prices right on product pages, making them a powerful tool for driving conversions.

While Magento 2 includes catalog price rules as a built-in feature, it comes with a significant limitation — there is no native way to import or export catalog price rules in bulk. This can quickly become a challenge for merchants managing large catalogs or migrating data between environments. In this guide, we’ll walk you step by step through what catalog price rules of Magento 2 are, how to create them, and, most importantly, how to easily import and export catalog price rules using the Improved Import and Export extension.

You’ll also find detailed instructions, a sample CSV table with required attributes and values, and practical tips to avoid common pitfalls. By the end, you’ll be ready to streamline your promotions and get the most out of Magento catalog price rules.

Continue Reading

The Most Advanced Magento 2 Configurable Product Setup Guide in 2025: From Definition & Creation to Optimization & Import

- E-Commerce, Magento 2

a gif image showing how a Magento 2 configurable product works on a product page: the selection of each new color swatch leads to the change of a product image

Magento 2 configurable products are essential building blocks for modern e-commerce stores, especially when you need to offer product variations like size, color, or material under a single parent product. Unlike simple products, configurable products provide a streamlined and user-friendly shopping experience while simplifying catalog management for store owners.

In this comprehensive guide, we’ll explain what a Magento 2 configurable product is, how it functions within your store, and why it’s a preferred option for merchants managing variant-rich inventories. You’ll learn how to create a configurable product in Magento 2 step by step, including key configuration settings, attribute setup, and product association.

We’ll also walk you through Magento 2 tier price configuration for configurable products, setting default options, and optimizing the frontend display. On top of that, we cover the crucial topic of importing configurable products into Magento 2 — both via built-in tools and using advanced solutions like Firebear’s Improved Import & Export extension for automated and flexible product data transfers.

Whether you’re launching your first configurable product or looking to optimize a large Magento 2 catalog, this guide has you covered with best practices, workarounds, and powerful automation tips.

Continue Reading

Complete Guide to Magento 2 Bundle Product with Price Setup, Customization, and Import Tips

- E-Commerce, Magento 2

Magento 2 bundle product frontend interface showcasing customizable product options and dynamic pricing

Magento 2 offers a rich set of product types to help store owners meet the diverse needs of modern shoppers. Among these, the Magento 2 bundle product stands out for its flexibility and customization. Unlike simple or configurable products, a bundle product allows customers to build their own product sets by selecting individual items from predefined options, creating a personalized shopping experience that boosts engagement and increases average order value.

But while bundle products are a powerful tool for front-end personalization, managing them on the back end can be surprisingly complex. From setting up dynamic pricing rules to handling custom options and ensuring a smooth import process, store admins often face a steep learning curve.

This complete guide dives deep into everything you need to know about Magento 2 bundle products — from understanding what they are and how they work, to step-by-step instructions on how to create bundle products in Magento 2, configure pricing, and even import them efficiently using the Improved Import & Export extension. Whether you’re building your first bundle or importing hundreds at once, we’ve got you covered — including advanced tips for working with custom options and dynamic prices.

Let’s break it all down and help you get the most out of Magento’s powerful bundling capabilities.

Continue Reading

How To Import/Export Categories to Magento 2

- 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 either need to recreate it manually or rely on third parties. So, welcome to our Magento 2 categories import tutorial. We know for sure how to import and export Magento 2 categories most efficiently.

The Magento StackExchange discussion inspired this post: 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: Magento 2 Categories Import Guide. 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 that Magento 2 doesn’t support and highlight the Magento Excel integration. 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. Of course, Magento’s export of products to Excel is also described below. 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

FireBear Improved Import & Export for Magento 2 – Extension Change Log

- Magento 2, Our extensions
improved import and export - Magento 2 extension

The following blog post will help you retrace the evolution of the Improved Import & Export Magento 2 module. The article gathers updates associated with the extension’s new version from the very beginning. At the time of 1.0.0, it was a basic import solution with an existing import jobs architecture and import cron automation. With the next few versions, the module got such enhancements as product attribute import on the fly, transfers from FTP, SFTP, URL, Dropbox, custom mapping, etc. Each new release made the Improved Import stronger and stronger. However, it was still an import-only tool until 1.5.0 was released. With this version, our extension became capable of both import and export processes. You can peruse the detailed evolution of the module and see its latest features below. 

Extension Manual | FAQ | Demo | Sample Files

3.8.7 (released 17.04.2024)

Features:

  • Magento 2.4.7. Support. The latest version of the extension supports Magento 2.4.7.
  • Customer Import. Support for separate street columns “_address_street_1”, “_address_street_2”, “_address_street_3”, “_address_street_4” when importing customer & addresses.
  • Improved Consecutive Export. Now, it is possible to export also last updated entities.
  • Export Mapping. The “salable_qty” column has been added to the export mapping section when exporting products with MSI data.
  • Order Export. A new event, “sales_order_save_commit_after,” to run order export jobs has been added.
  • Customer Import. A new customer import attribute has been added – “allowed_assistance.” It can enable/disable the Allow Remote Shopping Assistant feature.
  • Order History Import. Now order comments can be imported by the order’s “increment_id”. “status_history:entity_id” and “status_history:parent_id” are not required anymore.
  • Custom Options Price Import. It is now possible to import store-specific custom option prices.
  • Export Filters. Export filters support the following conditions: “=” “!=” “>” “<=” “contains” “not contains.”
  • Image Import. Additional logging has been added for deferred image import.
  • Performance. Customer import has improved memory consumption.
  • Data Storage. The DB’s “mapping” column type has been changed to “mediumblob” in the “firebear_import_jobs” table to allow the storage of more data.
  • Product Import. The ability to unassign products from the category has been added.
  •  Order Export. It is now possible to export order data in one line to XML and JSON formats.

Continue Reading

How to export Magento 2 data to Google Sheets

- E-Commerce, Magento 2, Our extensions

Transferring data between Magento 2 and Google Sheets seems a very efficient and time-saving way of synchronizing your e-commerce website with external platforms and other online storefronts. However, Magento 2 doesn’t let you do that if you rely on its default tools. If you need to import data, it is possible to create a CSV output of a corresponding Google Sheets table and then import it to your store. For the export purposes, you need to generate the output from your website and then open it in Google Sheets. Thus, instead of spending less time on daily duties, you have to perform a time-consuming routine. Luckily, there is a better way of synchronizing Magento 2 and Google Sheets.

FireBear keeps building up Improved Import and Export with powerful updates. Stay focused as with version 3.3.0 of the extension we introduce a long-awaited export of Magento 2 data to Google Sheets. The feature implementation marks the completion of the full-cycle Magento 2 and Google Sheets synchronization project. Now you are able to both import and export files from the source and arrange a highly manageable workflow.

How to do so? Follow this guide to learn more. Below, you will find an overview of the Magento 2 Google Sheets integration project as well as the most frequent use cases. Next, we describe Google API configuration, including such aspects as API library installation, API connection establishment, enabling Google Drive API, generating a Service Account Key, configuring a Service Account, and sharing the corresponding Google Drive folder. After that, we proceed to the Magento 2 Google Sheets export procedure. Continue Reading

Wyomind Mass Order Export for Magento 2 and 1

- E-Commerce, Magento 2, Magento tips & tricks

Wyomind Order Export Magento 2 Extension Review; Wyomind Order Export Magento Module Overview

Third-party tools can essentially simplify the default Magento order export management. We’ve already gathered the best import/export modules in the appropriate posts here: Magento import/export extensions; Magento 2 import/export extensions. Today, we’d like to draw your attention to the Order Export extension by Wyomind. Below, we will introduce you to the module’s features and backend functionality.   Continue Reading

The Improved Import / Export Magento 2 Extension by Firebear

- Magento 2, Our extensions

The Improved Import Export Magento 2 Extension by Firebear

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