"import"

Magento 2 Mass Product Update: Bulk Price & Stock Update via Import & Export

May 28, 2024 - E-Commerce, Import / Export Cookbook, Magento 2, Our extensions

magento 2 mass product update

Running an e-commerce website is associated with regular updates: prices often change, you receive new items, stock levels vary, etc. You may spend considerable time altering all these indexes manually. However, it is possible to facilitate the common methodology most merchants rely upon. Below, we’d like to introduce you to the Magento 2 mass stock update. It’s a process that can help you optimize regular data updates that take place on your e-commerce website. Below, we focus on two aspects: prices and stock levels. You will discover what the Magento bulk price update is. At the same time, the article will teach you to update Magento stock in bulk. We use the Improved Import & Export Magento 2 extension to mass update Magento 2 product prices and quantity (stock).

How to Import Images From an External URL in Magento 2

May 27, 2024 - Magento 2

Magento 2 Development; Magento 2 tutorial

The following article explains how to import images from an external URL in Magento 2. You cannot imagine an e-commerce website without product pictures. Uploading visual content elements, however, may be challenging. The more products you have, the more work should be done, especially when you upload each image manually.

Luckily, importing product images to Magento 2 with product data introduces a better way to fill your catalog with content. Instead of uploading pictures to your server and then providing their names during the import process, Magento 2 lets you import images from external URLs. Although this functionality is possible by default, there are several alternative ways to do so.

Below, we focus on the default approach and one of the alternatives. Let’s see how to import product images to Magento 2 using external URLs. Check other useful tips here: Magento 2 Cookbook. Continue Reading

Firebear Improved Import, Export & Mass Actions for Shopware 6

May 22, 2024 - E-Commerce, Our extensions

Below, we’d like to introduce you to our Shopware import plugin. Meet the Improved Import, Export & Mass Actions for Shopware 6. It is one of the ecosystem’s most fully featured and powerful data transfer solutions that offers lots of enhancements to the default import and export processes. Our Shopware import export plugin provides a straightforward way to connect your e-commerce website with different external platforms within and around the ecosystem, automating various routine processes. It introduces numerous integrations with other e-commerce platforms, tools, and service providers, including ERPs, CRMs, accounting, etc.

In the article below, we briefly describe the plugin’s key features. We explore import and export jobs, data transfer automation, mapping, and extended connectivity options of our Shopware 6 import & export plugin. After that, you will find a small description of the existing import & export solutions available in the Shopware marketplace along with the default data transfer capabilities of the platform.

How to import data from external MySQL database to Magento 2

May 6, 2024 - E-Commerce, Magento 2, Our extensions

magento mysql direct update table

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.

Welcome to our MySQL Magento guide. In the following post, we shed light on how to export and import database tables between MySQL and Magento 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 performing a Magento MySQL direct update of tables. 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

Ultimate Guide To Shopware 6 Import

April 29, 2024 - 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

April 17, 2024 - 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 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.

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

March 27, 2024 - 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.

How to Import Data via REST API into Magento 2

March 25, 2024 - 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

The Ultimate Guide to Shopify Import

March 19, 2024 - 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. Because 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 – the Import & Export Tool for Shopify.

Below, you will learn about the basic data transfer capabilities of Shopify: product import, inventory import, customer import, etc. You will learn how to transfer products to your e-commerce website using the platform’s 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 for this process. Next, we explore how to import inventory, customers, and orders to Shopify. After that, you will learn how our Import & Export Tool enhances the default data transfers. Also, don’t forget to check our Ultimate Guide to Shopify Export.
Continue Reading

How to Import Database in Magento 2

March 19, 2024 - Fire development, Magento 2

magento 2 import database command line

Recently, we’ve spotted a question on StackExchange regarding the Magento 2 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 Magento 2 to import a database via the command line. 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, the Magento import of a database becomes questionable. It is impossible to automate regular data transfers from a remote 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