Syncing Issues from Square to WooCommerce

I am helping a client get a small shop (100+ products) set up on their new website, and we are trying to sync the products from Square to WooCommerce.

When we sync the products from the plugin’s Square Updates tab, it gets to 88% and stalls. We also get 15-20 Alerts that products are not found in Square, when they actually are. There’s another Alert for two products which says the SKU doesn’t match. We have checked and rechecked the SKUs and they do all match. Many of the product that won’t sync are variable products but only have one variation.

Most products are updating in the background, but we are trying to get these last products synced up. If we try to check Sync with Square from the product page, we get the below error that SKUs are needed, but all these products and variations have unique SKUs and do match what’s in Square.

Product page error: https://postimg.cc/069qq6DW

Other Errors: https://postimg.cc/xq5NrHm7

<br>### WordPress Environment ###<br><br>WordPress address (URL): https://pointbeerstg.wpenginepowered.com<br>Site address (URL): https://pointbeerstg.wpenginepowered.com<br>WC Version: 8.9.3<br>REST API Version: ? 8.9.3<br>Action Scheduler Version: ? 3.7.4<br>Log Directory Writable: ?<br>WP Version: 6.5.4<br>WP Multisite: –<br>WP Memory Limit: 512 MB<br>WP Debug Mode: –<br>WP Cron: ?<br>Language: en_US<br>External object cache: ?<br><br>### Server Environment ###<br><br>Server Info: Apache<br>PHP Version: 8.2.19<br>PHP Post Max Size: 100 MB<br>PHP Time Limit: 3600<br>PHP Max Input Vars: 10000<br>cURL Version: 7.81.0<br>OpenSSL/3.0.2<br><br>SUHOSIN Installed: –<br>MySQL Version: 8.0.36-28<br>Max Upload Size: 50 MB<br>Default Timezone is UTC: ?<br>fsockopen/cURL: ?<br>SoapClient: ?<br>DOMDocument: ?<br>GZip: ?<br>Multibyte String: ?<br>Remote Post: ?<br>Remote Get: ?<br><br>### Database ###<br><br>WC Database Version: 8.9.3<br>WC Database Prefix: wp_<br>Total Database Size: 36.62MB<br>Database Data Size: 23.88MB<br>Database Index Size: 12.74MB<br>wp_woocommerce_sessions: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wp_woocommerce_api_keys: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>wp_woocommerce_attribute_taxonomies: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wp_woocommerce_downloadable_product_permissions: Data: 0.02MB + Index: 0.06MB + Engine InnoDB<br>wp_woocommerce_order_items: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wp_woocommerce_order_itemmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>wp_woocommerce_tax_rates: Data: 0.02MB + Index: 0.06MB + Engine InnoDB<br>wp_woocommerce_tax_rate_locations: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>wp_woocommerce_shipping_zones: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_woocommerce_shipping_zone_locations: Data: 0.02MB + Index: 0.05MB + Engine InnoDB<br>wp_woocommerce_shipping_zone_methods: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_woocommerce_payment_tokens: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wp_woocommerce_payment_tokenmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>wp_woocommerce_log: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wp_accessibility_checker: Data: 0.27MB + Index: 0.02MB + Engine InnoDB<br>wp_actionscheduler_actions: Data: 1.52MB + Index: 3.13MB + Engine InnoDB<br>wp_actionscheduler_claims: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wp_actionscheduler_groups: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wp_actionscheduler_logs: Data: 2.52MB + Index: 2.02MB + Engine InnoDB<br>wp_aioseo_cache: Data: 0.11MB + Index: 0.03MB + Engine InnoDB<br>wp_aioseo_notifications: Data: 0.02MB + Index: 0.06MB + Engine InnoDB<br>wp_aioseo_posts: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wp_commentmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>wp_comments: Data: 0.02MB + Index: 0.09MB + Engine InnoDB<br>wp_ff_scheduled_actions: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_fluentform_draft_submissions: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_fluentform_entry_details: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_fluentform_form_analytics: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_fluentform_form_meta: Data: 0.09MB + Index: 0.00MB + Engine InnoDB<br>wp_fluentform_forms: Data: 0.09MB + Index: 0.00MB + Engine InnoDB<br>wp_fluentform_logs: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_fluentform_order_items: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_fluentform_submission_meta: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_fluentform_submissions: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_fluentform_subscriptions: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_fluentform_transactions: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_jetpack_sync_queue: Data: 0.02MB + Index: 0.06MB + Engine InnoDB<br>wp_links: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wp_novashare_meta: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_options: Data: 3.31MB + Index: 0.08MB + Engine InnoDB<br>wp_postmark_log: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_postmeta: Data: 3.52MB + Index: 1.88MB + Engine InnoDB<br>wp_posts: Data: 2.52MB + Index: 0.23MB + Engine InnoDB<br>wp_sbi_feed_caches: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wp_sbi_feeds: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wp_sbi_instagram_feed_locator: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>wp_sbi_instagram_feeds_posts: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>wp_sbi_instagram_posts: Data: 0.06MB + Index: 0.00MB + Engine InnoDB<br>wp_sbi_sources: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>wp_seopress_content_analysis: Data: 1.52MB + Index: 0.02MB + Engine InnoDB<br>wp_seopress_significant_keywords: Data: 0.08MB + Index: 0.09MB + Engine InnoDB<br>wp_shortpixel_folders: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wp_shortpixel_meta: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wp_shortpixel_postmeta: Data: 2.52MB + Index: 0.83MB + Engine InnoDB<br>wp_shortpixel_queue: Data: 0.11MB + Index: 0.11MB + Engine InnoDB<br>wp_sib_model_forms: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_sib_model_users: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_simple_history: Data: 0.30MB + Index: 0.19MB + Engine InnoDB<br>wp_simple_history_contexts: Data: 3.52MB + Index: 2.03MB + Engine InnoDB<br>wp_term_relationships: Data: 0.08MB + Index: 0.06MB + Engine InnoDB<br>wp_term_taxonomy: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>wp_termmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>wp_terms: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>wp_usermeta: Data: 0.05MB + Index: 0.03MB + Engine InnoDB<br>wp_users: Data: 0.02MB + Index: 0.05MB + Engine InnoDB<br>wp_wc_admin_note_actions: Data: 0.05MB + Index: 0.02MB + Engine InnoDB<br>wp_wc_admin_notes: Data: 0.05MB + Index: 0.00MB + Engine InnoDB<br>wp_wc_category_lookup: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_wc_customer_lookup: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>wp_wc_download_log: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>wp_wc_order_addresses: Data: 0.02MB + Index: 0.06MB + Engine InnoDB<br>wp_wc_order_coupon_lookup: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>wp_wc_order_operational_data: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>wp_wc_order_product_lookup: Data: 0.02MB + Index: 0.06MB + Engine InnoDB<br>wp_wc_order_stats: Data: 0.02MB + Index: 0.05MB + Engine InnoDB<br>wp_wc_order_tax_lookup: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>wp_wc_orders: Data: 0.02MB + Index: 0.11MB + Engine InnoDB<br>wp_wc_orders_meta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>wp_wc_product_attributes_lookup: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wp_wc_product_download_directories: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wp_wc_product_meta_lookup: Data: 0.06MB + Index: 0.09MB + Engine InnoDB<br>wp_wc_rate_limits: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wp_wc_reserved_stock: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_wc_tax_rate_classes: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wp_wc_webhooks: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wp_woocommerce_square_customers: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_wpgb_cards: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>wp_wpgb_facets: Data: 0.02MB + Index: 0.05MB + Engine InnoDB<br>wp_wpgb_grids: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>wp_wpgb_index: Data: 0.11MB + Index: 0.16MB + Engine InnoDB<br>wp_wpgb_styles: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>wp_wt_iew_action_history: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_wt_iew_mapping_template: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br><br>### Post Type Counts ###<br><br>acf-field: 60<br>acf-field-group: 8<br>acf-post-type: 5<br>acf-taxonomy: 3<br>acf-ui-options-page: 1<br>attachment: 725<br>award: 9<br>beer: 11<br>custom_css: 1<br>event: 2<br>gblocks_global_style: 3<br>gblocks_templates: 56<br>gp_elements: 26<br>nav_menu_item: 45<br>page: 19<br>popup: 1<br>popup_theme: 8<br>post: 4<br>product: 135<br>product_variation: 273<br>soda: 8<br>wholesale: 20<br>wp_navigation: 4<br>wp-help: 3<br><br>### Security ###<br><br>Secure connection (HTTPS): ?<br>Hide errors from visitors: ?<br><br>### Active Plugins (32) ###<br><br>Accessibility New Window Warnings: by Equalize Digital – 1.0.8<br>Advanced Custom Fields PRO: by WP Engine – 6.3.1.2<br>Advanced Database Cleaner: by Younes JFR. – 3.1.4<br>Age Gate: by Phil Baker – 3.4.0<br>Beer Finder Gutenberg Block: by WPCenter – 1.3.3<br>Better Search Replace: by WP Engine – 1.4.7<br>Cache Enabler: by KeyCDN – 1.8.15<br>Fluent Forms: by Contact Form - WPManageNinja LLC – 5.1.18<br>Fluent Forms Pro Add On Pack: by Fluent Forms – 5.1.18<br>GenerateBlocks Pro: by Tom Usborne – 1.7.0<br>GenerateBlocks: by Tom Usborne – 1.9.1<br>GP Premium: by Tom Usborne – 2.4.1<br>HappyFiles Pro: by Codeer – 1.8.3<br>Smash Balloon Instagram Feed: by Smash Balloon – 6.3.1<br>Newsletter, SMTP, Email marketing and Subscribe forms by Brevo: by Brevo – 3.1.80<br>Perfmatters: by forgemedia – 2.3.0<br>Popup Maker: by Popup Maker – 1.19.0<br>ActiveCampaign Postmark (Official): by Andrew Yates & Matt Gibbs – 1.20.0<br>Qi Blocks: by Qode Interactive – 1.3<br>ShortPixel Image Optimizer: by ShortPixel - Convert WebP/AVIF & Optimize Images – 5.6.2<br>Simple History: by P?r Thernstr?m – 4.15.1<br>Simple Page Ordering: by 10up – 2.7.1<br>Variation Swatches for WooCommerce: by CartFlows – 1.0.8<br>WooCommerce.com Update Manager: by Automattic – 1.0.2<br>WooCommerce Shipping & Tax: by WooCommerce – 2.6.0<br>WooCommerce USPS Shipping: by WooCommerce – 4.9.0<br>WooCommerce Square: by WooCommerce – 4.6.2<br>WooCommerce: by Automattic – 8.9.3<br>WP Grid Builder: by Lo?c Blascos – 2.0.3<br>WP Help: by Mark Jaquith – 1.7.5<br>SEOPress PRO: by The SEO Guys at SEOPress – 7.8<br>SEOPress: by The SEO Guys at SEOPress – 7.8<br><br>### Inactive Plugins (0) ###<br><br><br>### Dropin Plugins () ###<br><br>advanced-cache.php: advanced-cache.php<br>object-cache.php: Memcached<br><br>### Must Use Plugins (5) ###<br><br>Force Strong Passwords - WPE Edition: by Jason Cosper – 1.8.0<br>WP Engine Cache Plugin: by WP Engine – 1.3.0<br>WP Engine Seamless Login Plugin: by WP Engine – 1.6.1<br>WP Engine Security Auditor: by wpengine – 1.1.1<br>WP Engine System: by WP Engine – 5.0.1<br><br>### Settings ###<br><br>API Enabled: –<br>Force SSL: –<br>Currency: USD ($)<br>Currency Position: left<br>Thousand Separator: ,<br>Decimal Separator: .<br>Number of Decimals: 2<br>Taxonomies: Product Types: external (external)<br>grouped (grouped)<br>simple (simple)<br>variable (variable)<br><br>Taxonomies: Product Visibility: exclude-from-catalog (exclude-from-catalog)<br>exclude-from-search (exclude-from-search)<br>featured (featured)<br>outofstock (outofstock)<br>rated-1 (rated-1)<br>rated-2 (rated-2)<br>rated-3 (rated-3)<br>rated-4 (rated-4)<br>rated-5 (rated-5)<br><br>Connected to WooCommerce.com: ?<br>Enforce Approved Product Download Directories: ?<br>HPOS feature enabled: ?<br>Order datastore: Automattic\WooCommerce\Internal\DataStores\Orders\OrdersTableDataStore<br>HPOS data sync enabled: –<br><br>### Logging ###<br><br>Enabled: ?<br>Handler: Automattic\WooCommerce\Internal\Admin\Logging\LogHandlerFileV2<br>Retention period: 30 days<br>Level threshold: –<br>Log directory size: 80 MB<br><br>### WC Pages ###<br><br>Shop base: #36404 - /shop/<br>Cart: ? Page does not contain the [woocommerce_cart] shortcode or the woocommerce/cart block.<br>Checkout: ? Page does not contain the [woocommerce_checkout] shortcode or the woocommerce/checkout block.<br>My account: #35609 - /my-account/<br>Terms and conditions: ? Page ID is set<br>but the page does not exist<br><br><br>### Theme ###<br><br>Name: GeneratePress Child<br>Version: 0.1<br>Author URL: https://tomusborne.com<br>Child Theme: ?<br>Parent Theme Name: GeneratePress<br>Parent Theme Version: 3.4.0<br>Parent Theme Author URL: https://tomusborne.com<br>WooCommerce Support: ?<br><br>### Templates ###<br><br>Overrides: –<br><br>### Square ###<br><br>Environment: Production<br>Tokenization Enabled: ?<br>Debug Mode: Off<br><br>### Cash App Pay (Square) ###<br><br>Environment: Production<br>Debug Mode: Off<br><br>### Admin ###<br><br>Enabled Features: activity-panels<br>analytics<br>product-block-editor<br>coupons<br>core-profiler<br>customize-store<br>customer-effort-score-tracks<br>import-products-task<br>experimental-fashion-sample-products<br>shipping-smart-defaults<br>shipping-setting-tour<br>homescreen<br>marketing<br>mobile-app-banner<br>navigation<br>onboarding<br>onboarding-tasks<br>product-variation-management<br>product-virtual-downloadable<br>product-external-affiliate<br>product-grouped<br>product-linked<br>product-pre-publish-modal<br>product-custom-fields<br>remote-inbox-notifications<br>remote-free-extensions<br>payment-gateway-suggestions<br>shipping-label-banner<br>subscriptions<br>store-alerts<br>transient-notices<br>woo-mobile-welcome<br>wc-pay-promotion<br>wc-pay-welcome-page<br><br>Disabled Features: minified-js<br>new-product-management-experience<br>settings<br>async-product-editor-category-field<br>launch-your-store<br><br>Daily Cron: ? Next scheduled: 2024-06-12 18:15:38 -05:00<br>Options: ?<br>Notes: 54<br>Onboarding: completed<br><br>### Action Scheduler ###<br><br>Complete: 8,868<br>Oldest: 2024-05-13 13:19:23 -0500<br>Newest: 2024-06-11 14:38:52 -0500<br><br>Failed: 4<br>Oldest: –<br>Newest: –<br><br>In-progress: 1<br>Oldest: –<br>Newest: –<br><br>Pending: 5<br>Oldest: 2024-06-11 14:39:15 -0500<br>Newest: 2024-06-14 16:23:32 -0500<br><br><br>### Status report information ###<br><br>Generated at: 2024-06-11 14:38:53 -05:00<br>

The page I need help with: [log in to see the link]