FAILS CONSTANTLY

Hi @cheets_uk

Thanks for reaching out!

We are using square to tie our online shop to our physical shop, we chose square as we were told it worked with woocommerce, it appears it does not.

Why in the logs do we always get this – wc_square_job_runner Failed in the scheduled actions. Its like the square servers cant respond quick enough to feed the website and it times out after 300seconds… 5 minutes!!

When it does work (rarely) it doesn’t remove products that are now gone from the lead system, the POS in the store.

I’m sorry to hear that you’re experiencing issues with the Square integration.

The wc_square_job_runner failed message in the logs usually indicates an interruption in the communication between WooCommerce and Square. This could be due to a number of factors, including server response times, internet connection issues, or plugin conflicts.

I’d like to understand your site properly. Please share with us the necessary information below for us to investigate the issue further:

• System Status Report which you can find via WooCommerce > Status > Get system report > Copy for support.
• Fatal error logs (if any) under WooCommerce > Status > Logs.

You could copy and paste your reply here or paste it via https://gist.github.com/ and send the link here.

After we have the basics working id like to aske why it cant handle image library on products, the POS can, WooCommerce can, why cant this plugin?

I would be happy to assist you, but I am not quite sure I understand your inquiry. Could you please provide additional details or clarify your question, so I can better assist you?

If a screenshot would be helpful, I’d recommend using https://snipboard.io. You can share the direct link to the image as a response to this topic.

Once we have more information, we’ll be able to assist you further.

System Status:

` WordPress Environment

WordPress address (URL): https://archies-empawrium.co.uk
Site address (URL): https://archies-empawrium.co.uk
WC Version: 8.3.1
REST API Version: ? 8.3.1
WC Blocks Version: ? 11.4.9
Action Scheduler Version: ? 3.6.4
Log Directory Writable: ?
WP Version: 6.4.2
WP Multisite: –
WP Memory Limit: 512 MB
WP Debug Mode: –
WP Cron: ?
Language: en_GB
External object cache: – Server Environment

Server Info: Apache
PHP Version: 8.0.30
PHP Post Max Size: 128 MB
PHP Time Limit: 300
PHP Max Input Vars: 2500
cURL Version: 8.1.2
OpenSSL/1.1.1t-fips

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

WC Database Version: 8.3.1
WC Database Prefix: dc_
Total Database Size: 56.96MB
Database Data Size: 34.01MB
Database Index Size: 22.95MB
dc_woocommerce_sessions: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
dc_woocommerce_api_keys: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
dc_woocommerce_attribute_taxonomies: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
dc_woocommerce_downloadable_product_permissions: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
dc_woocommerce_order_items: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
dc_woocommerce_order_itemmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
dc_woocommerce_tax_rates: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
dc_woocommerce_tax_rate_locations: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
dc_woocommerce_shipping_zones: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
dc_woocommerce_shipping_zone_locations: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
dc_woocommerce_shipping_zone_methods: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
dc_woocommerce_payment_tokens: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
dc_woocommerce_payment_tokenmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
dc_woocommerce_log: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
dc_actionscheduler_actions: Data: 5.27MB + Index: 7.38MB + Engine InnoDB
dc_actionscheduler_claims: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
dc_actionscheduler_groups: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
dc_actionscheduler_logs: Data: 5.33MB + Index: 4.89MB + Engine InnoDB
dc_commentmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
dc_comments: Data: 0.02MB + Index: 0.09MB + Engine InnoDB
dc_ctf_feeds_posts: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
dc_ctf_posts: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
dc_links: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
dc_nextend2_image_storage: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
dc_nextend2_section_storage: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
dc_nextend2_smartslider3_generators: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
dc_nextend2_smartslider3_sliders: Data: 0.06MB + Index: 0.03MB + Engine InnoDB
dc_nextend2_smartslider3_sliders_xref: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
dc_nextend2_smartslider3_slides: Data: 0.05MB + Index: 0.11MB + Engine InnoDB
dc_options: Data: 5.09MB + Index: 0.23MB + Engine InnoDB
dc_postmeta: Data: 10.11MB + Index: 7.22MB + Engine InnoDB
dc_posts: Data: 6.30MB + Index: 0.89MB + Engine InnoDB
dc_termmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
dc_terms: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
dc_term_relationships: Data: 0.30MB + Index: 0.19MB + Engine InnoDB
dc_term_taxonomy: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
dc_usermeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
dc_users: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
dc_wc_admin_notes: Data: 0.09MB + Index: 0.00MB + Engine InnoDB
dc_wc_admin_note_actions: Data: 0.09MB + Index: 0.02MB + Engine InnoDB
dc_wc_category_lookup: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
dc_wc_customer_lookup: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
dc_wc_download_log: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
dc_wc_orders: Data: 0.02MB + Index: 0.13MB + Engine InnoDB
dc_wc_orders_meta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
dc_wc_order_addresses: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
dc_wc_order_coupon_lookup: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
dc_wc_order_operational_data: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
dc_wc_order_product_lookup: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
dc_wc_order_stats: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
dc_wc_order_tax_lookup: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
dc_wc_product_attributes_lookup: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
dc_wc_product_download_directories: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
dc_wc_product_meta_lookup: Data: 0.30MB + Index: 0.56MB + Engine InnoDB
dc_wc_rate_limits: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
dc_wc_reserved_stock: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
dc_wc_tax_rate_classes: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
dc_wc_webhooks: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
dc_woocommerce_square_customers: Data: 0.08MB + Index: 0.00MB + Engine InnoDB Post Type Counts

attachment: 1571
custom_css: 1
customize_changeset: 2
et_body_layout: 2
et_footer_layout: 1
et_header_layout: 1
et_pb_layout: 10
et_template: 4
et_theme_builder: 1
nav_menu_item: 16
page: 16
post: 2
product: 1364
product_variation: 1152
revision: 159
shop_coupon: 1
shop_order: 1
wp_global_styles: 1
wpcf7_contact_form: 1
wpz-insta_feed: 1
wpz-insta_user: 1 Security

Secure connection (HTTPS): ?
Hide errors from visitors: ? Active Plugins (9)

Contact Form 7: by Takayuki Miyoshi – 5.8.4
Divi Booster: by Dan Mossop – 4.3.5
Hide Categories and Products for Woocommerce: by N.O.U.S. Open Useful and Simple – 1.2.9
Smart Slider 3: by Nextend – 3.5.1.21
Supreme Modules Lite - Divi Theme, Extra Theme and Divi Builder: by Supreme Modules – 2.5.3
Extra Product Sorting Options for WooCommerce: by SkyVerge – 2.10.0
WooCommerce Square: by WooCommerce – 4.4.0
WooCommerce: by Automattic – 8.3.1 (update to version 8.4.0 is available)
WP Migrate Lite: by WP Engine – 2.6.9 Inactive Plugins (0) Must Use Plugins (2)

StackCache: by Stack CP –
WP Migrate DB Compatibility: by Delicious Brains – 1.2 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)
variation (variation)

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: –
Enforce Approved Product Download Directories: ?
HPOS feature screen enabled: –
HPOS feature enabled: –
Order datastore: WC_Order_Data_Store_CPT
HPOS data sync enabled: – WC Pages

Shop base: #127624 - /store/
Basket: #125976 - /basket/
Checkout: #125977 - /checkout/
My account: #125978 - /my-account/
Terms and conditions: ? Page not set Theme

Name: Archies Empawrium
Version: 1.0.0
Author URL: https://abovemedia.co.uk
Child Theme: ?
Parent Theme Name: Divi
Parent Theme Version: 4.23.1
Parent Theme Author URL: https://www.elegantthemes.com
WooCommerce Support: ? Templates

Overrides: – Square

Environment: Production
Tokenization Enabled: –
Debug Mode: Save to Log Admin

Enabled Features: activity-panels
analytics
product-block-editor
coupons
core-profiler
customer-effort-score-tracks
import-products-task
experimental-fashion-sample-products
shipping-smart-defaults
shipping-setting-tour
homescreen
marketing
mobile-app-banner
navigation
onboarding
onboarding-tasks
product-variation-management
remote-inbox-notifications
remote-free-extensions
payment-gateway-suggestions
shipping-label-banner
subscriptions
store-alerts
transient-notices
woo-mobile-welcome
wc-pay-promotion
wc-pay-welcome-page

Disabled Features: customize-store
minified-js
new-product-management-experience
product-virtual-downloadable
product-external-affiliate
settings
async-product-editor-category-field

Daily Cron: ? Next scheduled: 2023-12-15 15:30:21 +00:00
Options: ?
Notes: 146
Onboarding: skipped Action Scheduler

Complete: 21,945
Oldest: 2023-11-14 13:14:42 +0000
Newest: 2023-12-15 13:11:59 +0000

Failed: 83
Oldest: 2023-09-10 18:38:18 +0100
Newest: 2023-12-10 16:09:42 +0000

In-progress: 1
Oldest: –
Newest: –

Pending: 4
Oldest: 2023-12-15 13:16:01 +0000
Newest: 2023-12-20 16:16:02 +0000 Status report information

Generated at: 2023-12-15 13:12:00 +00:00
`

fatal-errors-2023-12-10-5f2c37831925d02f65192cef47b5ea3d.log –

2023-12-10T12:55:57+00:00 CRITICAL Maximum execution time of 300 seconds exceeded in /home/sites/8b/6/65d885bafb/public_html/wp-content/plugins/woocommerce-square/vendor/apimatic/unirest-php/src/HttpClient.php on line 55

2023-12-10T13:58:03+00:00 CRITICAL Maximum execution time of 300 seconds exceeded in /home/sites/8b/6/65d885bafb/public_html/wp-includes/class-wp-image-editor-imagick.php on line 436

2023-12-10T16:15:42+00:00 CRITICAL Maximum execution time of 300 seconds exceeded in /home/sites/8b/6/65d885bafb/public_html/wp-includes/class-wp-image-editor-imagick.php on line 438

OTHER ERROR:

12-15-2023 @ 00:47:04 - Error: Unable to verify domain archies-empawrium.co.uk - response = Array
(
    [errors] => Array
        (
            [0] => Array
                (
                    [category] => INVALID_REQUEST_ERROR
                    [code] => BAD_REQUEST
                    [detail] => Invalid domain archies-empawrium.co.uk: expected GET https://archies-empawrium.co.uk/.well-known/apple-developer-merchantid-domain-association to return a 200 response code but instead returned 403.
                    [field] => domain_name
                )

        )

Last manual update got to 94% and has froze there for over 12 hours

Hi there @cheets_uk ??

Thank you for reaching back, with further details on this.

From the screenshot shared last (linked here, also, for reference) it appears that:

• 1340 products synced, out of 1364 (per the store’s System Status Report)
• There is an issue identified with enabling Apple Pay (as noted in the fatal errors from December 10), and there is a link for viewing the Square logs, for further details on it. Would you be so kind, and share them here, so we can better understand what is the reason behind?

Note that?Square has two different sets of logging that can be enabled. Payments, under the?WooCommerce > Settings > Checkout > Square?tab. And Sync, under the?WooCommerce > Settings > Integration.

Can you also share the Sync log, so that we can investigate the sync issue further?

We await your response to better assist you.

We are not bothered about Apple pay working on this, it tends to cause more problems with square than it is worth, Payments do work on the website, its the Syncing and updating inventory that is the problem we need to resolve.

As for telling me what the screen shot means, yes I understand that,,, why has it been stuck liker that for over 12 hours once it reached 94%… i suspect this is all to do with squares servers not being able to handle their workload.

So moving forward, and disregarding apple pay which we dont want at this stage … how do we get the syncs to work, and when they do work why dont they remove items that are no longer in the square account?

• This reply was modified 11 months, 2 weeks ago by Cheets_UK.
• This reply was modified 11 months, 2 weeks ago by Cheets_UK.

Hello @cheets_uk,

CRITICAL Maximum execution time of 300 seconds exceeded

It appears that your current PHP time limit (max_execution_time) is causing a bottleneck for these actions to run smoothly.

Can you please try increasing it to approximately 1000-1200 seconds and then try again? Your hosting provider should be able to assist you with this adjustment. :?)

Let us know how it goes!

You are saying this API needs 20 minutes to run??? It already has 5 minutes. That is ridiculous.

• This reply was modified 11 months, 2 weeks ago by Cheets_UK.

Hey, Ive asked…No we can not go beyond FIVE MINUTES execution time, that is a ridiculous request, are you saying this doesn’t work unless you have a dedicated servers? That was not expressed when square signed us up! Why on earth is it taking longer than 5 minutes

You do realise most PHP servers have a max exe time of 30 seconds and we are running at 300 and you want 1200 ??

There is obviously a MAJOR flaw with this plugin and the way its been coded.

• This reply was modified 11 months, 2 weeks ago by Cheets_UK.

So , I can get more execution time if I build a cron / ‘Scheduled Task’ direct into my server CP. … people should not have to do this, you are supposed to install the plugin and it works.

Can you tell me what the cron Command would be to run this?

Hi there @cheets_uk ??

Just for reference, below, I am attaching a screenshot of the settings at a test site of mine.

WooCommerce Square runs without issues, and I’d recommend testing with increasing the PHP time limit, and test, per my colleague’s recommendation.

Should the site’s current hosting provider is not able to accommodate this, feel free to test with Woo Express — available to test for free, for 14 days.

I hope this is helpful! Please let us know if you have any further questions or concerns.
We will be happy to help you further.

Those prices are extremely expensive!! We could get a VPS for far less!!! You are just now blatently trying to upsell your own hosting rather than provide a quality plugin.

Can you tell me what the cron Command would be to run this?

is this it? –

/home/sites/8b/6/65d885bafb/public_html/wp-content/plugins/woocommerce-square/vendor/apimatic/unirest-php/src/HttpClient.php

• This reply was modified 11 months, 2 weeks ago by Cheets_UK.

or can you provide a wget url???

for example… wget -q -O – ‘https://mysite.com/wp-cron.php?doing_wp_cron

Hello @cheets_uk,

Those prices are extremely expensive!! We could get a VPS for far less!!! You are just now blatently trying to upsell your own hosting rather than provide a quality plugin.

I understand your frustration. Just to clarify, we’re not attempting to upsell anything. My colleague was suggesting that you utilize the 14-day trial to test things out ( as a staging environment).

You do realise most PHP servers have a max exe time of 30 seconds and we are running at 300 and you want 1200 ??

Regarding this, you’re correct that 5 minutes is usually sufficient in most cases. However, this also hinges on your server’s performance, specifically its CPU and memory. Additionally, you can always revert back to 300 seconds once you’ve confirmed that the issue is related to your server’s PHP time limit. :?)

So , I can get more execution time if I build a cron / ‘Scheduled Task’ direct into my server CP. … people should not have to do this, you are supposed to install the plugin and it works.

The actions are scheduled via the Action Scheduler package, not WP Cron. You can refer to this documentation to learn more about how it works: Action Scheduler Documentation

Let us know if you have any other questions!

So this says, it asks for 30 seconds and “which is scheduled using WordPress’s built-in?WP-Cron?system”

Can you not tell me what the command is in your own plugin?

The memory is 512 and the max exe is 300, how does the ‘average’ wordpress site accomadte this plugin and its requirements?