"Magento 2 export"

How to Create, Edit & Import Magento 2 Catalog Price Rules

- E-Commerce, Magento 2

Magento 2 Catalog Price Rules: create, edit, import

Today, we are going to talk about Magento 2 Catalog Price Rules. It’s a powerful sales booster that allows for running price-focused campaigns based on discounts right in your catalog. You can apply Magento catalog price rules to products with particular attributes and their combinations to achieve the highest possible flexibility. Another good thing is that they are built into the platform. It is Magento’s native marketing tool which is extremely user-friendly and powerful. Below, we explain what catalog price rules are and how to create catalog price rules in Magento 2. 

Despite all the good things, there is one notable inconvenience. You cannot import catalog price rules to Magento 2 with the help of the default importer. We highlight this inconvenience, introducing a solution that brings the missing functionality to the platform. You only need to install the Improved Import and Export extension and learn what attributes are required for transferring catalog price rules in Magento 2. The details are carefully noted in the article below. You will find a sample table for the catalog price rule import to Magento 2 along with its attributes and values described.

Continue Reading

The Complete Guide to Magento 2 Bundle Product

- E-Commerce, Magento 2

Magento 2 bundle product

Magento 2 delivers several types of complex products. While the Magento 2 configurable product is the first thing that comes to mind in this case, you may also leverage product bundles. The Magento 2 bundle product is designed to provide customers with an additional creativity level and exceptional freedom. With this product type, they can create their own item sets from the available options. While buying Magento 2 bundle products is intuitive and doesn’t differ much from other e-commerce purchases, managing them in the Magento 2 admin is a quite complex routine that needs additional elucidation.  

In this guide, we show how to create bundle products in Magento 2 and how to import them to the Magento 2 catalog. The article guides you through the explanation of what the Magento bundle product is, focussing on various nuances of this item type. After that, the topic of the publication shifts to another vital aspect: the creation of a bundle product in Magento 2. The last section of this blog post is dedicated to the Magento 2 bundle product import. It describes specific attributes associated with bundle products and sheds light upon other nuances of transferring items of this type to your e-commerce website. Also, we provide a separate chapter that describes how to import bundle products to Magento 2 from Google Sheets. 

Continue Reading

The Complete Guide to Magento 2 Configurable Product

- E-Commerce, Magento 2

What is a Magento 2 configurable product? Being an inevitable part of most e-commerce websites, it is a phenomenon that goes beyond the borders of simple Magento 2 products. In the following article, we explore what Magento 2 configurable products are. You will find out their unique characteristics and key management aspects. After that, we proceed to how to create a configurable product in Magento 2. There is also a chapter dedicated to the way configurable products work within your catalog. The Magento 2 configurable product import is another essential topic covered below. You will learn how to import configurable products using the default data transfer tools. After that, we will explore an alternative approach that adds multiple benefits, such as automation and mapping.

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 Import JSON Files to Magento 2

- E-Commerce, Magento 2, Our extensions

Magento 2 JSON Import

The default Magento 2 data import capabilities are enough for satisfying only basic data transfer demands, but what if a more complex task must be solved? For instance, you need to import JSON files to Magento 2, while the system supports only the CSV standard. Therefore, you need to convert your JSON files to the supported file type in order to move them to your e-commerce website. Luckily, there is a more user-friendly solution for importing JSON to Magento 2.

Meet the Improved Import & Export Magento 2 extension. This module supports JSON data import so that you can move all the necessary information to your e-commerce store without comforting it to CSV. You can effortlessly move data in this format in both directions: to and from your Magento 2 website.

In this article, we discuss JSON file requirements for importing data to Magento 2 and provide a list of supported entities (you can transfer all core entities now). Besides, there is a step-by-step guide to importing JSON data to Magento 2. And if you are not familiar with the JSON format, you will find its brief description below. Continue Reading

How To Import/Export Categories to Magento 2

- E-Commerce, Fire development, Magento 2

Magento 2 Development

Below, you will find a brief description of how to import/export categories between two Magento 2 websites. Unfortunately, this functionality is not available by default. Magento 2 leaves you alone with a huge category tree. You need to recreate it manually or rely on third parties. And we know for sure how to import and export Magento 2 categories most efficiently. This post was inspired by the Magento StackExchange discussion. Question by Rafael Corrêa Gomes; answer by KAndy. However, it is only a partial overview of the Magento 2 category import and export. A full-featured guide on how to import and export categories, with all attributes explained can be found here: Read full-featured Magento 2 Category import and export guide. 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 Excel (XLS & XLSX) and OpenOffice (ODS) Files to Magento 2

- E-Commerce, Magento 2, Our extensions

Magento 2 Excel import export

We’ve already described hundreds of data import cases related to Magento 2 and many more are left to be mentioned in our blog. This time, we return to the topic of importing file standards the Magento 2 doesn’t support. Unfortunately, the system works with CSV files only and it is not the only requirement you should follow to be able to transfer an update to your database. You also have to edit third-party data and columns to make the file suitable, but let’s return to the unsupported formats.   

If you have an Excel (XLS or XLSX) or ODS file with data that should be imported to Magento 2, you’ve come to the right place. Although Magento 2 doesn’t let you do that by default, there is a reliable alternative solution at your service. Meet the Improved Import & Export extension – a tool that offers the most user-friendly way of Magento 2 Excel and ODS files import.

In the following article, we shed light on what to do with XLSX, XLS, and ODS files if you want to move them to Magento 2 via the default data transfer tools. After that, you will find a guide on how to import Excel and ODS files to Magento 2 in a way more user-friendly manner. Continue Reading

Wyomind Mass Order Export for Magento 2 and 1

- E-Commerce, Magento 2, Magento tips & tricks

Wyomind Order Export Magento 2 Extension Review; Wyomind Order Export Magento Module Overview

Third-party tools can essentially simplify the default Magento order export management. We’ve already gathered the best import/export modules in the appropriate posts here: Magento import/export extensions; Magento 2 import/export extensions. Today, we’d like to draw your attention to the Order Export extension by Wyomind. Below, we will introduce you to the module’s features and backend functionality.   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