To update woocommerce products (price, sale price, quantity…), we can use Google sheet as database & Google sheet API to automatically update woocommerce. Below is the workflow: 

Prepare the product template => update the template with real data => upload to woocommerce (manual/API): 

+ Download from woocommerce (export product data – built-in function of woocommerce)

+ Put the template product data to Google sheet

+ Update the product data in Google sheet (edit price, quantity…)

+ Upload edited data to Woocommerce: 

           . For manual upload: Download file from Goolge sheet as csv file (default file downloaded from Google sheet is encoded UTF8 csv file – supported by Woo). Note: Excel doesnt support the encoded utf 8 csv file => Dont use Excel.

           . For API work:

Ref: https://wisdmlabs.com/blog/google-apps-script-fetch-databases-to-google-spreadsheet/