It is very inconvenient to add a significant number of products manually -- in a single session -- to a Magento store. When you are adding hundreds or thousands of products one by one, it will take a long time. In that case, you require an easy & automatic process to add all the products to your Magento store. In the following tutorial, we will show you How to Import Products in Magento 1.9.x using a CSV file in Magento. We will discuss all the necessary steps you need to complete a successful import of products.

First of all, create all the categories you will need for products. Keep in mind that you should note down the IDs of the newly created categories. You will require them for the CSV file. If you also have an additional attribute for the products, you will also need to create it.

The next step is to add a product to your Magento installation manually. You will later export this product to a CSV file and use it as a template for importing the large batch. Now it's a time to make and download the sample CSV file that you will use as a template:

Step 1: Login to the Magento Admin Panel.

Step 2: Go to System > Import/Export > Dataflow - Profiles.

Step 3: Tap "Export All Products".

Step 4: Under the "Profile Information" section, select the desired store in the "Store" field where you have previously created a sample product, and you will also be importing the products.

Step 5: Under the "File Information" section, set "Data Transfer" to "Local/Remote Server."

Step 6: Under the "Data Format" section, you make sure to select "CSV / Tab Separated" for "Type."

Step 7: Tap "Save and Continue Edit."

Step 8: In the left menu, click "Run Profile."

Step 9: Tap "Run Profile in Popup" and wait for the process to finish.

The export success screen will specify the exported file name, and it will save the file under the "var/export/" directory. Download the CSV file to your computer. It will include columns for each of the attributes you have defined for your products. Open it using any spreadsheet program like MS Excel or OpenOffice Spreadsheet and use the same sequence to add the products you would like to import.

Once you have finished editing the data in the CSV file, now you are ready to import it back into your Magento store. Follow the few steps below to make it happen:

Step 1: Login back to Magento Admin Panel.

Step 2: Go to System > Import/Export > Dataflow - Profiles.

Step 3: Tap "Import All Products".

Step 4: Make sure you have selected the desired store and CSV file type.

Step 5: In the left menu, click "Upload File." Browse for the updated CSV file that needs to be imported.

Step 6: Tap "Save and Continue Edit."

Step 7: In the left menu, click "Run Profile." Select the CSV file from the drop-down menu.

Step 8: Tap "Run Profile in Popup" and wait for the process to finish.

You can now check the imported products from Magento Admin Panel. They will be present and assigned to the corresponding categories including the attributes you have added for them. If you are facing any issue, you can ask me anytime in the comments section below.