How to Import Products in Magento 2

Magento 2 is a CMS platform focused on building online stores and e-commerce websites. It allows you to import data and update your products, replace, delete, and so on. Magento uses CSV files (Comma Separated Value) for its data import, allowing data to be saved in a tabular format. CSVs look like a garden-variety spreadsheet but with a .cvs extension. CSV files can be used with almost any spreadsheet program, such as Microsoft Excel or Google Spreadsheets. In today’s guide, we have prepared instructions on how to import products in your e-commerce Magento 2 website. Let’s get into action!

How to Import Products in Magento 2? image

Related How to Install Magento – Beginner’s Guide

What Are the Types of Products in Magento 2?

There six main types of stock that you can find in any e-commerce website or online store. The usage of a specific stock depends on what you are selling and the type of your store. All of them have a unique SKU (stock-keeping unit). The types have different selling rates, and you can use some of them to increase your online store’s sales.

Type #1 – Simple Products in Magento

The simple product is sold only in one variation, and there are no options to choose between. It is the most popular type of stock on the online stores. It has a fixed size, weight, color, etc.

Example of a simple product.

Products in Magento image

Type #2 – Configurable Product

The Configurable stock is a combination of simple stocks. It has variations such as color, size, weight, etc. You can choose between the various options that the configurable goods provide. It is also a trendy type of stock in online stores. Most often, the configurable stock is the cloths.

Example of a Configurable Items.

configurable items image

Type #3 – Virtual Product

This type of product is not a physical item. It can’t be shipped or delivered. The Virtual product can be a service, software, subscription, etc., and it can be purchased online but not received as a good.

Example of a virtual product

virtual product image

Type #4 – Grouped Product

The grouped stock, as you can clue from its name, is nothing more a simple or a virtual attribute value, but both share the same characteristics. Most of the types are the same but different colors. Grouped stocks can increase your sales.

Example of a Grouped Stock.

Grouped Stock image

Type #5 – Bundled Product

The bundles are similar to one category that can be put in a combo or bundle. It is a famous selling trick, which can be found in most of the bigger online stores.

Example of a bundled stocks.

bundled stocks image

Type #6 – Downloadable Product

The downloadable item can be anything that can be download on your computer, such as software, game, file, song, etc.

Example of a downloadable product.

downloadable product image

Import Products in Magento 2 – Step Tour

Step #1 – Data Preparation

To start preparing your data first, you need to ensure that the files you are convented to CSV format. Then you need to go to the admin sidebar and choose System –> Data Transfer –> “Import”.

When you are at the importing settings, you need to set the type of product you want to import.
Go to settings and set “Entity Type” to “products.” After this, click “Download Sample File” and then save to start the downloading.

Next, you need to make sure you have confirmed that your import file’s size does not exceed the limit, which is 2MB.

If in your files includes images, make sure that the image files are uploaded to the appropriate location because, by default, they go in pub/media/import.
magento data preparation image

Step #2 – Import Behavior Configuration

In the behavior section, you need to select the reason for your importing: it can be a new file, update, delete, or replace.
After choosing the import behavior, you need to set the next section to “stop on error.” In the Allowed Errors Count filed, set the number of the error to stop the importing. That is all you need to fill in this section.
Let’s move to the next step.

Import Behavior Configuration image

Step #3 – Import File Identification

Right now, you need to be located in the “select file attachment” section. There click on the “choose file” and choose the file you want to import.
When you are ready with the importing, in the “Images File Directory,” enter the path to the uploaded images on the Magento server, such as “var/import,” or the full URL to the images on another server for example, “”

Import File Identification image

Step #4 – Check and Validate the Import Process

After completing all the steps up to here, you need to check and validate the process. Click on “Check Data” located on the upper-right corner. Then click import, and when everything is ready, you will receive a message.

Essential Howtohosting.Guide Tips

Tip #1 – Optimize the Images

Before uploading an image, is good to optimize it. It’s good to compress the size of the image and set your domain name in its title.
The “alt” attributes are also important for Goole, by giving the image alt attributes you are telling Google that is about.

Tip #2 – Convert to CSV

To importing files requires the CSV conversion. To convert to CSV you can upload the file to a program that supports this format, just like Exel. Then save the file with CSV format type.

Tip #3: Merge and Minify Your Website CSS and JS

To boost the speed of your store you can merge and minify the CSS and JavaScript of it.
Go to System -> Advanced -> Developer, and set ‘Yes’ to Java Script and CSS files. Save your new store configuration.

Tip #4 – gZIP

To accelerate your website on max you can use gZIP compression.
When the gZip compression is enabled, every page is getting compressed by the server before sending it to the visitor. In this way, when the file arrives, it’s decompressed and displayed on the user’s end.

Also Read Тhe Best Themes for Magento 2

Leave a Comment

Your email address will not be published.

This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.