Product Sync not Working
-
We have set up our client’s website on WordPress using WooCommerce and installed the Square by WooCommerce plugin to handle payment processing and product stock management. Our client’s in-store POS system is also Square, and we’ve configured the plugin to sync inventory between WooCommerce and Square.
However, we’ve encountered the following issues:
- Online orders placed through WooCommerce are not updating the stock levels in Square.
- Stock levels in Square are not syncing back to WooCommerce.
All products have been marked to sync with Square, and Square is selected as the sync setting. We have also verified that the “Fetch inventory from Square” option is checked. Despite these configurations, the synchronization does not appear to be working.
Could you please advise on how we can resolve this issue? Let me know if additional information required to investigate further. Further is there anything that needs to be set on the Square end to ensure this is working correctly.
The page I need help with: [log in to see the link]
-
Thanks for reaching out, it sounds like you’re doing all the right steps, but the stock synchronization between WooCommerce and Square should be happening smoothly. There might be a few reasons why it’s not updating as expected:
1. Ensure the Square API credentials are correct and have the necessary permissions.
2. Double-check if the products have matching SKUs in both WooCommerce and Square.
3. There might be a plugin or server cache issue, please try clearing the cache on your site.If these steps don’t resolve the issue, please send us the system status report. You can find it by going to WooCommerce → Status, selecting Get system report, and then Copy for Support.
Hi Reynier,
Thank you so much for your response.
I’ve reviewed the points you mentioned and can confirm the following:
- Matching SKUs: I have double-checked the SKUs, and they do match between WooCommerce and Square, so we can eliminate this as a possible cause.
- API Credentials: The Square API credentials are correct. We tested the sync previously, and it worked—for example, product details and descriptions were successfully pulled from Square and updated in WooCommerce. But I can confirm now that tis not working as even if i manually push a product’s sync, one of my products in Square has a stock level of 6 but on woocommerce it still says 8.
- Connection Status: The WooCommerce app in Square shows as connected.
- Cache Cleared: I’ve used WP Rocket’s cache clearing and preloading feature to ensure all cached data, including any server-side caching, has been removed.
How would you like me to share the system report with you?
Hi, please find the system report attached below:
<br>### WordPress Environment ###<br><br>WordPress address (URL): https://zestlivingararat.com.au<br>Site address (URL): https://zestlivingararat.com.au<br>WC Version: 9.4.3<br>Legacy REST API Package Version: The Legacy REST API plugin is not installed on this site.<br>Action Scheduler Version: ✔ 3.8.2<br>Log Directory Writable: ✔<br>WP Version: 6.7.1<br>WP Multisite: –<br>WP Memory Limit: 756 MB<br>WP Debug Mode: –<br>WP Cron: ✔<br>Language: en_AU<br>External object cache: –<br><br>### Server Environment ###<br><br>Server Info: LiteSpeed<br>PHP Version: 8.0.30<br>PHP Post Max Size: 128 MB<br>PHP Time Limit: 300<br>PHP Max Input Vars: 3000<br>cURL Version: 8.9.1<br>OpenSSL/1.1.1w<br><br>SUHOSIN Installed: –<br>MySQL Version: 10.6.19-MariaDB<br>Max Upload Size: 32 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: 9.4.3<br>WC Database Prefix: wp_<br>Total Database Size: 143.58MB<br>Database Data Size: 124.09MB<br>Database Index Size: 19.49MB<br>wp_woocommerce_sessions: Data: 5.02MB + Index: 0.14MB + 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.08MB + Index: 0.09MB + 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.03MB + 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_actionscheduler_actions: Data: 2.02MB + Index: 2.83MB + Engine InnoDB<br>wp_actionscheduler_claims: Data: 0.06MB + Index: 0.05MB + Engine InnoDB<br>wp_actionscheduler_groups: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wp_actionscheduler_logs: Data: 2.03MB + Index: 1.73MB + Engine InnoDB<br>wp_commentmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>wp_comments: Data: 0.06MB + Index: 0.09MB + Engine InnoDB<br>wp_e_events: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wp_e_notes: Data: 0.02MB + Index: 0.17MB + Engine InnoDB<br>wp_e_notes_users_relations: Data: 0.02MB + Index: 0.05MB + Engine InnoDB<br>wp_e_submissions: Data: 0.02MB + Index: 0.27MB + Engine InnoDB<br>wp_e_submissions_actions_log: Data: 0.02MB + Index: 0.11MB + Engine InnoDB<br>wp_e_submissions_values: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>wp_imagify_files: Data: 0.00MB + Index: 0.00MB + Engine MyISAM<br>wp_imagify_folders: Data: 0.00MB + Index: 0.00MB + Engine MyISAM<br>wp_jetpack_sync_queue: Data: 4.25MB + Index: 0.28MB + Engine MyISAM<br>wp_jet_post_types: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_jet_search_suggestions: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_jet_search_suggestions_sessions: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_jet_smart_filters_indexer: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_jet_taxonomies: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_links: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wp_mainwp_stream: Data: 0.04MB + Index: 0.04MB + Engine MyISAM<br>wp_mainwp_stream_meta: Data: 0.12MB + Index: 0.12MB + Engine MyISAM<br>wp_options: Data: 5.42MB + Index: 1.09MB + Engine InnoDB<br>wp_postmeta: Data: 33.20MB + Index: 6.50MB + Engine InnoDB<br>wp_posts: Data: 31.11MB + Index: 0.84MB + Engine InnoDB<br>wp_seopress_content_analysis: Data: 31.52MB + Index: 0.05MB + Engine InnoDB<br>wp_seopress_seo_issues: Data: 0.76MB + Index: 0.07MB + Engine MyISAM<br>wp_seopress_significant_keywords: Data: 1.52MB + Index: 2.02MB + Engine InnoDB<br>wp_termmeta: Data: 0.06MB + Index: 0.03MB + Engine InnoDB<br>wp_terms: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>wp_term_relationships: Data: 0.17MB + Index: 0.17MB + Engine InnoDB<br>wp_term_taxonomy: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>wp_usermeta: Data: 0.13MB + Index: 0.03MB + Engine InnoDB<br>wp_users: Data: 0.02MB + Index: 0.05MB + Engine InnoDB<br>wp_wc_admin_notes: Data: 0.06MB + Index: 0.00MB + Engine InnoDB<br>wp_wc_admin_note_actions: Data: 0.05MB + Index: 0.02MB + 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_orders: Data: 0.05MB + Index: 0.11MB + Engine InnoDB<br>wp_wc_orders_meta: Data: 0.08MB + Index: 0.14MB + 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_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.19MB + Index: 0.41MB + 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_wpr_above_the_fold: Data: 3.15MB + Index: 0.24MB + Engine MyISAM<br>wp_wpr_lazy_render_content: Data: 0.25MB + Index: 0.24MB + Engine MyISAM<br>wp_wpr_rocket_cache: Data: 0.11MB + Index: 0.16MB + Engine MyISAM<br>wp_wpr_rucss_used_css: Data: 1.17MB + Index: 0.36MB + Engine InnoDB<br>wp_yaysmtp_email_logs: Data: 0.41MB + Index: 0.00MB + Engine InnoDB<br>wp_yaysmtp_event_email_clicked_link: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wp_yaysmtp_event_email_opened: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wp_yith_wapo_addons: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_yith_wapo_blocks: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_yith_wapo_blocks_assoc: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br><br>### Post Type Counts ###<br><br>attachment: 2812<br>elementor_library: 18<br>elementor_snippet: 1<br>jet-engine: 4<br>jet-menu: 3<br>jet-smart-filters: 2<br>nav_menu_item: 101<br>page: 14<br>post: 1<br>product: 903<br>product_variation: 568<br>revision: 3<br>seopress_404: 7<br>seopress_schemas: 1<br>shop_coupon: 1<br>shop_order_placehold: 49<br>template-post-type: 2<br>wp_font_face: 33<br>wp_font_family: 12<br><br>### Security ###<br><br>Secure connection (HTTPS): ✔<br>Hide errors from visitors: ✔<br><br>### Active Plugins (29) ###<br><br>Adminimize: by WP Media – 1.11.11<br>Afterpay Gateway for WooCommerce: by Afterpay – 3.8.7<br>Classic Editor: by WordPress Contributors – 1.6.7<br>Elementor Pro: by Elementor.com – 3.25.4<br>Elementor: by Elementor.com – 3.25.10<br>Imagify: by Imagify Image Optimizer – Optimize Images & Convert WebP & Avif – 2.2.3.2<br>JetBlocks For Elementor: by Crocoblock – 1.3.15<br>JetElements For Elementor: by Crocoblock – 2.7.1.1<br>JetEngine: by Crocoblock – 3.5.8<br>JetMenu: by Crocoblock – 2.4.6<br>JetSearch: by Crocoblock – 3.5.4<br>JetSmartFilters: by Crocoblock – 3.5.7.1<br>Jetpack: by Automattic – 14.0<br>MainWP Child Reports: by MainWP – 2.2.3<br>MainWP Child: by MainWP – 5.3<br>Stoke Tools & Widgets: by Stoke Design Co – 2.1<br>The Plus Addons for Elementor: by POSIMYTH – 6.0.7<br>The Plus Addons for Elementor - Pro: by POSIMYTH – 5.6.1<br>Big File Uploads: by Infinite Uploads – 2.1.3<br>User Role Editor: by Vladimir Garagulya – 4.64.3<br>WooCommerce Distance Rate Shipping: by Automattic – 1.0.20 (update to version 1.5.1 is available)<br>Google Analytics for WooCommerce: by WooCommerce – 2.1.8<br>WooCommerce - ShipStation Integration: by WooCommerce – 4.4.5 (update to version 4.4.6 is available)<br>WooCommerce Square: by WooCommerce – 4.8.3<br>WooCommerce: by Automattic – 9.4.3<br>WP Rocket: by WP Media – 3.17.3<br>SEOPress PRO: by The SEO Guys at SEOPress – 8.3<br>SEOPress: by The SEO Guys at SEOPress – 8.3.1<br>YaySMTP: by YayCommerce – 2.6.0<br><br>### Inactive Plugins (0) ###<br><br><br>### Dropin Plugins () ###<br><br>advanced-cache.php: advanced-cache.php<br><br>### Must Use Plugins (1) ###<br><br>WP Migrate Lite Compatibility: by Delicious Brains – 1.3<br><br>### Settings ###<br><br>Legacy API Enabled: –<br>Force SSL: –<br>Currency: AUD ($)<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: 7 MB<br><br>### WC Pages ###<br><br>Shop base: #100 - /shop/<br>Cart: #101 - /cart/ - Contains the [woocommerce_cart] shortcode<br>Checkout: #102 - /checkout/ - Contains the [woocommerce_checkout] shortcode<br>My account: ❌ Page not set<br>Terms and conditions: ❌ Page not set<br><br>### Theme ###<br><br>Name: Stoke Design Co<br>Version: 1.0.0<br>Author URL: https://stokedesign.co<br>Child Theme: ✔<br>Parent Theme Name: Hello Elementor<br>Parent Theme Version: 3.1.1<br>Parent Theme Author URL: https://elementor.com/?utm_source=wp-themes&utm_campaign=author-uri&utm_medium=wp-dash<br>WooCommerce Support: ✔<br><br>### Templates ###<br><br>Overrides: /home/zestlivi/public_html/wp-content/plugins/theplus_elementor_addon/includes/woo-thankyou/thankyou.php version 3.7.0 is out of date. The core version is 8.1.0<br>Outdated Templates: ❌<br> <br> <br> Learn how to update |<br> <br> <br> <br> <br> Clear system status theme info cache<br><br>### Square ###<br><br>Environment: Production<br>Tokenization Enabled: –<br>Debug Mode: Save to Log<br><br>### Gift Cards (Square) ###<br><br>Environment: <br>Debug Mode: Save to Log<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>pattern-toolkit-full-composability<br>product-custom-fields<br>remote-inbox-notifications<br>remote-free-extensions<br>payment-gateway-suggestions<br>printful<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>launch-your-store<br><br>Disabled Features: product-data-views<br>experimental-blocks<br>minified-js<br>product-pre-publish-modal<br>settings<br>async-product-editor-category-field<br>product-editor-template-system<br>blueprint<br>reactify-classic-payments-settings<br>use-wp-horizon<br><br>Daily Cron: ✔ Next scheduled: 2024-12-05 05:21:24 +11:00<br>Options: ✔<br>Notes: 80<br>Onboarding: completed<br><br>### Action Scheduler ###<br><br>Complete: 5,975<br>Oldest: 2024-11-04 16:53:59 +1100<br>Newest: 2024-12-05 16:12:44 +1100<br><br>Pending: 55<br>Oldest: 2024-12-05 16:08:00 +1100<br>Newest: 2024-12-06 22:48:46 +1100<br><br>In-progress: 1<br>Oldest: –<br>Newest: –<br><br>Failed: 18<br>Oldest: 2024-07-04 16:24:12 +1000<br>Newest: 2024-11-07 12:52:25 +1100<br><br>Cancelled: 55<br>Oldest: 2024-11-13 22:32:37 +1100<br>Newest: 2024-12-04 18:42:51 +1100<br><br><br>### Status report information ###<br><br>Generated at: 2024-12-05 16:13:23 +11:00<br>Hello stokedesignco,
Thank you for your reply.
Could you confirm whether the stock sync was working before or has not worked since you set up WooCommerce Square?
Please share a screenshot of the WooCommerce Square Sync settings page.
I’d like to review the settings and make sure everything is correctly configured.To troubleshoot this further, checkmark the “Enable Logging” option at the bottom of the settings page.
Then try to sync a few products manually and check the error log at WooCommerce > System Status > Logs. With this step, we can check if there is any error in the backend and then resolve it.Looking forward to your response. 🙂
Hi,
Please find the screenshot link below:
After yesterday’s sync, the stock levels are now matching between systems. However, I’m waiting for an in-store sale to confirm if today’s sales and updated stock levels in Square will push correctly to WooCommerce. This functionality was definitely working before, as I conducted multiple tests to ensure all product data was updating properly in WooCommerce after syncs.
That said, the original issue persists: online orders are not triggering stock updates in Square as they should. Although payments are being processed through Square, these sales are not appearing in the Square dashboard either.
I’ve enabled logging too.
Hello stokedesignco,
Thank you for your reply.
Can you confirm if all products are fully synced with Square?
Additionally, was this update a result of a manual or automatic sync?It would be helpful to wait for a live order to verify if the stock updates correctly.
Please note the sync interval is set to 2 hours, so you may need to wait for updates.Also, sales data doesn’t sync between WooCommerce and Square; only product information is synced.
Let me know how the sync works when you have an order.
If there is an issue, check the error log under WooCommerce > System Status > Logs.Looking forward to your response. 🙂
Hi,
Thank you for your message. Client has confirmed that the sync is now working both ways. Thank you for your help!Thanks for letting us know! We’re glad the issue is sorted out.
If you need help with anything else, feel free to open a new topic.
The topic ‘Product Sync not Working’ is closed to new replies.
