I already have One MySQL database which is not in Magento. I need to Map field 1 by 1 & put into Magento 2 Database.
Need to perform Data Migration from Non Magento DB to Magento 2.
There may be some extra fields attributes will be added for Product & Customer & same way some of them will be removed.
Don't think can use Magento 2 Default Admin Import.
I have below options
- Export Non Magento Database in CSV & Convert it to that CSV in Magento CSV format
- Make a script which fetches data from Non Magento Database & Put Entry in relevant Magento 2 Database Tables.
Major part is Images. Following http://docs.magento.com/m2/ce/user_guide/system/data-import-product-images.html
Customer will provide Zip folder of all images via FTP. They will provide in Product Id/SKU wise format. Need to manage that as well.
Please let me know which is the best method & how to proceed
Magento 2: Product Import Error - Product Type is invalid or not supported. Duplicates found in column names [SOLVED]