"Our extensions"

How to Import Product Reviews in Magento 2 and Assign Them to Parent Configurable or Bundle Products

- Magento 2, Our extensions

illustrative image for the How to Import Product Reviews in Magento 2 and assign them to parent configurable or bundle products Guide with emojis, magento logo, and text on orange background

Magento 2 import of product reviews is a crucial task for any store that wants to boost trust, improve SEO, and display authentic customer feedback. While Magento natively supports reviews, it doesn’t provide built-in tools to manage them in bulk or associate feedback from child products with their parent configurable or bundle items.

With the Improved Import & Export extension, however, you can easily import product reviews to Magento 2, connect child reviews to parent products, and even automate the entire process. In this guide, we’ll walk you through how to import reviews in Magento 2, link child feedback with parent products, and explain why our import reviews extension for Magento 2 is the most efficient solution. For more developer insights, check out our Magento 2 Developer’s Cookbook.
Continue Reading

Improved Import / Export Magento 2 Extension Manual

- Magento 2, Our extensions

In this article, we take a closer look at the Improved Import & Export Magento 2 extension, covering everything you need to know about using it for data transfers in Magento 2 (both Adobe Commerce and Magento Open Source). You’ll learn how to install and configure the extension, create import and export jobs, and transfer data for different Magento entities. We also cover CLI data transfers, process automation, extension customization endpoints, and troubleshooting, along with practical use cases and specific features that can help you get more from the extension.

Improved Import & Export lets you import and export CSV, XML, and JSON files containing product data and product images in Magento 2. You can import files from a remote FTP/SFTP server, Dropbox, a direct URL to a source CSV file, Google Sheets, and other sources. The extension also supports dedicated category imports from CSV files, importing attribute values and creating new attributes on the fly, scheduling import jobs with cron, and more.

On the export side, Improved Import & Export provides advanced options for transferring Magento data, including order exports and configurable export jobs with attribute and database table field mapping. Continue Reading

Magento 2 GraphQL Tutorial: How to Import Data via GraphQL API into Magento 2 Open Source & Adobe Commerce

- E-Commerce, Magento 2, Our extensions

Magento 2 graphql import export

The following Magento 2 GraphQL tutorial describes how to import and export data into/from Magento 2 Open Source and Adobe Commerce with the help of the GraphQL API in 2026. This connection type is yet impossible out of the box, but the community is working hard to introduce it as a replacement for the REST API. At the same time, some tools enable Magento 2 GraphQL API import and export right now. For instance, you can leverage the Magento 2 GraphQL API import and export processes with the Improved Import & Export Magento 2 module.

The following article sheds light on how to import data into Magento 2 via the GraphQL API with the help of our extension. You will find out how to enable the Magento 2 GraphQL API import and what extra benefits it is associated with. If you are not familiar with what the GraphQL API is, we’ve also prepared a chapter that describes this standard and its benefits over REST and SOAP. Besides, an FAQ section provides answers to frequently asked questions about GraphQL Magento 2 import and export processes.
Continue Reading

Magento 2 REST API Import: Guide for Adobe Commerce & Magento Open Source

- E-Commerce, Magento 2, Our extensions

Magento 2 REST API Import

Magento 2 REST API provides a standard way to connect your store with external systems and exchange data through API requests. It can be used to integrate Magento 2 with ERP, CRM, PIM, supplier, marketplace, and other third-party platforms. Adobe Commerce and Magento Open Source use the REST API framework to expose a wide range of endpoints for working with store data.

However, using the Magento REST API to import data from an external system is not the same as sending an individual API request. When you need to retrieve product, customer, order, category, inventory, or other data regularly, you also need to handle authentication, data formats, attribute mapping, transformations, and import scheduling.

This is where the Improved Import & Export extension for Magento 2 comes in. It lets you connect Magento 2 to external REST API sources and import data in JSON or XML format. You can configure API requests, map external fields to Magento attributes, transform data, and automate recurring imports.

In this guide, we explain how the Magento 2 REST API works, how to configure REST API data import with Improved Import & Export in 2026, and which features can make API-based data synchronization easier in both Magento Open Source and Adobe Commerce.
Continue Reading

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

- 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 2 static 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.

Continue Reading

Magento 2 Product Reviews Import & Export Guide for Adobe Commerce & Open Source: Streamline Your Workflow and Boost Store Credibility

- E-Commerce, Magento 2, Our extensions

illustrative image for the Magento 2 Product Reviews Import & Export Guide with emojis, magento logo, and text on orange background

Magento 2 product reviews are more than just comments — they’re a trust signal, an SEO asset, and a conversion booster rolled into one. But while the platform lets customers leave reviews natively, it offers no built-in way to import or export them in bulk. That’s a serious bottleneck for merchants migrating catalogs, syncing staging environments, or preserving valuable user-generated content during store upgrades.

In this guide, we’ll show you how to take full control of product reviews in Magento 2 in 2026, focusing on how to import and export them efficiently using the Improved Import & Export extension. From formatting CSV files and mapping ratings to automating review imports across store views, everything happens directly in the admin panel without touching the database.

You’ll also find a detailed explanation of the Magento 2 product reviews CSV format, including attribute names, accepted values, and practical examples to avoid common mistakes. We’ll explore how the extension transforms what would otherwise be a manual, error-prone task into a streamlined, scalable workflow.

But before jumping into the technical setup, we’ll first review how to make sure product reviews are properly enabled in your Magento 2 store. That way, your Magento 2 product reviews import export efforts start on a solid foundation.

Continue Reading

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