Dec-27-2020, 02:41 PM
what a fool I was wrong to iterate
def update(id): data = { "stock_quantity": "1" } print(wcapi.put("products/" + id, data).json()) df1 = pd.read_csv('eurogold.csv', index_col=0) df1 = df1.drop_duplicates(['codbar']) # elimina duplicati df1['codbar'] = df1['codbar'].astype(str) print(df1) df2 = pd.read_csv('woo.csv', index_col=0) df2 = df2.dropna().reset_index(drop=True) print(df2) risultato = df2[df2.sku.isin(df1.codbar)].astype(str) for index, row in risultato.iterrows(): update(row['product_id'])