Monthly Archives: August 2021

How to Apply Filters to Magento 2 Import and Export

- E-Commerce, Magento 2, Our extensions

Magento 2 Import Export Filters

Imagine a situation when there is a massive data file with thousands of SKUs, but you need to import items with a price lower than $100 or products from a specific category. Or let’s assume that you need to create an export file that contains products that are enabled, have a price higher than 0, are in stock, and are visible in Catalog and Search or just in Catalog. How to do that? You need to apply filters to Magento 2 import and export or create import and export conditions. The following article sheds light on various details of both processes. Continue Reading

Firebear Improved Import & Export Plugin for Shopware

- E-Commerce, Our extensions

Firebear Improved Import & Export plugin for Shopware

Our Improved Import & Export module is one of the most fully featured and powerful data transfer solutions in the entire Magento ecosystem. The module offers lots of enhancements to the default import and export tools as well as propose features that make it unique in comparison to competitors. Improved Import & Export not only powers a straightforward way to connect several Magento websites but also goes far beyond the ecosystem. It introduces numerous integrations with other e-commerce platforms, tools, and service providers, including ERPs, CRMs, accounting systems, etc. In the article below, we briefly describe the extension’s key perks and then concentrate on how we implement them in another project – the Firebear Improved Import & Export Plugin for Shopware. You will find a detailed description of its core features and advantages below. Besides, we also focus on the existing import and export tools of Shopware. 

The article sheds light on the leading import and export solution for Magento 2 and then gradually proceeds to its Shopware counterpart. We explore import and export jobs, data transfer automation, mapping, and extended connectivity options of the Shopware 6 Improved Import & Export app. After that, you will find a small description of the existing import & export solutions available in the Shopware marketplace along with the default data transfer capabilities of the platform. Besides, we briefly describe how you can import & export data in Shopware 6 via API.

Continue Reading

How to Configure Import CSV File Size in Magento 2

- Fire development, Magento 2

Magento 2 Development; Magento 2 tutorial

While importing a CSV file into Magento 2, you may face the following restriction: the size of your file is more than allowed. Below, we shed light on how to change the file size limit in Magento 2. You will find a step-by-step guide on how to apply a new value to the existing restriction. Besides, we shed light upon how to avoid the timeout issue in Magento 2. If you are interested in more tips related to Magento 2, view our Developer’s Cookbook. 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 Run Magento 2 Import if Required Columns Are Missed

- E-Commerce, Magento 2, Our extensions

Magento 2 Import without Required Columns

Below, we shed light on a very important aspect of every import process – columns (attributes) of an import file. What if your data table doesn’t contain one? By default, you face the inability to transfer the update to your Magento 2 website. There are lots of different entities that can be transferred into Magento 2, so you have to deal with different data depending on your particular business case. However, the absence of the smallest detail can ruin all your data transfer efforts. Especially if you use the default data transfer solutions. 

Luckily, we know how to prevent such issues. Meet the Improved Import & Export Magento 2 extension. With the help of this plugin, you can import data to Magento 2 if some required columns are missed. The following article describes this process. You can either add the necessary columns manually or automate the addition of the missing data using the module’s functionality. Besides, you will discover the required CSV file structure as well as core features of the Improved Import & Export Magento 2 extension
Continue Reading

How to Run Product Import on Daily Basis in Magento 2

- E-Commerce, Magento 2

Magento 2 Development

Below, we shed light on how to run Magento 2 import processes on a daily basis. You can do that either in your admin interface or via CLI. While Magento 2 doesn’t let you automate data transfer processes and there is no way to use CLI to control imports and exports, you can enable the missing functionality with the help of third-party solutions. In the article below, we explain how to run Magento 2 import processes daily and use CLI to control them with the help of Improved Import & Export.

Also, you can look for an alternative point of view on Magento StackExchange. Take a look at the question by Massimo Camoni and the answer by Khoa TruongDinh. Since we leverage the advanced import functionality of the Improved Import & Export extension to address the issues mentioned in the discussion, you will also find a section that describes other possibilities the module provides.
Continue Reading

Value For Status Attribute Contains Incorrect Value: How To Fix Error During Magento 2 Import

- E-Commerce, Magento 2, Our extensions

Magento 2 Development; Magento 2 tutorial

When you try to manage a standard import process in Magento 2, you may face lots of issues and inconveniences caused by the platform’s requirements and limitations. For instance, we’ve already described how to fix ‘General System Exception Happened’ Error and eliminate it as fast as possible and with the minimum effort. Today, we’d like to draw your attention to another problem that often occurs during Magento 2 import. Meet the ‘Value For Status Attribute Contains Incorrect Value’ error. The following article sheds light on how to fix it, prevent multiple import issues, and make data transfers more user-friendly. Note that we use the Improved Import & Export Magento 2 extension to solve the problem and prevent other inconveniences. Therefore, you will also find its features described in the following material. 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

Inforca – A Magento 2 Agency with A Potential Of A Killer Whale

- E-Commerce, Magento 2

Let us introduce you to Inforca, a digital agency aimed at making the future of e-commerce beautiful and thriving. Although it is a relatively small company with 30+ clients served, Inforca has a portfolio full of nice and inspiring projects located mostly in Australia but also worldwide. Today, we announce our partnership with this digital agency. The company will rely on our Improved Import & Export extension as well as other tools and services to satisfy the business needs of e-commerce merchants all over the globe. Let’s say a few more words about Inforca. Continue Reading