"Improved Import/Export"

Magento 2 Google Sheets Integration Guide

Magento Google Sheets Integration

Have you ever known that importing data to Magento 2 from Google Sheets is possible? It is not a joke, and we will explore the Magento Google Sheets integration below.

Although you will never find the corresponding option in your Magento 2 administration, a robust third-party Magento 2 importer can do the job. The default import and export tools of your e-commerce website are scarce. You can perform only several basic data transfers with them. Therefore, it is necessary to leverage a third-party extension that replaces the default import and export functionality. So meet the Improved Import & Export module for Magento 2. This tool dramatically enhances the basic features associated with moving tables to and from your website. And, of course, it delivers the Magento 2 Google Sheets integration to the platform. 

In the following article, we shed light on the basic features of the Improved Import & Export extension that can help you with the Magento 2 Google Sheets integration. After that, you will find a link to our Master Import Table for the Magento 2 Google Sheets import along with detailed descriptions.

With this information, we proceed to the use cases associated with the Magento 2 Google Sheets import. You will learn to import data from a spreadsheet with multiple tabsautomate the corresponding transfersmove configurable products to your store, work with tier pricessave category positionscopy the existing reviews to your new website, etc. 

Continue Reading

Magento 2 MSI User Guide: How to Import & Export Magento 2 MSI (Multi Source Inventory)

- E-Commerce, Magento 2

Magento 2 MSI User Guide

This Magento 2 MSI user guide briefly explains the platform’s multi-source inventory functionality and then focuses on the Magento 2 MSI import and export. Magento 2.3 came out with the long-awaited Multi-Source Inventory (MSI) support. The feature is available right after you install the Magento 2 MSI module. Although the extension dramatically improves the basic experience associated with inventory management, it still lacks various vital functionalities, especially in data synchronization. Luckily, you can always address the existing issues with the help of third-party solutions. Regarding the Magento 2 MSI module and data transfers, the Improved Import & Export extension and its MSI add-on are at your service. 

In this blog post, you will learn how to import and export all Magento 2 MSI entities: sources and quantity of the products per source. Firstly, we describe the MSI module and explain how to install it. After that, you will find out what to do with the MSI add-on of the Improved Import & Export extensionNext, we focus on the Magento 2 MSI import. The article explores the CSV formatting of MSI entities used in Magento 2. You will learn how the stock sources MSI table works and what to do with the stock sources qty MSI tableThe last chapter of this Magento 2 MSI import/export guide describes how MSI source import/export works

Continue Reading

How to import & export Magento 2 categories with custom separators

- Magento 2, Our extensions

Magento 2 Development; Magento 2 tutorial

Since category names on an e-commerce website may contain commas, the export process may recognize them as separators, creating new categories in your export file. The same issue impacts your category tree on import: since the comma is considered a delimiter, a long category name can be split into several new categories. Below, we explain how to import and export Magento 2 categories with custom separators to avoid these issues. As usual, you will need the Improved Import & Export extension for Magento 2 since the platform’s default data transfer instruments do not support category import or export, nor it lets you use custom separators for category names when you import and export products.   Continue Reading

Improved Import / Export Magento 2 Extension Manual

- Magento 2, Our extensions

In this article, we’d like to draw your attention to the Improved Import & Export Magento 2 extensions. The following blog post contains all the information about the data transfer module. Below, you will find the Improved Import & Export Extension manual that sheds light upon all the key aspects associated with the plugin. We describe its installation, configuration, and import/export transfers, teach you how to add a new import and export job, talk about import and export processes associated with different entities. You will also discover various nuances of running data transfers via CLI, automating processes, using extension customization endpoints, and performing troubleshooting. Various use cases and specific features are also described in the manual.

Improved Import and Export extension allows importing and exporting CSV/XML/JSON files with product data and product images to Magento 2. The files can be imported from a remote FTP/SFTP server, Dropbox, direct URL of a source CSV fileGoogle Sheets, etc.  In addition, the extension offers a dedicated category import from CSV files, import of attribute values and new attributes on the fly, import job scheduling with cron jobs, and other features.

Besides, you get advanced export capabilities, including order export and export jobs, with attribute and table field mapping.

Continue Reading

The Best Improved Import/Export Extensions for Magento 2

- E-Commerce, Magento 2

Import Export Magento 2 Modules

Improved import & export Magento 2 extensions are designed to simplify some routine Magento tasks. They revamp the default abilities of the platform by adding convenient import/export options. Although, Magento 2 provides a lot of ecommerce possibilities in this area out-of-the-box, they are still not enough for seamless migration to/from other systems as well as for performing some daily tasks. Furthermore, in case you want to import products from Magento 1 to Magento 2, one of the following tools will essentially simplify this procedure. Besides, check our digest of the Magento 1 export tools here: The Best Improved Import/Export Extensions for Magento. They will be necessary for moving data out of your old store. And don’t forget about the Complete Guide to Magento 2 Product Import / Export. In that post, we describe core nuances of the default import/export process as well as provide Magento 2 import csv examples and description. But what bout popular Magento 2 import extensions and Magento 2 export modules?

Continue Reading

Manual for Product Feed Export Add-on of Improved Import and Export

Welcome to the manual for the free Magento 2 Product Export Add-on of the Improved Import and Export extension. This tool is developed to simplify your integration with all kinds of services that require your product feed: Amazon, eBay, Facebook, or even drop shippers – provide all of them with your catalog in the form of a feed. 

In the article below, we shed light on what the Magento 2 Product Export Add-on of the Improved Import and Export extension is. After that, you will find a guide on how to install the tool. We also explain how the add-on works, including such aspects as feed category mapping and product feed export jobs.

Continue Reading

How To Synchronize Magento 2 With Any Online Marketplace To Import/Export Product Data

- E-Commerce, Magento 2

Magento 2 Omnichannel Extension

Magento 2 is not only a reliable platform for building online storefronts but also a fully-featured tool for connecting multiple branches of your business together. However, a few manipulations are required. After that, you can use your e-commerce website as a hub for omnichannel retail. The platform makes the multi-channel approach more affordable to everyone since you can easily leverage marketplaces like Google Shopping, eBay, and Amazon along with your storefront. To cover as many buyers as possible, place your goods there, generating additional sales every day. But how to synchronize Magento 2 with any online marketplace? You will discover the answer below. 

The following article sheds light on Magento 2 integrations with drop shipping platforms, price comparison engines, and online marketplaces. We explore feed export extensions and highlight their issues. Also, you will discover a universal connector – Improved Import & Export. This tool offers broad data feed management features and rich integration opportunities. The possible integrations based on the module are listed in this article too.
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

Magento 2 Order Export Extensions Comparison (Amasty, Xtento, Wyomind, Commerce Extensions)

- E-Commerce, Magento 2

Magento 2 Order Export Extensions Comparison (Amasty, Xtento, Wyomind, Commerce Extensions)

Chances are, you are going to connect your Magento 2 store to an external platform that works with order data. It can be any service that simplifies the default ecommerce routine or adds some new possibilities. ERPs, CRMs, warehouses, dropshipping systems, or carriers may require this information. Unfortunately, it is hard to provide it unless you use a third-party Magento 2 module. Below, we compare four different Magento 2 order export extensions: Amasty Export Orders, Xtento Order Export, Wyomind Mass Order Export, and Commerce Extensions Import Export Bulk Orders. Besides, you can check our Improved Import Export for Magento 2, which also helps to achieve the same goal and provides dozens of features that are not available with the solutions mentioned above. Continue Reading

Firebear Improved Import Export Magento 2 Extension FAQ

Below you can find the FAQ related to the Improved Import & Export Magento 2 extension by Firebear Studio. We provide answers to general questions, shed light on the Firebear Studio services and policies, as well as explain various technical nuances associated with the module. You will find out how much technical knowledge is required to use the tool, is it suitable with PWA stores, why is Improved Import & Export better than the default Magento 2 data transfer solutions and similar alternatives, do we offer installation services and support, how long is the money-back period, and so on.  Continue Reading