I have a database in which some products and its categories. I would like to create a Magento site using this database with all Magento functionalities. I am using Magento 1.9.x and MySql database. How can I do this? Does anyone have any ideas how I could do that?

1 Answer 1


I think the easiest way is to export a CSV from the existing database according to Magento's CSV structure. Then import that CSV into Magento through the System > Import/Export > Import functionality.

To see the structure you can insert a product in Magento and then export via System > Import/Export > Export functionality.

You can find a good documentation of the Import/Export functionality by Vinai Kopp here: http://netzarbeiter.com/media/MagentoImagine/ImportExport.pdf

Hope it helps.

  • thank you for your reply... What will I do if the external db upadate it's product details?Is it possible to do with REST API?
    – Sruthi
    May 23, 2016 at 9:01
  • in that case you have to perform a regular update; you can both choose to schedule an export and import or implement API integration; it's your choice May 23, 2016 at 9:47
  • But It is not possible to perform regular upadate right... So how can I use REST API in this? I am new to this :(
    – Sruthi
    May 23, 2016 at 9:55
  • I can't explain here how Magento REST API works, please refer to the official documentation and if something doesn't sound clear post a specific question. May 23, 2016 at 10:41
  • Is it possible to display products in Magento site from external db(non Magento db)
    – Sruthi
    May 24, 2016 at 6:15

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.