WooCommerce not syncing from Square
-
I followed the directions and connected my square account. Sync Setting is Square -> WooCommerce
When I hit the “Import all products from square” button, it says:
You are ready to sync products! O products are marked “sync with Square”
So it does not import anything.
How do I fix this?
-
Hi @emotiongear
Thanks for reaching out!
I understand that you are unable to sync products on your site using Square.
I trust that you follow the instructions on this support documentation about WooCommerce Square: Sync Settings, yes?
If so, then please check the troubleshooting tips about Sync Issues.
If still this did not resolve the issue, please share your System Status Report that you can find via
WooCommerce > Status. SelectGet system reportand thenCopy for support. Once you’ve done that, you can paste it into your reply here.If you could also provide the 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.
Thanks!
WordPress Environment WordPress address (URL): https://thefloraculture.com
Site address (URL): https://thefloraculture.com
WC Version: 7.5.1
REST API Version: ✔ 7.5.1
WC Blocks Version: ✔ 9.6.6
Action Scheduler Version: ✔ 3.5.4
Log Directory Writable: ✔
WP Version: 6.2
WP Multisite: –
WP Memory Limit: 768 MB
WP Debug Mode: –
WP Cron: ✔
Language: en_US
External object cache: – Server Environment Server Info: Apache
PHP Version: 7.4.33
PHP Post Max Size: 128 MB
PHP Time Limit: 300
PHP Max Input Vars: 10000
cURL Version: 7.84.0
OpenSSL/1.1.1p SUHOSIN Installed: –
MySQL Version: 5.5.5-10.5.15-MariaDB-cll-lve
Max Upload Size: 128 MB
Default Timezone is UTC: ✔
fsockopen/cURL: ✔
SoapClient: ✔
DOMDocument: ✔
GZip: ✔
Multibyte String: ✔
Remote Post: ✔
Remote Get: ✔ Database WC Database Version: 7.5.1
WC Database Prefix: 2T6lnhB6k_
Total Database Size: 80.46MB
Database Data Size: 65.40MB
Database Index Size: 15.06MB
2T6lnhB6k_woocommerce_sessions: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
2T6lnhB6k_woocommerce_api_keys: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
2T6lnhB6k_woocommerce_attribute_taxonomies: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
2T6lnhB6k_woocommerce_downloadable_product_permissions: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
2T6lnhB6k_woocommerce_order_items: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
2T6lnhB6k_woocommerce_order_itemmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
2T6lnhB6k_woocommerce_tax_rates: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
2T6lnhB6k_woocommerce_tax_rate_locations: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
2T6lnhB6k_woocommerce_shipping_zones: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
2T6lnhB6k_woocommerce_shipping_zone_locations: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
2T6lnhB6k_woocommerce_shipping_zone_methods: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
2T6lnhB6k_woocommerce_payment_tokens: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
2T6lnhB6k_woocommerce_payment_tokenmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
2T6lnhB6k_woocommerce_log: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
2T6lnhB6k_actionscheduler_actions: Data: 10.52MB + Index: 6.38MB + Engine InnoDB
2T6lnhB6k_actionscheduler_claims: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
2T6lnhB6k_actionscheduler_groups: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
2T6lnhB6k_actionscheduler_logs: Data: 4.52MB + Index: 4.03MB + Engine InnoDB
2T6lnhB6k_bwp_lookbook: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
2T6lnhB6k_commentmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
2T6lnhB6k_comments: Data: 0.02MB + Index: 0.09MB + Engine InnoDB
2T6lnhB6k_e_events: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
2T6lnhB6k_gla_attribute_mapping_rules: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
2T6lnhB6k_gla_budget_recommendations: Data: 0.20MB + Index: 0.11MB + Engine InnoDB
2T6lnhB6k_gla_merchant_issues: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
2T6lnhB6k_gla_shipping_rates: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
2T6lnhB6k_gla_shipping_times: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
2T6lnhB6k_links: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
2T6lnhB6k_mailpoet_automations: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
2T6lnhB6k_mailpoet_automation_runs: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
2T6lnhB6k_mailpoet_automation_run_logs: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
2T6lnhB6k_mailpoet_automation_run_subjects: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
2T6lnhB6k_mailpoet_automation_triggers: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
2T6lnhB6k_mailpoet_automation_versions: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
2T6lnhB6k_mailpoet_custom_fields: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
2T6lnhB6k_mailpoet_dynamic_segment_filters: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
2T6lnhB6k_mailpoet_feature_flags: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
2T6lnhB6k_mailpoet_forms: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
2T6lnhB6k_mailpoet_log: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
2T6lnhB6k_mailpoet_migrations: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
2T6lnhB6k_mailpoet_newsletters: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
2T6lnhB6k_mailpoet_newsletter_links: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
2T6lnhB6k_mailpoet_newsletter_option: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
2T6lnhB6k_mailpoet_newsletter_option_fields: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
2T6lnhB6k_mailpoet_newsletter_posts: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
2T6lnhB6k_mailpoet_newsletter_segment: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
2T6lnhB6k_mailpoet_newsletter_templates: Data: 2.52MB + Index: 0.00MB + Engine InnoDB
2T6lnhB6k_mailpoet_scheduled_tasks: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
2T6lnhB6k_mailpoet_scheduled_task_subscribers: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
2T6lnhB6k_mailpoet_segments: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
2T6lnhB6k_mailpoet_sending_queues: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
2T6lnhB6k_mailpoet_settings: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
2T6lnhB6k_mailpoet_statistics_bounces: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
2T6lnhB6k_mailpoet_statistics_clicks: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
2T6lnhB6k_mailpoet_statistics_forms: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
2T6lnhB6k_mailpoet_statistics_newsletters: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
2T6lnhB6k_mailpoet_statistics_opens: Data: 0.02MB + Index: 0.08MB + Engine InnoDB
2T6lnhB6k_mailpoet_statistics_unsubscribes: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
2T6lnhB6k_mailpoet_statistics_woocommerce_purchases: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
2T6lnhB6k_mailpoet_stats_notifications: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
2T6lnhB6k_mailpoet_subscribers: Data: 0.02MB + Index: 0.13MB + Engine InnoDB
2T6lnhB6k_mailpoet_subscriber_custom_field: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
2T6lnhB6k_mailpoet_subscriber_ips: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
2T6lnhB6k_mailpoet_subscriber_segment: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
2T6lnhB6k_mailpoet_subscriber_tag: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
2T6lnhB6k_mailpoet_tags: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
2T6lnhB6k_mailpoet_user_agents: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
2T6lnhB6k_mailpoet_user_flags: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
2T6lnhB6k_options: Data: 14.48MB + Index: 0.64MB + Engine InnoDB
2T6lnhB6k_postmeta: Data: 17.50MB + Index: 1.38MB + Engine InnoDB
2T6lnhB6k_posts: Data: 12.36MB + Index: 0.20MB + Engine InnoDB
2T6lnhB6k_termmeta: Data: 0.05MB + Index: 0.03MB + Engine InnoDB
2T6lnhB6k_terms: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
2T6lnhB6k_term_relationships: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
2T6lnhB6k_term_taxonomy: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
2T6lnhB6k_usermeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
2T6lnhB6k_users: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
2T6lnhB6k_wc_admin_notes: Data: 0.05MB + Index: 0.00MB + Engine InnoDB
2T6lnhB6k_wc_admin_note_actions: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
2T6lnhB6k_wc_category_lookup: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
2T6lnhB6k_wc_customer_lookup: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
2T6lnhB6k_wc_download_log: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
2T6lnhB6k_wc_order_coupon_lookup: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
2T6lnhB6k_wc_order_product_lookup: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
2T6lnhB6k_wc_order_stats: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
2T6lnhB6k_wc_order_tax_lookup: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
2T6lnhB6k_wc_product_attributes_lookup: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
2T6lnhB6k_wc_product_download_directories: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
2T6lnhB6k_wc_product_meta_lookup: Data: 0.02MB + Index: 0.09MB + Engine InnoDB
2T6lnhB6k_wc_rate_limits: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
2T6lnhB6k_wc_reserved_stock: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
2T6lnhB6k_wc_tax_rate_classes: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
2T6lnhB6k_wc_webhooks: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
2T6lnhB6k_woocommerce_square_customers: Data: 1.52MB + Index: 0.00MB + Engine InnoDB Post Type Counts attachment: 369
bwp_footer: 6
bwp_megamenu: 4
customize_changeset: 1
elementor_library: 2
mailpoet_page: 1
nav_menu_item: 47
ourteam: 4
page: 36
post: 15
product: 3
revision: 300
shop_coupon: 1
shop_order: 10
testimonial: 4
wpcf7_contact_form: 5 Security Secure connection (HTTPS): ✔
Hide errors from visitors: ✔ Active Plugins (21) Redux Framework: by Team Redux – 4.4.0
Akismet Anti-Spam: by Automattic – 5.1
Codisto Channel Cloud: by Codisto – 1.3.65
Contact Form 7: by Takayuki Miyoshi – 5.7.5.1
Elementor: by Elementor.com – 3.12.0
Facebook for WooCommerce: by Facebook – 3.0.16
Google Listings and Ads: by WooCommerce – 2.4.2
Hello Dolly: by Matt Mullenweg – 1.7.2
Jetpack: by Automattic – 11.9.1
MailPoet: by MailPoet – 4.10.0
Pinterest for WooCommerce: by WooCommerce – 1.2.16
TikTok: by TikTok – 1.0.16
Under Construction: by WebFactory Ltd – 3.97
Variation Swatches for WooCommerce: by Woosuite – 2.1.8
Widget Importer & Exporter: by ChurchThemes.com – 1.6
WPC Smart Wishlist for WooCommerce: by WPClever – 4.6.3
WooCommerce Payments: by Automattic – 5.6.2
WooCommerce Shipping & Tax: by WooCommerce – 2.2.4
WooCommerce Square: by WooCommerce – 3.6.1
WooCommerce: by Automattic – 7.5.1
Wpbingo Core: by TungHV – 1.0 Inactive Plugins (0) 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)
subscription (subscription)
variable (variable)
variable subscription (variable-subscription) 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: ✔
Order datastore: WC_Order_Data_Store_CPT WC Pages Shop base: #9 - /shop/
Cart: #10 - /cart/
Checkout: #11 - /checkout/
My account: #12 - /my-account/
Terms and conditions: ❌ Page not set Theme Name: Flacio
Version: 1.0.8
Author URL: http://wpbingosite.com/
Child Theme: ❌ – If you are modifying WooCommerce on a parent theme that you did not build personally we recommend using a child theme. See: How to create a child theme
WooCommerce Support: ✔ Templates Overrides: flacio/woocommerce/archive-product.php
flacio/woocommerce/cart/cart-shipping.php
flacio/woocommerce/cart/cart-totals.php
flacio/woocommerce/cart/cart.php
flacio/woocommerce/cart/cross-sells.php
flacio/woocommerce/cart/mini-cart.php
flacio/woocommerce/checkout/form-checkout.php
flacio/woocommerce/checkout/review-order.php
flacio/woocommerce/content-product.php
flacio/woocommerce/content-single-product.php
flacio/woocommerce/loop/add-to-cart.php
flacio/woocommerce/loop/loop-end.php
flacio/woocommerce/loop/loop-start.php
flacio/woocommerce/loop/no-products-found.php
flacio/woocommerce/loop/orderby.php
flacio/woocommerce/loop/pagination.php
flacio/woocommerce/loop/rating.php
flacio/woocommerce/loop/result-count.php
flacio/woocommerce/loop/sale-flash.php
flacio/woocommerce/myaccount/form-login.php
flacio/woocommerce/order/form-tracking.php
flacio/woocommerce/single-product/add-to-cart/external.php
flacio/woocommerce/single-product/add-to-cart/grouped.php
flacio/woocommerce/single-product/add-to-cart/simple.php
flacio/woocommerce/single-product/add-to-cart/variable.php
flacio/woocommerce/single-product/add-to-cart/variation-add-to-cart-button.php
flacio/woocommerce/single-product/price.php
flacio/woocommerce/single-product/product-image.php
flacio/woocommerce/single-product/product-thumbnails.php
flacio/woocommerce/single-product/related.php
flacio/woocommerce/single-product/review.php
flacio/woocommerce/single-product/sale-flash.php
flacio/woocommerce/single-product/short-description.php
flacio/woocommerce/single-product/tabs/additional-information.php
flacio/woocommerce/single-product/tabs/description.php
flacio/woocommerce/single-product/tabs/tabs.php
flacio/woocommerce/single-product/title.php
flacio/woocommerce/single-product/up-sells.php
flacio/woocommerce/single-product-reviews.php
flacio/woocommerce/single-product.php
flacio/woocommerce/content-product_cat.php Subscriptions WCS_DEBUG: ✔ No
Subscriptions Mode: ✔ Live
Subscriptions Live URL: https://thefloraculture.com
Subscriptions-core Library Version: 5.5.0
Subscription Statuses: –
WooCommerce Account Connected: ❌ No Store Setup Country / State: United States (US) — Texas Subscriptions by Payment Gateway Payment Gateway Support WooCommerce Payments: products
refunds
multiple_subscriptions
subscription_cancellation
subscription_payment_method_change_admin
subscription_payment_method_change_customer
subscription_payment_method_change
subscription_reactivation
subscription_suspension
subscriptions
gateway_scheduled_payments
tokenization
add_payment_method Admin Enabled Features: activity-panels
analytics
coupons
customer-effort-score-tracks
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
product-variation-management
settings Daily Cron: ✔ Next scheduled: 2023-03-30 12:12:07 +00:00
Options: ✔
Notes: 49
Onboarding: completed WooCommerce Payments Version: 5.6.2
Connected to WPCOM: Yes
Blog ID: 197693304
Account ID: acct_1MgK2mFzvllobDBD Action Scheduler Complete: 22,321
Oldest: 2023-02-27 12:12:12 +0000
Newest: 2023-03-30 03:59:03 +0000 Failed: 11
Oldest: 2023-02-27 12:14:54 +0000
Newest: 2023-03-22 07:58:39 +0000 Pending: 6
Oldest: 2023-03-30 04:01:03 +0000
Newest: 2023-04-06 02:40:11 +0000 Status report information Generated at: 2023-03-30 04:00:12 +00:00
`Hi @emotiongear
Thanks for sharing the requested information above.
If you could also provide the fatal error logs (if any) under WooCommerce > Status > Logs.
Otherwise, please enable debugging under WooCommerce > Settings > Square > Enable Logging. Then, try to run the sync again and go back to WooCommerce > Status > Logs to copy the logs produced after.
Thanks!
This is the only fatal error:
2023-03-30T02:52:19+00:00 CRITICAL Uncaught Error: Class ‘Extendify\ApiRouter’ not found in /home/theflor1/public_html/wp-content/plugins/redux-framework/extendify-sdk/routes/api.php:34
Stack trace:0 /home/theflor1/public_html/wp-includes/class-wp-hook.php(308): Extendify->{closure}(Object(WP_REST_Server))
1 /home/theflor1/public_html/wp-includes/class-wp-hook.php(332): WP_Hook->apply_filters(NULL, Array)
2 /home/theflor1/public_html/wp-includes/plugin.php(517): WP_Hook->do_action(Array)
3 /home/theflor1/public_html/wp-includes/rest-api.php(577): do_action(‘rest_api_init’, Object(WP_REST_Server))
4 /home/theflor1/public_html/wp-includes/rest-api.php(535): rest_get_server()
5 /home/theflor1/public_html/wp-includes/rest-api.php(2889): rest_do_request(Object(WP_REST_Request))
6 [internal function]: rest_preload_api_request(Array, ‘/wc-analytics/r…’)
7 /home/theflor1/public_html/wp-content/plugins/woocommerce/src/Internal/Admin/Settings.php(145): array_reduce(Array, ‘rest_preload_ap…’)
8 /home/theflor1/public_html/wp-includes/class-w in /home/theflor1/public_html/wp-content/plugins/redux-framework/extendify-sdk/routes/api.php on line 34
The log was a facebook for woocommerce:
02-27-2023 @ 19:24:54 - Unable to detect valid feed configuration: No catalog ID
Also now, for some reason, it imported 87 products (out of about 300).
It did not import any inventory numbers, so they all say OUT OF STOCK
Hi @emotiongear
Thanks for sharing the error logs above. These are not connected to the Square plugin though.
Just to confirm, have you followed the instructions here on how to How to Enable Syncing? You should enable the Sync with Square setting below:
If yes and still the error persists, please try to switch to the default Storefront theme and only WooCommerce and Square plugins are enabled, try to run the sync again and see if this works?
If so, then this kind of problem is usually caused by your theme or a third-party plugin present on your site. We can run a conflict test to verify this. I’d recommend cloning your site to a staging environment and performing the tests described on this guide without modifying your live site or impacting customers. Many hosts provide staging facilities, so it’s worth checking in with them. It’s also possible to do it using the free WP Staging plugin.
If this was caused by a third-party plugin present on your site, it would be best to reach out to the developers for further assistance here.
Let us know how it goes!
Hi @emotiongear
Also now, for some reason, it imported 87 products (out of about 300).
It did not import any inventory numbers, so they all say OUT OF STOCK
I’m glad that sync is running now, however, only 87 products were imported.
Can you please share if there are any patterns or similarities to the products that were not synced?
Please also refer to this section about When I import from Square, some of my products are missing! Where are they? and see if this resolves the issue here.
I cannot see any patterns for the items not synced.
Also, why is it not syncing the inventory numbers, instead of saying OUT OF STOCK for all the items?
I checked the link you gave me and it did not help
Hi,
For better assistance, please contact us at WooCommerce.com > My Account > Support. You may need to create an account before you can access that page.
Please include a link to this forum thread.
We will be glad to help.
The topic ‘WooCommerce not syncing from Square’ is closed to new replies.
