Welcome !! Thanks for visting Intellect Outsource Blog The ultimate ecommerce service providers.

Magento bulk product upload with ease and pace

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, import bulk products in Magento stores

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

Adding products manually one by one in different product types, we have described this in detail in our other blogs. Please review the following blog post.

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

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 export 2

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

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.

Importing Your 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 step 1

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

magento import step 2

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 bulk import step 4

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 bulk import step 3

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 bulk import step 6

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 bulk import step 7

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

magento bulk import step 8

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

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.

ask eCommerce related questions free samples and quick quote

Subscribe to Our Newsletter

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

  

Recent Post