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
|
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 |
|
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 |
|
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) |
|
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 |
|
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 |
|
6) Opt for store view(s) products will be imported to on this step if you have several store views |
|
7) Base formats (date/time formats and separators) are accessible in subsequent window |
|
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 |
|
9) Check whether import settings were configured in suitable manner on preview import step and, if everything is OK, continue with import wizard |
|
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 |
|
*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
Further Reading:
- Magento Bundle Products Import
- Update Magento Inventory Having Product SKU and Quantity in the Import File
- Magento Import: Fast, Cheap, High-Quality. Choose Any Two Options
- How to Import Products Avoiding Data Loss
- How to Import Magento Virtual Products
- Required CSV File Values for Error-Free Magento Import via Admin
- How Many Products it is Possible to Import to Magento? Will it Work for a Million of Products?
- How to Import Downloadable Products to Magento
- Sort Magento Products within a Category
- Magento Simple Products. How to Import Simple Products
- How to Assign Multiple Products to Categories
- Magento Import of Large Product Files: Workaround
- How to Fetch and Import Most Recent File into Magento?
- Magento Import: 101 Questions&Answers
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 |
|
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 |
|
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) |
|
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 |
|
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 |
|
6) Opt for store view(s) products will be imported to on this step if you have several store views |
|
7) Base formats (date/time formats and separators) are accessible in subsequent window |
|
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 |
|
9) Check whether import settings were configured in suitable manner on preview import step and, if everything is OK, continue with import wizard |
|
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 |
|
*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
Further Reading:
- Magento Bundle Products Import
- Update Magento Inventory Having Product SKU and Quantity in the Import File
- Magento Import: Fast, Cheap, High-Quality. Choose Any Two Options
- How to Import Products Avoiding Data Loss
- How to Import Magento Virtual Products
- Required CSV File Values for Error-Free Magento Import via Admin
- How Many Products it is Possible to Import to Magento? Will it Work for a Million of Products?
- How to Import Downloadable Products to Magento
- Sort Magento Products within a Category
- Magento Simple Products. How to Import Simple Products
- How to Assign Multiple Products to Categories
- Magento Import of Large Product Files: Workaround
- How to Fetch and Import Most Recent File into Magento?
- Magento Import: 101 Questions&Answers
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 [email protected] 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 🙁