How To Import Product CSV Magento 2 Step By Step

In this post, we will give you best solution for “Import product CSV Magento 2″ quickly and exactly, please follow these steps in our blog:

* Prepare Data to Import Product CSV Magento 2

Step 1:

Open the Admin panel of your store and go to SYSTEM → Import

Step 2:

Select Products from Entity Type Dropdown and then click on Download Sample File

The downloaded sample file will look like this:

* Import Data Product:

Step 1:

I am going to add only one sample product, so I’ll delete the rest of the sample products. My CSV will now look like this:

Now to add images to the products, add the following rows in your CSV: Base_image, base_image_label, thumbnail_image, thumbnail_image_label, small_image, small_image_label.

Note: Don’t add the rows shown above if they are already given in the sample sheet

Step 2:

Upload all the images of the product in your Magento 2 pub/media/import folder.

Note: Make sure that all the images that you upload have the same name as in CSV.

The final CSV will look like this:

Step 3:

Navigate to SYSTEM → Import from the admin panel, select Products from Entity Dropdown, and Add/Update from Import Behaviour Dropdown. Now upload the CSV file by clicking on choose file and enter /pub/media/import in the Image File Directory text field. Now just click on Check Data.

You will get the following message if you have followed all the steps above correctly. Now click on Import.

Once you get to import successfully, go to PRODUCTS → Catalog and you will see the product with the image:

So to add bulk products in Magento 2, delete all the sample products and add your own by giving it attribute details in the Sample CSV.

Note: Keep the same format as is in the sample sheet.

Congratulation! You’ve imported a big existing Data to your Magento Store. We hope that this blog “How To Import Product CSV Magento 2” will become a help to you!

Here are some new Magento 2 Extensions you may be looking for:

Phuong Pham

Recent Posts

15+ Must-have Magento 2 Free Extensions To Supercharge Your Store In 2025 | Latest updates

Magento 2 is an incredibly flexible and powerful eCommerce platform that can be tailored to…

6 days ago

Black Friday 2024: Hot Deals Collection For Magento 2

Black Friday and Cyber Monday – BFCM 2024 are nearly around the corner, and it’s…

1 week ago

What To Consider While Using Magento 2.0 For Your Streaming App?

When it comes to e-Commerce platforms, undoubtedly Magento 2.0 grabs the spotlight. Magento might not…

1 week ago

Landofcoder BFCM 2024: Biggest Sale Of The Year – 30% OFF All Magento 2 Extensions

The holiday shopping season is here, and there’s no better time to supercharge your Magento…

1 week ago

Top 10 Progressive Web App Development Companies To Elevate Your Business

In today’s digital landscape, the rapid evolution of advanced web applications, particularly Progressive Web Apps…

2 weeks ago

Why Your Retail Business Needs Big Data eCommerce In 2025?

As eCommerce booms, big data eCommerce will be all about providing insight into how to…

2 weeks ago