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 Magento 2. Let’s get into action!


Also Read 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 product depends on what you are selling and the type of your store. All of them have a unique SKU (stock-keeping unit). The product 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 a type of product sold only in one variation, and there are no options to choose between. It is the most popular type of product on the online stores. It has a fixed size, weight, color, etc.

Example of a simple product.

Products in Magento

Type #2 – Configurable Product

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

Example of a configurable product.

Products in Magento

Type #3 – Virtual Product

This type of product is not a physical product. 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

Products in Magento

Type #4 – Grouped Product

The grouped product, as you can clue from its name, is nothing more a simple or a virtual product, 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 Product.

Products in Magento

Type #5 – Bundled Product

The bundle products 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 product.

Products in Magento

Type #6 – Downloadable Product

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

Example of a downloadable product.

Products in Magento

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 import 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.



Step #2 – Import Behavior Configuration

In the import behavior section, you need to select the reason for your import: 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 to import. That is all you need to fill in this section.
Let’s move to the next step.




Step #3 – Import File Identification

Right now, you need to be located in the “select file to import” section. There click on the “choose file” and choose the file you want to import.
When you are ready with the import, 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, “http://domain.com/images.”




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 – Covert to CSV

Importing files to Magento 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. Required fields are marked *

Time limit is exhausted. Please reload CAPTCHA.