How to Import and Export products in Magento 2?

In this post, we introduce the way to import and export product in Magento 2. This tutorial is written in detail so it is easy for all merchants to follow.

  1. Get a Magento formatted CSV file

Manually create your own CSV file

If you decide to start with a blank CSV file, ensure your file is formatted correctly for a Magento 2 site. Here are a few tips:

  • Your CSV must be UTF-8 format
  • Make sure the attribute code and not attribute label is used when populating the headings in your spreadsheet
  • Ensure to save the file in .CSV format
  • Stick with default options
  1. Add a product to your spreadsheet
  • I would highly recommend using Open Office as your spreadsheet of choice. Once installed, right click on CSV file you’ve exported from Magento and open it with Open Office
  1. Upload your data to your Magento 2 store
  • To import products from your CSV file, navigate System> Data Transfer> Import
  • Choose Products
  • In Import Behavior, there are 3 options:
  • Add/Update: New data will be added to existing products or new products will be created if they don’t already exist in store. the only field that can’t be updated in SKU
  • Replace: Existing data will be replaced with the new data from spreadsheet
  • Delete: If a product in the spreadsheet matches a product in store, this product will be deleted from database
  • Choose your Field Separator and Multiple Value Separators. Although by default Magento use a comma as a Field Separator, you can use a pipe instead. If you are using pipe as the field separator, you need to configure your CSV file to work with a pipe
  • Tap Select your file then select Check Data
  • Once receiving an Ok go message, tap Import
  • When you complete setting, you will receive the following message Import successfully done
  1. Upload product images and final tweaks

Make any final amendments to your products

  1. Test
  2. Enable/Disable your products

To Import/Export products in your Magento 2 store, click on the Enable Product toggle.

That’s end of tutorial importing/exporting products in Magento 2. Hopefully all of you can perform this tutorial successfully.