Не могу отправить данные в MySql. Ошибка "Cannot add or update a child row: a foreign key constraint fails"

for item in all_product: 
for items in item: 
name = items[0] 
address =  items[1] 
uuid = items[2] 
stock = items[3] 
id_citt = items[4] 
other_id = items[5] 
sale_date = items[6] 
print(id_citt) 
# Создаем кортеж для вставки в БД 
values_tuple = (id_citt, sale_date, stock, other_id) 
list_tumles.append(values_tuple) 
print(list_tumles) 
#print(values_tuple) 
insert_query = "INSERT INTO main_dnsshopavails (id, date, stock, product_id) VALUES (%s, %s, %s, %s) ON DUPLICATE KEY UPDATE date=VALUES(date), stock=VALUES(stock)" 
# Выполняем SQL-запрос 
 
db = MySQLdb.connect(host=DB_HOST, user=DB_USER, passwd=DB_PASSWORD, db=DB_NAME, connect_timeout=360) 
 
cursor = db.cursor() 
 
cursor.executemany(insert_query, list_tumles) 
 
print("Запрос успешно выполнен.") 
 
 
cursor.connection.commit() 
cursor.close() 
db.close()

list_tumles = []
for item in all_product1:
    name = item[0]
    address =  item[1]
    uuid = item[2]
    stock = item[3]
    id_citt = item[4]
    other_id = item[5]
    date = item[6]
    idsh = item[7]
    print(id_citt)
    # Создаем кортеж для вставки в БД
    values_tuple = (date, stock, other_id, idsh)
    list_tumles.append(values_tuple)
print(list_tumles)
    #print(values_tuple)
insert_query = "INSERT INTO main_dnsshopavails (date, stock, product_id, shop_id) VALUES (%s, %s, %s, %s) ON DUPLICATE KEY UPDATE date=VALUES(date), stock=VALUES(stock)"
db = MySQLdb.connect(host=DB_HOST, user=DB_USER, passwd=DB_PASSWORD, db=DB_NAME, connect_timeout=360)
cursor = db.cursor()
cursor.executemany(insert_query, list_tumles)
 
print("Запрос успешно выполнен.")
 
 
cursor.connection.commit()
cursor.close()
db.close()