Import Magento Products Quickly and Safely
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
*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:

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

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

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...

Magento Import: 101 Questions&Answers
Frequently asked questions about Magento import (general questions, errors, categories/images import issues etc). Read More...
Hello!
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.
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.
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)
Hi! I need to create bundle products. Can I import them with your tool?
Hello!
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.
Import works flawlessly. Thanks for the great tool.
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.
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.
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.
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
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!
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/
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