Import Products into Magento
January 19, 2013
Add Comment
There’s a little confusion on how to import products into a Magento ecommerce store. I spent some time researching and trying to find the best method on doing this. Magento actually has built a pretty robust import/export mechanism into the ecommerce cms that has a ton of flexibility to do many things. I’m not going to cover all of those. This is just for those of you who simply just want to import products into their Magento Open Sourece.
Step 1 – Add a new product manually After fresh installation
Add a new product manually to the Magento Store, assign it to a category, and fill out all fields that will be necessary to your Magento store. The obvious ones are price, description, quantity etc, It’s important.
Step 2 – Export Your Data
Now we want to export your products data to a .csv file so that we can view the fields that are required to import. Go to System > Import/Export > Profiles. Now click on Export All Products then Run Profile. Click on the “Run Profile in Popup” button. Once the export is completed, go to your var/export directory on your Magento install and you will find the .csv file to download.
Step 3 – Analyze The .CSV File
If you look at your .csv export file you will see the field names that you need to match up. Now just start filling yours in and creating your csv file ready for import. This step is extremely important. Otherwise Magento can't match what you are trying to import and the importing will fail. At a most basic level, here are the fields that I imported:
>> store
>> attribute_set
>> type
>> sku
>> category_ids
>> status
>> visibility
>> tax_class_id
>> weight
>> price
>> name
>> description
Step 4 – Import Your edited .CSV File
Then go to System > Import/Export > Profiles. Now click on Import All Products. Change “Type” under Data Format to CSV/Tab Seperated. Now click on Upload File, and browse for your .csv file and click “Save and Continue Editing”. Now go to “Run Profile” and select your file from the dropdown menu. Click the button underneath to run the import. All your products should now be imported.
It was the easiest most simple approach that I could find for Importing Products into a Magento Open Source Ecommerce Store. I tried this myself and it worked well for me. After that, I updated manually all of my Images and products Quantity.
Hope, you should like this tips.
Step 1 – Add a new product manually After fresh installation
Add a new product manually to the Magento Store, assign it to a category, and fill out all fields that will be necessary to your Magento store. The obvious ones are price, description, quantity etc, It’s important.
Step 2 – Export Your Data
Now we want to export your products data to a .csv file so that we can view the fields that are required to import. Go to System > Import/Export > Profiles. Now click on Export All Products then Run Profile. Click on the “Run Profile in Popup” button. Once the export is completed, go to your var/export directory on your Magento install and you will find the .csv file to download.
Step 3 – Analyze The .CSV File
If you look at your .csv export file you will see the field names that you need to match up. Now just start filling yours in and creating your csv file ready for import. This step is extremely important. Otherwise Magento can't match what you are trying to import and the importing will fail. At a most basic level, here are the fields that I imported:
>> store
>> attribute_set
>> type
>> sku
>> category_ids
>> status
>> visibility
>> tax_class_id
>> weight
>> price
>> name
>> description
Step 4 – Import Your edited .CSV File
Then go to System > Import/Export > Profiles. Now click on Import All Products. Change “Type” under Data Format to CSV/Tab Seperated. Now click on Upload File, and browse for your .csv file and click “Save and Continue Editing”. Now go to “Run Profile” and select your file from the dropdown menu. Click the button underneath to run the import. All your products should now be imported.
It was the easiest most simple approach that I could find for Importing Products into a Magento Open Source Ecommerce Store. I tried this myself and it worked well for me. After that, I updated manually all of my Images and products Quantity.
Hope, you should like this tips.
Genrerating Link.... 15 seconds.
Your Link is Ready.
0 Response to "Import Products into Magento"
Post a Comment