Improved Import & Export major update - full Google Sheets & Drive integration. Fixed price Magento 1 > Magento 2 migration service! EXPLORE

"Magento 2 import"

The Complete Guide to Magento 2 Bundle Products, and how to import them

- E-Commerce, Magento 2

Magento 2 delivers several types of complex products. While configurable items are the first thing that comes to mind in this case, you may also leverage product bundles. Magento 2 bundle products are 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. And while buying bundled 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 and how to import such products to the Magento 2 catalog. The article guides you through the explanation of what bundle products are, focussing on various nuances of this product type. After that, the topic of the publication shifts to another vital aspect: we explain how to create bundle products in Magento 2. The last section of this blog post is dedicated to the bundle product import to Magento 2. 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

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

Continue Reading

How to import Magento 2 product and custom attributes

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

Continue Reading

How to solve Specified URL key already exists error during Magento 2 import

- E-Commerce, Magento 2

When creating or importing categories and products some may encounter Magento 2 error message ‘URL key for specified store already exists’. It may be the URL rewrites, database issue, or other things not considered.

Anyways, if there is an error there will also be a solution. In this article, we will talk about how to solve Magento 2 ‘URL key for specified store already exists’ error when importing products and categories to your store.

Below, we describe when the error occurs, exploring specific conditions that cause it. This article mentions three different cases that usually lead to ‘URL key for specified store already exists. Next, we focus on the most frequent reason – duplicate URLs. You will find out how to get rid of duplicate URLs when importing data to Magento 2. The article provides separate examples for products and categories. After that, we put an emphasis on other features related to the Improved Import & Export extension – the solution that we use to address the ‘URL key for specified store already exists’ issue.

Continue Reading

Magento 2 import and export guide list

Since Magento 2 import and export are complex processes that require additional knowledge and skills, it is hard to cover all their nuances in a single article. Therefore, you can find dozens of materials dedicated to Magento 2 data transfers in our blog. To simplify your interactions with all these publications, we’ve gathered them in this guide list. Below, you will find articles related to Magento 2 import and export processes divided into the following groups: General import instructions, Magento 2 product import, Additional import entities, other articles. We describe the native data transfer solutions as well as shed light upon the core alternatives. You will find out how to automate import/export processes, transfer data from external systems, use Google Sheets and other platforms to move data files from, leverage APIs in import and export processes, etc. By default, Magento 2 offers quite scarce data transfer solutions, especially when it comes to the Open Source version. However, you can easily enhance the basic functionality. Read the corresponding materials listed below to discover the most reliable ways to get fully featured import/export instruments.

Continue Reading

The complete guide to Magento 2 simple product customizable options (custom options)

- Magento 2, Our extensions

The guide is dedicated to the customizable options — the extra settings available for simple, downloadable, and virtual products in Magento 2 that enable the creation of product variations. Products with custom options resemble configurable products staying a unique system element at the same time. Throughout the text, we’ll discover the peculiarities of custom options, learn how to use them properly, and how to import them to your Magento 2 store.

Read Magento 2 Import and Export Guide List

Continue Reading

The Improved Import / Export Magento 2 Extension by Firebear

- Magento 2, Our extensions

The Improved Import Export Magento 2 Extension by Firebear

We’ve started a new project aimed at improving the default Magento 2 import/export functionality. Although this process is significantly refined now, it still lacks some important features; therefore we are working on this Magento 2 extension. We have the aim to build a multi-purpose solution.

Improved Import extension for Magento 2 provides a possibility to import 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 fly import of product attribute values, import/export cron jobs and more!

Buy Improved Import Magento 2 Extension

Improved Import Magento 2 Extension Manual 

Improved Import Magento Extension

Continue Reading

How to Import and Export Magento 2 Catalog Price Rules

- E-Commerce, Magento 2, Our extensions

Catalog Price Rules is a sales booster that allows running price-focused campaigns based on the discounts for products with particular attributes and their combinations. Being a native marketing tool, Catalog Price Rules are extremely user-friendly to set up. However, like any other separate entity, the functionality presents its specifics when it comes to importing. The details are carefully noted in the article below.

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