Thanks for your advice Michael. In my code i have checked every single line of the csv or xls file and make it as list of dictionaries and check the conditions and import single product after importing the single product that i am importing the product related suppliers and then insert another product. If we insert the product one by one, is it taking time to import? Can i use the queries rather than ORM functionality?

While it is certainly possible to use raw querries, using ORM objects is preferable as there might be some unforseen impacts when manipulating the DB directly (Unknown impacts, different modules, etc...). There might also be future changes that might break your import method. However, if you intend to go forward with this kind of scenario, here is how I would suggest you proceed: - Backup database - Import a few objects using ORM method (try to pick a set that goes trought all edge cases you could think of) - Backup this version - Rollback to original backup - Import the same objects using database method - Backup this version - Compare the results from both import methods Doing so, ensures you process the objects closely enough to the original ORM model and that you haven't forgotten anything in the process. The pgsql backups being text based SQL dumps, they sould be easy enough to compare.