As you didn’t answered our last topic “autosync trigger not working (topic 2)”, i’m starting a new topic; (please forget about that topic codes because they have changed).
As we improved our security parameters, we want to use the specific “consumer_key” and “consumer_secret” which we made by woocommerce REST API key generator to use in your sheet instead of those that the sheet makes them.
would you kindly mind remove the auto generated “consumer_key” and “consumer_secret” values from the “setting” page of your sheet and let us set them up manually?
your auto generated values have problem in length and they don’t correctly inserted in wp_woocommerce_api_keys
table (the “consumer_key” doesn’t get hashed).
As far as security is concerned, The “consumer_key” and “consumer_secret” MUST setup by “MAIN ADMIN” users of woocommerce website themselves NOT by your plugin or sheet or etc.
Many thanks again