Shopify–NetSuite Sync for Household Brands: Map Refills, Concentrates, and Multipacks

What this looks like in household consumables

A cleaning brand sells a spray bottle, a concentrate refill, and a starter kit containing both. The storefront emphasizes the finished-use yield, while NetSuite records physical containers. An order for two refills must remain two concentrate packages rather than becoming the number of spray bottles suggested by the marketing description.

Records, ownership, and update rules

Work through the process

1. 01
   List physical products

   Document each sold package and its ERP relationship. Treat concentrate and ready-to-use goods as different products even when they share a scent or product-family label.
2. 02
   Separate yield from quantity

   Retain marketing yield only in its proper descriptive context. Use approved physical units and pack counts for order, inventory, shipment, and return comparisons.
3. 03
   Validate kit transformations

   Test orders containing refills, bottles, and starter kits together. Confirm that the component breakdown preserves the original purchased lines and does not double-count a bottle included in a kit.
4. 04
   Govern product changes

   Version package and kit changes while preserving past purchases. A revised concentration or container size needs product-owner review rather than a silent update to every historical mapping.
5. 05
   Run a refill and starter-kit test order through to NetSuite

   Place a Shopify test order for two concentrate refills and one starter kit, then open the sales order it creates in NetSuite. The refill line should read two of the refill item, with no quantity inferred from how many bottles the concentrate could fill. The kit line should resolve to its approved recipe, one bottle and one refill, without a second bottle appearing because bottles are also sold on their own. Next, change only the yield claim in the Shopify product description. If any NetSuite line quantity moves, or the item record changes before product operations confirms the physical product is the same, stop the rollout and correct the mapping.

Handle the exceptions explicitly

Yield claim changes

Do not alter physical order quantities; ask product operations whether the actual item changed.

Refill packaging is redesigned

Review stable item identity and effective mapping before accepting new orders.

Kit component is replaced

Require the approved recipe or substitution decision and preserve the original purchase.

What to verify before expanding

• A refill order maps to physical refill packages rather than implied finished-use volume.
• Starter kits preserve their approved component counts.
• Changing an advertised dilution or yield claim leaves the physical order and inventory quantities unchanged.
• A starter-kit component substitution preserves the purchased recipe and records the separate approved fulfillment decision.

Technical references

• Stacksync two-way sync quick start
• Stacksync Shopify supported objects
• Stacksync NetSuite supported objects
• Shopify product variant model