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

"magento 2"

Magento 2 import and export COOKBOOK index post. Use cases and instructions

This is an index blog post for Magento 2 import and export use cases. In this post you will find links with the description to the posts which describe how to use Improved Import & Export extension for Magento 2.

Each use case article comes with the step by step instructions and screenshots illustrating the extension setup process. Each article covers a particular use case/question, for example: how to map product attributes, how to update stock and price of the Magento 2 product.

  • Read and bookmark articles
  • Try out the instructions at our Magento 2 demo store
  • Check out Master Table which contains samples of every Magento 2 entity export and import file.

Continue Reading

Import/Export cookbook: How to automate Magento 2 product catalog update from Google Sheets, FTP/SFTP, Google Drive, OneDrive, Dropbox

Working with suppliers requires you to regularly update your Magento 2 product catalog with new prices, stock updates, and sometimes other relevant attributes. Store managers can spend a lot of time manually going product by product, spending their time and going attribute by attribute.

With Improved Import & Export extension for Magento 2 you can automate product catalog update tasks with cron scheduler and recurring import jobs, that automatically fetch the file with supplier updates from the source, and upload it to your store.

In the article below, I will give you step by step instructions on how to do it.

Continue Reading

Import/Export cookbook: How to update Magento 2 product prices during import quickly, without editing the CSV table

If you are a dropshipper or want to follow the inflation and increase product prices for your whole Magento 2 catalog or a part of it, you can do it quickly with the Improved Import & Export extension.

Export product catalog and import it back with the Price Rules – a quick filter that allows increasing and decreasing prices by a percent or a flat value.

Continue Reading

Import/Export cookbook: How to update Magento 2 product price and quantity using import and export. HINT: it’s fast and easy

Improved Import & Export Magento 2 extension documentation is huge! I know. It is aimed to cover every aspect of the extension.

However, you do not need to read it all, or understand each and every attribute of every entity. In this article, I will show you how to mass update Magento 2 product prices and quantity (stock) using import and export procedures.

Continue Reading

Leverage Magento 2 and Reach New E-Commerce Heights with Lumao

- E-Commerce, Magento 2

Meet the team of developers from France called Lumao. It gathers the best developers specializing in Magento 2. Being a certified Magento partner, the agency delivers the best coding experiences associated with the platform. And we are happy to announce our partnership with Lumao. The agency streamlines our Improved Import & Export along with other tools to integrate Magento 2 websites with any external systems in the most efficient and seamless manner. If you’re looking for a team of experts, you’ve come to the right place. Continue Reading

How to Run Product Import in Magento 2 from CLI

- Fire development, Magento 2

Magento 2 Development; Magento 2 tutorial

If you want to optimize your daily routine related to Magento 2 product import, you’ve come to the right place. Below, we shed light on several data transfer optimizations that will help you save tons of time spent on daily chores. Many merchants look for tips on how to import products to Magento 2 using the command line interface or an alternative way to achieve the same goal. Below, you will find the answer. The following article is based on the StackExchange question by Massimo Camoni and the answer by Khoa TruongDinh. However, it extends the solution provided in the discussion. So, let’s see how to run Magento 2 product import via CLI. Also, you will find out what commands to use to export products from Magento 2.
Continue Reading

How to Import & Export WSDL Data to/from Magento 2

Magento 2 Development; Magento 2 tutorial

In the following article, we shed light on how to import and export data between Magento 2 and other systems using WSDL. Below, we define what WSDL is and how to manage it. You will find out the background of the Magento 2 WSDL import & export with the Improved Import & Export extension. Besides, we shed light upon the WSDL structure and elements, including the WSDL message part and port type binding. The benefits of WSDL are also listed below. And since the article described various data transfer processes based on the Improved Import & Export module, we also highlight the most important features of the extension. 
Continue Reading

How to fix store ID-related issues on Magento 2 import

- E-Commerce, Magento 2

Magento 2 export CLI

StackExchange teems with interesting and useful tips related to Magento 2. This time, we’ve dug up a discussion where the author named Jackson complains about store ID-related issues that occur in Magento 2. Let’s take a look at the problem and provide several possible solutions. Jackson points to a particular script used to import data from a CSV file. However, the use of ->setStoreId(0) causes an issue – two values for the same field in the database table occur. As a result, it is necessary to delete second values to enable changes on the frontend but it often leads to the incorrect display. How to address the problem? You will find out how to fix store ID-related issues on Magento 2 import as it is portrayed in the discussion. At the same time, we provide a reliable alternative based on the Improved Import & Export. Also, you will discover other improvements associated with the module.
Continue Reading

How to Export Products, Orders, Customers, & Other Magento 2 Entities to Remote FTP & SFTP Server

- E-Commerce, Magento 2, Our extensions

Magento 2 Development; Magento 2 tutorial

Unfortunately, Magento 2 doesn’t provide any opportunities to export products, orders, customers, or other Magento 2 entities to a remote FTP or SFTP server. You have to run a standard export procedure instead and transfer the output manually. Besides, it is impossible to automate this process. The system leaves you in a situation when it is necessary to repeat all its steps manually every time an update is required. Luckily, there is a better way of achieving this goal. As you’ve probably guessed, it involves a third-party solution. In our example, we use the Improved Import & Export Magento 2 extension to export products, orders, customers, and other Magento 2 entities to a remote FTP/SFTP server. It also lets you import all entities from this file source. Continue Reading

How to Import and Export Magento 2 Catalog Price Rules

- E-Commerce, Magento 2, Our extensions

Consider Magento 2 Catalog Price Rules a sales booster that allows running price-focused campaigns based on the discounts. You can apply them to products with particular attributes and their combinations to achieve the highest possible flexibility. Another good thing about catalog price rules in Magento 2 is that it is a platform’s native marketing tool. Also, Catalog Price Rules are extremely user-friendly to set up. However, there is one notable inconvenience associated with this entity. You cannot import Catalog Price Rules to Magento 2 by default. Luckily, there is an opportunity to get the missing functionality. You need the Improved Import and Export extension to transfer Catalog Price Rules between Magento 2 and external systems. The details are carefully noted in the article below. You will find a sample table for the Catalog Price Rule import. After that, we will explore the Catalog Price Rule attributes used in Magento 2. Also, there is a detailed description of how to prepare for and configure a Catalog Price Rule import process.

Continue Reading