"Our extensions"

How to Import Compressed Data (ZIP, TAR, TGZ) to Magento 2

- E-Commerce, Magento 2, Our extensions

Magento 2 Compressed Data ZIP TAR TGZ Import

What if your partner provides a vital data update in a compressed file? Prior to importing it to Magento 2, you need to unpack the archive. Next, if a file stored there is not CSV, you need to run the conversion. Furthermore, if it contains unsupported attributes, you need to replace them with the ones used in Magento 2. All these actions consume tons of time. However, it is possible to automate them. 

The following article discusses two ways of importing compressed data to Magento 2. Firstly, we shed light on a common approach that slightly simplifies the algorithm described above. Secondly, you will discover an alternative solution that dramatically improves the corresponding admin experience. It not only enables the import of archives to Magento 2 but also supports many more file types and enables the import of third-party data to Magento 2. Below, you will find out how to import ZIP and TAR to Magento 2 with the help of the Improved Import & Export extension.

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

How to import data from SAP ASE (Sybase) database to Magento 2

Magento 2 SAP ASE Sybase Data Import

What if a vital data update is stored within the SAP Adaptive Server database but you need to transfer it to your Magento 2 website? The default tools built into your e-commerce store are useless if you need to create a direct connection. The same is about most third-party tools. So, how to move the crucial information to your e-commerce store most efficiently? Below, you will find the answer. We describe a common way of importing SAP ASE bases into Magento 2 and then compare it with a more user-friendly approach.

The common way of moving SAP ASE tables into Magento 2 is a complex procedure that consists of several steps. First of all, you need to perform a CSV export from the Sybase SQL server. We describe this process in the dedicated step-by-step guide below. Next, you need to map third-party attributes to Magento 2 records. After that, it is possible to import an SAP ASE table into Magento 2. You will find the pros and cons of this approach below.

As for the easy way of moving Sybase SQL server bases into Magento 2, it is way more straightforward since it involves Improved Import & Export. You provide the connection parameters and configure other aspects of your data transfer. That’s it! Let’s explore each step of both procedures in more detail and compare two approaches side by side.
Continue Reading

How to Import & Export Data from Office 365 Excel Online to Magento 2

Magento 2 Import Export Office 365 Excel Online

Do you use Office 365? Perhaps, your e-commerce partners do that? Anyhow, we have some good news for you: it is possible to connect Magento 2 to Office 365 Excel Online directly. By default, Magento 2 doesn’t provide this opportunity. Furthermore, it doesn’t offer support for native Excel files, but we know a reliable solution that enables the data import and export from Office 365 Excel Online in Magento 2.

In the following article, we briefly describe what Microsoft Office 365 Excel is. Consider it a reliable alternative to Google Sheets! After that, you will learn how to import and export data from Office 365 Excel Online into Magento 2. We describe the features of the Magento 2 Office 365 Excel integration and provide a step-by-step guide on how to import data from the popular service into your e-commerce website. In addition, there is a chapter that describes the benefits of this integration. 

The last section of the article is dedicated to the Improved Import & Export extension since it is the foundation of the integration. We describe such features as cron-based automation, mapping, supported file formats, and sources, as well as alternative ways to exchange data between Magento 2 and other systems.
Continue Reading

Mirasvit Health & Performance Monitoring Suite for Magento 2

- E-Commerce, Magento 2, Our extensions

Magento 2 performance monitoring module

Website performance is one of the main concerns for every ecommerce business. Online stores with slow loading pages have lower conversion rates and sales since they provide a negative user experience and make shoppers leave a website without a purchase. That’s why it is important to use performance monitoring tools that can quickly identify issues slowing down your web store pages. Besides, a reliable monitoring extension should have an alerting system so that merchants will be able to rapidly react to any problems and fix them before customers are affected.

Mirasvit Health & Performance Monitoring Suite for Magento 2 helps store owners to track changes in the code and configuration settings and view main website performance indicators. The extension provides an automatic reporting system that sends notifications to admins if it finds issues negatively affecting the website functionality.

In the following post, we explore the functionality of the Magento 2 performance monitoring extension in more detail.

Continue Reading

Magento 2 SAP Business One Integration

- E-Commerce, Magento 2, Our extensions

Magento 2 SAP Business One Connector

We’ve already described how to connect Magento 2 to SAP S/4HANA, and now it’s time to shed light on the Magento 2 SAP Business One integration. Below, we discuss core features of the popular ERP software as well as provide a reliable Magento 2 SAP Business One connector. If you are looking for a reliable tool designed to increase your business productivity dramatically, check the following post. Continue Reading

Magento 2 SAP Integration

- E-Commerce, Magento 2, Our extensions

SAP ERP Magento integration

SAP is enterprise software designed to manage such e-commerce sides as various business operations and relations between your brand and customers. Although SAP systems are mostly used by big companies, there are also software solutions designed for small enterprises. No matter how big or small your business is. The ERP platform offers lots of tools that can be customized following any specific needs. However, Magento 2 SAP integration still becomes a challenge for most merchants. Here at Firebear, we know how to simplify it as much as possible. If you’ve got stuck amidst the process or only dream about the successful connection, you’ve come to the right place: our specialists know how to establish the Magento 2 SAP integration right. Continue Reading

Firebear SAP Business One Shopify Integration App

- E-Commerce, Our extensions, Shopify

Shopify SAP Business One Integration App

Men do not live by Magento alone. Therefore, we expand our influence to other ecommerce platforms and, this time, want to introduce you to the Firebear SAP Business One Shopify Integration App. This tool is developed to connect your Shopify website to SAP Business One ERP, synchronizing data between the two systems. The interconnection is based on the Integration Framework for SAP B1 and includes many features that simplify and automate the way you sync Shopify with SAP Business One. Below, we shed light on the project as well as share access to its early version. Continue Reading

Manual for Free Magento 1 to Magento 2 migration add-on for Improved Import and Export extension (

Free Magento 1 to Magento 2 migration add-on helps to move data from Magento 1 store to Magento 2, or from one Magento 2 instance to another. With the add-on you connect together databases of two stores, choose which entity you want to migrate, and hit ‘Run’ button.

THE ADD-ON IS NO LONGER SUPPORTED

The latest version NOW SUPPORTS MIGRATION FROM MAGENTO 2 TO MAGENTO 2 in addition to M1>M2.

Continue Reading