7 Advantages of Import via Store Manager over Magento Admin ImportEach and every merchant who is into e-commerce, sooner or later faces the necessity to input new entities and further update inventory. Due to that fact there raised the necessity for the ways of improving and enhancing default Magento admin import functionality, making it simpler and more approachable for ordinary users without special skills or technical competence. One of such tools is Store Manager for Magento that offers flexible process of product import from .csv. As Magento data import process is considered to be the main source of bringing changes and updating your inline shop with new entities, it is top-most important to automate or skip the steps of file preparation without having to update data long hours. Such procedures like manually adjusting the file or increasing the prices are unnecessary and lead to wasting a lot of time. In this article it will be described why performing Magento import from .csv via Store Manager is more convenient than with the help of Magento admin. So what are the advantages of .cvs spreadsheet upload via Store Manager over admin import?
Magento admin import with its requirements vs Store Manager without any requirements
Magento admin has strict requirements to the file you are going to use for data import. Obviously that your supplier will not provide you with the exactly required file format. You might be lacking of some columns with obligatory information, so most likely you will receive notification that without that info the file cannot be uploaded. Probably all the users have faced this issue while updating goods with admin import tool.On the contrary, Store Manager has more flexible system for data upload and you need only SKU for identification and the data you would like to update or upload. So if you are missing of some column Store Manager for imports .csv properly and the file will be accepted anyway. Below you can find what to do with missing data.
Raw database column names vs user-friendly mapping featureAll column names in your .csv file should fit to attribute codes or database tables that may be unfamiliar to you. For example what type_id field is used for? What data should be placed here? The worst thing is when while Magento admin import, the column names from your .csv file differ from the ones in your database, then .csv file won’t be accepted and the data won’t be uploaded.
Store Manager in its turn, provides its users the names of attributes or fields where the data have to be imported to. In our case unfamiliar type_id field will be named as product type, that is much more clear. Also you will see hints when hovering over the column name to see more detailed explanations. Also there is a possibility to assign columns by indicating from which field to take information and to which database column it should be placed, so the exact match of column names is not required. For example if you have field Recommended Product Price from your supplier to be imported to Magento from .csv, with Store Manager for Magento you will be able to assign it to price field without modifying your file.