How to Import Products in Magento 2
Do you own a Magento 2 store with a large number of products? Do you wish to add a large database related to the products in your backend? Do you want to update the products data? And, are you lazy just like me?
Look no more, because this post is for you! Get the time-saving method that helps import products in Magento 2.
Magento 2 Import Products CSV: an easy solution to save you from going through all the troubles of managing a large database of products in the backend!
Follow the stepwise method given below and you’re done
Method to Import Products in Magento 2:
- Login to Admin Panel
- Navigate to System > Import.
- Select Products in the Entity Type drop-down and click Download Sample File.
- You’ll get the CSV file like this:
- Choose the sample products you need to import and delete all the odd ones. If you want to import product images, add the next rows to the CSV file:
- Upload the product images to the Magento 2 pub/media/import folder. Make sure that all the uploaded images have the same name as in the CSV file.
- When the CSV is ready, return to System>Import>Entity Type>Products, select Add/Update from the Import Behavior drop-down menu.
- Select the Choose file option and type /pub/media/import in the Image File Directory text field. Then choose the Check Data option.
- After receiving the validation results notification, click Import.
- When the product import is finished go to Catalog > Products and check the products with the images are displayed on the product grid. Don’t forget to make the products live in-store – Enable Product Toggle:
- You can manage all the import and export activities from the Import History tab. For that, navigate to System>Data Transfer>Import History.
If you want to import products with images in bulk, delete all the sample products from the CSV file and insert your own ones with all the attribute details.
With the help of this tutorial, one should be able to import products in Magento 2 easily!
However, doubts regarding the tutorial are welcome in the Comments section below and I’d be happy to help
If this post proves to be a time-saving technique, feel free to rate it with 5 stars
Thank You.
Related Read: Magento 2: Export Products into CSV
2 Comments
Hi Sanjay, this is a really nice post, thanks for that. In many cases the default Magento 2 import functionality used from the backend is not the right solution, especially when it comes to regularly imports, e. g. nightly, with a bigger amount of products. In our projects we use M2IF – https://m2if.com, which is 100 % compatible with the Magento 2 standard CSV format and can simply be combined with CRON to realize automation. Check it out, we are curious to hear from you.
Thanks
Tim
Sure, Tim. Thank you for sharing. Look promising. Will check it out and reach out to you 🙂