"magento 2"

Magento Google Sheets Integration 2025: How to Sync Data via Import & Export Easily

July 7, 2025 - 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 this feature isn’t available in the default Magento 2 administration, 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. This module not only streamlines standard import and export processes but also delivers full Magento Google Sheets integration to your store. With it, you can connect your 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 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.

How to Import Customers & Customer Addresses to Magento 2: Complete Tutorial, CSV Samples & Tips

July 3, 2025 - Magento 2

Illustrative image for the Magento 2 customer import guide with emojis, magento logo, and text on orange background

Importing customers into Magento 2 is a critical step when migrating from another platform, syncing CRM data, or simply managing your customer base more efficiently. Whether you’re setting up a new store or updating existing records, knowing how to import customers to Magento 2 can save you hours of manual work and prevent costly data entry errors.

In this guide, we’ll walk you through everything you need to know about the Magento import of customers. You’ll learn how to use both the default Magento 2 import tool and advanced third-party solutions to streamline customer and address data uploads. We’ll also explain how to work with the three key entities: Customers Main File, Customer Addresses, and Customers and Addresses — each offering a different way to manage customer data imports.

To get started, we’ll show you how to prepare a valid Magento 2 customer import sample CSV, explain the structure of the required columns, and cover how to map attributes correctly. Whether you’re using the built-in Magento 2 functionality or looking to boost your workflow with the Firebear Improved Import & Export extension, this article has you covered.

Let’s dive into the step-by-step process of importing customers and their addresses into Magento 2, so you can get it right the first time.

Ultimate Magento B2B Tutorial: What Magento 2 Companies, Requisition Lists, Shared Catalogs, and Quotes Are, and How to Import, Export Them

July 2, 2025 - 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 is rapidly evolving, and Magento B2B (Adobe Commerce) stands out as a powerful solution for wholesalers, manufacturers, and enterprise-level merchants. With native Magento 2 B2B features like company accounts, shared catalogs, requisition lists, and negotiable quotes, businesses can streamline complex purchasing workflows and manage client-specific pricing with ease.

However, while Magento 2 B2B is feature-rich out of the box, its default import and export tools fall short when handling B2B-specific data. That’s where Firebear’s Improved Import & Export extension comes into play. It unlocks full support for Magento 2 B2B entities, enabling seamless data exchange between your store and external CRMs, ERPs, or marketplaces.

In this guide, you’ll explore how Magento 2 B2B works, how to import and export key B2B entities, and how to boost your operations with advanced automation tools tailored for B2B e-commerce in Magento 2.

Magento 2 Multi Source Inventory (MSI): Full Guide + Import & Export Explained

June 30, 2025 - E-Commerce, Magento 2

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

Magento 2 Multi Source Inventory (MSI) is a powerful feature introduced in Magento 2.3 that allows merchants to manage inventory across multiple physical locations natively within the platform. This Magento 2 MSI user guide walks you through the key functionalities of the multi-source inventory system, with a specific focus on how to import and export MSI data efficiently.

From the moment you install the Magento 2 MSI module, you gain access to flexible inventory tools that support complex warehouse setups, regional stock allocation, and streamlined product availability management. However, while Magento MSI significantly enhances default inventory management, it still falls short in areas like bulk data synchronization and automation.

That’s where third-party solutions come into play. Tools like the Improved Import & Export extension and its dedicated MSI add-on fill these gaps by enabling seamless MSI data transfers—saving time and reducing errors.

In this guide, you’ll discover what Magento 2 Multi Source Inventory is, how to configure it, and how to import and export all MSI entities, including stock sources or product quantities per source, with MSI CSV formatting rules. Whether you’re a merchant managing multiple warehouses or a developer optimizing backend operations, this Magento 2 MSI import/export guide has you covered.

Magento CMS Block Guide: How to Create, Import & Export Static Blocks in Magento 2

June 24, 2025 - E-Commerce, Magento 2, Our extensions

Illustrative image for the Magento 2 CMS Block Guide with emojis, magento logo, and text on orange background

Creating a standout storefront in Magento 2 often comes down to how well you manage your CMS blocks or static blocks that power everything from homepage banners to promotional widgets. These reusable content elements are the building blocks of engaging layouts and dynamic pages. Whether you’re customizing your homepage, setting up seasonal offers, or building with Magento Page Builder, Magento CMS blocks are key to delivering rich, branded experiences.

Yet, despite their critical role, Magento 2 doesn’t offer built-in tools for importing or exporting CMS elements like static blocks, pages, or widgets. That’s where the Improved Import & Export extension steps in, enabling seamless data transfers across stores and environments.

In this comprehensive guide, we explore what Magento 2 CMS blocks are, the difference between static and dynamic blocks, how to create and insert blocks, and how to import and export Magento 2 static blocks quickly and accurately. You’ll learn how to structure your import table, configure import jobs, and avoid common pitfalls. We’ll also walk through every CMS block attribute, share ready-to-use sample files, and explain how to move CMS content between Magento 2 installations with confidence. Whether you’re a developer, store admin, or agency partner, this tutorial will help you master Magento CMS block management like a pro.

Magento 2 Configurable Product Import: Complete Guide with Sample CSV

June 17, 2025 - E-Commerce, Magento 2

Illustrative image for the Magento 2 Configurable Product Import Guide with emojis, magento logo, and text on orange background

Importing a single product into Magento 2 is fairly straightforward using the built-in tools under System → Import. But when it comes to Magento 2 configurable product import, things get much more complex. Migrating configurable product data — especially when it includes multiple associated simple products and custom attributes — can quickly become overwhelming if you’re moving from an old Magento installation or another platform entirely.

The good news? With the right approach and correctly structured CSV files, importing configurable products into Magento 2 is not only possible but entirely manageable. In this guide, we’ll walk you through everything you need to know to import configurable products in Magento 2, including how to prepare your data, avoid common pitfalls, and speed up the process using the Improved Import & Export extension.

We’ll also provide a downloadable Magento 2 configurable products sample CSV, explain key differences from importing via the default solution, and highlight how to fix issues when variations don’t appear as expected. Whether you’re dealing with a catalog of 10 or 10,000 items, this tutorial is your starting point. Continue Reading

Magento 2 Export Customers Tutorial: Export Customer Data with Ease

June 10, 2025 - Import / Export Cookbook, Magento 2

Illustrative image for the Magento 2 export customers tutorial with emojis, magento logo, and text on orange background

Magento 2 export of customers is a core task for any store owner or administrator. Whether you’re migrating to another platform, syncing with external CRMs, or creating backups, the ability to export customers in Magento 2 efficiently and accurately is essential. Just like in the case of Magento’s customer import, the platform’s default export tools have limitations that can slow you down or lead to incomplete data. That’s why understanding your options — and knowing how to optimize them — is so important.

In this article, we’ll walk you through why exporting customer data matters, how to do it using the default Magento 2 tools, and how to take your exports to the next level with the Firebear Improved Import & Export extension. We’ll also compare native functionality with Firebear’s advanced features, so you can decide which Magento 2 customer export method works best for your store, whether you’re a technical user or a non-coder looking for simplicity and automation. Continue Reading

Magento 2 Swatch Image Guide: How to Create, Manage & Import Color Swatches

June 9, 2025 - E-Commerce, Magento 2

Magento 2 swatch image functionality is crucial in creating a visually engaging shopping experience, especially for configurable products. Whether you’re showcasing different colors, textures, or patterns, Magento 2 swatches allow you to present product variations in an intuitive, customer-friendly way. However, many merchants struggle with managing and importing these swatches effectively, which can lead to poor product presentation and missed sales opportunities.

In this guide, we’ll walk you through everything you need to know about Magento swatches — including how to create color swatches, configure swatch image sizes, retrieve swatch image URLs, and most importantly, how to import Magento 2 swatch images using a streamlined, automated process. You will learn how to prepare your CSV files, map the necessary attributes, and avoid common pitfalls that come with importing swatches.

By the end of this article, you’ll be able to manage and import Magento swatches like a pro, giving your storefront the visual polish it deserves.

Magento 2 Product Position in Category: Import, Export & Visual Sorting Explained

June 5, 2025 - E-Commerce, Magento 2

Illustrative image for the magento 2 product position in category guide with emojis, magento logo, and text on orange background

Today, we’d like to introduce you to the Magento 2 product positions in categories. You will learn what a product position in a category means and how to import this data to Magento 2. Unfortunately, the default Magento 2 import and export tools don’t offer a way to manage this information, forcing you to manually reorder items within each category, which can be time-consuming and error-prone, especially with large catalogs.

That’s where the Improved Import & Export extension steps in. It solves this limitation by letting you import and export product positions across categories using familiar file formats like CSV, XML, XLSX, ODS, and JSON. With just a few steps, you can automate visual merchandising tasks and keep your store’s product display in perfect order.

In this guide, you’ll learn exactly what product position in a Magento 2 category means, how the categories_position attribute works, and how to seamlessly import or export product sorting data. We’ll also highlight the advantages of using Firebear’s Improved Import & Export extension to make this process smooth, scalable, and fully customizable.

Let’s begin by exploring the concept of the Magento 2 product position in category and why it matters for your business.

Magento 2 Categories Import & Export Guide: CSV, Product Positions, Store View-Specific Names & More

June 4, 2025 - E-Commerce, Magento 2

Illustrative image for the magento 2 categories import & export guide with emojis, magento logo, and text on orange background

Managing your Magento 2 categories import and export process efficiently is crucial for keeping your product catalog organized and your store running smoothly. However, Magento 2 doesn’t support native category import and export features, making it difficult to transfer category trees, product positions, or store view-specific category names. That’s where the Improved Import & Export extension comes in — a powerful solution that unlocks the ability to import categories to Magento 2, export them with full attributes, and even manage product positions within each category.

In this article, we’ll walk you through everything you need to know about Magento 2 export of categories and the corresponding import workflows. You’ll learn how to transfer your entire category structure via CSV, configure advanced attributes, map data from external platforms, and streamline the import of product positions within categories. We’ll also show you how to manage category transfers per multiple store views — all with the help of a reliable automation tool. Whether you’re performing your first Magento import categories operation or looking to optimize bulk updates across stores, this guide has you covered. Let’s dive in.