Magento Expert Forum - Improve your Magento experience

Results 1 to 10 of 10

How to Import Products in Magento

  1. #1
    Super Moderator linh's Avatar
    Join Date
    Mar 2013
    Posts
    9
    Thanks
    0
    Thanked 2 Times in 2 Posts

    Lightbulb How to Import Products in Magento

    It is rather inconvenient to manually add a large number of products at once to a Magento installation. Inserting products one by one will take a long time especially when you have hundreds or thousands of products.

    In such cases you need an automatic way to add all those products to your Magento online store. We will address all steps you need to take in order to achieve a successful import.

    First, access your Magento administrator backend and go to Catalog -> Manage Categories.


    Create all product categories you will need. You can do so by filling the form displayed below:


    When you fill the form with all the information you like click the Save Category button.


    Bear in mind that at this point you should make note of the newly created category ids. It would be best to save them in a simple text file as you will need them for the import. The category ID will be displayed upon saving the category. It is recommended to make notes as shown below


    If you plan to have additional attributes for the products you are importing you will need to create those via Catalog ->Attributes ->Manage Attributes -> Add new Attribute. You can use this functionality to add all custom attributes that are not present by default in a standard Magento installation. Note also that you can add additional attributes later at the moment you are creating a sample product. It is up to you whether to create the attributes before that or at the point you are creating the first product.

    The next step is to manually add a product to your Magento installation. You will later export this product and use it as a template for importing the large batch. Make sure you include all attributes you will use for the products you are going to import in the sample product. You might want to delete all default products that might be present as you will not need them and then create the new product you will use as a template for the import.

    Once you create the new product and save it it will appear in the products list for your Magento store.



    You are now ready to make the sample export that you will use as a template. In the Magento administrator area go to System -> Import/Export -> Dataflow - Profiles -> Export All Products. 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 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 file name where the products were exported.


    Using an FTP client download this file to your local computer. The file will include columns for each of the attributes you have defined for your products. Open it in a spreadsheet program (MS Excel, Open Office Spreadsheet) and add the products you would like to import. Make sure you are copy/pasting the corresponding attributes in the correct columns. Also here is when you will have to add the category IDs. Use the IDs from the text file you saved earlier and put the corresponding category ID for the products you are adding.

    Once you have accomplished the above go back to the Magento administrator area and choose System -> Import/Export -> Dataflow - Profiles -> Import All Products. Then choose Upload file and browse for the .csv file that you have updated with the products that need to be imported. Once you have uploaded it click Import All Products again, then Run Profile, 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.

    View more threads in the same category:


  2. #2
    Junior Member jaredovi's Avatar
    Join Date
    Mar 2013
    Posts
    68
    Thanks
    2
    Thanked 14 Times in 11 Posts

    Default

    Hi man, why your post include some strange background of product and magento words?

  3. #3
    Moderator shunavi's Avatar
    Join Date
    Mar 2013
    Posts
    124
    Thanks
    9
    Thanked 26 Times in 17 Posts

    Default

    Quote Originally Posted by jaredovi View Post
    Hi man, why your post include some strange background of product and magento words?
    Heheh, maybe you search content and then view post when your search keywords is highlighted.

  4. #4
    New member
    Join Date
    Jun 2013
    Posts
    8
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Default

    We have an application that offers an easier way to import products and addresses some of these issues. You can get more info on it at www.ClaraStream.com and feel free to email me at [email protected] if you have any questions.

  5. #5
    Junior Member
    Join Date
    Sep 2018
    Location
    United Kingdom
    Posts
    635
    Thanks
    0
    Thanked 4 Times in 4 Posts

    Default

    Go to the System section of Magento and click “Import” at the top. On the Entity Type, choose “Products” from the drop down list. Click the link to “Download Sample File” and save it to your computer. This file is a layout of how Magento currently looks at your website.

  6. #6
    Junior Member
    Join Date
    Sep 2018
    Location
    United Kingdom
    Posts
    228
    Thanks
    0
    Thanked 2 Times in 2 Posts

    Default

    Go to the System section of Magento and click “Import” at the top. On the Entity Type, choose “Products” from the drop down list. Click the link to “Download Sample File” and save it to your computer. This file is a layout of how Magento currently looks at your website.

  7. #7
    Junior Member
    Join Date
    Sep 2018
    Location
    Oman, Muscat
    Posts
    2,084
    Thanks
    0
    Thanked 4 Times in 4 Posts

    Default

    Go to the System segment of Magento and snap "Import" at the top. On the Entity Type, pick "Items" starting from the drop list. Snap the connection to "Download Sample File" and spare it to your PC. This record is a design of how Magento as of now takes a gander at your site.

  8. #8
    Junior Member
    Join Date
    Nov 2019
    Posts
    1,083
    Thanks
    6
    Thanked 3 Times in 3 Posts

    Default

    Great post! Thanks for sharing in the community.

  9. #9
    Junior Member
    Join Date
    Sep 2018
    Location
    United Kingdom
    Posts
    635
    Thanks
    0
    Thanked 4 Times in 4 Posts

    Default

    Then upload the product images to the Magento 2 pub/media/import folder. All the uploaded images should have the same name as in the CSV file.
    When the CSV is ready, return to System>Import>Entity Type>Products, choose Add/Update from the Import Behavior drop-down menu:

  10. #10
    Junior Member
    Join Date
    Sep 2018
    Location
    United Kingdom
    Posts
    228
    Thanks
    0
    Thanked 2 Times in 2 Posts

    Default

    Magento 2 import products with images
    Then upload the product images to the Magento 2 pub/media/import folder. All the uploaded images should have the same name as in the CSV file.
    When the CSV is ready, return to System>Import>Entity Type>Products, choose Add/Update from the Import Behavior drop-down menu:

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •