Improved Import / Export MAJOR UPDATE 3.0 - Excel, Json, XML, APIs, automation, mapping, attributes, consecutive run and more EXPLORE

"Magento 2 import"

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

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

- Magento 2, Our extensions
improved import and export - Magento 2 extension
Improved Import & Export for Magento 2
Extension Manual | FAQ | Demo | Sample Files

Improved Import Export Magento 2 Roadmap – vote for the most exciting features and we will implement them first. Leave your suggestions in the comments and we will add them to the poll.

3.1.8 (released 16.09.2019)

Features

  • Added URL rewrites entity for import and export
  • Added Widgets entity for import and export
  • Added Product Reviews entity for import and export
  • Added Catalog Search Terms entity for import and export
  • Added Search Synonyms entity for import and export
  • Added Gift Card entity for import and export (Magento 2 Commerce/Cloud only)
  • Added Page Hierarchy entity for import and export (Magento 2 Commerce/Cloud only)
  • Added Visual Merchandise – product category position attribute – import and export
  • Added possibility to ‘disable’ products in your Magento 2 if they are not in the imported table
  • Added support for multisheet Excel XLSX files – you can select the sheet to import from
  • Added possibility to specify the URL path to images in the Image File Directory field in addition to FTP path
  • Added new cron group to register import or export job crons in the same group
  • Dropbox source improvements: folder select, whitespaces in filenames, latest file
  • Change cron group for dynamic cron handling.
  • Upsell and Crossell products can now be removed on import completion
  • Categories can now be imported and exported per store view
  • Attribute option values can now be deleted during import
  • Attributes can now be imported and exported for specific store view

Bugfixes

  • Fixed issue where products would export for all store views instead of default only
  • Fixed issue where the images with the same filename were uploaded to the server
  • Fixed issue with attribute option values not imported for particular store views
  • Fixed issue with the order export where the extension log wouldn’t give proper error
  • Fixed issue with product import exception generate_url
  • Fixed change format curl-request in Dropbox.
  • Fixed issue where default attribute value could be deleted
  • Fixed unserialized error in the job form
  • Fixed issue where date filters wouldn’t work for order export
  • Fixed issue where downloadable products wouldn’t import on schedule, only manually
  • Fixed issue where rice rules were not applied for existing products (added categories to price rule conditions)
  • Fixed issue where long XSLT code was preventing the jobs from editing
  • Fixed issue where all file validation errors were cleared
  • Fixed undefined error when importing Advanced Pricing
  • Fixed issue with exporting customer addresses with invalid _website attribute
  • Fixed wyomind integration class definition
  • Fixed issue with pipe separator for varchar attribute changed to ‘comma separated’
  • Fixed issue where configurable products with only a single variation couldn’t be created
  • Fixed issue with Text Swatch attribute type import, if there was a change in description new value were added
  • Fixed issue with Text Swatch exporting admin value instead of admin description
  • Fixed issue with Categories import with ‘/’ as a separator breaking category pathing for CSV files
  • Fixed issue with pipe separator changing to comma for CSV files
  • Fixed issue with Product Attributes import with ‘0’ value
  • Fixed issue with attributes mapping unable to set default value to ‘0’
  • Fixed issue with Advanced Pricing importing only the last value in the row
  • Fixed issue with saving export jobs with undefined filter resulting in js error
  • Fixed issue with ‘Import source’ field sometimes missing values on first job loads
  • Fixed issue with ‘additional_attributes’ column not being removed when ‘Divide additional attributes’ setting enabled
  • Fixed issue with importing Magento 1 payment information converting serialize data to json
  • Fixed issue with simple products not being attached to grouped products during import
  • Fixed issue with ‘Replace’ behavior sometimes giving console error during job execution
  • Fixed issue with the Product entity import giving ‘url is not unique’ error with ‘replace’ behavior
  • Fixed issue with SOAP API file validation
  • Fixed issue with Advanced Pricing export job exporting not all price data
  • Fixed issue with the export jobs exporting data for all store views if no store view has been selected
  • Fixed issue with setFinishedAt function called before import process is finished
  • Fixed issue where product image and status were not imported if attribute mapping has been enabled
  • Fixed issue with line breaks when exporting text areas
  • Fixed issue with date and time filters for export jobs sometimes functioning improperly
  • Fixed issue with Map Attribute sections sometimes deleting incorrect mapping row
  • Fixed issue with ‘replace’ behavior adding new entities for Customers and Category entities
  • Fixed issue with not working Category Level Separator
  • If image is not found the proper message is now displayed in the extension log and console
  • Depending on the selected entity, some of the options are not properly hidden
  • Updated file validation criteria when importing Product Attributes
  • For importing product attributes added an error message if the attribute_set (required attribute) is empty
  • Missing attributes have been added to Map Attributes section for ALL entities
  • Store view selector is now properly displayed only for the entities that support multiple store views
  • Updated sample files in both GitHub and Master Table Google Sheet
  • Swatches attribute type values can now be properly imported with additional_attributes column
  • Refactored export model configuration, merget config from config.xml and di_export.xml
  • EntityInterface implemented into the export models
  • Split database setup is not properly supported for Order entity
  • Implemented retry functionality when deadlock mysql error occurs
  • Magento Order Management is now proprely supported
  • Configurable products from Magento 1 MagMi CSV tables can now be properly created in Magento 2
  • Import job and console log now properly display error message if the product has empty SKU value
  • Products are now exported page by page to avoid timeout issue

Continue Reading

The Complete Guide to Magento 2 Related Products, Up-sells, and Cross-sells, and how to import them

The triplet ‘related products, up-sells, and cross-sells’ can be called ‘a promo engine for an e-store’. The products are distinguished based on the display location and they may serve specific marketing goals but the core idea of being a purchase stimulus is similar for all of them. In this guide, we will cover how to enrich your store content by importing related products, cross-sells, and up-sells.

Continue Reading

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

Modern digital trading World is full of products, that must be delivered digitally. The products that don’t need shipping, packing or downloading. Such products don’t have size, weight, but they play a prominent role in global trading.

There is a dedicated type, for such kind of products, in Magento 2 ‘Virtual Products’. In this article you will learn the main aspects of using virtual products and get the instructions on how to import and export them from your Magento 2 store.
Continue Reading

How to import Magento 2 product and custom attributes

- E-Commerce, Magento 2

In this blog article we will talk about how to import product attributes, attribute groups and attribute sets to Magento 2 store. How the attributes behave and which values Magento 2 understands in the import tables.

Importing products to Magento 2 is impossible without product attributes. They dictate which values the products have, which options and variations. That’s why having the ability to import product attributes is a must

Continue Reading

Magento 2 import XSLT transformation – how to import any XML to Magento 2

- E-Commerce, Magento 2

When working with the suppliers, you often come across custom XML table formatting. Such tables cannot be imported to Magento 2 without giving all product attributes particular names.

Same applies to the export. Your CRM system probably accepts a set format of XML files. So as other software you might be using.

That’s why we are introducing XSLT support for Improved Import and Export extension. To help you get the required XML formatting for any needs you might have.

Continue Reading

How to Import JSON Files to Magento 2

Magento 2 JSON Import

By default, Magento 2 provides limited capabilities when it comes to data import. They are enough for satisfying basic demands, but what if a more complex tas must be solved? For instance, you need to import JSON files to Magento 2. Unfortunately, this opportunity is available neither in Magento 2 out-of-the-box nor most third-party extensions. But below, we shed light on how to import JSON to Magento 2. Continue Reading