ReallyDeeJ

Yes, I tried disconnecting & reconnecting square, many many times… Still no change.

Creating a support ticket now.

I changed the PHP version from 8.2 to 8.1.27, set max post size to 2GB & time limit to 1200 & still no change.

I even re-imported the entire site from staging to production again. The issue is still occurring except now instead of being stuck at 97% it gets stuck at 104% :-\

Looking at the Ajax request that returns the sync status it returns this, the percentage, imported / updated/ skipped products counts don’t change, I can’t see any indication that the sync is actually progressing. Or working at all.

{
“success”: true,
“data”: {
“action”: “sync”,
“id”: “8b235662178f6896e165d8330960c193”,
“job_products_count”: 71,
“percentage”: 104.22535211267605,
“imported_products_count”: 74,
“updated_products_count”: 0,
“skipped_products_count”: 0,
“status”: “processing”
}
}

This site was meant to launch 2 days ago & this is currently holding everything up.

Still no error message or anything useful to give any indication of what the problem may be.

Hey @anastas10s,

Yes, the sync setting is set to Square.

Yes, all the requirements are met:
– PHP 7.4+ – PHP 8.2
– WordPress 5.8+ – WP 6.4.2
– WooCommerce 6.8+ – WC 8.5.1 (just upgraded from 8.4 to see if it made a difference, it didnt)
– A Square account – YES
– An SSL certificate to use the payment gateway – YES
– Background processing to support automatic product sync – YES

I’ve temporarily disabled Wordfence (as that wasn’t enabled on staging when everything was working) but still no change. We do have W3TC caching plugin installed, this was also on staging & we only have static page caching enabled for users who don’t have anything in their cart + JS minification, we’re not doing things like object caching, disabling this plugin also makes no difference. As for the caching setting in that doc you linked, yes we have PHP opcache.save_comments enabled.

As for troubleshooting the sync issues:
– Are SKUs set for your Square and WooCommerce products? YES
– Is the Square product assigned to the Location that’s configured in the plugin settings? YES
– Does your site support background processing? YES

Still stuck in the same spot with a sync that won’t go past 97%, won’t end, won’t give any errors (apache logs, WC logs, nothing…)

And here’s one of the square logs, all 141k+ lines of it – https://gist.github.com/DeeJ/2053ca9619bd795120c73ff95aac5493

• This reply was modified 2 years, 2 months ago by ReallyDeeJ.

Resolved.

We are using Disk: Enhanced for page caching. Although it’s slower than normal (150ms+ vs the 60ms we’re used to).

In Performance > Minify the ‘Rewrite URL structure’ option is not enabled, it’s disabled (the checkbox has disabled=”disabled” so I can’t enable it at all).

Performance > Install doesn’t give me any rewrite rules to use. The install script was actually returning a 500 error as $other_areas was null on line 281 of wp-content/plugins/w3-total-cache/inc/options/install.php. The install page would only properly load after I edited that line to check $other_areas wasn’t empty before running the count($other_areas) on that line.

The .htaccess file is in the site root (in our case /var/www/{sitename}/www/), the same directory that index.php, wp-config.php etc is in.

Unfortunately I can’t publicly post the URL of the site.