Google Sheet API Error: Invalid data[0]: Unable to parse range: products!AQ

[Antti-Pekka]

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!

[Antti-Pekka]

[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 378

[Antti-Pekka]

[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 350

[Tran]

I have the same error, solved yet?

[Tran]

I think it’s easier if you create 1 sample product then sync back to google sheet, then use that for sync into woocommerce

[Author]

Posts