How Should the Sample of CSV File for Magento Import Look Like?
Import to database is the most widespread medium of Magento content management. It’s preeminent way of appending new products and information associated to them as well as previously disposed at catalog data renewing. Import of product information is being characterized by bundles of marvellous functions, beneficial for shopkeepers, namely bulk product, image, category, etc upload, precise inventory management, product stock control and so on.
The most prevailing file format, used for data upload, is csv. Though import 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 database import.
From this follows, to succeed in import from csv and get correct results, you are obliged to smartly structurize comma-separated file. Notwithstanding you are going to update content or append new products to shop 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 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 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 upload of vast products amount.
- Get file from vendors. You can ask wholesalers to adjust files, they are sending and make them perfect for 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 import from csv. Nevertheless, the file exported again requires manual changes implementation, as the file, exported by default upload method, is not suitable for transfer 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 upload. In case some fields are missing in the file or improper values are specified, 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 shop”, what is unfamiliar for admin import tool.
Find more info on Store Manager import capabilities - www.mag-manager.com/magento-import