"improved import / export"

The Complete Guide to Virtual Product in Magento 2

- E-Commerce, Magento 2, Our extensions

virtual product in magento 2

The modern e-commerce world is full of all possible tools and options. Even digital products are divided into numerous categories with unique peculiarities. And today, we are going to talk about a virtual product in Magento 2. Products of this type don’t need to be shipped, packed, or even downloaded. They don’t have either size or weight but play a prominent role in global trading. In this article, we explore the main aspects of using the Magento 2 virtual product type. You will learn what a Magento virtual product is and get instructions on how to create one. After that, we focus on the frontend appearance and describe how to import and export virtual products in Magento 2.
Continue Reading

FireBear Improved Import & Export for Magento 2 – Extension Change Log

- Magento 2, Our extensions
improved import and export - Magento 2 extension

The following blog post will help you retrace the evolution of the Improved Import & Export Magento 2 module. The article gathers updates associated with the extension’s each new version from the very beginning. At the time of 1.0.0, it was a basic import solution with an existing import jobs architecture and import cron automation. With the next few versions, the module got such enhancements as product attribute import on the fly, transfers from FTP, SFTP, URL, and Dropbox, custom mapping, etc. Each new release made the Improved Import stronger and stronger. However, it was still an import-only tool until 1.5.0 was released. With this version, our extension became capable of both import and export processes. You can peruse the detailed evolution of the module and see its latest features below. 

Extension Manual | FAQ | Demo | Sample Files

3.8.6 (released 20.09.2023)

Features:

  • Log Files Management Automation. The latest version provides the ability to clear import/export log files automatically. Two options are available: “Clear import/export logs by cron” and “Days Saved in Log”. 
  • Developer Improvement. The “categoriesMapping” method is now public. 
  • Product Online Import. The extension does not disable products when the “product_online” field is empty in the import file.
  • Image Import. The following improvements to the image import process were introduced in 3.8.6:
    • A new product import option called “Keep original image name” is available. When enabled, it keeps the original image name when importing images by URL. 
    • Import images by URL when the URL contains a port number.
    • Import images by URL when the URL contains spaces.
  • Products not in Import List. The “Update Products that are not in the import list” feature now has the following new options:
    • Set products to “Out of stock” status
    • Set products qty to 0
    • Set products to “Out of stock” status and set products qty to 0
  • Google Drive Import. The extension now replaces the existing export file on Google Drive instead of creating a new file with a duplicated name.
  • Order Import. Support for one-line addresses when importing orders.

Continue Reading

How to update product price during Magento 2 import

- E-Commerce, Magento 2

Magento 2 lets you specify a new product price upon import, but what if you want to update category prices by $10? Or what if your supplier raised all prices by 10%? With the default data transfer tools, you have to apply such adjustments manually to every product in your catalog. The more products you have, the more time you will spend. Therefore, nobody wants to calculate and apply each new price manually. In this article, we will tell you how to automate the process. You will need the Improved Import and Export extension. The module dramatically extends the default data transfer capabilities of Magento 2 and introduces the ability to update product prices during Magento 2 import via Price Rules – a set of conditions that adjust the price of the imported products. 

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 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

Product Feed Export with Improved Import and Export

Implementing your product feeds into external marketplaces leads to a huge boost in sales, conversion rates, and overall store visibility within the Internet. It’s a tedious work to do manually, so is it possible to make the routine fast and painless? The answer is ‘yes’. Product feeds can be extracted from your Magento 2 database with the help of the free Product Feed Export add-on of Improved Import and Export. Full control, full automation with minimum efforts from your side. How’re things done? See the guide below.

Continue Reading

The Improved Import / Export Magento 2 Extension by Firebear

- Magento 2, Our extensions

The Improved Import Export Magento 2 Extension by Firebear

Below, you will see a brief description of our project aimed at improving the default Magento 2 import/export functionality. Although the basic processes are significantly refined now, they still lack some important features; therefore, we work on this Magento 2 extension with the aim to build a multi-purpose solution.

Improved Import extension for Magento 2 provides a possibility to transfer your CSV, XML, JSON, XLSX, ODS files with products data and product images to Magento 2 from a remote FTP server, Dropbox, Google Sheets, a direct URL of a source file, supports dedicated categories import, REST and SOAP APIs, on the fly import of product attribute values, import/export cron jobs, and many more features!

In the article below, you will find the extension’s shortened roadmap and brief description. We separately discuss the light version of the module and its entire stack as well as share use cases. Also, this blog post contains information on how to import data from Google Sheets, transfer categories to Magento 2, import product attributes, creating new attributes on the fly, etc. Other useful materials include Magento CLI import commands, import file samples, import fields mapping reference, etc. Continue Reading

How to import and export updates within Magento 2. Consecutive Export

- E-Commerce, Magento 2, Our extensions

Saving time is a priority when we deal with database updates. The most beneficial solution in the situation is to find an adequate method and tool that will reduce the number of backend actions and prevent errors and duplication.

In this guide, we will explore which processes can be used within Magento 2 to add new data to the one previously transferred without running countless imports and exports or recreating a whole new database. 

Continue Reading