Rating 5 stars - 2 votes

Import Magento Products Quickly and Safely

How to Import Products in Magento 2 - Check detailed tutorial!

Magento product import is a salient and, indisputably, workable means of store data handling. The import tool is extremely important when it comes to product management. Be it new merchandise appending or current ones renewing, you won’t go without the instrument of bulk data upload.

When you have multitude of wares in catalog, new products spin up and you have to arrange them within short span of time, data upload from .csv will come to assistance. One thing should be considered - import of products and associated data is a bulk procedure that can be perilous and impact entire store database. To bypass sudden product transfer mishaps and ensure flawless data appending, you may resort to Store Manager for Magento solution.

Store Manager bestows store owners and shop administrators with easy-to-use and helpful Import/Export utility called Wizard. It consists of several windows within which Magento import settings are being designated. Each and every window is accompanied with guiding clues, so-called prompts that tell you what should be done on this or that step.

As it has been already mentioned, data upload is significant and at the same time risky operation, and, respectively, you should consider a couple of things before starting the import process

  • product import success depends on the file, that undergoes data transfer. What fields are included and how information is organized really matters and influences outcomes
  • Store Manager recognizes files of .csv, .xml, .ods, .xls/xlsx, .txt formats so that if products to be uploaded are accessible in one of these files, you can readily proceed with appending to get the sample of product feed you can simply export several items
  • new products won’t be added to database until all the required by Magento fields are included into file, whereas renovating merchandise you have to provide product identifier (name, SKU, ID, ean code, icecat code, etc) and details you want to update

Below in this article you can find detailed guideline and valuable pieces of advice on Magento product data import

1) In the first place, start up Import Wizard utility in the way that suits you best: via Store -> Import/Export -> Import/Export Products, click on appropriate option on the toolbar or find it in product context menu

Launch Import Wizard in Store Manager
Launch Import Wizard in Store Manager

2) Afterwards you will be instantly transferred to the succeeding window asking you to opt for action to be performed. Correspondingly you have to select Import operation. Note, you may start database backup directly from this window of the wizard utility

Magento Products Import
Magento Products Import

3)Logically, you have to indicate source of the file products will be taken from. These can be local spreadsheets or those disposed at remote location. Once data file source is selected you are to provide path (if this is locally placed file), URL to file or FTP details and file path (if remote feed is used)

Select File for Products  Import
Select File for Products Import

4)Information you are going to upload to database will be represented on this step of Magento import wizard. Make sure correct file separators are designated since improperly set delimiters will negatively influence import results

Set File Delimiters
Set File Delimiters

5)The succeeding stage of product import wizard expects you to designate other settings:

Delimiters for file details - symbol that will be used to detach categories in category tree, images in Image Gallery, information in related fields

Category Options - you may use category ID instead of category path in the course of data import if you check the box of the same name available in this field. Another option allows you to preserve category associations and, if to-be-uploaded merchandise already exist in some categories, leave them in these categories and also place to folders provided in the file

Downloadable Products - on condition that downloadable products should be uploaded you must check this box and indicate local director they have been placed to

Images - not infrequently images are being added in the process of Magento product import. In this case “Import Images” box should be checked and, if these pictures are stored locally, directory containing them is to be indicated

Set Fields Delimiters
Set Fields Delimiters

6) Opt for store view(s) products will be imported to on this step if you have several store views

Select Store View for Products Import
Select Store View for Products Import

7) Base formats (date/time formats and separators) are accessible in subsequent window

Set Date and Time Format
Set Date and Time Format

8)In order product details to be placed to correct database fields, you should set associations between file columns and corresponding fields. Do not forget to opt for identifier by which Magento products will be recognized. If related products (cross-sells, up-sells, related products) are being uploaded, choose identification method for them as well. To input pre-defined values for some fields you, respectively, must click on Set default values button

Products Import Identifiers
Products Import Identifiers

9) Check whether import settings were configured in suitable manner on preview import step and, if everything is OK, continue with import wizard

Preview Import Step
Preview Import Step

10) The last window requires you to carefully designate import options: product upload method (add and modify, updater products only, just add new products or only add); if needed manage merchandise that are not listed in the file (remove these products from Magento database, set them to Out of Stock or disable them), clear product relations (for related product, up-sells, cross-sells, configurable products, grouped, bundle or downloadable products).

There also is the ability run Custom SQL query right after the import is completed.

After you click on the Import button the process of Magento import will start

Import  Methods Step
Import Methods Step

*Product IDs are incremented by Magento system itself, Store Manager does not allow to force ID during import in order to ensure data integrity.

*Global attributes have the same values within all the store views and, correspondingly, can not be updated for specific store view.

*When importing to specific store view, uncheck Default Values Store View box to bypass default values overwriting.

Store Manager for Magento lowers the chance of error occurrence and, at one time, improves product upload providing store owners with advantageous possibilities and makes it more and more flexible.

Import abundance of products accurately with advanced Magento import tool Import Now

Related Articles:

Card image

Sample of CSV File for Magento Import

Get the full list of columns to be included in CSV file for successful import. Read More...

Card image

How to Perform Automated Product Import

Schedule Magento import to be accomplished on hourly, daily or weekly basis using the saved configuration. Read More...

Card image

Products Are Not Showing Up After Magento 2 Import

Most likely reasons why your products are not displayed at the store after the import. Read More...

Card image

Magento Import: 101 Questions&Answers

Frequently asked questions about Magento import (general questions, errors, categories/images import issues etc). Read More...

Maurice Bnnm
Maurice Bnnm • 10/13/2018

Hello, I try to import 17500 products but it's getting really slow after the first 5000 products. It takes 1 minute per product to import. It starts really fast but after 5000 it's getting slow. I tried all different options. (Cache import, Just add, Add only, Accelerate etc.) any idea's ? Thanks! If I cancel the job and start over (check option Add new products) its continue where I stopped the job and it's getting much faster. But the images are not right anymore 🙁

Comment screens
Comment screens

Magento Store ManagerMod Maurice Bnnm • 10/13/2018

Thank you for your question.
The import speed can be related to the type of connection you are using. With the Direct one, it can take more time as there are many requests to the server sent and a lot of factors (such as database size, server performance, internet speed, etc) influent on the import process. You can alternatively setup the Bridge type as it is considered to be faster for massive operations, here is the step by step guide http://store-manager-for-ma.... Regarding the images, please, specify what exactly is not right, so we could advise you on this regard.
Kindly let us know.

Comment screens
Comment screens

Maurice Bnnm
Maurice Bnnm eMagicOne • 10/16/2017

Thanks for the response. I use direct connection with the cache option.
The image problem:
If I stop the import process at for example 10% and take a look in to the catalog all product images are correct. When I start the import process it continues where it stopped (10%) but all images of the second import are not correct anymore. Every single product had a image of an another product.

Magento Store ManagerMod Maurice Bnnm • 10/16/2017

Thank you for clarifying your issue.
In this case, the reason of your issue needs to be checked by the technical specialist to advise you on this regard. Please, contact our Support Center via the email contact@mag-manager.com and attach a couple of details so the tech person could check import settings and reproduce your question from our side, namely: 1) your store configuration file (can be saved at: Store Manager > Preferences(F12) > Database Connection tab > Store Configuration section > Actions... > Save current configuration: http://www.screencast.com/t/imtA1iO6
2) the file you have used for import
3) import configuration file (it can be saved at the last step of import in .cfg format)

kevin • 07/05/2016

Hi! I need to create bundle products. Can I import them with your tool?

Magento Store ManagerMod Kevin • 07/05/2016

Store Manager for Magento supports import of all product types including bundle products. There should be bundled product options arranged in the file, like this article describes - https://www.mag-manager.com.... You should also consider Product Relation Identification method in the import wizard and select the one you use in the import file.

Comment screens
Comment screens

dave • 05/13/2016

Import works flawlessly. Thanks for the great tool.

Marco • 05/05/2016

First thanks for this tutorial .. and I have a question. My store has several store views and I want to add translations for product descriptions. How your application does this? Thanks.

Magento Store ManagerMod Marco • 05/09/2016

Hello, Marco! Glad you are using our application.
Store Manager for Magento supports import per store view and allows you to set product details in various languages, you can easily do it as it's outlined in this tutorial - https://www.mag-manager.com/useful-articles/how-to/how-to-import-products-into-magento-store-views/
On one of import wizard steps you should choose what store view data should be imported to, e.g Chinese, French, Portuguese. The thing you should remember is that, you can import to one store view at a time.

Roger • 04/15/2016

Just testing import. Works greatly.
I want to ask one thing. I have imported products from .csv and now have some new products and want to import them without any changes of existing. Direct how it is done. Thanks.

Magento Store ManagerMod Roger • 04/15/2016

Thank you, Roger.
We are glad, you enjoy using Store Manager.
See, there are import methods, available at "Import Options" step of wizard. If you have existing and new products in one file and, as you have said, want to skip existing, just select ''Add Only" method. New products from the file will be added only. See attached screenshot

Comment screens
Comment screens

tim • 03/30/2016

Hi! Looked through the post, seems like this is nice import tool.
I have a question, besides. If I import products with ) quantity, is it possible to disable them, so they are not be available at the website, until quantity increases. Thanks in advance!

Magento Store ManagerMod Tim • 03/30/2016

Hello, Tim! Thanks for your feedback. If you mean that quantity for your imported products is 0, then you can disable them using expression in the import wizard. See this post about expressions and sample formulae - https://www.mag-manager.com/useful-articles/how-to/how-to-input-missing-data-and-modify-existing-on-the-fly-by-means-of-expressions-in-the-process-of-magento-import/ Whenever you need to increase product quantity and enable them, update these fields with Multi Editor - https://www.mag-manager.com/useful-articles/additional-features/magento-multi-editor/