Now compatible with Magento 2.4.4 PHP 8.1 Check new release of Improved Import & Export

"Firebear"

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.4 (released 29.05.2023)

Features:

  • Product Import. The “User Defined” checkbox on the Bundle Options tab of a product page in the Magento admin is linked to the “can_change_qty” column in a product import file.
  • Order Import. The “order_id” and “order_item_id” fields are now optional in the item:downloadable_link_data column when importing orders with downloadable links.
  • Customer Import. A customer group code (“_customer_group_code”) has higher priority than a group ID (“group_id”) during customer import.
  • MSI Product Export.  It is possible to decide whether you need to export salable quantities during product export or not. The export job’s “Add MSI data to export” option enables salable quantity export. If it is turned on, an export file contains the “msi_stock_[stock_id]_salable_qty” and “msi_stock_[stock_id]_is_salable” columns, where “[stock_id]” is a numerical ID of your stock. For instance, msi_stock_1_salable_qty or msi_stock_2_salable_qty.
  • Product Export.  Product export now contains the “parent_sku” column. If a simple product is a child of a few different products, parent products are separated by a comma in the “parent_sku” attribute column.
  • MSI Product Import.  Improved Import & Export automatically changes a stock status based on qty value if the “msi_[source_code]_status” column is omitted, where “[source_code]” is the code of a particular inventory source, such as default, de, or en (e.g., msi_default_status, msi_de_status, msi_en_status). The status is set to “in stock” if qty>0 and “out of stock” if qty=0.
  • Product Attributes. The extension exports product attributes in the same order as on the “Map Attributes” tab.
  • Product Import.  Improved Import & Export converts product weight during import according to the “Weight Factor” value in the import job settings. The default value is “1” – the weight value is exactly as in the import table. To convert kg to g need to set the value to “1000”. To convert g to kg, set the value “0.001”.
  • Order Export. You can export order addresses in a single line with the help of the export job option named “Data in one line”. This feature works only for export. If addresses are separated in different columns in one line – they will not be imported.
  • Category Export. Both a file and mapping tab associated with category export now contain the “parent_id” column.
  • Shipment Import.  The shipment import field named “shipment_track:source_code” provides the ability to create a shipment from the specific stock source.
  • XSLT Field Type. The XSLT field type has been changed to “mediumblob”, which supports more than 65535 symbols.
  • Developer Improvement. The “preparePlatformRowForDb()” public method has been added to the Product class to enable the use of plugins.

Bugfixes:

  • Fixed issue when not all categories were exported due to collection reset.
  • Fixed issue when the global price for a product was exported instead of a website-specific price.
  • Fixed the “Advanced Price” replace behavior. Now it works based on a specific website.
  • Fixed issue with category name export. Initially, names based on the global store view were exported instead of store-specific names.
  • Fixed issue with undefined ‘getMultipleCategorySeparator()’ method while running the core Magento import.
  • Fixed problem when 0 ‘children_count’ was saved to DB during category import.
  • Fixed problem when empty lines were exported during shipment item export.
  • Fixed problem with export category level separator when it was applied only to the first category level.
  • Fixed the category separator on the “Map Categories” import tab. Initially, only ‘/’ was displayed even if another separator was selected. It used to cause problems with categories that already had “/” in their names.
  • Fixed the “Implicit conversion from float to int” error caused by conflicts with some third-party extensions.
  • Fixed problem with the address “imcrement_id”. This column can be used to identify the correct address if an import file does not contain “entity_id”.
  • Fixed problem when only the last bunch of data was exported to a zip file.
  • Fixed the “columnNameInvalid in rows” error when saving Import Job with the “Save & Run” button.
  • Fixed problem when stock qty was not updated using the core Magento import with the enabled MSI modules.
  • Fixed problem when an import process was interrupted if images were not found on a remote OneDrive account. Now, a job shows a warning and keeps running.
  • Fixed the “Object could not be converted to string” error during orders export.
  • Fixed problem with Reviews import when an invalid column error was shown for the “vote:…” column.
  • Fixed issue when a product was accidentally assigned to a “Default source” despite the import file didn’t contain any stock data.
  • Fixed the “Cannot read properties of undefined (reading ‘items’)” JS issue when clicking on the Validate button on the import job page.
  • Fixed memory leak associated with category import caused by the infinite recursive calls.
  • Fixed memory leak associated with product import caused by loading all store products instead of a specific bunch during Product Video Urls loading. 
  • Fixed the “Column cannot be null” error when importing empty values for the “out_of_stock_qty” column during product import.
  • Fixed problem with the export date filter when data was exported till the current time instead of the end of the day.
  • Fixed the export filter field and the “Yes/No” field when products with “No” value were not found.
  • Fixed problem when the configurable product’s “disabled” status became “enabled” even if the import file didn’t contain the status column. 
  • Fixed problem when duplicated attribute options were created during attribute import.

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

How to Import JSON Files to Magento 2

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 and Export Orders to Magento 2

Magento 2 Orders Import

The following article sheds light on how to import orders to Magento 2. Merchants usually do that when they migrate to Magento 2 or synchronize their business with external marketplaces. However, you cannot do that within the admin’s default tools. Therefore, a third-party extension is necessary to maintain this process. 

Besides, the blog post explains how to export orders from Magento 2. This procedure comes in handy in similar cases: when the migration from Magento 2 is required or orders are processed in external systems. Unlike the Magento 2 order import, the corresponding export process is available in the administration right on the order page. Although you can transfer orders from your website with the help of the default tools, we describe a more fully featured but at the same time natural way of doing that. 

In the article below, you will discover how the order import works. We explore the Magento 2 order file structure and generate invoices and shipments while importing tracking numbers. You will also see how to export orders from Magento 2. The last chapter of the article reveals other features of the tool that we use to run data transfers.
Continue Reading

Firebear Improved Import & Export App for Shopify 

shopify import & export app

Our Improved Import & Export extension for Magento 2 is the most potent data transfer tool in the ecosystem. It not only powers connections between Magento websites but also lets you integrate your e-commerce store with various ERP, CRM, accounting, and whatever systems. Besides, the module provides the ability to import data from other e-commerce platforms, such as Magento or BigCommerce. However, we’ve decided not to put bounds to our creative endeavors. We continue our expansion to new e-commerce systems with the Firebear Import & Export Tool app for Shopify. In the following material, we shed light on the project.  Also, check our Firebear SAP Business One Shopify Integration App and The Ultimate Guide to Shopify Import. Continue Reading

Firebear Improved Configurable Product for Magento 2 – Extension Change Log

- Magento 2, Our extensions
Improved Configurable Product for Magento 2
Extension Manual | Guide to configurable products

Improved Configurable Product for Magento 2 – the complete enhancement for configurable product, allowing for dynamic content updates, custom options for configurable products and many more.

1.6.0 (released 29.06.2022)

Features

  • Compatibility with Magento 2.4.4 and PHP 8.1
  • Name of the configurable product displayed in the cart now reflects the selected options
  • The salable quantity can now be displayed as a ‘Left in stock’ quantity
  • Replaced dependencies of jquery/ui
  • Reworked AJAX requests for getting information about the variations of the configurable products

Bugfixes

  • Fixed issue with di:compile (compatibility with Magento 2.4.4 and PHP 8.1)
  • Fixed issue with ‘A Configurable Product in a bundle product’ functionality (compatibility with Magento 2.4.4 and PHP 8.1)
  • Fixed issue with opening configurable product page when a child product has tier prices (compatibility with Magento 2.4.4 and PHP 8.1)
  • Fixed issue with opening a product list page with a configurable product when its child products has tier prices (Compatibility with magento 2.4.4 and php8.1)
  • Fixed issue with “Show how many products left in stock” functionality
  • Fixed issue with saving a configurable product variation with custom options
  • Fixed issue with mixed prices of custom options
  • Fixed issue with wrong SKU of the custom options
  • Fixed issue with incorrect display of products quantity in the matrix
  • Fixed compatibility issue with some third party extensions during re-indexing
  • Fixed conflict with REST API
  • Fixed issue where the swatches were unselected
  • Fixed issue with placing orders related to the manageable product stock for configurable products
  • Fixed issue with updating item information in the summary block on a bundle product page
  • Fixed issue with opening a shopping cart page after adding a bundle product to it
  • Fixed issue with adding bundle products with radio type options to the shopping cart
  • Fixed issue with updating summary block on a bundle product page
  • Fixed issue with opening a bundle product with a configurable product with custom options in a bundle option
  • Fixed issue with updating a base image on a configurable product page
  • Fixed issue with updating a qty of a bundle product option in a summary block
  • Fixed issue with updating a configurable product price when a custom option of a configurable product variation was selected
  • Fixed issue with opening a configurable product page with tier prices in a matrix grid
  • Fixed issue with displaying a file custom option in the shopping cart
  • Fixed “Area code is not set” exception when loading custom options
  • Fixed some class definitions
  • Fixed issue with adding a configurable product with custom options to the shopping cart when the matrix is enabled but product attributes are not matrix elements
  • Fixed issue with updating a price of a bundle product option in a summary block

Continue Reading

Black Friday & Cyber Monday with Firebear & Friends

- E-Commerce, Magento 2, Our extensions

If you want to save some money on extensions for your e-commerce business, it is the best time to purchase the tools you need since November is the season of the most substantial discounts. Here at Firebear, we also know about Black Friday and Cyber Monday and provide special offers on all our products. Furthermore, most of our partners and friends also offer similar conditions. So, how to purchase our tools with a discount, what other companies provide beneficial conditions, what instruments to choose? You will find the answers below.   Continue Reading

Atelier E-Commerce Agency

- E-Commerce, Magento 2

atelier e-commerce agency

Atelier E-Commerce is an agency that responds to the e-commerce challenges of its customers and supports them in their growth. With 10+ years of experience, the company has gathered the best Magento experts who can easily understand your needs, create an efficient and stable e-commerce site, and support you in gaining new customers and sales. Since Atelier is our partner, we provide the agency with access to Improved Import & Export extension and other tools designed to simplify and automate data transfers between Magento 2 and other platforms.  Continue Reading

West Point Digital – Design, Build and Grow your Shopify E-Commerce

- E-Commerce, Magento 2

West Point Digital is a Shopify agency for brands that are looking for a reliable partner. Although many small merchants leverage this e-commerce platform without any help from third parties, West Point Digital offers more complex solutions, providing beautiful designs, scalable storefronts, and optimized conversion rates. And we are happy to announce that we are partners with this digital agency. Firebear provides tools for transferring data to/from Shopify as well as assists in migrations from Magento 2 to Shopify. Continue Reading

Fat Media – A Digital Marketing Agency Able To Solve Any E-Commerce Inquiry

- E-Commerce, Magento 2

Fat Media is an award-winning agency based in the UK. Currently, its offices are available in Lancaster, Bristol, and London. The team behind the company is rapidly growing and now includes more than 100 specialists in such areas as website design and development, digital marketing, user experience research, branding and graphic design, etc. And we are happy to announce our partnership with Fat Media. It means that our Improved Import & Export extension and other tools will help the agency’s clients synchronize their data and run updates. Continue Reading