• Resolved Becky

    (@swanrj08)


    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]

Viewing 9 replies - 1 through 9 (of 9 total)
  • Hi @swanrj08 ??

    Thank you for reaching out — we’re happy to help!

    Syncing Issues from Square to WooCommerce

    While investigating the site’s System Status Report (SSR), it appears logging is currently not enabled. Let’s change that, as a next step, in order to gain further insight as to what’s happening. It can be enabled/disabled via the checkbox available towards the bottom of the screen, exemplified at the link here. Once enabled, and logs are available, kindly share them here, via a service like https://quickforget.com/.

    While troubleshooting the sync issue, best to temporarily disable caching/performance functionality. Plugins like Cache Enabler, and Perfmatters, for example.

    Moreover, the notice in red letters here, appears to report that the SKU is not entered at a variation level?

    I hope this is helpful! We look forward to your response. In the meantime, please let us know if you have any further questions or concerns.

    • This reply was modified 5 months, 1 week ago by anastas10s. Reason: typos
    Thread Starter Becky

    (@swanrj08)

    Thank you,

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

    The logs report a code: 200 (OK, in human language), in their entirety. Apparently things are stuck somewhere else.

    As a next step, kindly go to?WooCommerce > Status > Scheduled Actions, search for the?Square?actions in the?Pending?and?In Progress?filters, and?delete?them. New ones will be immediately created, but any currently stuck ones will be gone.
    Screenshot, to exemplify this: https://d.pr/i/pehW24

    I hope this helps! Let us know how it goes.

    Thread Starter Becky

    (@swanrj08)

    That didn’t see to do anything. I tried to sync again and got the same errors.

    Plugin Support ckadenge (woo-hc)

    (@ckadenge)

    Hi @swanrj08,

    Thanks again for getting back to us.

    I understand, even after following the steps shared by my colleague, the issue still persists. In that case, could you please try following the troubleshooting steps from our guide here?

    If that does not help, please share any logs under WooCommerce > Status > Logs. Look for any logs related to Square and share them with us. You can copy and paste them via https://gist.github.com/ and send the link here.

    Thread Starter Becky

    (@swanrj08)

    We have gone through these troubleshooting steps with no change. I did contact WPEngine to turn off their Long Process Killer as well, and that got us to 88%, but these last products won’t sync. We had inititally set up the products in WooCommerce first because we didn’t know we were going to use Square. Do you think it would help to delete the products in Woo that won’t sync and just import them from Square, rather than trying to sync them?

    Plugin Support Shameem R. a11n

    (@shameemreza)

    Hi @swanrj08

    Yes, deleting these products in WooCommerce and then re-importing them from Square might indeed resolve the issue. However, before doing that, can you try again by increasing the PHP Post Max Size from 100 MB to 2 GB?

    Please let us know how it goes. If the issue persists, we’ll continue to investigate and troubleshoot further.

    Thread Starter Becky

    (@swanrj08)

    I think we have this figured out. This issue can be closed.

    Plugin Support Shameem R. a11n

    (@shameemreza)

    Hi @swanrj08

    That’s great to hear! Thanks for letting us know.

    I will mark this thread as resolved. Should you have further inquiries, kindly create a new topic here.

    Thanks!

Viewing 9 replies - 1 through 9 (of 9 total)
  • You must be logged in to reply to this topic.