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/