Square Inventory not updating to WooCommerce

Hello @shinteetahgmailcom,

Thank you for reaching out!

Seems like you’ve been on the hunt for a solution. :?)

Have you given manual syncing a shot from WooCommerce > Settings > Square?

If a product isn’t syncing properly, you should see some errors there. Additionally, you can check out the logs in WooCommerce > Status > Logs. Try searching for the word “Square” in the drop-down menu.

Link to image: https://d.pr/i/7ZQPEf

Could you also attach a copy of your site’s System Status report? You can find it via WooCommerce > Status. Select “Get system report” and then “Copy for support” (after you scroll down a bit)”. Once done, please paste it here in your reply or via a text-sharing service like https://gist.github.com/.

Look forward to hearing back from you.

Thanks for the reply! Yes, I’ve also tried manually syncing, which I should have mentioned with the sync records. It likes to hang at 94-96% and take foreeeever to finish; I don’t know if that’s relevant to anything.

In latest news, my most recent attempt to sync had more success than previously, but not a complete sync. One of my book titles now accurately shows paperbacks in stock, but still no hardbacks.

There are no fatal errors for Square in the logs. There is a Square log for today, but it has no errors per my quick search.

My system status report:

`
### WordPress Environment ###

WordPress address (URL): https://lauravanarendonkbaugh.com
Site address (URL): https://lauravanarendonkbaugh.com
WC Version: 7.8.2
REST API Version: ? 7.8.2
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: Apache
PHP Version: 8.2.5
PHP Post Max Size: 512 MB
PHP Time Limit: 120
PHP Max Input Vars: 1000
cURL Version: 7.68.0
OpenSSL/1.1.1f

SUHOSIN Installed: –
MySQL Version: 8.0.28-0ubuntu0.20.04.3
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.2
WC Database Prefix: wp_j7d3et_
Total Database Size: 165.88MB
Database Data Size: 126.94MB
Database Index Size: 38.94MB
wp_j7d3et_woocommerce_sessions: Data: 4.86MB + Index: 0.13MB + Engine MyISAM
wp_j7d3et_woocommerce_api_keys: Data: 0.00MB + Index: 0.01MB + Engine MyISAM
wp_j7d3et_woocommerce_attribute_taxonomies: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_j7d3et_woocommerce_downloadable_product_permissions: Data: 0.01MB + Index: 0.02MB + Engine MyISAM
wp_j7d3et_woocommerce_order_items: Data: 0.03MB + Index: 0.02MB + Engine MyISAM
wp_j7d3et_woocommerce_order_itemmeta: Data: 0.29MB + Index: 0.14MB + Engine MyISAM
wp_j7d3et_woocommerce_tax_rates: Data: 0.00MB + Index: 0.01MB + Engine MyISAM
wp_j7d3et_woocommerce_tax_rate_locations: Data: 0.00MB + Index: 0.01MB + Engine MyISAM
wp_j7d3et_woocommerce_shipping_zones: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_j7d3et_woocommerce_shipping_zone_locations: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_j7d3et_woocommerce_shipping_zone_methods: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_j7d3et_woocommerce_payment_tokens: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_j7d3et_woocommerce_payment_tokenmeta: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_j7d3et_woocommerce_log: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_j7d3et_actionscheduler_actions: Data: 1.02MB + Index: 1.02MB + Engine InnoDB
wp_j7d3et_actionscheduler_claims: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_j7d3et_actionscheduler_groups: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_j7d3et_actionscheduler_logs: Data: 1.52MB + Index: 0.52MB + Engine InnoDB
wp_j7d3et_blc_filters: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_j7d3et_blc_instances: Data: 1.52MB + Index: 0.33MB + Engine InnoDB
wp_j7d3et_blc_links: Data: 10.52MB + Index: 0.83MB + Engine InnoDB
wp_j7d3et_blc_synch: Data: 0.09MB + Index: 0.06MB + Engine InnoDB
wp_j7d3et_clva_poll: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_j7d3et_clva_poll_answers: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_j7d3et_clva_poll_logs: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_j7d3et_commentmeta: Data: 17.03MB + Index: 0.54MB + Engine MyISAM
wp_j7d3et_comments: Data: 14.29MB + Index: 0.53MB + Engine MyISAM
wp_j7d3et_defender_audit_log: Data: 6.52MB + Index: 5.47MB + Engine InnoDB
wp_j7d3et_defender_email_log: Data: 0.08MB + Index: 0.02MB + Engine InnoDB
wp_j7d3et_defender_lockout: Data: 0.97MB + Index: 1.31MB + Engine MyISAM
wp_j7d3et_defender_lockout_log: Data: 1.77MB + Index: 0.21MB + Engine MyISAM
wp_j7d3et_defender_scan: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_j7d3et_defender_scan_item: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_j7d3et_dlm_downloads: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_j7d3et_dlm_order: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_j7d3et_dlm_order_customer: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_j7d3et_dlm_order_item: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_j7d3et_dlm_order_transaction: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_j7d3et_dlm_reports_log: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_j7d3et_dlm_session: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_j7d3et_download_log: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_j7d3et_enewsletter_members: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_j7d3et_enewsletter_meta: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_j7d3et_gaplus_login: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_j7d3et_jetpack_waf_blocklog: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_j7d3et_links: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_j7d3et_mbp_nudges: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_j7d3et_mbp_progress: Data: 0.02MB + Index: 0.00MB + Engine MyISAM
wp_j7d3et_mclean_refs: Data: 1.52MB + Index: 0.00MB + Engine InnoDB
wp_j7d3et_mclean_scan: Data: 0.08MB + Index: 0.00MB + Engine InnoDB
wp_j7d3et_mp_term_relationships: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_j7d3et_options: Data: 11.96MB + Index: 0.35MB + Engine MyISAM
wp_j7d3et_orgSeriesIcons: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_j7d3et_orgseriesicons: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_j7d3et_popover_ip_cache: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_j7d3et_postmeta: Data: 9.26MB + Index: 2.71MB + Engine MyISAM
wp_j7d3et_posts: Data: 11.72MB + Index: 7.55MB + Engine MyISAM
wp_j7d3et_qss: Data: 0.06MB + Index: 0.03MB + Engine InnoDB
wp_j7d3et_tec_events: Data: 0.08MB + Index: 0.02MB + Engine InnoDB
wp_j7d3et_tec_occurrences: Data: 0.09MB + Index: 0.06MB + Engine InnoDB
wp_j7d3et_term_relationships: Data: 0.07MB + Index: 0.16MB + Engine MyISAM
wp_j7d3et_term_taxonomy: Data: 0.01MB + Index: 0.01MB + Engine MyISAM
wp_j7d3et_termmeta: Data: 0.00MB + Index: 0.01MB + Engine MyISAM
wp_j7d3et_terms: Data: 0.01MB + Index: 0.04MB + Engine MyISAM
wp_j7d3et_usermeta: Data: 0.12MB + Index: 0.06MB + Engine MyISAM
wp_j7d3et_users: Data: 0.00MB + Index: 0.01MB + Engine MyISAM
wp_j7d3et_wc_admin_note_actions: Data: 0.09MB + Index: 0.02MB + Engine InnoDB
wp_j7d3et_wc_admin_notes: Data: 0.08MB + Index: 0.00MB + Engine InnoDB
wp_j7d3et_wc_category_lookup: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_j7d3et_wc_customer_lookup: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_j7d3et_wc_download_log: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_j7d3et_wc_order_coupon_lookup: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_j7d3et_wc_order_product_lookup: Data: 0.06MB + Index: 0.06MB + Engine InnoDB
wp_j7d3et_wc_order_stats: Data: 0.05MB + Index: 0.05MB + Engine InnoDB
wp_j7d3et_wc_order_tax_lookup: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_j7d3et_wc_product_attributes_lookup: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_j7d3et_wc_product_download_directories: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_j7d3et_wc_product_meta_lookup: Data: 0.06MB + Index: 0.09MB + Engine InnoDB
wp_j7d3et_wc_rate_limits: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_j7d3et_wc_reserved_stock: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_j7d3et_wc_tax_rate_classes: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_j7d3et_wc_webhooks: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_j7d3et_wf301_404_logs: Data: 7.77MB + Index: 0.49MB + Engine MyISAM
wp_j7d3et_wf301_linkhero: Data: 22.55MB + Index: 15.64MB + Engine InnoDB
wp_j7d3et_wf301_redirect_logs: Data: 0.17MB + Index: 0.01MB + Engine MyISAM
wp_j7d3et_wf301_redirect_rules: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_j7d3et_wfBadLeechers: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_j7d3et_wfBlockedCommentLog: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_j7d3et_wfBlocks: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_j7d3et_wfBlocksAdv: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_j7d3et_wfLeechers: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_j7d3et_wfLockedOut: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_j7d3et_wfNet404s: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_j7d3et_wfScanners: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_j7d3et_wfThrottleLog: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_j7d3et_wfVulnScanners: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_j7d3et_woocommerce_square_customers: Data: 0.05MB + Index: 0.00MB + Engine InnoDB
wp_j7d3et_wpmailsmtp_debug_events: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_j7d3et_wpmailsmtp_tasks_meta: Data: 0.02MB + Index: 0.00MB + Engine InnoDB

### Post Type Counts ###

attachment: 1947
custom_css: 3
customize_changeset: 2
dlm_download: 4
dlm_download_version: 4
happyform: 4
happyforms-message: 179
inc_popup: 1
jp_img_sitemap: 1
jp_sitemap: 1
jp_sitemap_master: 1
landing-page: 1
mbt_book: 57
mec-events: 2
module: 12
nav_menu_item: 63
oembed_cache: 11
page: 32
pms-subscription: 1
post: 554
product: 102
product_variation: 93
revision: 516
safecss: 1
series_grouping: 7
shop_coupon: 152
shop_order: 182
shop_order_refund: 14
slide_in: 1
t4pframework: 5
tb_book: 5
tribe_events: 321
tribe_organizer: 12
tribe_venue: 9
tribe-ea-record: 20
unit: 3
wcct_countdown: 1
wdscan_result: 1
wmpc-trash: 68
wp_block: 1
wp_global_styles: 2
xlwcty_thankyou: 1

### Security ###

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

### Active Plugins (35) ###

301 Redirects Pro: by WebFactory Ltd – 6.09
Autoptimize: by Frank Goossens (futtta) – 3.1.8.1
Broken Link Checker: by WPMU DEV – 2.2.0
Cryout Serious Theme Settings: by Cryout Creations – 0.5.14
Database Cleaner: Clean, Optimize & Repair (Pro): by Jordy Meow – 0.8.5
Defender: by WPMU DEV – 3.12.0
Docket Cache: by Nawawi Jamili – 22.07.05
Download Monitor: by WPChill – 4.8.6
DreamHost Panel Login: by DreamHost
danielbachhuber – 1.0.0

Flexible Checkout Fields: by WP Desk – 3.5.10
Happyforms: by Happyforms – 1.37.5
WP Armour - Honeypot Anti Spam: by Dnesscarkey – 2.1.4
Jetpack Protect: by Automattic - Jetpack Security team – 1.4.0
Jetpack: by Automattic – 12.3
Media Cleaner: by Jordy Meow – 6.6.4
MyBookProgress Professional Upgrade: by Author Media – 1.0.1
MyBookProgress - Stormhill Media: by Stormhill Media – 1.0.7
MyBookTable Professional Upgrade 3.0: by Stormhill Media – 3.3.1
MyBookTable Bookstore by Stormhill Media: by Stormhill Media – 3.3.3
PublishPress Series: by PublishPress – 2.11.4
Blubrry PowerPress: by Blubrry – 10.4
ShortPixel Adaptive Images: by ShortPixel – 3.7.3
Squirrly SEO (Peaks): by Squirrly – 12.2.03
The Events Calendar: by The Events Calendar – 6.1.2.2
Two Factor Authentication: by David Anderson
original plugin by Oskar Hane and enhanced by Dee Nutbourne – 1.14.16

UpdraftPlus - Backup/Restore: by UpdraftPlus.Com
DavidAnderson – 2.23.7.0

WooCommerce Weight Based Shipping: by weightbasedshipping.com – 5.5.4
NextMove Lite - Thank You Page for WooCommerce: by XLPlugins – 2.16.0
WooCommerce Payments: by Automattic – 6.1.1
WooCommerce PayPal Payments: by WooCommerce – 2.1.0
WooCommerce Shipping & Tax: by WooCommerce – 2.2.5
WooCommerce Square: by WooCommerce – 4.0.0
WooCommerce: by Automattic – 7.8.2
WP Mail SMTP: by WP Mail SMTP – 3.8.0
WPMU DEV Dashboard: by WPMU DEV – 4.11.18

### Inactive Plugins (4) ###

Database Cleaner: Clean, Optimize & Repair: by Jordy Meow – 0.9.3
Finale Lite - Sales Countdown Timer & Discount for WooCommerce: by XLPlugins – 2.16.0
WooCommerce Coupon Generator: by Jeroen Sormani – 1.2.0
WooCommerce Extended Coupon Features FREE: by Soft79 – 3.3.3

### Dropin Plugins (1) ###

object-cache.php: Docket Cache Drop-in

### Settings ###

API Enabled: ?
Force SSL: –
Currency: USD ($)
Currency Position: left
Thousand Separator: ,
Decimal Separator: .
Number of Decimals: 2
Taxonomies: Product Types: credits (credits)
external (external)
grouped (grouped)
simple (simple)
subscription (subscription)
variable (variable)
variable subscription (variable-subscription)
variation (variation)

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: #167579 - /shop/
Cart: #6133 - /cart/
Checkout: #6134 - /checkout/
My account: #6135 - /my-account/
Terms and conditions: #168719 - /refund_returns/

### Theme ###

Name: Parabola Child
Version: 1.0.0
Author URL: 
Child Theme: ?
Parent Theme Name: Parabola
Parent Theme Version: 2.4.0.1
Parent Theme Author URL: https://www.cryoutcreations.eu
WooCommerce Support: ?

### Templates ###

Archive Template: Your theme has a woocommerce.php file
you will not be able to override the woocommerce/archive-product.php custom template since woocommerce.php has priority over archive-product.php. This is intended to prevent display issues.

Overrides: –

### WooCommerce PayPal Payments ###

Onboarded: ?
Shop country code: US
WooCommerce currency supported: ?
Advanced Card Processing available in country: ?
Pay Later messaging available in country: ?
Webhook status: –
Vault enabled: –
Logging enabled: –
Reference Transactions: –
Used PayPal Checkout plugin: –
Tracking enabled: –

### Square ###

Environment: Production
Tokenization Enabled: –
Debug Mode: Off

### 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-07-11 18:45:47 -04:00
Options: ?
Notes: 160
Onboarding: completed

### WooCommerce Payments ###

Version: 6.1.1
Connected to WPCOM: Yes
Blog ID: 41321590
Account ID: acct_1LxNKAFxYYOLIZbD

### Action Scheduler ###

Complete: 3,017
Oldest: 2023-06-09 17:39:09 -0400
Newest: 2023-07-10 16:50:42 -0400

Failed: 15
Oldest: 2023-02-15 10:03:28 -0500
Newest: 2023-06-20 20:07:57 -0400

Pending: 14
Oldest: 2023-07-10 16:50:37 -0400
Newest: 2023-07-17 08:22:17 -0400


### Status report information ###

Generated at: 2023-07-10 16:50:52 -04:00
`

Hi @shinteetahgmailcom

Thank you for reaching out to us, and sharing additional information.

Yes, I’ve also tried manually syncing, which I should have mentioned with the sync records. It likes to hang at 94-96% and take foreeeever to finish; I don’t know if that’s relevant to anything.

In latest news, my most recent attempt to sync had more success than previously, but not a complete sync. One of my book titles now accurately shows paperbacks in stock, but still no hardbacks.

Sometimes, server or browser caching can cause delays or inconsistencies in inventory updates. Since you’re currently using multiple caching plugins, I recommend turning them off temporarily to see if the sync completes successfully.

Make sure to enable your server’s opcache.save_comments setting as well. It’s necessary for the plugin and product sync to function properly. If it’s not enabled, you might need to reach out to your hosting provider to adjust the setting.

Also, take a moment to check your inventory history in Square. If you don’t see the changes logged there, then the issue might be on the Square side.

Although you’ve deactivated other plugins, there could still be a conflict with your theme. Try switching to the default Storefront theme to see if the issue persists.

Please let us know how these steps work for you. If the issue still persists, please get back to us with any additional information you might have, and we will continue to investigate. We understand how important this is for your business and are committed to helping you resolve this issue as soon as possible.

Thanks!

Since you’re currently using multiple caching plugins, I recommend turning them off temporarily to see if the sync completes successfully.

Disabling caching reaches 100% faster, but it doesn’t finish faster, just hangs at a higher number. XD It does eventually finish, with or without caching enabled.

Make sure to enable your server’s?opcache.save_comments?setting as well.

Has been enabled, confirmed it still is.

Although you’ve deactivated other plugins, there could still be a conflict with your theme. Try switching to the default?Storefront?theme to see if the issue persists.

I’ve been using the same theme for years and have made no recent changes to coincide with the syncing problem, but just to be completist, I tried a basic theme, Twenty Twenty-Three. I did not notice a change in sync speed or success.

Also, take a moment to check your inventory history in Square. If you don’t see the changes logged there, then the issue might be on the Square side.

I’m not sure I understand this point. Are you saying that Square should reflect changes in WooCommerce? But Square is the system of record, so WooCommerce should update to match Square. Are you saying that my inventory in Square is wrong? That’s not the case; I just did a bunch of live sales in Square, and I receive inventory in Square, so stock in and out are both managed and accurate in Square. I’m not sure what you want me to check here or why WC sync should enact changes in Square.

Hllo @shinteetahgmailcom

Thank you for reaching out to us. We appreciate your patience and efforts in troubleshooting the issue you’re experiencing with syncing.

Although you’ve been using the same theme for years, updates to plugins, WordPress, or even WooCommerce can sometimes cause unforeseen conflicts. It’s great that you’ve already tried switching to the Twenty Twenty-Three theme, although it’s unfortunate that this didn’t resolve the issue.

At this point, I would recommend enabling WordPress debugging by adding the following lines to your wp-config.php file for further troubleshooting:

define( 'WP_DEBUG', true );
define( 'WP_DEBUG_LOG', true );
define( 'WP_DEBUG_DISPLAY', false );

This will create a debug.log file in your wp-content directory capturing any errors or notices that occur during the sync process. Make sure to check the logs for any errors happening during the sync.

I’m not sure I understand this point. Are you saying that Square should reflect changes in WooCommerce? But Square is the system of record, so WooCommerce should update to match Square. Are you saying that my inventory in Square is wrong? That’s not the case; I just did a bunch of live sales in Square, and I receive inventory in Square, so stock in and out are both managed and accurate in Square. I’m not sure what you want me to check here or why WC sync should enact changes in Square.

You’re correct that Square is the system of record and WooCommerce should update to match Square. When you make live sales or receive inventory in Square, those changes should be reflected in WooCommerce. However, sometimes issues may arise where the synchronization between the two platforms isn’t functioning as expected.

In this case, I suggest checking your inventory history in Square as a first step to troubleshooting. This isn’t to imply that your inventory in Square is wrong, but rather to ensure that the changes you’ve made in Square (like live sales or receiving inventory) are being logged correctly. If you see these changes in Square but not in WooCommerce, this might indicate an issue with the synchronization process between the two systems.

The WooCommerce Square extension is designed to sync your inventory between the two platforms but doesn’t enact changes in Square. Instead, it pulls the data from Square and updates your WooCommerce store to match. If this process isn’t happening correctly, then it’s a matter we need to investigate further.

I hope this clarifies the point.

Additionally, please can you share a copy of the following:

• Fatal Error log: Share a copy of any fatal error log found 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.

Thank you for your cooperation and understanding.

>> ?If you see these changes in Square but not in WooCommerce, this might indicate an issue with the synchronization process between the two systems. <<

Yes, I believe we’ve struck upon the key point. ?? I received new inventory into Square again since my last reply here. That increase in stock shows in Square, and it does not show in WooCommerce. It’s probable that there is an issue with the synchronization process.

>> Additionally, please can you share a copy of the following: Fatal Error log:?Share a copy of any fatal error log found under?WooCommerce → Status → Logs. <<

The last fata error is from mid-June, well before I started having any sync issues, which began this past Sunday.

>> Make sure to check the logs for any errors happening during the sync. <<

I did find these:

[11-Jul-2023 16:50:38 UTC] PHP Deprecated:  Using ${var} in strings is deprecated, use {$var} instead in [redacted]/wp-content/plugins/woocommerce-square/includes/Sync/Stepped_Job.php on line 171
[11-Jul-2023 16:50:38 UTC] PHP Deprecated:  Using ${var} in strings is deprecated, use {$var} instead in [redacted]/wp-content/plugins/woocommerce-square/includes/Sync/Stepped_Job.php on line 175
[11-Jul-2023 16:50:42 UTC] PHP Deprecated:  Creation of dynamic property WooCommerce\Square\Emails\Sync_Completed::$body is deprecated in [redacted]/wp-content/plugins/woocommerce-square/includes/Emails/Sync_Completed.php on line 37
[11-Jul-2023 16:50:42 UTC] PHP Deprecated:  Creation of dynamic property WooCommerce\Square\Emails\Sync_Completed::$email_type is deprecated in [redacted]/wp-content/plugins/woocommerce/includes/emails/class-wc-email.php on line 254
[11-Jul-2023 16:50:42 UTC] PHP Deprecated:  Creation of dynamic property WooCommerce\Square\Emails\Access_Token_Email::$body is deprecated in [redacted]/wp-content/plugins/woocommerce-square/includes/Emails/Access_Token_Email.php on line 47
[11-Jul-2023 16:50:42 UTC] PHP Deprecated:  Creation of dynamic property WooCommerce\Square\Emails\Access_Token_Email::$email_type is deprecated in [redacted]/wp-content/plugins/woocommerce/includes/emails/class-wc-email.php on line 254

Hello @shinteetahgmailcom,

Thank you for sharing the logs!

These are just deprecation notices for the developers, they have no effect on the functionality of the plugin or your site, you can just ignore them.

I just had a peek at your site’s system status, and it seems like your server’s PHP Time Limit, currently set at 120 seconds, might be creating a bit of a bottleneck. Please try increasing to at least 1000.

Just to clarify, the PHP Time Limit is the maximum amount of time that PHP scripts are allowed to run. If any script runs longer than the set time, PHP will stop it and flag an error, which can explain why the sync process is terminated at 96%.

You can adjust this by tweaking themax_execution_time in your PHP configuration file, then try syncing again manually. Your hosting provider should be able to help you with this.

Let us know how it goes!

>> These are just deprecation notices for the developers, they have no effect on the functionality of the plugin or your site, you can just ignore them. <<

Yep. ?? I didn’t think they were relevant to this, but Shameem didn’t seem to take my view that this is a sync issue rather than a Square user error, so now I’m just hyper-documenting everything that’s asked for.

>> it seems like your server’s PHP Time Limit, currently set at 120 seconds, might be creating a bit of a bottleneck. <<

Oh, good catch. That was definitely set higher, but then I upgraded to 8.2 a couple of weeks ago and that would have reset it. It’s back to 1000. (The PHP upgrade did not coincide with the sync issue, or I would have been suspicious; again the sync issues started this week.) The sync still hangs at 100% for a long time, though.

This time I was able to successfully sync a few more variations. Yay! But not everything.

What else can I try? I will be entering one of my two busiest online periods at the end of the month, and it would be really helpful if my online inventory was accurate!

Just to add confusion — I’ve identified some items where one variation is updating correctly and another is not.

For example a book title is available in 4 formats. Ebook and audio are virtual and not tracked, so no sync issues. The paperback inventory is updating from Square. The hardback inventory is not.

The “tracked with Square” setup is obviously correct, or the paperback wouldn’t be updating. But one variation is not syncing. Yes, the SKU is correct, I’ve copy-pasted to avoid mistakes and triple-checked. It’s showing out of stock on the website, though I have stock in my office and in Square.

This is very frustrating.

Hi there @shinteetahgmailcom ??

Thank you for reaching back, elaborating further on the inventory sync you are facing!

Could you try disabling Cloudflare temporarily for your site? It can be done from their dashboard, with a switch.

I’ve noticed in the site’s System Status Report (SSR) that error logging is not enabled. Therefore, kindly enable it in the screen at WooCommerce > Settings > Square.?This logging helps troubleshoot Square sync and connectivity issues, and its log files start with?square:?

We need to have a test product, and to know how to spot the test item in our logs. The only way to sync Square to?WooCommerce is with the automated hourly sync. Since that sync updates EVERYTHING, you won’t be able to easily identify the product you are using for testing when looking at the sync logs. A little tip for this is:

Edit the item on?WooCommerce. Wait a minute, then check the sync logs. You’ll see the logs for?WooCommerce updating this item, and it will contain the Square Item ID. It will be a long alpha-numeric string such as:?f3c11135-5437-4bd9-bbcd-e6e10e232469

Now we’ll be able to search the logs for that string to easily check for errors:

• Edit the product’s inventory level on Square
• Use?WP?Crontrol?to run the schedule hourly auto-sync. This is the?woocommerce_square_inventory_poll?hook
• The sync may take a while but check the logs to see what information is logged for the Square Item ID that you made note of earlier

Square > WooCommerce hourly automated sync issues typically fall into one of these categories:

• Product was not properly setup or plugin instructions weren’t followed (Reminder new products added to Square aren’t grabbed by the automated hourly sync. Use the manual sync instead)
• Cron Issue – the scheduled hourly cron is not firing when it should. You can check this by forcing the cron using WP Crontrol (if it works, but the scheduled hourly does not)
• Server environment is blocking communication

Let us know how that goes, we will be standing by for your response. Cheers!

I have paused CloudFlare and restarted logging.

I edited a troublesome product and then checked the only log for today. I don’t see a string such as you describe, so I’ll paste below for help.

>> Product was not properly setup or plugin instructions weren’t followed (Reminder new products added to Square aren’t grabbed by the automated hourly sync. Use the manual sync instead)
Cron Issue – the scheduled hourly cron is not firing when it should.
Server environment is blocking communication <<

Product/plugin setup and cron jobs appear to be working correctly, or we wouldn’t be seeing the updates for some of the variations. As I explained, these are not new products, these are already in WC and just not updating inventory, and I’ve tried both auto and manual sync. Likewise, I suspect that server communication is happening, because some products update and some variations in other products update. I appreciate that these are typical issues for general lack of sync. I’m looking for the weird thingy that is causing only some items or only some variations to fail to update.

Thanks!

07-13-2023 @ 12:04:52 - Request
 Request
method:
uri: listLocations
user-agent: WooCommerce-Square/4.0.0 (WooCommerce/7.8.2; WordPress/6.2.2)
headers: Array
(
)
body:
duration: 0.14281s

07-13-2023 @ 12:04:52 - Response
 Response
code: 200
message:
headers: Array
(
    [0] => HTTP/2 200
    [date] => Thu, 13 Jul 2023 16:04:52 GMT
    [content-type] => application/json
    [content-length] => 781
    [cf-ray] => 7e62c3a678f4ef90-PDX
    [cf-cache-status] => DYNAMIC
    [content-encoding] => gzip
    [strict-transport-security] => max-age=631152000; includeSubDomains; preload
    [vary] => Accept-Encoding
    [frame-options] => DENY
    [square-version] => 2022-11-16
    [squareup--connect--v2--common--versionmetadata-bin] => CgoyMDIyLTExLTE2
    [x-content-type-options] => nosniff
    [x-frame-options] => DENY
    [x-sq-dc] => sjc2b
    [x-sq-region] => sjc2b
    [x-xss-protection] => 1; mode=block
    [set-cookie] => __cf_bm=6BsMIyAYjp4SuXcHaPrsoJYHWE4HUe2IPmfRkQpiSpY-1689264292-0-AQgvPrKnNL5oTKLDQGf9J27iz5pxVpZ3+1UuNF2a0RSMAJJZznGzTzyHVDEKNA3hTJ/G0BNbuqtv3djVpL8Couk=; path=/; expires=Thu, 13-Jul-23 16:34:52 GMT; domain=.connect.squareup.com; HttpOnly; Secure; SameSite=None
    [server] => cloudflare
)
body: {
    "locations": [
        {
            "id": "DEAPZKJZPRQZH",
            "name": "Aeclipse Press",
            "address": {
                "address_line_1": "8063 Madison Ave",
                "address_line_2": "#1160",
                "locality": "INDIANAPOLIS",
                "administrative_district_level_1": "IN",
                "postal_code": "46227",
                "country": "US"
            },
            "timezone": "America\/New_York",
            "capabilities": [
                "CREDIT_CARD_PROCESSING",
                "AUTOMATIC_TRANSFERS"
            ],
            "status": "ACTIVE",
            "created_at": "2017-04-15T05:40:41Z",
            "merchant_id": "4CA25Q78TDKJ3",
            "country": "US",
            "language_code": "en-US",
            "currency": "USD",
            "business_name": "Laura VanArendonk Baugh, author",
            "type": "PHYSICAL",
            "website_url": "http:\/\/www.LauraVanArendonkBaugh.com",
            "business_hours": {},
            "twitter_username": "Laura_VAB",
            "facebook_url": "facebook.com\/LauraVBaugh",
            "coordinates": {
                "latitude": 39.648801,
                "longitude": -86.12156
            },
            "logo_url": "https:\/\/square-web-production-f.squarecdn.com\/files\/b958d274e22b39e2bb7213496ff92bb782e301ab\/original.png",
            "pos_background_url": "https:\/\/square-web-production-f.squarecdn.com\/files\/77e4719cedc892f7966c5930673a903d43912aaf\/original.jpeg",
            "mcc": "7991"
        },
        {
            "id": "L7HEE289FP1BF",
            "name": "Etsy",
            "address": {
                "address_line_1": "10209 VANDERGRIFF RD",
                "locality": "INDIANAPOLIS",
                "administrative_district_level_1": "IN",
                "postal_code": "46239-9593",
                "country": "US"
            },
            "timezone": "America\/New_York",
            "capabilities": [
                "CREDIT_CARD_PROCESSING",
                "AUTOMATIC_TRANSFERS"
            ],
            "status": "INACTIVE",
            "created_at": "2020-12-30T21:22:10.298Z",
            "merchant_id": "4CA25Q78TDKJ3",
            "country": "US",
            "language_code": "en-US",
            "currency": "USD",
            "business_name": "Aeclipse Press (Etsy)",
            "type": "MOBILE",
            "website_url": "http:\/\/www.LauraVanArendonkBaugh.com",
            "business_hours": {},
            "twitter_username": "Laura_VAB",
            "facebook_url": "facebook.com\/LauraVBaugh",
            "coordinates": {
                "latitude": 39.713301,
                "longitude": -85.985069
            },
            "logo_url": "https:\/\/square-web-production-f.squarecdn.com\/files\/b958d274e22b39e2bb7213496ff92bb782e301ab\/original.png",
            "pos_background_url": "https:\/\/square-web-production-f.squarecdn.com\/files\/77e4719cedc892f7966c5930673a903d43912aaf\/original.jpeg",
            "mcc": "7991",
            "full_format_logo_url": "https:\/\/square-web-production-f.squarecdn.com\/files\/77e4719cedc892f7966c5930673a903d43912aaf\/original.jpeg"
        }
    ]
}

07-13-2023 @ 12:06:19 - Starting step cycle: update_category_data
07-13-2023 @ 12:06:19 - Request
 Request
method:
uri: searchCatalogObjects
user-agent: WooCommerce-Square/4.0.0 (WooCommerce/7.8.2; WordPress/6.2.2)
headers: Array
(
)
body:
duration: 0.14032s

07-13-2023 @ 12:06:19 - Response
 Response
code: 200
message:
headers: Array
(
    [0] => HTTP/2 200
    [date] => Thu, 13 Jul 2023 16:06:19 GMT
    [content-type] => application/json
    [content-length] => 66
    [cf-ray] => 7e62c5c26855ef4b-PDX
    [cf-cache-status] => DYNAMIC
    [content-encoding] => gzip
    [strict-transport-security] => max-age=631152000; includeSubDomains; preload
    [vary] => Origin, Accept-Encoding
    [square-version] => 2022-11-16
    [x-content-type-options] => nosniff
    [x-download-options] => noopen
    [x-frame-options] => SAMEORIGIN
    [x-permitted-cross-domain-policies] => none
    [x-speleo-traceid] => CDN-0ed57fc6-3d97-4df9-9b42-f0296f2bd8e3
    [x-sq-dc] => sjc2b
    [x-sq-region] => sjc2b
    [x-xss-protection] => 1; mode=block
    [set-cookie] => __cf_bm=XwU67W2dkdOi7.IVEAP2dSNHLKrAuazfKS6Kjt1HuSc-1689264379-0-ARCyUtnUdgqKwjAMwZqJpvSGh3pbGaNkd2yqzU1wyT720xYA7nNn98LdrgOwyNUCKiDawmOxevqi3RoUa+vmf9A=; path=/; expires=Thu, 13-Jul-23 16:36:19 GMT; domain=.connect.squareup.com; HttpOnly; Secure; SameSite=None
    [server] => cloudflare
)
body: {
    "latest_time": "2023-07-11T21:20:02.101Z"
}

07-13-2023 @ 12:06:19 - Completed job step: update_category_data (Updated categories: 0)
07-13-2023 @ 12:06:19 - Completed step cycle: update_category_data (0.16s)
07-13-2023 @ 12:06:19 - Starting step cycle: update_product_data
07-13-2023 @ 12:06:19 - Request
 Request
method:
uri: searchCatalogObjects
user-agent: WooCommerce-Square/4.0.0 (WooCommerce/7.8.2; WordPress/6.2.2)
headers: Array
(
)
body:
duration: 0.10426s

07-13-2023 @ 12:06:19 - Response
 Response
code: 200
message:
headers: Array
(
    [0] => HTTP/2 200
    [date] => Thu, 13 Jul 2023 16:06:19 GMT
    [content-type] => application/json
    [content-length] => 66
    [cf-ray] => 7e62c5c388bfef5f-PDX
    [cf-cache-status] => DYNAMIC
    [content-encoding] => gzip
    [strict-transport-security] => max-age=631152000; includeSubDomains; preload
    [vary] => Origin, Accept-Encoding
    [square-version] => 2022-11-16
    [x-content-type-options] => nosniff
    [x-download-options] => noopen
    [x-frame-options] => SAMEORIGIN
    [x-permitted-cross-domain-policies] => none
    [x-speleo-traceid] => CDN-2a48e8a2-d51b-426d-81ab-01a181a7d1ab
    [x-sq-dc] => sjc2b
    [x-sq-region] => sjc2b
    [x-xss-protection] => 1; mode=block
    [set-cookie] => __cf_bm=ekhnz4JODlF1Ef2rutERObyZSYwlYJ1vXenngszZkGU-1689264379-0-Ad7ToCuvuEl0dB4jjnDWwgVpnrnav8hjIzqF2C6o7y92FSrILKn577V9+sD3n3cnqhv9E+HtL4A3ekvmLnDiDSU=; path=/; expires=Thu, 13-Jul-23 16:36:19 GMT; domain=.connect.squareup.com; HttpOnly; Secure; SameSite=None
    [server] => cloudflare
)
body: {
    "latest_time": "2023-07-11T21:20:02.101Z"
}

07-13-2023 @ 12:06:19 - Completed job step: update_product_data (Updated products: 0)
07-13-2023 @ 12:06:19 - Completed step cycle: update_product_data (0.11s)
07-13-2023 @ 12:06:19 - Starting step cycle: update_inventory_tracking
07-13-2023 @ 12:06:19 - Request
 Request
method:
uri: searchCatalogObjects
user-agent: WooCommerce-Square/4.0.0 (WooCommerce/7.8.2; WordPress/6.2.2)
headers: Array
(
)
body:
duration: 0.13338s

07-13-2023 @ 12:06:19 - Response
 Response
code: 200
message:
headers: Array
(
    [0] => HTTP/2 200
    [date] => Thu, 13 Jul 2023 16:06:19 GMT
    [content-type] => application/json
    [content-length] => 66
    [cf-ray] => 7e62c5c49d93ef10-PDX
    [cf-cache-status] => DYNAMIC
    [content-encoding] => gzip
    [strict-transport-security] => max-age=631152000; includeSubDomains; preload
    [vary] => Origin, Accept-Encoding
    [square-version] => 2022-11-16
    [x-content-type-options] => nosniff
    [x-download-options] => noopen
    [x-frame-options] => SAMEORIGIN
    [x-permitted-cross-domain-policies] => none
    [x-speleo-traceid] => CDN-8516944a-e38a-4b78-bbc7-938a6c375403
    [x-sq-dc] => sjc2b
    [x-sq-region] => sjc2b
    [x-xss-protection] => 1; mode=block
    [set-cookie] => __cf_bm=vbLW0nmfeKdURx1PeD.IQzYH7cmCfQOmmkFu2mLvXK0-1689264379-0-AenWZmbKK9jF201vi2+VhdBKKPmxwckwLuRszbHO+XTCCXAaQTV/oRTP3kYL8v+aPoeyJc/BKjb5E2BMksyxp78=; path=/; expires=Thu, 13-Jul-23 16:36:19 GMT; domain=.connect.squareup.com; HttpOnly; Secure; SameSite=None
    [server] => cloudflare
)
body: {
    "latest_time": "2023-07-11T21:20:02.101Z"
}

07-13-2023 @ 12:06:19 - Completed job step: update_inventory_tracking
07-13-2023 @ 12:06:19 - Completed step cycle: update_inventory_tracking (0.14s)
07-13-2023 @ 12:06:19 - Starting step cycle: update_inventory_counts
07-13-2023 @ 12:06:19 - Request
 Request
method:
uri: batchRetrieveInventoryCounts
user-agent: WooCommerce-Square/4.0.0 (WooCommerce/7.8.2; WordPress/6.2.2)
headers: Array
(
)
body:
duration: 0.11704s

07-13-2023 @ 12:06:19 - Response
 Response
code: 200
message:
headers: Array
(
    [0] => HTTP/2 200
    [date] => Thu, 13 Jul 2023 16:06:19 GMT
    [content-type] => application/json
    [content-length] => 26
    [cf-ray] => 7e62c5c5db5def24-PDX
    [cf-cache-status] => DYNAMIC
    [content-encoding] => gzip
    [strict-transport-security] => max-age=631152000; includeSubDomains; preload
    [vary] => Origin, Accept-Encoding
    [square-version] => 2022-11-16
    [x-content-type-options] => nosniff
    [x-download-options] => noopen
    [x-frame-options] => SAMEORIGIN
    [x-permitted-cross-domain-policies] => none
    [x-speleo-traceid] => CDN-839eca7b-817c-4d36-bc88-f2de07a9970d
    [x-sq-dc] => sjc2b
    [x-sq-region] => sjc2b
    [x-xss-protection] => 1; mode=block
    [set-cookie] => __cf_bm=rsfHDMsJDPVjPxYtuKMZFEkAo9EBl.Sczo93b7Udo5M-1689264379-0-AaUUispr4ci9GAFRG3q3uLoeFucZ9ZuL0fxRikUReLkOqX0QqhoZ0oPVLsBQox55rYxnSr5mAVg8xtPHkI5Ygpg=; path=/; expires=Thu, 13-Jul-23 16:36:19 GMT; domain=.connect.squareup.com; HttpOnly; Secure; SameSite=None
    [server] => cloudflare
)
body: {}

07-13-2023 @ 12:06:19 - Completed job step: update_inventory_counts (Synced products: 0)
07-13-2023 @ 12:06:19 - Completed step cycle: update_inventory_counts (0.13s)
07-13-2023 @ 12:21:22 - Starting step cycle: update_category_data
07-13-2023 @ 12:21:22 - Request
 Request
method:
uri: searchCatalogObjects
user-agent: WooCommerce-Square/4.0.0 (WooCommerce/7.8.2; WordPress/6.2.2)
headers: Array
(
)
body:
duration: 0.19376s

07-13-2023 @ 12:21:22 - Response
 Response
code: 200
message:
headers: Array
(
    [0] => HTTP/2 200
    [date] => Thu, 13 Jul 2023 16:21:22 GMT
    [content-type] => application/json
    [content-length] => 66
    [cf-ray] => 7e62dbd01814ef94-PDX
    [cf-cache-status] => DYNAMIC
    [content-encoding] => gzip
    [strict-transport-security] => max-age=631152000; includeSubDomains; preload
    [vary] => Origin, Accept-Encoding
    [square-version] => 2022-11-16
    [x-content-type-options] => nosniff
    [x-download-options] => noopen
    [x-frame-options] => SAMEORIGIN
    [x-permitted-cross-domain-policies] => none
    [x-speleo-traceid] => CDN-da45aa87-7b6c-47f8-ab25-d1d89d2732cf
    [x-sq-dc] => sjc2b
    [x-sq-region] => sjc2b
    [x-xss-protection] => 1; mode=block
    [set-cookie] => __cf_bm=dGkNokQnVYmOLMRlu1McUmyPBykK8m9e4jszAS.KhCQ-1689265282-0-AT7p+vn4esxMkkgjbD8xSHF1A9P5llOV+xNpbD7FAl8Nbb8IZMe2njtx1Q2ptg60GqHCv8NDSv0N+h4rJbO61P4=; path=/; expires=Thu, 13-Jul-23 16:51:22 GMT; domain=.connect.squareup.com; HttpOnly; Secure; SameSite=None
    [server] => cloudflare
)
body: {
    "latest_time": "2023-07-11T21:20:02.101Z"
}

07-13-2023 @ 12:21:22 - Completed job step: update_category_data (Updated categories: 0)
07-13-2023 @ 12:21:22 - Completed step cycle: update_category_data (0.22s)
07-13-2023 @ 12:21:22 - Starting step cycle: update_product_data
07-13-2023 @ 12:21:22 - Request
 Request
method:
uri: searchCatalogObjects
user-agent: WooCommerce-Square/4.0.0 (WooCommerce/7.8.2; WordPress/6.2.2)
headers: Array
(
)
body:
duration: 0.0988s

07-13-2023 @ 12:21:22 - Response
 Response
code: 200
message:
headers: Array
(
    [0] => HTTP/2 200
    [date] => Thu, 13 Jul 2023 16:21:22 GMT
    [content-type] => application/json
    [content-length] => 66
    [cf-ray] => 7e62dbd12a51ef57-PDX
    [cf-cache-status] => DYNAMIC
    [content-encoding] => gzip
    [strict-transport-security] => max-age=631152000; includeSubDomains; preload
    [vary] => Origin, Accept-Encoding
    [square-version] => 2022-11-16
    [x-content-type-options] => nosniff
    [x-download-options] => noopen
    [x-frame-options] => SAMEORIGIN
    [x-permitted-cross-domain-policies] => none
    [x-speleo-traceid] => CDN-d24d6f6d-70bf-4710-9cb5-f92ef495ee8b
    [x-sq-dc] => sjc2b
    [x-sq-region] => sjc2b
    [x-xss-protection] => 1; mode=block
    [set-cookie] => __cf_bm=T6Ln4Cf0AdJbiT5hcPUh.JPPlauM8rJJzOozgdShgGo-1689265282-0-AaIZ/mD0IzENkzFJgpUr2BM4UuYx2kx1YOHc795yCxbFNitJHL/LLbu3M0ZIyZQjo6Z9K4XxxF8NGGo34hsghtk=; path=/; expires=Thu, 13-Jul-23 16:51:22 GMT; domain=.connect.squareup.com; HttpOnly; Secure; SameSite=None
    [server] => cloudflare
)
body: {
    "latest_time": "2023-07-11T21:20:02.101Z"
}

07-13-2023 @ 12:21:22 - Completed job step: update_product_data (Updated products: 0)
07-13-2023 @ 12:21:22 - Completed step cycle: update_product_data (0.11s)
07-13-2023 @ 12:21:22 - Starting step cycle: update_inventory_tracking
07-13-2023 @ 12:21:23 - Request
 Request
method:
uri: searchCatalogObjects
user-agent: WooCommerce-Square/4.0.0 (WooCommerce/7.8.2; WordPress/6.2.2)
headers: Array
(
)
body:
duration: 0.69507s

07-13-2023 @ 12:21:23 - Response
 Response
code: 200
message:
headers: Array
(
    [0] => HTTP/2 200
    [date] => Thu, 13 Jul 2023 16:21:23 GMT
    [content-type] => application/json
    [content-length] => 66
    [cf-ray] => 7e62dbd23aa9ef10-PDX
    [cf-cache-status] => DYNAMIC
    [content-encoding] => gzip
    [strict-transport-security] => max-age=631152000; includeSubDomains; preload
    [vary] => Origin, Accept-Encoding
    [square-version] => 2022-11-16
    [x-content-type-options] => nosniff
    [x-download-options] => noopen
    [x-frame-options] => SAMEORIGIN
    [x-permitted-cross-domain-policies] => none
    [x-speleo-traceid] => CDN-ca75bca3-43a8-47d1-8af4-f79602736068
    [x-sq-dc] => sjc2b
    [x-sq-region] => sjc2b
    [x-xss-protection] => 1; mode=block
    [set-cookie] => __cf_bm=aoHVtD2kX.4khcLqRtyNsbOB64CFnHP9qtsCgACHmQo-1689265283-0-AcTsjv9Wqq7r+AMxJFv61H7sODKfIQvJ3LbTDgIpS+Y5tFSSBhwAshrUPSV719eFbmIyV+Oc0cBc64czUffnDrY=; path=/; expires=Thu, 13-Jul-23 16:51:23 GMT; domain=.connect.squareup.com; HttpOnly; Secure; SameSite=None
    [server] => cloudflare
)
body: {
    "latest_time": "2023-07-11T21:20:02.101Z"
}

07-13-2023 @ 12:21:23 - Completed job step: update_inventory_tracking
07-13-2023 @ 12:21:23 - Completed step cycle: update_inventory_tracking (0.70s)
07-13-2023 @ 12:21:23 - Starting step cycle: update_inventory_counts
07-13-2023 @ 12:21:23 - Request
 Request
method:
uri: batchRetrieveInventoryCounts
user-agent: WooCommerce-Square/4.0.0 (WooCommerce/7.8.2; WordPress/6.2.2)
headers: Array
(
)
body:
duration: 0.10786s

07-13-2023 @ 12:21:23 - Response
 Response
code: 200
message:
headers: Array
(
    [0] => HTTP/2 200
    [date] => Thu, 13 Jul 2023 16:21:23 GMT
    [content-type] => application/json
    [content-length] => 26
    [cf-ray] => 7e62dbd6fa88ef77-PDX
    [cf-cache-status] => DYNAMIC
    [content-encoding] => gzip
    [strict-transport-security] => max-age=631152000; includeSubDomains; preload
    [vary] => Origin, Accept-Encoding
    [square-version] => 2022-11-16
    [x-content-type-options] => nosniff
    [x-download-options] => noopen
    [x-frame-options] => SAMEORIGIN
    [x-permitted-cross-domain-policies] => none
    [x-speleo-traceid] => CDN-71122240-1035-4602-ab4a-b7ad388a05fd
    [x-sq-dc] => sjc2b
    [x-sq-region] => sjc2b
    [x-xss-protection] => 1; mode=block
    [set-cookie] => __cf_bm=h_MZ4.oI.GunhZ0s1c5xNhveDN3O1gSfz2J0JpYJWRw-1689265283-0-Ad10e/OzdEsfnNUADDN0EB3vz3++BnRoLUi7n17yDZJ06H6tzpgBBGgqqNDcUvP0+U5aiN8EuYdpUS3lAhXMBpQ=; path=/; expires=Thu, 13-Jul-23 16:51:23 GMT; domain=.connect.squareup.com; HttpOnly; Secure; SameSite=None
    [server] => cloudflare
)
body: {}

07-13-2023 @ 12:21:23 - Completed job step: update_inventory_counts (Synced products: 0)
07-13-2023 @ 12:21:23 - Completed step cycle: update_inventory_counts (0.12s)

Hey @shinteetahgmailcom

I edited a troublesome product and then checked the only log for today.

Thank you for sharing that. All response codes were 200, in the nine occurrences of the log, meaning OK.

As I explained, these are not new products, these are already in WC and just not updating inventory, and I’ve tried both auto and manual sync.?

Could you try with creating a new product in WooCommerce, then manual sync, and see how it goes, please?

Subsequently, edit inventory for a product in Square, then use?WP Crontrol?to run the?woocommerce_square_inventory_poll?hook from the?Tools > Cron Events?tab. This can take a while for larger sites, so keep checking the item over the next 15 minutes as the background sync runs.

Determining in which direction the information sync is failing is important to find the problem.

Lastly, just to confirm, the missing product(s) are listed under the same?Square Location?as defined in the?plugin settings. Correct?

Thanks!

>> Could you try with creating a new product in WooCommerce, then manual sync, and see how it goes, please? <<

New variable product created in WC before manual sync. It shows in WC, not in Square, as expected.

>> Subsequently, edit inventory for a product in Square, then use?WP Crontrol?to run the?woocommerce_square_inventory_poll?hook <<

Interestingly, I don’t see that hook listed. Inventory is still syncing, though; I just had a big live event with lots of sales and some stock is updating on WC. Just not all.

>> ?just to confirm, the missing product(s) are listed under the same?Square Location?as defined in the?plugin settings. Correct? <<

I have only one location, and it’s the same in both, yes.

Thank you for reaching back, elaborating further on this, @shinteetahgmailcom , and congrats on the successful live event.

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, so that we can keep track of what’s already been done.

We will be able to help you further there.

Okay, it’s a brief victory that has not been tested over time, but it appears that we have full sync again.

I deactivated Woocommerce Payments. I think that did it. I can’t explain why, but that’s the only structural change I made yesterday.

A customer contacted me to say that she couldn’t get her payment to go through, so I disabled WC Payments and tested a credit card payment on Square. It worked, so I asked her to try again, and her payment went through. So I left Payments disabled, and later inventory on the holdout items and variations was synced.

I’ll keep an eye on it and see if sync success continues reliably, but I wanted to update.