Ultimate Guide To Shopware 6 Import

- E-Commerce, Shopware

Welcome to the world of Shopware import! Like every e-commerce system, Shopware 6 provides the ability to import and export information between your website and external data sources. This functionality simplifies content management chores, such as data updates or product translations. Besides, the Shopware 6 import lets you easily move products to product comparison engines and marketplaces. In this Shopware import guide, we generally describe the available options, reviewing the basic import plugin of Shopware 6 along with its profiles. You will learn how to import data to Shopware 6 and what entities are supported. Also, check our Ultimate Guide To Shopware 6 Export. 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 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, 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.7 (released 17.04.2024)

Features:

  • Magento 2.4.7. Support. The latest version of the extension supports Magento 2.4.7.
  • Customer Import. Support for separate street columns “_address_street_1”, “_address_street_2”, “_address_street_3”, “_address_street_4” when importing customer & addresses.
  • Improved Consecutive Export. Now, it is possible to export also last updated entities.
  • Export Mapping. The “salable_qty” column has been added to the export mapping section when exporting products with MSI data.
  • Order Export. A new event, “sales_order_save_commit_after,” to run order export jobs has been added.
  • Customer Import. A new customer import attribute has been added – “allowed_assistance.” It can enable/disable the Allow Remote Shopping Assistant feature.
  • Order History Import. Now order comments can be imported by the order’s “increment_id”. “status_history:entity_id” and “status_history:parent_id” are not required anymore.
  • Custom Options Price Import. It is now possible to import store-specific custom option prices.
  • Export Filters. Export filters support the following conditions: “=” “!=” “>” “<=” “contains” “not contains.”
  • Image Import. Additional logging has been added for deferred image import.
  • Performance. Customer import has improved memory consumption.
  • Data Storage. The DB’s “mapping” column type has been changed to “mediumblob” in the “firebear_import_jobs” table to allow the storage of more data.
  • Product Import. The ability to unassign products from the category has been added.
  •  Order Export. It is now possible to export order data in one line to XML and JSON formats.

Continue Reading

Magento 2 Google Sheets Integration Guide

- E-Commerce, Magento 2, Our extensions

Magento Google Sheets Integration

Have you ever known that importing data to Magento 2 from Google Sheets is possible? It is not a joke, and we will explore the Magento Google Sheets integration below.

Although you will never find the corresponding option in your Magento 2 administration, a robust third-party Magento 2 importer can do the job. The default import and export tools of your e-commerce website are scarce. You can perform only several basic data transfers with them. Therefore, it is necessary to leverage a third-party extension that replaces the default import and export functionality. So meet the Improved Import & Export module for Magento 2. This tool dramatically enhances the basic features associated with moving tables to and from your website. And, of course, it delivers the Magento 2 Google Sheets integration to the platform. 

In the following article, we shed light on the basic features of the Improved Import & Export extension that can help you with the Magento 2 Google Sheets integration. After that, you will find a link to our Master Import Table for the Magento 2 Google Sheets import along with detailed descriptions.

With this information, we proceed to the use cases associated with the Magento 2 Google Sheets import. You will learn to import data from a spreadsheet with multiple tabs, automate the corresponding transfers, move configurable products to your store, work with tier prices, save category positions, copy the existing reviews to your new website, etc. 

Continue Reading

Magento 2 Page Builder Import & Export

- E-Commerce, Magento 2, Our extensions

Magento 2 Page Builder Data Import Export

In the following article, we shed light on Magento 2 Page Builder. You will learn its core features. After that, we will focus on the Magento 2 Page Builder import and export. Since you cannot transfer anything to/from the tool via the platform’s default instruments, it is necessary to install a third-party extension. Below, we explore the most intuitive and easy-to-use solution aimed at recreating the missing functionality. Meet the Improved Import & Export extension. With its help, you can most efficiently import and export the data associated with Page Builder in Magento 2.

The blog post below unveils the most important facts about Magento Page Builder. You will learn about its drag-and-drop functionality, grid system, visual effects, flexible integrations, products, instant previews, schedules, etc. Besides, there is a technical introduction to the tool and a brief description of Bluefoot CMS as the foundation of the Page Builder in Magento. After that, the article switches to its key part – you will learn how to import and export data to/from Magento 2 Page Builder. Since the process incorporates the Improved Import & Export extension, you will also find its features described below.
Continue Reading

How to Import Custom CSV to Magento 2 Programmatically

- E-Commerce, Fire development, Magento 2

magento 2 import custom csv programmatically

Let’s discuss the Magento 2 import of custom CSV files. Recently, we’ve been surfing across endless StackExchange discussions and stumbled upon an exciting topic that wasn’t highlighted in our Cookbook. The problem was easy to understand: there was a custom CSV and a user had to import it to Magento 2. The probability of a similar situation for an average e-commerce business is quite high.  Therefore, we’ve decided to narrate it in our blog, adding several more vital facts. So, what is the issue?

Bilal Usean asked the community how to import a custom CSV file to a custom table in Magento 2. Although forum members provided several ways to achieve this goal, we didn’t find any user-friendly solution aimed at people with less technical skills than required by the most rated answer. Variants discussed on StackExchange seem to be highly efficient but too complicated. However, there is one more way to import a custom CSV file to Magento 2 with the minimum headache. Below, we provide the original answer as well as our alternative solution. You will also learn how to import a custom CSV to Magento 2 programmatically. Since some of the provided solutions incorporate the Improved Import & Export extension, we also share its core features after discussing the initial resolution.
Continue Reading

How to Import Magento 2 Product by Store View?

- Fire development, Magento 2, Our extensions

Magento 2 product by store view import

You’ve come to the right place if you run a multilingual storefront or use several different store views. Below, we explore a situation when you need to import Magento 2 product data by store view. While this procedure may seem quite exhausting when you use the default import tools, you may rely on several other ways to simplify these data management chores. Below, we provide community-based recommendations on Magento 2 product import per store view for both Magento 1 and Magento 2. At the same time, you will find a solution proposed by the Firebear team. 

The article incorporates materials from the StackExchange question by ruuter. Once we came across it, we thought it was good to share our experience in this area. Thus, if you don’t know how to import individual product data per store view in Magento 2, we will teach you below. 

Also, note that the article compares the traditional approach that works for Magento 1.x with the new way introduced in Magento 2. As for the improved solution, we shed light on the associated product import automation, product data transfers per store view from external sources, and the use of alternative data sources, such as Google Sheets or API connections. Continue Reading

Magento 2 MSI User Guide: How to Import & Export Magento 2 MSI (Multi Source Inventory)

- E-Commerce, Magento 2

Magento 2 MSI User Guide

This Magento 2 MSI user guide briefly explains the platform’s multi-source inventory functionality and then focuses on the Magento 2 MSI import and export. Magento 2.3 came out with the long-awaited Multi-Source Inventory (MSI) support. The feature is available right after you install the Magento 2 MSI module. Although the extension dramatically improves the basic experience associated with inventory management, it still lacks various vital functionalities, especially in data synchronization. Luckily, you can always address the existing issues with the help of third-party solutions. Regarding the Magento 2 MSI module and data transfers, the Improved Import & Export extension and its MSI add-on are at your service. 

In this blog post, you will learn how to import and export all Magento 2 MSI entities: sources and quantity of the products per source. Firstly, we describe the MSI module and explain how to install it. After that, you will find out what to do with the MSI add-on of the Improved Import & Export extension. Next, we focus on the Magento 2 MSI import. The article explores the CSV formatting of MSI entities used in Magento 2. You will learn how the stock sources MSI table works and what to do with the stock sources qty MSI table. The last chapter of this Magento 2 MSI import/export guide describes how MSI source import/export works. 

Continue Reading

Magento Error Log to Debug Magento 2 Import & Export

- E-Commerce, Magento 2, Our extensions

magento error log

Today, we are going to discuss the Magento error log for import and export processes. Since Magento 2 doesn’t have any import and export logs, debugging becomes way more difficult than most users expect. It is still possible but you need to spend way more time and effort than in the case of third-party solutions. In the following article, we shed light on how to debug and log the Magento 2 import and export processes and errors with the help of the Improved Import & Export Magento 2 extension.

Below, you will discover a Magento 2 debug log for import and export processes available in our extension. We describe how to view and manage them. Besides, the article touches upon the topic of debugging the Magento 2 import and export process and errors, mostly focussing on how to avoid the existing problems. Other useful tips are available here: Magento 2 Developer’s Cookbook.
Continue Reading

Magento 2 Import of Custom Attributes: How to Import Products with Custom Attributes to Magento 2

- E-Commerce, Magento 2

magento 2 import custom attributes

When you import products to Magento 2, you may face various difficulties. Transferring them to your website without headaches is possible if all items suit the Magento 2 requirements. However, when Magento 2 custom attributes enter the game, merchants usually experience difficulties. So, let’s talk about the Magento 2 import of custom attributes. The following article provides several tips on importing products with custom attributes to Magento 2.

Below, you will find various recommendations on how to streamline this process. First of all, we shed light upon how to enable the Magento 2 product import if you have to deal with custom attributes, avoiding the most common errors. After that, you will find a short guide on how to automate the procedure. Next, the article touches upon the topic of missing attributes. We explain how to create them on the fly automatically. And of course, products bound to third-party categories are also a topic of our discussion. We describe how to match them to the ones you use in your e-commerce catalog. More useful tips are available here: Developer’s Cookbook.
Continue Reading

How to Import Data via REST API into Magento 2

- E-Commerce, Magento 2, Our extensions

Magento 2 REST API Import

Today, we’d like to draw your attention to the Magento 2 REST API Import. Depending on the edition of your Magento 2 installation, your built-in import and export tools may vary a little. However, the difference is not vast: you can create update schedules in Commerce while the Open Source edition doesn’t let you do that. The common thing is that neither of them lets you leverage the REST API import in Magento 2. Luckily, the missing functionality can be enabled with minimum effort. You only need to install the Improved Import & Export Magento 2 module. The extension offers all the features necessary to leverage the Magento 2 REST API import and export. 

The following article sheds light on how to import data into Magento 2 via REST API. We discuss how to enable the Magento 2 REST API import and what extra benefits you can get. If you are not familiar with what the Magento 2 REST 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 Magento 2 REST API import/export processes.
Continue Reading