extraData/MerchantData.py

files = os.listdir(path)
for dataFile in files:
    data = json.load(open(path + dataFile))
    for product in data:
        try:
            for merchant in product["relationships"]["products_compared"]:
                store = Store.objects.filter(name=merchant["attributes"]["merchant"]["report_storename"]).first()
                newMerchant = Merchant()
                newMerchant.name = merchant["attributes"]["merchant"]["name"]
                newMerchant.link = merchant["attributes"]["merchant"]["unique_identifier"]
                newMerchant.store = store
                newMerchant.save()
                print(newMerchant.name)
        except:
            pass