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.

All the articles in this post feature and require Improved Import & Export extension for Magento 2 installed, as native Magento 2 import either lacks functionality or doesn’t work at times

Get Improved Import & Export extension for Magento 2

Use CMD+F or Ctrl+F to find the keywords of your questions. This will help you if you are lost in the article names.

#1 How to update Magento 2 product price and quantity using import and export.

In this post you will learn how to save time on bulk product catalog updates, and that not all product attributes are necessary when updating existing products.

And will get step by step instructions that can help you save lots of management time, and quicken product attribute update process.

#2 How to update Magento 2 product prices during import quickly, without editing the CSV table

In this post you will learn that Improved Import and Export extension has built-in price adjustment block that lets you adjust product prices during the import process.

Also, you will learn how to filter products for the price update and get useful instruction which will help you quickly set up price update jobs.

#3 How to automate Magento 2 product catalog update from Google Sheets, FTP/SFTP, Google Drive, OneDrive, Dropbox

In this post you will learn how to automate import of the Magento 2 product catalog updates which your supplier or partner sends you. How to configure the import job if the file with the updates is placed to an FTP/SFTP, Dropbox, OneDrive, Google Drive, or if it is a Google Sheets table.

Additionally, you will learn how to set up the schedule of the job, to run automatically in time intervals required for your business.

#4 How to import products to Magento 2 with VAT price included and deduct the VAT automatically to display regular price

In this post you will learn what to do if you need to import the file with product prices which ALREADY include VAT, and how to do it automatically. Without editing the imported table or any other manipulations, just Improved Import & Export extension for Magento 2.

#5 How to import product prices for Magento 2 Shared Catalogs

In this article you will lear what are Magento 2 Commerce Shared Catalogs and how you can enable them.

You will also learn that Shared Catalogs share the functionality with product Advanced Prices and that you do not need to import separate file to update the product prices inside the Shared Catalog.

The articles above is just a beginning. With time we will be adding more articles on the subjects that interest you. If you want a explicit breakdown and a step by step guide on a particular feature of Improved Import & Export extension or Magento 2 import and export functionality in general – drop us a line here:


Request Magento 2 import/export cookbook guide