Importing & Exporting Products in Magento Using CSV Files

If you want to make changes to multiple product or customer records, it is often more efficient to do so in a tabular interface, such as a spreadsheet. With Magento Community’s Export and Import tools which resides in System tab, you can do just that. First, you export the data from your store to a spreadsheet file. After you add or update the records in the spreadsheet, you re-import the data back to your store.

Here are the steps for Exporting Data in Magento:

• Go to Import/export -> Data Flow-Profiles Option in the System's tab,Choose option from the List of profiles which shows that what you want to export. In these Case, We are choosing Export all products option.You'll see something like this:

After Clicking On Export All Products Screen will look like below Image:

• Under Profile Information -> Store choose the desired store where you will be importing the products.
• This should also match the store where you have previously created a sample product. Under Data Transfer drop down menu choose Local/Remote Server. 
• Under Data Format make sure CSV / Tab Separated is selected for type and click Save Profile.

•  Then click export all products again and click Run Profile in Popup.

This will save a file named “export_all_products.csv” under the var/export/ directory for your Magento installation. The export success screen will look like this and will specify the filename where the products were exported.

Now we going to see the import part.

Here are the steps for Importing Data in Magento:

• Now you have "export_all_products.csv" file in hand.
• Again,Just Navigate to Import/export -> Data Flow-Profiles Option in the System's tab,Choose option from the List of profiles which shows that what you want to export. In these Case, We are choosing Import all products option.You'll see something like this:

After Clicking On Import All Products Screen will look like below Image:

• Under Profile Information -> Store choose the desired store where you will be importing the products.
• This should also match the store where you have previously created a sample product. Under Data Transfer drop down menu choose Local/Remote Server. 
• Under upload Tab make sure export_all_products file is uploaded.Check the Below Screenshot:

• After Uploading,Just Click on Run Profile Tab.Then select the .csv file you have just uploaded from the drop down menu and click Run Profile in Popup. A status screen will open and the products will start importing.

When the import completes you will get an export success message.

You can now go to the products section of the Magento administrator backend and check the imported products. They will be present there and assigned to the corresponding categories with the attributes you have added for them.