Magento bulk product upload Step-by-Step Guideline

product upload tips
Share On :

The web world is doubtlessly fast-moving, and to catch up with this pace, time management has to be done judiciously. For those in eCommerce, shopping cart maintenance may sometimes be a mind-numbing and time-consuming task.

Magento, because of its unique features, is preferred by many online retailers. If upload bulk product in Magento store properly, it can save a lot of time. Here are some great tips for facilitating swift product upload.

We have two ways to add products to Magento stores.

  1. Add products one by one by Magento default
  2. Using excel template, upload bulk products in Magento stores

Let's take a closer look at both methods so you can see the difference.

Adding products one by one manually is very difficult. The best way to add products is by using the bulk product import feature of your ecommerce platform. To know more details about it, please read bulk upload best practices.

Let us check How to bulk upload and export products in Magento 2?

There isn't much difference between Magento 1 and Magento 2. Both platforms offer similar product import features. However, Magento 2 has improved the overall construction and made it more professional. The best idea to export product data files from your Magento store is the easiest method to create CSV template for bulk uploading.

In the export file, Magento will automatically list all the Data type fields like Name, category, options arrangement columns, description, Images, etc.

Using exported template CSV files, you can easily make edits to update existing products or add new products efficiently.

The below steps will help you know how to Export the default CSV import template from your Magento store.

Go to the System section and click on "Export."

magento export import dashboard step 1

In the Entity Type, use the drop-down list to select "Products."

magento 2 export 1

According to the Product Entity Type Section, you can see a list of Entity Attributes.

From here, you can include or exclude any of the entity attributes from the exported file. Once you exclude and have required attributes into the export file, Scroll down to the very bottom of the page and click "Continue."

magento exporting product data

Save the export file wherever you wish to locate it on your PC for easy use.

This is your Magento store importing data file template. Open it. You can see all the required files, product types, data format, additional added attributes, etc. Use this CSV template to add your new products.

It's quite genuine that bulk product upload is always preferred rather than uploading one by one. For a business with several thousands of products to be uploaded, it is in fact impractical. With the bulk import feature, you can upload even thousands of products using CSV file. But proper attention to details has to be given in light of the fact that configurable and simple products may have different layouts.

Please review the following screenshot. You can copy product rows to create a new product entry much more comfortable. The exported file format will help update all the required files, update and manage options, attributes, category columns, etc. This file makes the process of uploading new products very easy.

Here you need to know one important section is Attributes. When you add values in attributes, you need to confirm whether the values are already assigned in Attribute or have a clear idea about the Product Attribute's Catalog Input Type selected with Text Fields.

What is attribute set in Magento?

An attribute set is a collection of attributes (product details) that can be used to create products. Attribute sets allow you to group similar attributes together so that they can be easily applied to products. For example, you could create an attribute set for t-shirts that includes the attributes size, color, and style. This would allow you to easily apply these attributes to all t-shirts in your store.

If attributes are not appropriately managed, there may be a chance to have errors when importing products into the Magento store.

magento 2 default csv template sample

Once done, save your spreadsheet in CSV file format, as Magento does not support XLS or other spreadsheet formats.

Uploading Bulk Products Using the Magento Default Sample Data File

If you check and confirm the file is 100% accurate, you can import your products in bulk.

Go to System and click on the "Import" link.

magento export import dashboard section

Change the Entity Type to "Products" from the drop-down menu.

Magento import settings entity type selection

Click on the Import Behavior drop-down and select "Add/Update." For this tutorial, you'll want to keep all of the other settings as default.

Magento import behavior selection

Now, scroll to the bottom and click the button "Choose File." This will automatically open the explorer window on your computer. Then, you have to find and open the saved file, which consists of updated product information.

Magento File to Import

After you select the file to import, next come to the in the Images File Directory field. Enter the relative path to the location on the Magento server where uploading images are saved.

When it comes to Importing Product Images, it should also be uploaded in volume, and secured FTP should be used for that. Before this process, cross-checking has to be done to assure the correctness of information related to all the products.

Magento Select file to Import

Now, Click the "Check Data" button on the top right. Magento will then scan your spreadsheet to make sure it has a good structure.

Magento Import Check Data

Once Magento confirms no errors in the file, click the "Import" button.

Click on Import button, if no errors

Once the file gets import in Magento, view your newly added products in the Catalog screen. Here, you can make any required edits or other alterations you need.

Magento product catalog management dashboard

The import feature of Magento becomes very useful when you need to add a large number of items at once. It will benefit you to save a lot of your time to list your products one by one. Magento import features are one of the best methods for those who look to open an online store and sell a large number of products.


Intellect Outsource offers seamless ecommerce management services, including bulk ecommerce product data entry & product upload, online store development, virtual assistants, complete product catalog management, online store backend operation, and many more. We are here, ready to start discussing how to help you succeed in the ecommerce business. Ready to work with us?

Get regular ecommerce news directly in your inbox and link with hundreds of ecommerce entrepreneur.