Square Sync Failing & Only Half of Inventory Shows

Hi @lauranvaca

The sync process may be timing out due to the large number of products you’re trying to import from Square. To troubleshoot, I would suggest the following steps:

1. Increase the PHP memory limit and the maximum execution time in your server settings. This could potentially solve the issue if it’s caused by a timeout.
2. Deactivate other plugins temporarily to check if there’s a conflict causing the sync to fail.
3. Check the product data in Square to ensure there are no inconsistencies or missing information that could be causing the sync to fail.

If you’re still experiencing issues after trying these steps, please share a copy of the following:

• System Status Report: Navigate to WooCommerce → Status. Select Get System Report and then Download for Support.
• Fatal Error log: Share a copy of any fatal error log found under WooCommerce → Status → Logs.

You could copy and paste your reply or share it via Mozilla Community Pastebin and share the link here. This will help us investigate further and provide you with a more accurate solution.

I hope this helps! Please let us know how it goes or if you need further assistance.

Hi @shameemreza , Thank you! I tried all 3 suggestions and the sync still gets stuck trying to import products.

Here is the information you requested: https://paste.mozilla.org/BfdAGibc

Hello Lauranvaca

Thank you for your reply.

I reviewed the SSR of your site and noticed that the WP Memory Limit is set to 96 MB.
This amount of memory is too low for WooCommerce to work properly.

I recommend increasing the WP Memory Limit to 512 MB.
You may need to contact your host and ask them to increase the WP Memory Limit.
For more details about server requirements, you can check this documentation.

Let me know if this solves your problem.
I am here for further assistance if needed. ??

Best regards.

Hi There @doublezed2,

Thank you for the suggestion. However, the Sync is still behaving the same way (not starting) even after I made the Memory Limit 512. Could it be the PHP Time limit is 60?

Hi @lauranvaca

Could it be the PHP Time limit is 60?

Yes, you should increase PHP time limit to 1200 and PHP post max size to 2 GB, then disconnect and reconnect your Square account again.

Let us know how that goes. Looking forward to helping you.

Hi ?? We haven’t heard back from you in a while, so I’m going to mark this as resolved – we’ll be here if and/or when you are ready to continue.

I tried the suggestion and adjusted the time etc. I tried to sync again and It’s been several hours now and it at least says “Updated: 100” now. Where it normally would say “0”, but the “Synced products” number hasn’t gone up. It’s also making the page jump every now and then, so it feels like it might be working now? Can’t confirm yet.

https://www.dropbox.com/scl/fi/9xn2ar939ig0fv1ua9icz/Screen-Shot-2024-06-04-at-12.10.47-PM.png?rlkey=exadnn5uxn5j8cpt94lvnhf59&dl=0

I’m going to let this run all day and come back.

Hi @lauranvaca,

Thank you for the additional details. You can keep an eye on the sync process and the logs. Please keep us posted if you have any news!

Cheers!
-OP

Hi there ?? ,

We haven’t heard from you in a while, so I’m going to mark this as resolved. Feel free to start a new thread if you have any more questions.

All the best,
Omar