Firebear Studio is bringing its import and export expertise to Shopware commerce!
Learn how we have planned and decided to develop the import and export solution for the Shopware 6 store owners, and how we plan to improve it
Working with suppliers requires you to regularly update your Magento 2 product catalog with new prices, stock updates, and sometimes other relevant attributes. Store managers can spend a lot of time manually going product by product, spending their time and going attribute by attribute.
With Improved Import & Export extension for Magento 2 you can automate product catalog update tasks with cron scheduler and recurring import jobs, that automatically fetch the file with supplier updates from the source, and upload it to your store.
In the article below, I will give you step by step instructions on how to do it.
In the following article, we shed light on how to import and export data between Magento 2 and other systems using WSDL. Below, we define what WSDL is and how to manage it. You will find out the background of the Magento 2 WSDL import & export with the Improved Import & Export extension. Besides, we shed light upon the WSDL structure and elements, including the WSDL message part and port type binding. The benefits of WSDL are also listed below. And since the article described various data transfer processes based on the Improved Import & Export module, we also highlight the most important features of the extension.
Continue Reading
Unfortunately, Magento 2 doesn’t provide any opportunities to export products, orders, customers, or other Magento 2 entities to a remote FTP or SFTP server. You have to run a standard export procedure instead and transfer the output manually. Besides, it is impossible to automate this process. The system leaves you in a situation when it is necessary to repeat all its steps manually every time an update is required. Luckily, there is a better way of achieving this goal. As you’ve probably guessed, it involves a third-party solution. In our example, we use the Improved Import & Export Magento 2 extension to export products, orders, customers, and other Magento 2 entities to a remote FTP/SFTP server. It also lets you import all entities from this file source. Continue Reading
Below, we shed light on how to enable Magento 2 SOAP API import. Unfortunately, this functionality is not possible by default, but you can add the missing feature to your e-commerce store with the help of a third-party extension. The following article sheds light on SOAP, compares it with REST, and offers a reliable tool for enabling the corresponding functionality for Magento 2. You can leverage the Magento 2 SOAP 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 SOAP API with the help of our extension. We discuss how to enable the Magento 2 SOAP API import and what extra benefits you can get. If you are not familiar with what SOAP API is, we’ve also prepared a chapter that describes this standard. Besides, there is an FAQ section that provides answers to frequently asked questions about SOAP and Magento 2 import/export processes.
Continue Reading
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.
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.
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
What if a vital data update is stored within the 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
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
