Magento import to database is the most widespread medium of Magento store content management. It’s preeminent way of appending new products and information associated to them as well as previously disposed at Magento store data renewing. Magento data import is being characterized by bundles of marvellous functions, beneficial for Magento store owners, namely bulk product, image, category, etc upload, precise inventory management, product stock control and so on.
The most prevailing file format, used for Magento import, is csv. Though Magento import from csv is defined as the fastest and most workable way of data upload, it can be really tough nut to crack at times. Magento has strict system of requirements to file data structure, what has essential influence on overall csv to Magento import.
From this follows, to succeed in Magento import from csv and get correct results, you are obliged to smartly structurize comma-separated file. Notwithstanding you are going to update Magento store data or append new products to store database, you have to include certain fields to the file you will upload.
Make sure there are the following columns specified in the file:
SKU (unique product identification)
attribute_set (e.g Default, T-Shirts, Computers )
type (e.g simple, configurable)
status (e.g Enabled)
weight (put “1” if you do not use it)
tax_class_id (None or another tax class, listed in drop-down)
In the event if the file contained above enumerated fields, products will be added at backend after csv to Magento upload. To make them visible at frontend, you should include the following columns to file, used for Magento import:
visibility (Catalog, Search)
quantity (this field is obligatory in case you enabled product stock tracking in the administration area)
To carry out csv to Magento appending swimmingly, you should get well-rounded csv file. In what way to do it?
Create the file with required records by yourself. You can rely upon yourself and, keeping in mind, what fields are required for spotless Magento import from csv, add information to spreadsheet. This is quite a reliable way of csv file creating, although can be tedious and tiresome, especially in case you are going to perform Magento import of vast products amount.
Get file from vendors. You can ask wholesalers to adjust files, they are sending and make them perfect for Magento import. Although, you can’t be certain of file correctness, as suppliers, usually, have a lot of clients with different requirements and they are not eager to hang around file data structurizing.
Export data to the file. You can fall back upon data export to csv file. Having exported just one product, you get the file, including database columns, necessary for Magento import from csv. Nevertheless, the file exported again requires manual changes implementation, as the file, exported by default Magento import method, is not suitable for Magento import to database.
Thus, whatever method of file building up you prefer, you are about to face inconveniences, related to distinct system of requirements to Magento import file. To bypass the difficulties and simplify data upload performing, entrust it to Store Manager for Magento desktop application. With this solution you won’t be bound to rigid scheme of csv file organization and will have a possibility to input values immediately in the course of csv Magento import. In case some fields are missing in the file or improper values are specified, Magento user can easily improve the matters with Store Manager application. Furthermore, updating previously appended to database information, you are not obliged to include all the fields, listed above. Indicate only those fields, which you need to renew (e.g product price, quantity) and product identifier (SKU, Name, ID). One more advantage is that, the application supports the scheme “export file – bring changes to data – import data back to store”, what is unfamiliar for Magento admin import tool.
Posted in: Magento