Back to feed
Dev.to
Dev.to
7/7/2026
Syncing a wholesaler's API into WooCommerce without overselling or melting the server

Syncing a wholesaler's API into WooCommerce without overselling or melting the server

Short summary

A practical architecture guide for syncing a wholesaler's REST API into WooCommerce, treating the store as a derived cache rather than the system of record. Key decisions include declarative field mapping keyed on EAN/supplier index, dumb stock rules that hide unavailable products every cycle, margin logic applied above the pull layer, and split sync cadences with frequent stock/price polls and rare full-catalog refreshes. The same pull-map-protect-compute-schedule pattern generalizes to any ERP integration.

  • Treat WooCommerce as a cache with a checkout attached; the wholesaler is the system of record
  • Use declarative field maps keyed on EAN/supplier index, dumb stock rules, and split sync cadences to prevent overselling and server overload
  • The same architecture pattern applies to any ERP integration (Comarch, Dynamics, NetSuite) — only the data source changes

Generated with AI, which can make mistakes.

Is this a good recommendation for you?

Comments

Failed to load comments. Please try again.

Explore more