wiki/knowledge/woocommerce/lamarie-square-sync-failure.md · 682 words · 2026-04-05
LaMarie Beauty — WooCommerce-Square Sync Failure
Overview
During a production audit of the [1] website, Kimberly Gehrmann (client-side technical lead) discovered that the native WooCommerce-Square sync plugin — while installed and enabled — is not functioning. Inventory is not flowing between systems, products are being maintained manually in two places, and the sync logs show clear evidence of silent failure. This issue predates and is independent of the [2] work, and was a primary factor in the decision to [3] until foundational issues are resolved.
Symptoms
- ~3,000 logged sync attempts in the WordPress sync log, each with identical start and end timestamps — indicating the sync process is firing but completing instantaneously without doing any work.
- Products manually entered in WooCommerce rather than synced from Square, evidenced by naming inconsistencies between the two systems.
- No inventory flow between Square (source of truth) and WooCommerce — stock levels updated in Square do not propagate to the website.
- Dual-entry burden — staff must update product/service data in both Square and WooCommerce independently.
Root Cause (Suspected)
The native WooCommerce for Square plugin is enabled but misconfigured or broken. The identical start/end timestamps on sync log entries indicate the sync job is being triggered but exiting immediately — likely due to a configuration error, authentication failure, or plugin conflict — rather than actually exchanging data with the Square API.
"The timestamp of every single one of those logs, the start and the end time of that action is exactly the same."
— Kimberly Gehrmann, audit review meeting
Note: A previous attempt to use Zapier for WooCommerce-Square sync was abandoned because it was corrupting data in Square. The current setup relies solely on the native plugin. Zapier/Make are not in use for this integration.
Investigation Evidence
| Signal |
Finding |
| Sync log entry count |
~3,000 entries present |
| Sync log timestamps |
Start time = End time on all entries |
| WooCommerce product data source |
Manual entry (not synced from Square) |
| Naming consistency |
Inconsistencies between Square and WooCommerce product names |
| Inventory parity |
Not maintained — systems are diverged |
Impact
- Operational: Staff must manually update products and inventory in both Square and WooCommerce. Any discrepancy between systems is invisible until manually caught.
- Data integrity: WooCommerce product catalog may be stale or inconsistent with Square at any given time.
- Blocked work: The sync failure is a prerequisite blocker for any further integration work, including the paused Bookly Connect project. There is no safe path to adding more sync complexity on top of a broken foundation.
- Historical context: SEO underperformance was the original reason LaMarie Beauty engaged Asymmetric for a site rebuild (at a discounted rate). The sync failure is a separate but compounding foundational issue discovered in the same audit.
Action Items
- [ ] Mark Hope — Investigate the native WooCommerce for Square plugin configuration on production. Validate or refute the timestamp anomaly in sync logs. Identify whether the failure is authentication, configuration, or plugin conflict.
- [ ] Mark Hope — Restore functional sync between WooCommerce and Square, with Square as the authoritative source of truth for products and inventory.
- [ ] Kimberly Gehrmann — Send cleaned audit notes to Melissa with full details of sync log findings and product naming discrepancies.
The sync failure was one of several production issues surfaced in the same audit session:
- [4] — Yoast installed but target keywords and location schema missing from product pages.
- [5] — 6–7 second add-to-cart delays, non-responsive quantity updates, unstyled cart sidecar.
- [6] — "Our Team" buttons link to generic booking page instead of individual provider profiles on Square.