Woocommerce not sending inventory and images to sqaure

Here is a snippet of the log which is very long:

body: {
“objects”: [
{
“type”: “ITEM”,
“id”: “4IUJ45L43HS4I633TVPXABTS”,
“updated_at”: “2019-11-28T10:45:37.888Z”,
“version”: 1574937937888,
“is_deleted”: false,
“present_at_all_locations”: false,
“present_at_location_ids”: [
“4PX7H2SWS9SXJ”
],
“item_data”: {
“name”: “Marc Darcy – Eton Navy Tweed Waistcoat”,
“category_id”: “MM4GOVSYLLKOBTN7QOLSL2VT”,
“variations”: [
{
“type”: “ITEM_VARIATION”,
“id”: “3PXU47IDDYYADPKMRYJDJM2Z”,
“updated_at”: “2019-11-28T10:45:37.888Z”,
“version”: 1574937937888,
“is_deleted”: false,
“present_at_all_locations”: false,
“present_at_location_ids”: [
“4PX7H2SWS9SXJ”

system status

### WordPress Environment ###

WordPress address (URL): https://furbellow.co.uk/wp
Site address (URL): https://furbellow.co.uk
WC Version: 3.8.1
REST API Version: ? 1.0.2
Log Directory Writable: ?
WP Version: 5.3
WP Multisite: –
WP Memory Limit: 255 MB
WP Debug Mode: –
WP Cron: –
Language: en_GB
External object cache: ?

### Server Environment ###

Server Info: nginx/1.17.6
PHP Version: 7.3.11
PHP Post Max Size: 128 MB
PHP Time Limit: 180
PHP Max Input Vars: 3000
cURL Version: 7.29.0
NSS/3.36

SUHOSIN Installed: –
MySQL Version: 5.5.5-10.0.38-MariaDB
Max Upload Size: 128 MB
Default Timezone is UTC: ?
fsockopen/cURL: ?
SoapClient: ?
DOMDocument: ?
GZip: ?
Multibyte String: ?
Remote Post: ?
Remote Get: ?

### Database ###

WC Database Version: 3.8.1
WC Database Prefix: wp_
MaxMind GeoIP Database: ?
Total Database Size: 45.93MB
Database Data Size: 27.85MB
Database Index Size: 18.08MB
wp_woocommerce_sessions: Data: 0.08MB + Index: 0.02MB + Engine InnoDB
wp_woocommerce_api_keys: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_woocommerce_attribute_taxonomies: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_woocommerce_downloadable_product_permissions: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
wp_woocommerce_order_items: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_woocommerce_order_itemmeta: Data: 0.08MB + Index: 0.09MB + Engine InnoDB
wp_woocommerce_tax_rates: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
wp_woocommerce_tax_rate_locations: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_woocommerce_shipping_zones: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_woocommerce_shipping_zone_locations: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_woocommerce_shipping_zone_methods: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_woocommerce_payment_tokens: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_woocommerce_payment_tokenmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_woocommerce_log: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_commentmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_comments: Data: 1.05MB + Index: 0.13MB + Engine InnoDB
wp_failed_jobs: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_links: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_mailchimp_carts: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_mailchimp_jobs: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_options: Data: 2.20MB + Index: 0.13MB + Engine InnoDB
wp_postmeta: Data: 15.55MB + Index: 12.00MB + Engine InnoDB
wp_posts: Data: 5.52MB + Index: 3.36MB + Engine InnoDB
wp_queue: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_search_filter_cache: Data: 1.33MB + Index: 0.81MB + Engine InnoDB
wp_search_filter_term_results: Data: 0.11MB + Index: 0.05MB + Engine InnoDB
wp_termmeta: Data: 0.08MB + Index: 0.06MB + Engine InnoDB
wp_terms: Data: 0.06MB + Index: 0.03MB + Engine InnoDB
wp_term_relationships: Data: 0.33MB + Index: 0.19MB + Engine InnoDB
wp_term_taxonomy: Data: 0.06MB + Index: 0.06MB + Engine InnoDB
wp_usermeta: Data: 0.13MB + Index: 0.06MB + Engine InnoDB
wp_users: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
wp_wc_admin_notes: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_wc_admin_note_actions: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_wc_category_lookup: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_wc_customer_lookup: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_wc_download_log: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_wc_order_coupon_lookup: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_wc_order_product_lookup: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
wp_wc_order_stats: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
wp_wc_order_tax_lookup: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_wc_product_meta_lookup: Data: 0.17MB + Index: 0.36MB + Engine InnoDB
wp_wc_tax_rate_classes: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_wc_webhooks: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_wpfingerprint_checksums: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_wpfingerprint_diffs: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_yoast_seo_links: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_yoast_seo_meta: Data: 0.44MB + Index: 0.00MB + Engine InnoDB

### Security ###

Secure connection (HTTPS): ?
Hide errors from visitors: ?

### Active Plugins (18) ###

Advanced Custom Fields PRO: by Elliot Condon – 5.6.7
BirchPress Scheduler Personal: by BirchPress – 2.9.46.P
Classic Editor: by WordPress Contributors – 1.5
Honeypot for Contact Form 7: by Nocean – 1.14.1
Contact Form 7 Extension For Mailchimp: by Renzo Johnson – 0.5.09
Contact Form 7: by Takayuki Miyoshi – 5.1.5
Flamingo: by Takayuki Miyoshi – 2.1
Mailchimp for WooCommerce: by Mailchimp – 2.3 – Not tested with the active version of WooCommerce
Manual Image Crop: by Tomasz Sita – 1.12
Search & Filter Pro: by Code Amp – 2.4.6
Simple Revisions Delete by bweb: by Brice CAPOBIANCO – 1.5
Hosting Tools: by 34SP.com – 2.3.0
Fix for Square Version Mismatch: by John Coy – 0.1.0
WooCommerce Admin: by WooCommerce – 0.22.0
WooCommerce Square: by WooCommerce – 2.0.7
WooCommerce: by Automattic – 3.8.1
Yoast SEO: by Team Yoast – 12.6.1
WP Fingerprint: by 34SP.com – 2.1.2

### Inactive Plugins (1) ###

Coming Soon Page & Maintenance Mode by SeedProd: by SeedProd – 5.1.0

### Dropin Plugins (2) ###

advanced-cache.php: advanced-cache.php
object-cache.php: 34SP.com WP Redis

### Settings ###

API Enabled: –
Force SSL: –
Currency: GBP (￡)
Currency Position: left
Thousand Separator: ,
Decimal Separator: .
Number of Decimals: 2
Taxonomies: Product Types: external (external)
grouped (grouped)
simple (simple)
variable (variable)

Taxonomies: Product Visibility: exclude-from-catalog (exclude-from-catalog)
exclude-from-search (exclude-from-search)
featured (featured)
outofstock (outofstock)
rated-1 (rated-1)
rated-2 (rated-2)
rated-3 (rated-3)
rated-4 (rated-4)
rated-5 (rated-5)

Connected to WooCommerce.com: –

### WC Pages ###

Shop base: #4997 - /shop/
Basket: #4998 - /basket/
Checkout: #4999 - /checkout/
My account: #5000 - /my-account/
Terms and conditions: #516 - /returns-policy/

### Theme ###

Name: 
Version: – 0 is available
Author URL: 
Child Theme: ? – If you are modifying WooCommerce on a parent theme that you did not build
personally we recommend using a child theme. See: How to create a child theme

WooCommerce Support: ?

### Templates ###

Overrides: furbellow/woocommerce/archive-product.php
furbellow/woocommerce/cart/cart.php version 3.5.0 is out of date. The core version is 3.8.0
furbellow/woocommerce/checkout/form-checkout.php
furbellow/woocommerce/checkout/payment.php
furbellow/woocommerce/checkout/thankyou.php version 3.2.0 is out of date. The core version is 3.7.0
furbellow/woocommerce/content-single-product.php
furbellow/woocommerce/global/quantity-input.php
furbellow/woocommerce/loop/no-products-found.php
furbellow/woocommerce/myaccount/form-login.php
furbellow/woocommerce/myaccount/my-account.php
furbellow/woocommerce/product-searchform.php
furbellow/woocommerce/single-product/product-image.php
furbellow/woocommerce/single-product/related.php
furbellow/woocommerce/single-product/up-sells.php

Outdated Templates: ?
					
					
						Learn how to update

### Square ###

Environment: Production
Tokenization Enabled: –
Debug Mode: Off

### Action Scheduler ###

Complete: 135
Oldest: 2019-10-29 01:02:09 +0000
Newest: 2019-11-28 21:45:08 +0000

Pending: 4
Oldest: 2019-11-28 22:20:07 +0000
Newest: 2019-12-05 20:41:36 +0000

Canceled: 15
Oldest: 2019-10-29 15:28:08 +0000
Newest: 2019-12-05 10:40:43 +0000

In-progress: 0
Oldest: –
Newest: –

Failed: 0
Oldest: –
Newest: –

Hi there,

We have had a number of cases where cache was crippling the auto sync. Can you try and remove these:

advanced-cache.php: advanced-cache.php
object-cache.php: 34SP.com WP Redis

Kind regards,

@conschneider How do I go about removing that please?

Hi again,

They will be located in this folder on your server: /wp-content/mu-plugins – you will need FTP.

Also ask your hosting provider how they are implemented. You might also have to comment out some lines in your wp-config.php.

Kind regards,

@conschneider unfortunately this hasn’t worked. If we add one new item all the info goes across but syncing all 479 isn’t working

@conschneider

Could it be something to do with this maximum execution time?

2019-11-19T12:02:59+00:00 CRITICAL Maximum execution time of 180 seconds exceeded in /var/www/vhosts/furbellow.co.uk/httpdocs/wp/wp-includes/class-wp-image-editor-imagick.php on line 355

2019-11-19T12:53:24+00:00 CRITICAL Maximum execution time of 180 seconds exceeded in /var/www/vhosts/furbellow.co.uk/httpdocs/wp/wp-includes/class-wp-image-editor-imagick.php on line 355

2019-11-19T20:37:55+00:00 CRITICAL Uncaught Error: Call to a member function getObjects() on string in /var/www/vhosts/furbellow.co.uk/httpdocs/wp-content/plugins/woocommerce-square/includes/Sync/Manual_Synchronization.php:186
Stack trace:
#0 /var/www/vhosts/furbellow.co.uk/httpdocs/wp-content/plugins/woocommerce-square/includes/Sync/Stepped_Job.php(114): WooCommerce\Square\Sync\Manual_Synchronization->refresh_category_mappings()
#1 /var/www/vhosts/furbellow.co.uk/httpdocs/wp-content/plugins/woocommerce-square/includes/Sync/Stepped_Job.php(55): WooCommerce\Square\Sync\Stepped_Job->do_next_step()
#2 /var/www/vhosts/furbellow.co.uk/httpdocs/wp-content/plugins/woocommerce-square/includes/Handlers/Background_Job.php(172): WooCommerce\Square\Sync\Stepped_Job->run()
#3 /var/www/vhosts/furbellow.co.uk/httpdocs/wp-content/plugins/woocommerce-square/includes/Handlers/Background_Job.php(123): WooCommerce\Square\Handlers\Background_Job->process_job(Object(WooCommerce\Square\Sync\Manual_Synchronization))
#4 /var/www/vhosts/furbellow.co.uk/httpdocs/wp-cont in /var/www/vhosts/furbellow.co.uk/httpdocs/wp-content/plugins/woocommerce-square/includes/Sync/Manual_Synchronization.php on line 186

Hi again,

Could it be something to do with this maximum execution time?

Yes. Based on this log your server times out while processing it’s long job queue. This says: “wp-image-editor-imagick.php occupied me for more than 180 seconds. I am tapping out.” And then WooCommerce Square goes “No power, cannot load my files. Good bye”

This explains why your sync is failing. Your server cannot handle the load and terminates the product sync in midflight.

You need more hardware power.

Kind regards,

Hi there,

We haven’t heard from you in a while so I’ll be marking this thread as resolved.

Feel free to open a new thread and link to this one if you have further questions though.

Have a wonderful day ahead!