"Our extensions"

Magento Google Sheets Integration 2026: How to Sync Data via Import & Export Easily Between Google Sheets & Magento 2 Open Source or Adobe Commerce

- E-Commerce, Magento 2, Our extensions

Illustrative image for the Magento 2 google sheets integration guide with emojis, magento and google sheets logos, and text on orange background

Magento Google Sheets integration makes it possible to import and export data between the two platforms without complex manual steps. While in 2026 this feature isn’t available in the default Magento 2 administration, no matter whether you use Magento Open Source or Adobe Commerce, you can unlock it easily with the right third-party tools.

Meet the Improved Import & Export extension for Magento 2 — a powerful solution designed to transform how you handle data and connect Magento Open Source or Adobe Commerce to Google Sheets. With this module, you can connect your entire Magento catalog to Google Sheets, schedule automatic data synchronization, and eliminate repetitive manual tasks.

In this guide, we’ll walk you through the key features of the Improved Import & Export extension and explain how it simplifies Magento to Google Sheets data transfers. You’ll also find a link to our Master Import Table, where you can explore detailed descriptions of supported entities and attributes for Magento 2 Google Sheets import.

Finally, we’ll dive into practical use cases for connecting Magento to Google Sheets. You’ll discover how to import data from spreadsheets with multiple tabs, automate recurring updates, migrate configurable products, manage tier pricing, preserve category positions, copy existing product reviews to a new website, and much more. And, of course, we cover the following aspects of Magento export to Google Sheets:

  • Export Magento orders to Google Sheets
  • Magento product dynamic update to Google Sheets
  • Magento categories to Google Sheets
  • Magento customers to Google Sheets

Continue Reading

Magento 2 Excel Integration Guide 2026: How to Export Magento 2 Products to Excel and Import Back

- E-Commerce, Magento 2, Our extensions

Magento 2 Excel integration with the Improved Import & Export extension

Managing product data in Magento 2 often means working with spreadsheets — whether you’re adding new items, updating inventory, or preparing seasonal pricing changes. While Magento’s native tools can handle CSV files, many merchants still rely on Excel (XLS or XLSX) for day-to-day catalog work in 2026. This creates a challenge: Magento 2 doesn’t support direct Excel imports or exports by default, no matter whether you’re on Magento Open Source or Adobe Commerce. It means you’ll need to convert your files to CSV and adjust column formats before they’re ready for use.

If you’ve ever tried to export products from Magento to Excel or import them back again, you know the process isn’t exactly straightforward. Default functionality forces you into extra steps — from reformatting data to manually mapping attributes — and leaves no option for importing an Excel file directly into Magento 2.

That’s where a more efficient approach comes in. With the Improved Import & Export extension, you can connect Magento 2 Open Source and Adobe Commerce to Excel seamlessly, importing XLS/XLSX product data without conversion and exporting your catalog straight to Excel. This makes it easier to handle bulk updates, synchronize data with suppliers, and speed up catalog management without technical headaches.

In this guide, we’ll walk you through both the default Magento workflow and the improved method for working with Excel. You’ll learn about Magento 2 Excel product import, discover how to export products from Magento to Excel in just a few clicks, and find out other nuances of Magento Open Source and Adobe Commerce integration with Excel.

Continue Reading

How to Import JSON Files in 2026: Adobe Commerce & Magento 2 JSON Integration

- E-Commerce, Magento 2, Our extensions

Magento 2 JSON Import

The default Magento 2 data import capabilities are enough to satisfy only basic data transfer demands, but what if a more complex task must be solved? For instance, you need to import JSON files into Magento 2, while the system, both Adobe Commerce and Magento Open Source, 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 Magento 2 JSON integration.

Meet the Improved Import & Export extension. This module supports 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

Magento 2 URL Rewrites Guide: How to Import, Export & Manage SEO-Friendly URLs Like a Pro

- E-Commerce, Magento 2, Our extensions

illustrative image for the Magento 2 URL Rewrites Guide with emojis, magento logo, and text on orange background

Struggling to manage SEO-friendly URLs in Magento 2? That’s where the Magento 2 URL rewrites come into play. While both Magento Open Source and Adobe Commerce handle automatic URL generation for products, categories, and CMS pages, they fall short when it comes to importing or exporting those rewrites in bulk — a major roadblock during migrations or Magento SEO updates.

By default, Magento 2 doesn’t offer native tools to import or export URL rewrites, making tasks like moving a product catalog, updating the structure after a rebrand, or syncing data between environments time-consuming and error-prone. You’re left with manual editing or risky database changes — neither of which scale well.

That’s why we created this guide. Below, we explore how URL rewrites work in Magento 2, how the url_rewrite table is structured, and most importantly, how to import and export Magento 2 URL rewrites for both Adobe Commerce and Magento Open Source using the Improved Import & Export extension. Whether you’re migrating from Magento 1, syncing multiple store views, or cleaning up old redirect chains, the extension gives you full control over your URL rewrite data, directly from the admin panel.

You’ll also find a breakdown of the Magento 2 URL rewrite import table, complete with attribute descriptions and sample values to help you avoid common pitfalls. Let’s dive in and turn a frustrating manual process into a clean, automated workflow.
Continue Reading

Adobe Commerce B2B Features: Complete Magento 2 B2B Guide + Import & Export Tutorial for Magento 2 Companies, Requisition Lists, Shared Catalogs, and Quotes

- E-Commerce, Magento 2, Our extensions

Illustrative image for the Magento 2 B2B guide (MSI) with emojis, magento logo, and text on orange background

B2B e-commerce comes with a different set of requirements than traditional online retail. Businesses need to manage company accounts, customer-specific pricing, purchasing permissions, shared catalogs, quotes, and repeat orders — all within a single commerce environment. That is where Adobe Commerce B2B, often referred to as Magento B2B, becomes especially useful. Its native Magento 2 B2B features are designed to support complex buying relationships and give wholesalers, manufacturers, and enterprise merchants more control over how their customers purchase.

But managing B2B data can be challenging when your catalog, customer, ERP, CRM, or other business systems need to stay synchronized. Magento’s native data tools do not provide the same level of flexibility for importing and exporting B2B entities as they do for many standard store data types.

This is where the Improved Import & Export extension by Firebear adds value. It extends Magento’s data transfer capabilities with dedicated support for Magento 2 B2B entities, making it easier to exchange companies, shared catalogs, negotiable quotes, requisition lists, and other data with external systems.

In this guide, we break down the main Adobe Commerce B2B features, explain how Magento 2 B2B functionality works, and show how to import and export key B2B data efficiently.

Continue Reading

Magento 2 Shipping Tracking Guide: How to Import & Export Order Tracking Numbers

- E-Commerce, Magento 2, Our extensions

illustrative image for the Magento 2 Shipping Tracking Guide with emojis, magento logo, and text on orange background

Managing Magento shipping tracking is one of the most important parts of providing a smooth post-purchase experience. Customers expect real-time updates on their orders, and while Magento 2 makes it easy to display product details, handling Magento 2 order tracking numbers is far more complex. By default, the platform doesn’t allow you to import tracking data directly from external systems, making it difficult to automate integrations with shipping providers.

That’s where the Improved Import & Export extension changes the game. With it, you can seamlessly import and export tracking numbers in bulk, connect Magento 2 to carrier platforms, and keep order statuses updated automatically. This means no more manual data entry, fewer errors, and a faster order fulfillment process — all while enhancing Magento 2 shipment tracking for your customers.

In this guide, we’ll walk you through importing and exporting Magento order tracking information step by step. You’ll discover all the tracking-related features the extension offers, learn how to set up automation, and explore additional tools to keep your shipping operations running efficiently.

Continue Reading

Magento B2B Quote Guide for Adobe Commerce: How to Import, Export & Manage Negotiable Quotes in Magento 2

- E-Commerce, Magento 2, Our extensions

Illustrative image for the Magento B2B Quote guide with emojis, magento logo, and text on orange background

Managing Magento B2B quote data doesn’t have to be a manual nightmare. Whether you’re migrating to a new B2B store or integrating with a third-party platform, handling Magento 2 quotes can quickly become time-consuming, especially since the default Magento tools don’t support importing or exporting negotiable quotes. That’s where most store owners hit a wall.

But what if you could automate the entire process of transferring Magento B2B quotes with just a few clicks?

In this guide, we’ll walk you through the most efficient way to import and export Magento 2 B2B quotes, saving hours of manual work and ensuring data accuracy. We’ll start with what negotiable quotes are and how the quote workflow operates in Magento 2. Then, we’ll dive into how to structure your import files, streamline your export process, and unlock the full potential of Magento quote management.

Let’s simplify your Magento quote operations, starting now.

Continue Reading

Magento 2 B2B Requisition List Guide for Adobe Commerce: Management, Optimization, Import & Export Explained

- E-Commerce, Magento 2, Our extensions

Illustrative image for the Magento 2 B2B Requisition List Guide with emojis, magento logo, and text on orange background

Magento 2 B2B requisition list functionality is a game-changer for streamlining repeat orders and simplifying bulk purchasing in Adobe Commerce. In this guide, we’ll walk you through everything you need to know about requisition lists in Magento B2B: what they are, how they work, and, most importantly, how to import and export requisition list data efficiently in 2026.

Although the feature is exclusively available in Adobe Commerce with the B2B module, the platform’s native tools don’t support B2B entity transfers out of the box. That’s why we’ll show you how to use a powerful third-party extension to handle Magento 2 requisition list imports using properly structured CSV files. Below, you will discover a ready-to-use sample CSV and a detailed breakdown of all supported attributes to help you avoid errors and speed up implementation.

Whether you’re just getting started with Magento requisition lists or looking to automate the process, this article will guide you step by step — from setup to bulk data transfers.
Continue Reading

Magento 2 Store Credit: Complete Adobe Commerce & Open Source Guide + Import/Export

- E-Commerce, Magento 2, Our extensions

illustrative image for the "Magento 2 ІStore Credit Guide for Adobe Commerce" with emojis, text, and magento logo on orange background

Store credit in Magento 2 is a useful feature that gives merchants a flexible way to issue value to customers and let them use it toward future purchases. But there is an important distinction to make from the start: Magento 2 store credit is a native Adobe Commerce feature and is not available in Magento Open Source out of the box.

In this guide, we explain what Magento 2 store credit is and how it works. You will learn what it is and how to configure and use store credit in Adobe Commerce. We also clarify how you can add similar functionality as a Magento Open Source merchant. Another important aspect that this guide covers is Magento 2 store credit import and export, which is not supported by the platform’s default tools and requires an additional solution such as Improved Import & Export. But before going any further, let’s start with the basics. Continue Reading

Magento 2 Content Staging: What It Is, How It Works, and How to Import Content Staging Data in Adobe Commerce

- E-Commerce, Magento 2, Our extensions

illustrative image for the "Magento 2 Content Staging Guide for Adobe Commerce" with emojis, text, and magento logo on orange background

If you run a busy Magento store, making changes at the right time can be just as important as making the changes themselves. Magento 2 Content Staging helps solve this problem by letting you prepare updates in advance and schedule when they should go live. It can be useful for seasonal promotions, product updates, price changes, and other planned changes to the storefront.

But what is Content Staging, exactly, and how does it work in practice? In this guide, we take a closer look at Magento Content Staging, its key capabilities, and its role in managing scheduled updates in Adobe Commerce exclusively. We’ll also cover staging data import and export, including the options available when the default tools are not enough.

Continue Reading