"import"

How to import data from external MySQL database to Magento 2

July 21, 2021 - E-Commerce, Magento 2, Our extensions

Magento 2 mysql data import

Often it is necessary to import products, customers, orders, or other data types to Magento 2 from a third-party MySQL database. However, Magento 2 doesn’t let you do that. Although the default tools don’t support such file sources as external databases, there are several ways to synchronize Magento 2 with external databases.

In the following post, we shed light on how to achieve this goal in two different ways. Firstly, we describe a common approach that involves the default Magento 2 import solution. It requires tons of manual work and cannot be automated. You need to run a CSV export from your MySQL database, match third-party attributes to ones used in Magento 2, and import your MySQL table into your e-commerce website.

On the contrary, you will find out how to avoid numerous unnecessary chores while importing data to Magento 2 from a MySQL database. This approach involves the Improved Import & Export extension. The module combines MySQL database connection and other data import activities within a single interface right in your Magento 2 admin.

After that, we shed light on several MySQL facts as well as describe the core features of the Improved Import & Export extension. To make the long story short, let’s see how to import data from an external MySQL database to Magento 2.
Continue Reading

How to Export and Import Magento 2 Categories

July 20, 2021 - E-Commerce, Magento 2

Unfortunately, Magento 2 doesn’t let you import and export categories by default. Although the platform’s capabilities associated with data transfers are fairly limited, you can address the existing issues with ease. It is necessary to install a third-party module to import and export categories to Magento 2. In the following article, we shed light on how to transfer an existing category tree to/from your e-commerce website using the Improved Import & Export Magento 2 extension. After describing the Magento 2 category export, we peruse a sample import table that contains product categories. After that, our attention is focused on specific Magento 2 category attributes: we explore use cases and attribute mapping to let you transfer categories to Magento 2 from any external platforms. Next, there is a detailed step-by-step guide that depicts Magento 2 category import. Also, you will find out how to import product positions in categories (a part of the Visual Merchandiser functionality of Magento 2) and move Magento 2 categories per different store views.

Improved Import & Export for Shopware 6 User Manual

July 14, 2021 - E-Commerce, Shopware

Improved Import & Export for Shopware 6
User Manual

Improved Import & Export is the Shopware 6 extension that is installed on your store manually, and allows you to import and export products and other entities in and out of your store fast and with the required values.

Latest release is 1.0.0

Import and export of products with custom properties and categories
Support of CSV files
Mapping of custom properties

How to import and export Magento 2 MSI and how it works. Magento 2 multi source inventory (MSI) import guide and manual

July 13, 2021 - E-Commerce, Magento 2

Magento version 2.3 came out with the long-awaited Multi-Source Inventory (MSI) support. The feature is available right after you install the MSI extension. Although the module dramatically improves the basic experience associated with inventory management, it still lacks various vital functionalities, especially in the area of data synchronization. Luckily, you can always address the existing issues with the help of third-party solutions. When it comes to 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. We describe what the MSI module is and how to install it. After that, you will find out what to do with the MSI add-on of the Improved Import & Export extension. All the existing requirements associated with Magento 2 MSI import and export processes are also listed in the article.

Besides, we focus on the table formatting of MSI entities. You will learn how the stock sources MSI table works and what to do with the stock sources qty MSI table. Next, the blog post sheds light upon how to import and export Magento 2 products with multiple MSI warehouses.

The last chapter of this Magento 2 MSI import/export guide describes how MSI source import/export works. We put emphasis on how to export and import Magento 2 stock sources. You will find out how to edit an import table and import it to your website.

The Ultimate Guide to Shopify Import

July 8, 2021 - Our extensions, Shopify

Shopify import products, customers, inventory, orders

Every decent e-commerce platform offers built-in import and export tools. However, they are usually far from being an omnipotent solution that can cope with any business requirement. In view of this, agencies create third-party solutions that close the existing gaps between the platform’s objective reality and the merchants’ subjective needs. What about Shopify? What data transfer solutions does it offer? What reliable alternatives are currently available in the ecosystem?

In this Shopify import guide, you will find out what import functionality is hidden behind the platform and how to enhance it in the most user-friendly and at the same time powerful way. Let’s explore the system’s native capabilities first and then proceed to the most powerful third-party solution that copes with any data transfer challenges and enables any Shopify import customizations – Firebear Improved Import & Export App for Shopify.

Below, you will learn about the basic import capabilities of Shopify. We describe how to transfer products to your e-commerce website using its built-in functionality. The article examines two different cases: importing products from another website and reimporting them within the borders of your store. In addition to that, we provide a CSV file structure required in the ecosystem. The same tutorials are available for other entities: we teach how to import inventory, customers, and orders to Shopify.
Continue Reading

How to Import Data via REST API into Magento 2

June 30, 2021 - E-Commerce, Magento 2, Our extensions

How to Import REST API data to Magento 2

Depending on the edition of your Magento 2 installation, your built-in import and export tools may vary a little bit. However, the difference is not very vast: with the Commerce edition, you can create schedules of updates while the Open Source edition doesn’t let you do that. At the same time, neither of them lets you leverage REST API import processes. Luckily, the missing functionality can be enabled at any moment with minimum effort. You only need to install the Improved Import & Export Magento 2 module to leverage the Magento 2 REST API import and export processes.

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 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 REST and Magento 2 import/export processes.
Continue Reading

How to Import Database in Magento 2

June 29, 2021 - Fire development, Magento 2

Magento 2 import export debug log

Recently, we’ve spotted a question on StackExchange regarding database import. David Duong faced problems while transferring a database on Magento 2.3.3. Below, we shed light on the issue and the provided solution for the Magento 2 database import. However, it is quite a complex process since the system doesn’t let you transfer a database to Magento 2 directly. You always need to create an output file that contains a particular entity. If your file incorporates several types of data (e.g., products and orders), it is necessary to split it into two separate tables.

Furthermore, you always have to edit attributes in the imported file to make them suitable for the Magento 2 requirements. Otherwise, no database import to Magento 2 is possible. And it is impossible to automate regular data transfers from a database to your e-commerce website. However, there is a tool that solves all these issues. After we describe a method provided in the StackExchange discussion, you will find out how to achieve the missing functionality with the help of the Improved Import & Export Magento 2 extension. For more tips and advice, read our Cookbook. Continue Reading

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

June 21, 2021 - Magento 2, Our extensions

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.5.2 (released 21.06.2021)

Features

Added possibility to enable login and password encryption for FTP and SFTP sources. The setting is available under Stores > Configuration > Firebear Improved Import & Export
Added possibility to import and export products with the quantity per warehouse. If Magento 2 MSI extension is installed, you can import and export products with additional attributes msi_{warehouse_name}, msi_{warehouse_name}_qty, msi_{warehouse_name}_status
Added support of OneDrive as an import and export source. One OneDrive account per store can be added in the extension settings
Added possibility to delete an imported file after the import process completes if you are uploading a file to the store
Added possibility to use ‘tab’ (just type in ‘t’) as a multiple value separator, and field separator, enabling use of the .tsv files
Added possibility to import ALL files from the specified folder, works with sources: file, FTP, SFTP
Added possibility to import .zip archives. You still need to select the proper file type which is contained in the archive.
Added possibility to specify EMPTY_VALUE constant. You can use any symbol to specify that the field should have an empty value after import completes.
Improved URL generation pattern, you can now use [product_attribute_code] to include any product attribute value into the final URL
Now it will not be possible to create multiple export jobs which target the same output file. When duplicating the export jobs the output file path is reset and you need to fill it again. Also, the prefix ‘Duplicate of original_job_name’ will be added to the duplicated job.
Speed improvements for configurable products import

Bugfixes

Fixed issue with product images when Remove All Images and Remove Images from Directory options were enabled together
Fixed issue where Skip Errors Validation system wouldn’t work when importing from command line
Fixed issue with importing product images from Google Drive and DropBox filesystem
Fixed issue when it was not possible to import product price rules by attribute set condition
Fixed issue when it was not possible to save the address of the URL if the URL resulted in 404 error
Fixed issue with the default product stock update when the imported file doesn’t contain stock attributes
Fixed issue when it was not possible to export products page by page
Fixed issue with the product images import when the path to the image is not URL
Fixed issue with importing orders with Json file type
Fixed issue with updating category names using entity_id
Fixed issue with the export filters missing multi-select attributes
Fixed issue with customers sometimes not being confirmed after the import
Fixed issue with the category import when the incorrect value specified for the ‘position’ attribute
Fixed issue with the advanced pricing import with ‘Replace’ behavior adding new lines of the advanced pricing
Fixed issue with the category mapping tab when several pages are added
Fixed issue with the Generate Unique URL if duplicate not working with the URL Generation Pattern
Fixed issue with the Advanced Pricing export when the price has been fetched by the entity link field
Fixed issue with the product image database entries being duplicated for each store in the multi-store environment
Fixed issue with the category mapping preserving cached paths when new import source is selected
Fixed issue with FTP and SFTP sources not working properly in several cases and not being able to connect
Fixed issue with updating category attribute ‘is_anchor’ for multi-store environment due to the inherited Magento 2 behavior
Added URL key validator

Improved Import / Export Magento 2 Extension Manual

June 15, 2021 - Magento 2, Our extensions

In this article, we’d like to draw your attention to the Improved Import & Export Magento 2 extensions. The following blog post contains all the information about the data transfer module. Below, you will find the Improved Import & Export Extension manual that sheds light upon all the key aspects associated with the plugin. We describe its installation, configuration, and import/export transfers, teach you how to add a new import and export job, talk about import and export processes associated with different entities. You will also discover various nuances of running data transfers via CLI, automating processes, using extension customization endpoints, and performing troubleshooting. Various use cases and specific features are also described in the manual.

Improved Import and Export extension allows importing and exporting CSV/XML/JSON files with product data and product images to Magento 2. The files can be imported from a remote FTP/SFTP server, Dropbox, direct URL of a source CSV file, Google Sheets, etc. In addition, the extension offers a dedicated category import from CSV files, import of attribute values and new attributes on the fly, import job scheduling with cron jobs, and other features.

Besides, you get advanced export capabilities, including order export and export jobs, with attribute and table field mapping.

How to import Magento 2 product and custom attributes

June 4, 2021 - E-Commerce, Magento 2

In this article, we talk about how to import product attributes, attribute groups, and attribute sets to a Magento 2 store. Besides, we discuss how the attributes behave and which values Magento 2 understands in the import tables. The topic is extremely important since transferring products to Magento 2 is impossible without product attributes. They dictate which values the products have and which options and variations exist. That’s why having the ability to import product attributes is a must. Since Magento 2 doesn’t let you import product attributes by default, we use the Improved Import & Export extension to manage all the processes. Below, you will find how the module works when it comes to the Magento 2 product attribute import. We provide a table with product attributes, offer tips on importing attributes to your e-commerce website, and highlight several more important aspects.