← All posts Insights 3 min read

Inventory Sync Direction: One-way vs. Two-way (and When Each Breaks)

The first integration decision isn’t which fields — it’s which way the data flows. A short, opinionated guide to one-way vs. two-way inventory sync, what each costs, and the three-number reconciliation report you should build on day one.

Most integration questions sound like product questions but are really direction questions. The first decision on any WooCommerce↔NetSuite or Shopify↔NetSuite project isn’t which fields — it’s which way the data flows. Get that wrong and you’ll spend the next year writing reconciliation scripts.

Here is the short, opinionated version of what we tell clients on the first call.

One-way: NetSuite is the source of truth

Inventory levels, prices, item masters live in NetSuite. Your store reads from NetSuite on a schedule and writes nothing back to the item record. Orders flow store → NetSuite as new sales orders. That’s it.

  • Use it when: you have a single warehouse, a small SKU count, and an operations team that already lives inside NetSuite.
  • What breaks: nothing in steady state. Onboarding new SKUs is slow because everything has to round-trip through NetSuite first.
  • What it costs: a single scheduled job, idempotent writes, and a clear “do not edit on the store side” rule for staff.

Two-way: both systems are partial sources of truth

This is where most teams get into trouble. Two-way doesn’t mean “both systems can write everything.” It means each field has exactly one owner, and the owners are split across the two systems. Prices in NetSuite. Marketing content (descriptions, images, categories) in the store. Inventory in NetSuite, but with a reservation/decrement that flows back from the store on order placement.

  • Use it when: you have multiple sales channels, a marketing team that needs to ship content fast, or fulfillment partners reporting back from outside NetSuite.
  • What breaks: field-ownership ambiguity. If your CSV importer in the store can overwrite a price, you have a bug, not an integration.
  • What it costs: conflict resolution rules, a “last write wins” timestamp on every synced field, and a reconciliation report nobody wants to build but everybody needs.

The decision in one paragraph

If you can list every field by name and say “this owner, that owner” without hedging, you’re ready for two-way. If you can’t, run one-way for ninety days, watch what your team actually edits where, and then promote individual fields to two-way as ownership stabilises. Two-way isn’t a product feature — it’s an organisational commitment. Treat it like one.

The reconciliation report you’ll want anyway

Whichever direction you pick, build the report on day one: a daily diff of item count, total on-hand inventory, and total open order value between the two systems. Three numbers. If they ever drift, you find out the same morning, not three weeks into a quarter close.

That single report has caught more integration bugs in our work than any monitoring tool. It costs an hour to build and saves a week of incident response.


Ship it

Need this in your stack?

We build, integrate, and ship — no calls, just delivery.

Start a project →