My client has been having a lot of problems with this plugin failing to import or sync products. The plugin hangs a lot and will take a long time to even import one product. The import usually never finishes and I have to end it manually. The Square sync actions fail a lot – screenshot: https://prnt.sc/tcRCkcXx8nsS
Is there anything that can be done to improve this? Is there perhaps a way to limit the number of imports per interval? This has been happening since we started using this plugin.
The website is hosted on WP Engine and everything is updated to the lastest version.
The page I need help with: [log in to see the link]
I understand you are facing issues with imports, and the Square sync actions frequently fail.
To troubleshoot this, please share a screenshot of the General Settings page. On that same page, enable the logging option so the plugin can generate logs during the next sync attempt.
Once logging is enabled, try syncing again. Then go to WooCommerce > Status > Logs, locate the Square log, and share it with me via Pastebin.com.
WooCommerce Square is already optimized to handle the sync process most efficiently. There is no need to do anything manually.
Thanks for sharing the screenshots and the log file. The log is quite large, which makes me wonder how many products you have on your site? The logs do not indicate any errors that might affect the sync.
To assist you further, I’d like to review your site’s configuration. Please share your System Status Report by pasting it into https://pastebin.com and sharing the link here.
Also, was the sync working correctly before? If so, when did the issue start?
The sync works sometimes, and this sync seemed to work okay. It has always been an issue since we started using it 6+ months ago. There is more of a problem with importing.
From the screenshot of Scheduled Actions, I see 747 pending actions, and only one action is being processed at a time. This could create a bottleneck.
It’s possible that the sync works smoothly when there are fewer pending actions, but struggles when the queue is larger.
Please open the Pending Actions tab and share a screenshot with me. I would like to review the scheduled actions and check if this behavior is expected.
Once I have reviewed the pending actions, we can revisit the system status report and check if any of the plugins are responsible for those pending actions.
Looking forward to your response. 🙂
This reply was modified 1 year, 1 month ago by Zee. Reason: Rewrite
Somebody said it’s due to product quantity updates which would make sense since products are being imported and/or updated. I cleared the actions, but there were over 700, so maybe that is what is slowing down the syncing.
I tried accessing the screenshot you shared, but it seems to have been deleted. Could you please upload it again?
Many plugins, including WooCommerce, use Scheduled Actions, so the root cause of issues can vary between users.
You mentioned having 102 published products, which isn’t a large number. Could you tell me how often you add or update products? Once I can view the screenshot, I’ll be in a better position to help you further.
Alternatively, you can set up a staging site, disable plugins, and monitor if any actions are still being scheduled. Comparing the staging site with the production site might provide some insights into the problem.
Apologies, I’ve restored that screenshot. My client just has a small gift shop connected to their brewery. We update products via the Square sync since Square is the system of record. That runs every hour.
We add a few new products each month. We haven’t been using the import feature because there are a lot of products for the Brewery’s taproom that they don’t want to sync to the website. So the gift shop manager may add products to Square and Woo manually, then we manually start a sync. We are trying to figure out a way to simplify this process by using the import function for new products.
I am actually working on a staging site, so I can look at those things. Yesterday, I cleared out all the completed and pending actions. When I ran the Square product import again, the pending actions filled back up to 748 and there were a lot of square job runner failures: https://prnt.sc/kGd_PS7x0CU4
Thank you for the explanation and for sharing the screenshot. I’d like us to check a setting in your wp-config.php file.
Please navigate to your hosting control panel, locate your site’s installation folder, and edit the wp-config.php file. Use cmd+f (Mac) or ctrl+f (Windows) to search for the following line:
define('DISABLE_WP_CRON', true);
If this line is present, change the value to false. If it’s not there, you can add it, set it to false, and then save the file. Afterward, go to your Scheduled Actions and try running the failed or pending actions again.
Let me know what you observe after making this change.
We did previously have it set to false, but I changed it a couple days ago. My client uses WPengine which has a toggle for an Alternate Cron which is described to “Replaces wp-cron with more efficient cron job management, improving performance during high-traffic events and ensuring cron tasks are not missed during low-traffic.”
This disables the DISABLE_WP_CRON setting in the wp-config.php file. If anything, it’s worked a bit smoother since enabling this feature. But we do still see the import freezing.
I also do not see a way to rerun failed scheduled actions, only pending ones.
This seems to be working a bit better and I see there’s also a bug fix for the related product transient deletion, which seemed to be part of the problem. I’m going to go ahead and close this.
