Home › Forums › WooCommerce Google Sync Plugin › Google Sheet API Error: Invalid data[0]: Unable to parse range: products!AQ
- This topic has 4 replies, 2 voices, and was last updated 3 years, 9 months ago by Tran.
-
AuthorPosts
-
February 15, 2021 at 6:55 pm #22496Antti-PekkaParticipant
Hello
I have problems syncing products. Categories sync well from Google sheet to woocommerce, but I cannot Export current categories & products (“Error while syncing-back” notice occurs)
When I sync products from Google Sheets to woocommerce, I get “critical error” warning; however product is still created to woocommerce and can be edited, but the sync status is not updated to 1 in Google sheets and I get error: “Google Sheet API Error: Invalid data[0]: Unable to parse range: products!AQ”
Thank you in Advance!
February 15, 2021 at 8:37 pm #22517Antti-PekkaParticipant[15-Feb-2021 20:10:22 UTC] PHP Fatal error: Uncaught AutomatticWooCommerceHttpClientHttpClientException: JSON ERROR: Syntax error in /var/web/site/public_html/wp-content/plugins/sync-wc-google/lib/woocommerce/vendor/automattic/woocommerce/src/WooCommerce/HttpClient/HttpClient.php:378
PHP Stacktrace:
/var/web/site/public_html/wp-content/plugins/sync-wc-google/lib/woocommerce/vendor/automattic/woocommerce/src/WooCommerce/HttpClient/HttpClient.php(422): Automattic\WooCommerce\HttpClient\HttpClient->processResponse()
/var/web/site/public_html/wp-content/plugins/sync-wc-google/lib/woocommerce/vendor/automattic/woocommerce/src/WooCommerce/Client.php(82): Automattic\WooCommerce\HttpClient\HttpClient->request(‘products’, ‘GET’, Array, Array)
/var/web/site/public_html/wp-content/plugins/sync-wc-google/inc/wc-api.php(365): Automattic\WooCommerce\Client->get(‘products’, Array)
/var/web/site/public_html/wp-content/plugins/sync-wc-google-pro/wc-google-sheet-pro.php(206): WCGS_WC_API->get_products_for_syncback()
/var/web/site/public_html/wp-includes/c in /var/web/site/public_html/wp-content/plugins/sync-wc-google/lib/woocommerce/vendor/automattic/woocommerce/src/WooCommerce/HttpClient/HttpClient.php on line 378February 15, 2021 at 8:40 pm #22518Antti-PekkaParticipant[15-Feb-2021 20:05:30 UTC] PHP Fatal error: Uncaught AutomatticWooCommerceHttpClientHttpClientException: Error:
Sivustolla on ollut kriittinen virhe.
Lue lisää virheiden löytämisestä WordPressissä.
[internal_server_error] in /var/web/site/public_html/wp-content/plugins/sync-wc-google/lib/woocommerce/vendor/automattic/woocommerce/src/WooCommerce/HttpClient/HttpClient.php:350
PHP Stacktrace:
/var/web/site/public_html/wp-content/plugins/sync-wc-google/lib/woocommerce/vendor/automattic/woocommerce/src/WooCommerce/HttpClient/HttpClient.php(386): Automattic\WooCommerce\HttpClient\HttpClient->lookForErrors(Object(stdClass))
/var/web/site/public_html/wp-content/plugins/sync-wc-google/lib/woocommerce/vendor/automattic/woocommerce/src/WooCommerce/HttpClient/HttpClient.php(422): Automattic\WooCommerce\HttpClient\HttpClient->processResponse()
/var/web/site/public_html/wp-content/plugins/sync-wc-google/lib/woocommerce/vendor/automattic/woocommerce/src/WooCommerce in /var/web/site/public_html/wp-content/plugins/sync-wc-google/lib/woocommerce/vendor/automattic/woocommerce/src/WooCommerce/HttpClient/HttpClient.php on line 350March 16, 2021 at 1:14 am #23382TranParticipantI have the same error, solved yet?
March 16, 2021 at 1:25 am #23383TranParticipantI think it’s easier if you create 1 sample product then sync back to google sheet, then use that for sync into woocommerce
-
AuthorPosts
- You must be logged in to reply to this topic.