Square not syncing to WooCommerce

  • Resolved IMD

    (@imd)


    1 year, 9 months ago

    Having similar issues as other recent posts. I just installed the WooCommerce Square plugin yesterday. Put in all the settings per the guide. Imported the products from Square (so products in WooCommerce were pulled fresh from Square, and created in WooCommerce by this plugin). Made a price change to a product in Square. Wanted that new price to be updated in WooCommerce. (I have Square set as the sync setting, so Square is used as the store of record). When sync is finished, all I get is a bunch of errors saying “Product #xxx is excluded from sync as the product type “simple” is unsupported.”

    I’ve been through many many FAQs, troubleshooting lists, checking all the settings. Everything seems to be correct. I’m just puzzled as how the products in Woo are created BY the plugin directly from Square, and then it says the type of product that it created itself is unsupported.

    My Square settings:

    WooCommerce > Status > Get system report
    https://insightmarketingdesign.com/preview/square/system_status.html

    WooCommerce > Status > Log
    Its huge, so would rather not post it. I search in the log for the item that I updated the price in Square, and the new price is indeed reflected in the log. It’s just not translating through the product in WooCommerce.

    Yes, SKUs match, product is set to sync in woocommerce, etc

    • This topic was modified 1 year, 9 months ago by IMD.
Viewing 14 replies - 1 through 14 (of 14 total)

  • I am having the same issue!

    Try to rollback the plugin to the previous version of the plugin. Seems to be an issue with the latest update.

    Thread Starter IMD

    (@imd)

    hollysieck – you are brilliant! I was aware of the Rollback feature but don’t use it often. I can’t believe I didn’t think to try that! It’s all working now. Thanks for the followup!

    Thread Starter IMD

    (@imd)

    I spoke too soon. Mostly it is working, just categories syncing is not. For example, i change the Title of a category in Square, then run a sync in WooCommerce, and the Category Title in WooCommerce is not changed to match the new one that is in Square. This happens with both the manual sync and when doing the “Import New Products” from the Settings page.

    Sigh.

    Reach out to WooCommerce support directly on their website. They are really helpful!

    Hi there @imd ??

    Thank you for contacting Woo support!

    First, apologies for the delay. We have seen a recent influx of tickets and are currently working through a backlog.

    Square not syncing to WooCommerce

    After investigating the information you are sending over, I noticed that your site fails to comply with all requirements (directly linked here) for the WooCommerce Square plugin. Can you make sure it does, while having the latest, version 3.9.0, active, and see if the issue persists, please?

    It will be useful to enable Square sync/connectivity logging?that can be enabled in WooCommerce > Settings > Square.?This logging helps troubleshoot Square sync and connectivity issues, and its log files start with?square.

    Let us know how that goes!

    Thank you for the kind words, @hollysieck! If you have a few minutes, we’d love if you could leave us a review: https://www.ads-software.com/support/plugin/woocommerce-square/reviews/

    I am having the same issue with the Woocommerce Square app. I have rolled it back to 3.8.3 but obviously would like to see it fixed. Is there any information I can provide?

    Thread Starter IMD

    (@imd)

    Thanks for your reply Pepe!

    I was able to get the category syncing “problem” figured out. It wasn’t actually a problem, just my misunderstanding of how it works. I found out there are actually TWO places in Square to create / edit Categories, which I didn’t really comprehend at the time. Turns out that I was editing categories in my Square online ordering page and expecting those changes to sync to my Woo products. That is not the case. I found the other place to manage categories (within the Item Library), and THAT is the place that syncs with the Woo products.

    Regarding having my site meet the requirements of the plugin, it is still in development and not live, so I am unable to put an SSL on it quite yet. That’s the only requirement that my site doesn’t meet. I will make it live so I can put an SSL on it, but put the site in maintenance mode since I don’t want it live yet. I’ll report back what happens!

    Thread Starter IMD

    (@imd)

    Hi again,

    I have made my site live and added an SSL cert to it, confirmed with hosting server admin that background processing is active and working and that all other minimum requirements are met. I updated the WooCommerce Square plugin to latest 3.9.0 and ran a sync. Still get the same errors. Rolled back to version 3.8.3 and ran sync again and everything ran fine without errors.

    For what its worth, when hosting server admin was in there checking the logs, they found this error output:

    [26-Jun-2023 16:01:57 UTC] PHP Warning: foreach() argument must be of type array|object, bool given in {path to folder}/plugins/woocommerce-square/includes/Sync/Records.php on line 96

    Hi @imd

    Thanks for getting back to us with additional information about your issue here.

    I understand that there is a compatibility issue with the WooCommerce Square plugin version 3.9.0 on your site. The issue is not present in version 3.8.3, which suggests the problem may lie with changes introduced in the newer version.

    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.

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

    Thread Starter IMD

    (@imd)

    I updated the plugin to the latest version again, ran a sync and got the error messages again. I did this so I could have fresh errors in the logs if any.

    It shows there are no fatal error logs.

    Heres the system report:

    WordPress Environment

WordPress address (URL): https://lakesideeatsdeli.com
Site address (URL): https://lakesideeatsdeli.com
WC Version: 7.8.1
REST API Version: ? 7.8.1
WC Blocks Version: ? 10.2.4
Action Scheduler Version: ? 3.5.4
Log Directory Writable: ?
WP Version: 6.2.2
WP Multisite: –
WP Memory Limit: 256 MB
WP Debug Mode: –
WP Cron: ?
Language: en_US
External object cache: –

Server Environment

Server Info: LiteSpeed
PHP Version: 8.0.29
PHP Post Max Size: 512 MB
PHP Time Limit: 300
PHP Max Input Vars: 1000
cURL Version: 8.1.2
OpenSSL/1.1.1u

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

Database

WC Database Version: 7.8.1
WC Database Prefix: wpum_
Total Database Size: 10.62MB
Database Data Size: 7.55MB
Database Index Size: 3.07MB
wpum_woocommerce_sessions: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wpum_woocommerce_api_keys: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wpum_woocommerce_attribute_taxonomies: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wpum_woocommerce_downloadable_product_permissions: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
wpum_woocommerce_order_items: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wpum_woocommerce_order_itemmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wpum_woocommerce_tax_rates: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
wpum_woocommerce_tax_rate_locations: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wpum_woocommerce_shipping_zones: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wpum_woocommerce_shipping_zone_locations: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wpum_woocommerce_shipping_zone_methods: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wpum_woocommerce_payment_tokens: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wpum_woocommerce_payment_tokenmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wpum_woocommerce_log: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wpum_actionscheduler_actions: Data: 1.52MB + Index: 0.88MB + Engine InnoDB
wpum_actionscheduler_claims: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wpum_actionscheduler_groups: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wpum_actionscheduler_logs: Data: 1.52MB + Index: 0.47MB + Engine InnoDB
wpum_commentmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wpum_comments: Data: 0.02MB + Index: 0.09MB + Engine InnoDB
wpum_gf_draft_submissions: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wpum_gf_entry: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wpum_gf_entry_meta: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
wpum_gf_entry_notes: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wpum_gf_form: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wpum_gf_form_meta: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wpum_gf_form_revisions: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wpum_gf_form_view: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wpum_gf_rest_api_keys: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wpum_links: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wpum_options: Data: 3.05MB + Index: 0.06MB + Engine InnoDB
wpum_postmeta: Data: 0.22MB + Index: 0.14MB + Engine InnoDB
wpum_posts: Data: 0.09MB + Index: 0.06MB + Engine InnoDB
wpum_posts_BU: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
wpum_termmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wpum_terms: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wpum_term_relationships: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wpum_term_taxonomy: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wpum_usermeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wpum_users: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
wpum_wc_admin_notes: Data: 0.06MB + Index: 0.00MB + Engine InnoDB
wpum_wc_admin_note_actions: Data: 0.06MB + Index: 0.02MB + Engine InnoDB
wpum_wc_category_lookup: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wpum_wc_customer_lookup: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wpum_wc_download_log: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wpum_wc_order_coupon_lookup: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wpum_wc_order_product_lookup: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
wpum_wc_order_stats: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
wpum_wc_order_tax_lookup: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wpum_wc_product_attributes_lookup: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wpum_wc_product_download_directories: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wpum_wc_product_meta_lookup: Data: 0.02MB + Index: 0.09MB + Engine InnoDB
wpum_wc_rate_limits: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wpum_wc_reserved_stock: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wpum_wc_tax_rate_classes: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wpum_wc_webhooks: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wpum_woocommerce_square_customers: Data: 0.05MB + Index: 0.00MB + Engine InnoDB

Post Type Counts

attachment: 34
envira: 2
page: 2
post: 2
product: 35
product_variation: 32
revision: 9
seedprod: 1

Security

Secure connection (HTTPS): ?
Hide errors from visitors: ?

Active Plugins (7)

Gravity Forms: by Gravity Forms – 2.7.9
Coming Soon Page, Maintenance Mode, Landing Pages & WordPress Website Builder by SeedProd: by SeedProd – 6.15.7
Envira Gallery: by Envira Gallery Team – 1.9.7.1
Gravity Forms reCAPTCHA Add-On: by Gravity Forms – 1.1
WooCommerce Square: by WooCommerce – 3.9.0
WooCommerce: by Automattic – 7.8.1
WP Rollback: by GiveWP.com – 1.7.3

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)
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: –
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: ? Page ID is set
but the page does not exist

Cart: ? Page ID is set
but the page does not exist

Checkout: ? Page ID is set
but the page does not exist

My account: ? Page ID is set
but the page does not exist

Terms and conditions: ? Page not set

Theme

Name: Lakeside Eats
Version: (update to version 0 is available)
Author URL: https://insightmarketingdesign.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: –

Admin

Enabled Features: activity-panels
analytics
product-block-editor
coupons
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
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: core-profiler
minified-js
new-product-management-experience
product-variation-management
settings
async-product-editor-category-field

Daily Cron: ? Next scheduled: 2023-06-29 22:46:41 +00:00
Options: ?
Notes: 73
Onboarding: skipped

Action Scheduler

Complete: 3,177
Oldest: 2023-05-30 12:46:30 +0000
Newest: 2023-06-29 13:12:39 +0000

Pending: 2
Oldest: 2023-06-29 13:27:39 +0000
Newest: 2023-06-29 14:14:08 +0000

Status report information

Generated at: 2023-06-29 13:13:27 +00:00
`

    Thanks!

    Hello,

    As a temporary workaround, Can you please roll back the version of Square to the 3.8 to see if this works on your end? You can roll -back any plugin by installing the WP Rollback free plugin.

    Before making any change, please be sure to back up your site.

    Let us know how that goes for you.

    • This reply was modified 1 year, 9 months ago by Igor H.
    Thread Starter IMD

    (@imd)

    Yes, I have the older 3.8 version active for now

    Plugin Support abwaita a11n

    (@abwaita)

    Hi @imd,
    Glad to see that you already downgraded. Our developers have already developed a fix for the issue, and we’re hoping that it’ll come with the next Square update. So, be on the look out for the next version.

Viewing 14 replies - 1 through 14 (of 14 total)
  • The topic ‘Square not syncing to WooCommerce’ is closed to new replies.