Square Location Name Change Breaks Woocommerce Connection

Hello,

It would be great if you please share a copy of your site’s System Status Report: You can find it via WooCommerce > Status. Select “Get system report” and then “Copy for support”.?

And please share a copy of any fatal error log found under WooCommerce > System Status > Logs (if available).

Looking forward to hearing from you.

WordPress Environment

WordPress address (URL): https://www.evfloraldesign.com
Site address (URL): https://www.evfloraldesign.com
WC Version: 7.2.2
REST API Version: ?</img> 7.2.2
WC Blocks Version: ?</img> 8.9.2
Action Scheduler Version: ?</img> 3.4.0
Log Directory Writable: ?</img>
WP Version: 6.1.1
WP Multisite: –
WP Memory Limit: 768 MB
WP Debug Mode: –
WP Cron: ?</img>
Language: en_US
External object cache: ?</img>

Server Environment

Server Info: Apache
PHP Version: 7.4.33
PHP Post Max Size: 256 MB
PHP Time Limit: 120
PHP Max Input Vars: 3000
cURL Version: 7.66.0
OpenSSL/1.1.1q-fips

SUHOSIN Installed: –
MySQL Version: 5.7.39-42-log
Max Upload Size: 256 MB
Default Timezone is UTC: ?</img>
fsockopen/cURL: ?</img>
SoapClient: ?</img>
DOMDocument: ?</img>
GZip: ?</img>
Multibyte String: ?</img>
Remote Post: ?</img>
Remote Get: ?</img>

Database

WC Database Version: 7.2.2
WC Database Prefix: rqc_
Total Database Size: 21.97MB
Database Data Size: 16.52MB
Database Index Size: 5.45MB
rqc_woocommerce_sessions: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
rqc_woocommerce_api_keys: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
rqc_woocommerce_attribute_taxonomies: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
rqc_woocommerce_downloadable_product_permissions: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
rqc_woocommerce_order_items: Data: 0.08MB + Index: 0.02MB + Engine InnoDB
rqc_woocommerce_order_itemmeta: Data: 0.42MB + Index: 0.41MB + Engine InnoDB
rqc_woocommerce_tax_rates: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
rqc_woocommerce_tax_rate_locations: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
rqc_woocommerce_shipping_zones: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
rqc_woocommerce_shipping_zone_locations: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
rqc_woocommerce_shipping_zone_methods: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
rqc_woocommerce_payment_tokens: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
rqc_woocommerce_payment_tokenmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
rqc_woocommerce_log: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
rqc_actionscheduler_actions: Data: 0.06MB + Index: 0.13MB + Engine InnoDB
rqc_actionscheduler_claims: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
rqc_actionscheduler_groups: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
rqc_actionscheduler_logs: Data: 0.05MB + Index: 0.03MB + Engine InnoDB
rqc_commentmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
rqc_comments: Data: 0.13MB + Index: 0.09MB + Engine InnoDB
rqc_layerslider: Data: 0.05MB + Index: 0.00MB + Engine InnoDB
rqc_layerslider_drafts: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
rqc_layerslider_revisions: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
rqc_links: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
rqc_mailchimp_carts: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
rqc_mailchimp_jobs: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
rqc_nf3_actions: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
rqc_nf3_action_meta: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
rqc_nf3_chunks: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
rqc_nf3_fields: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
rqc_nf3_field_meta: Data: 0.08MB + Index: 0.00MB + Engine InnoDB
rqc_nf3_forms: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
rqc_nf3_form_meta: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
rqc_nf3_objects: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
rqc_nf3_object_meta: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
rqc_nf3_relationships: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
rqc_nf3_upgrades: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
rqc_options: Data: 2.42MB + Index: 0.09MB + Engine InnoDB
rqc_postmeta: Data: 7.52MB + Index: 3.03MB + Engine InnoDB
rqc_posts: Data: 1.52MB + Index: 0.27MB + Engine InnoDB
rqc_rank_math_404_logs: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
rqc_rank_math_analytics_gsc: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
rqc_rank_math_analytics_objects: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
rqc_rank_math_internal_links: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
rqc_rank_math_internal_meta: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
rqc_rank_math_redirections: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
rqc_rank_math_redirections_cache: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
rqc_rank_math_sc_analytics: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
rqc_say_what_strings: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
rqc_sgs_log_events: Data: 1.02MB + Index: 0.00MB + Engine InnoDB
rqc_sgs_log_visitors: Data: 1.52MB + Index: 0.00MB + Engine InnoDB
rqc_smush_dir_images: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
rqc_termmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
rqc_terms: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
rqc_term_relationships: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
rqc_term_taxonomy: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
rqc_usermeta: Data: 0.14MB + Index: 0.14MB + Engine InnoDB
rqc_users: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
rqc_wc_admin_notes: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
rqc_wc_admin_note_actions: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
rqc_wc_category_lookup: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
rqc_wc_customer_lookup: Data: 0.05MB + Index: 0.03MB + Engine InnoDB
rqc_wc_download_log: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
rqc_wc_order_coupon_lookup: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
rqc_wc_order_product_lookup: Data: 0.06MB + Index: 0.06MB + Engine InnoDB
rqc_wc_order_stats: Data: 0.06MB + Index: 0.05MB + Engine InnoDB
rqc_wc_order_tax_lookup: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
rqc_wc_product_attributes_lookup: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
rqc_wc_product_download_directories: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
rqc_wc_product_meta_lookup: Data: 0.02MB + Index: 0.09MB + Engine InnoDB
rqc_wc_rate_limits: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
rqc_wc_reserved_stock: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
rqc_wc_tax_rate_classes: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
rqc_wc_webhooks: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
rqc_woocommerce_square_customers: Data: 0.16MB + Index: 0.00MB + Engine InnoDB
rqc_wpforms_tasks_meta: Data: 0.02MB + Index: 0.00MB + Engine InnoDB

Post Type Counts

attachment: 747
avia_framework_post: 10
fpf_fields: 2
nav_menu_item: 26
nf_sub: 8
page: 15
post: 31
product: 5
product_variation: 16
revision: 34
shop_order: 269
wp_global_styles: 1

Security

Secure connection (HTTPS): ?</img>
Hide errors from visitors: ?</img>

Active Plugins (14)

Query Monitor: by John Blackbourn – 3.11.1
LayerSlider: by Kreatura Media – 7.6.7
Attachment Taxonomies: by Felix Arntz – 1.1.1
Flexible Product Fields PRO: by WP Desk – 2.3.0
Flexible Product Fields: by WP Desk – 2.3.4
AI Powered Marketing: by Kliken – 1.1.0
Ninja Forms: by Saturday Drive – 3.6.14
SiteGround Optimizer: by SiteGround – 7.2.9
SiteGround Security: by SiteGround – 1.3.8
Variation Swatches for WooCommerce: by RadiusTheme – 2.3.3
Woo Store Vacation: by MyPreview – 1.6.0
WooCommerce Delivery & Tax: by WooCommerce – 2.1.1
WooCommerce Square: by WooCommerce – 3.4.2
WooCommerce: by Automattic – 7.2.2

Inactive Plugins (4)

Jetpack: by Automattic – 11.6
Mailchimp for WooCommerce: by Mailchimp – 2.7.6
Rank Math SEO: by Rank Math – 1.0.105
Woosquare Payment: by wpexperts.io – 2.9

Dropin Plugins (3)

advanced-cache.php: advanced-cache.php
db.php: Query Monitor Database Class (Drop-in)
object-cache.php: Memcached

Settings

API Enabled: –
Force SSL: –
Currency: USD ($)
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: ?</img>
Enforce Approved Product Download Directories: –
Order datastore: WC_Order_Data_Store_CPT

WC Pages

Shop base: #780 - /shop/
Cart: #782 - /cart/
Checkout: #784 - /checkout/
My account: #786 - /my-account/
Terms and conditions: ?</img> Page not set

Theme

Name: EV Floral Custom Theme
Version: 1.0.0
Author URL: https://burchinteractive.com
Child Theme: ?</img>
Parent Theme Name: Enfold
Parent Theme Version: 5.3.1.1
Parent Theme Author URL: https://kriesi.at
WooCommerce Support: ?</img>

Templates

Overrides: evfloral2018/woocommerce/cart/cart-totals.php
evfloral2018/woocommerce/checkout/form-shipping.php
evfloral2018/woocommerce/emails/admin-new-order.php

Square

Environment: Production
Tokenization Enabled:
Debug Mode: Off

Admin

Enabled Features: activity-panels
analytics
coupons
customer-effort-score-tracks
experimental-products-task
experimental-import-products-task
experimental-fashion-sample-products
shipping-smart-defaults
shipping-setting-tour
homescreen
marketing
multichannel-marketing
mobile-app-banner
navigation
onboarding
onboarding-tasks
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: minified-js
new-product-management-experience
settings

Daily Cron: ?</img> Next scheduled: 2023-01-05 19:23:56 +00:00
Options: ?</img>
Notes: 21
Onboarding: completed

Action Scheduler

Complete: 87
Oldest: 2022-12-04 23:15:31 +0000
Newest: 2023-01-04 20:34:02 +0000

Failed: 5
Oldest: 2022-10-31 19:59:35 +0000
Newest: 2022-11-28 20:16:56 +0000

Pending: 2
Oldest: 2023-01-05 05:33:39 +0000
Newest: 2023-01-05 18:49:26 +0000

Status report information

Generated at: 2023-01-04 21:56:13 +00:00
`

Hi @darylburch

Thanks for sharing the System Status Report.

Have you tried disconnecting your Square account and reconnecting it again and see if this works? (WooCommerce > Settings > Square > Connection)

Otherwise, please provide the fatal error logs (if any) under WooCommerce > Status > Logs.

Let us know how it goes!

Yes. Disconnected & reconnected. And orders have gone through fine since 12/29. Unfortunately, I didn’t check the logging checkbox until the 29th. So, now logs prior to that.

Hi @darylburch,

Disconnected & reconnected. And orders have gone through fine since 12/29. Unfortunately, I didn’t check the logging checkbox until the 29th. So, now logs prior to that.

Thank you for these details!

I want to make sure we fully understand the situation:

Your client changed their email address, which caused transactions to not be sent to Square. The issue has been fixed now, but there are 16 transactions missing from Square from Nov 11 – Dec 28th. For these 16 transactions, your customers were charged and you have received this money in your bank account. But you do not see these transactions in your Square account.

Is that correct?