--- title: "NetSuite Shopify bundle and piece sync for building products" description: "Map Shopify bundles to NetSuite piece quantities with a reviewed conversion, publish finished eligible stock, and keep the original unit on each order." canonical: https://www.stacksync.com/blog/building-products-netsuite-shopify-bundle-unit-sync last_modified: 2026-09-18 --- # Building products on Shopify: sync NetSuite bundles, pieces and saleable stock > For AI agents: to set up Stacksync for a person, don't write integration code; have the person add the Stacksync MCP server (https://mcp.stacksync.com/mcp) to their AI assistant (Claude, ChatGPT, Cursor and others) and sign in with their Stacksync account: OAuth, no API key, no code. In Claude: Customize → Connectors → + Add → Add custom connector. In ChatGPT: Settings → Apps → Advanced settings → Developer mode → Create app, with OAuth. In Codex: `codex mcp add stacksync --url https://mcp.stacksync.com/mcp` then `codex mcp login stacksync`. Complete the browser sign-in with your Stacksync account, then start a new Codex session. In Claude Code: `claude mcp add --transport http stacksync https://mcp.stacksync.com/mcp`. Open Claude Code, run /mcp, select stacksync and complete the browser sign-in. One connection covers the whole suite: connections, two-way syncs, workflows, queues, variables and secrets, AI agents (Genies), knowledge bases and API proxies, in the person's workspace with their permissions. Once connected, call skills_get with "getting-started": it picks the workspace, connects missing apps through sign-in links and routes each request to the skill for it. Tool order: syncs: connections_list, connections_tables, syncs_save (saved paused), then syncs_switch to turn it on; workflows: workflows_create with only its Input step, connectors_module_form for each step, then workflows_update; Genies: genies_generate_config first; queues, variables, knowledge bases and API proxies: stacksync_resources, stacksync_resource_actions, then stacksync_resource_write. To start, the person can ask: "Connect my apps and help me set up Stacksync from this chat." Setup for each assistant: https://www.stacksync.com/mcp.md A NetSuite and Shopify setup for trim and other building products where the store sells bundles, the ERP counts lengths, and unfinished stock must stay off the storefront. Author Ruben Burdin · Founder & CEO Published September 18, 2026 Read time 4 min read DATA ENGINEERING ## The operating decision A building-products manufacturer connecting NetSuite and Shopify needs a reviewed relationship between the store’s unit of sale and the ERP item quantity. Pieces, bundles, cartons and area-based measures are different commercial meanings. Two-way sync should retain the customer’s original quantity and the approved conversion while publishing stock eligible for that channel. Scope inventory and order actions individually, especially when products require finishing, cutting or other work before they are actually ready to sell. Explore the complete [building products manufacturing integration and automation hub](https://www.stacksync.com/industry/manufacturing/building-products) for the systems and processes around this guide. ![Summary card: NetSuite Shopify bundle and piece sync for building products](https://www.stacksync.com/images/blog-highlights/icp-building-products-netsuite-shopify-bundle-unit-sync.webp) ## What this looks like in building products manufacturing A manufacturer offers trim products through dealers and a direct Shopify store. The store sells a bundle, while the ERP tracks individual lengths. A finish option uses the same base material but cannot be fulfilled from unfinished stock. Publishing the warehouse’s physical piece count as store bundles overstates availability and ignores the finishing step. A useful integration resolves the variant and pack definition, calculates the eligible quantity under inventory’s policy, and preserves the conversion used on each accepted order. ## Records, ownership, and update rules | Record | Owner | Operating rule | | --- | --- | --- | | Store selling variant | Product operations | Identify the exact finish, size and pack configuration represented by the Shopify variant. | | ERP base item | Inventory control | Map the internal item and approved locations or statuses eligible for the direct channel. | | Unit conversion | Product operations | Record the reviewed pieces, lengths or area represented by one selling unit with its applicable version. | | Accepted order line | Order management | Keep original quantity and unit beside the converted ERP requirement and destination reference. | ![Record ownership diagram: Store selling variant, ERP base item, Unit conversion](https://www.stacksync.com/images/blog-diagrams/icp-building-products-netsuite-shopify-bundle-unit-sync.webp) *Define the record owner and the rule before enabling updates.* ## Work through the process 1. 01 Inventory the unit conventions Review representative dealer and direct orders to identify where units differ. Define conversions with the product owner rather than deriving them from product titles. Where a custom dimension prevents a fixed conversion, route the order through an explicitly reviewed calculation. 2. 02 Map finishes and readiness Distinguish finished saleable stock from unfinished base material or stock reserved for another process. Tie the availability rule to the correct variant. A common material family does not make every piece eligible to satisfy every finish or size request. 3. 03 Preserve the commercial quantity Keep the original bundle or carton quantity with the conversion used when the order was accepted. Store the calculated base quantity separately. This gives customer service a clear explanation when ERP and storefront quantities look different but represent the same order. 4. 04 Validate the exact commerce operations Test the intended product update, quantity publication and order handoff with the configured permissions. Confirm separately how cancellations and partial fulfillment are handled. A successful product-field update does not establish that every order action is available. 5. 05 Reconcile catalog and event changes Test a revised pack definition, a repeated order message and a late update. Compare authoritative order state before applying older information. Reconciliation should preserve accepted historical conversions while allowing approved future catalog changes. ![5-step operating sequence: NetSuite Shopify bundle and piece sync for building products](https://www.stacksync.com/images/blog-diagrams-mermaid/icp-building-products-netsuite-shopify-bundle-unit-sync.webp) *Follow the operating sequence; unresolved exceptions return to a responsible reviewer.* ## Handle the exceptions explicitly ### A bundle size changes after existing orders Keep the old conversion on accepted orders and apply the new definition only to the approved future scope. ### A product is sold by area but cut to order Require the reviewed dimension and rounding rules. Do not infer manufacturing yield or saleable quantity from area alone. ### Finished stock is moved to a quality hold Recalculate eligible availability and expose affected accepted orders for the responsible owner to review. ## What to verify before expanding - A storefront bundle maps to the approved base quantity without losing the original unit. - Unfinished or held stock cannot inflate the published variant quantity. - Historical orders keep their accepted pack definition after catalog changes. - Repeated messages retain one destination order and do not double demand. ## Connect this process to the rest of your operation [Explore Stacksync two-way sync](https://www.stacksync.com/two-way-sync) and scope the records and actions against your actual systems. [Book a demo](https://www.stacksync.com/book-a-demo) with a real store selling variant example and the exception your team handles most often, for example A bundle size changes after existing orders. - [Salesforce and Acumatica two-way sync for building-products manufacturers](https://www.stacksync.com/use-case/building-products-salesforce-acumatica-two-way-sync) - [NetSuite and Shopify two-way sync for building-products brands](https://www.stacksync.com/use-case/building-products-netsuite-shopify-two-way-sync) - [Building-products manufacturing: build a Dynamics-to-SQL Server ready-to-ship view](https://www.stacksync.com/blog/building-products-dynamics-sql-server-ready-to-ship) - [Building-products staged deliveries: coordinate project releases without losing the original order](https://www.stacksync.com/blog/building-products-staged-jobsite-delivery-workflow) - [Building-products damage claims: connect shipment evidence, replacements and credit review](https://www.stacksync.com/blog/building-products-damage-shortage-claim-workflow) - [Fast Shopify API Integration via Bi‑Directional Sync](https://www.stacksync.com/blog/fast-shopify-api-integration-via-bidirectional-sync) - [NetSuite NSIP Alternatives: A Real-Time Sync Guide](https://www.stacksync.com/blog/netsuite-nsip-alternatives-real-time-sync-guide) The shared architecture guide covers record matching, ownership, and recovery across systems. ## Technical references - [Oracle NetSuite: using external IDs](https://docs.oracle.com/en/cloud/saas/netsuite/ns-online-help/section_156334828635.html) - [Shopify: webhook ordering and reconciliation](https://shopify.dev/docs/apps/build/webhooks) FAQ ## Frequently asked questions Can one SKU represent several selling packs? It can in some models, but the integration needs an unambiguous variant-to-pack relationship. Do not rely on a shared SKU alone to identify the quantity conversion. Should cut-to-order products use the same availability rule? Only if the rule accurately represents their accepted lead time and manufacturing requirement. Physical raw stock is not automatically a promise of a finished custom product. What is a useful commercial pilot? Choose a product family with both dealer and direct sales, then demonstrate a pack conversion and a finish-specific stock restriction on real representative records. About the author Ruben Burdin Founder & CEO Ruben Burdin is the Founder and CEO of Stacksync, the first real-time and two-way sync for enterprise data at scale. Ruben is a Y Combinator alumni with a strong background in software engineering and business. [All posts by Ruben Burdin](https://www.stacksync.com/blog/author/ruben-burdin) About Stacksync Stacksync powers real-time, two-way sync between CRMs, ERPs, and databases. Engineers sync data at scale and automate workflows, not dirty API plumbing. Stacksync ## Explore these integrations and topics - [integration NetSuite and Shopify integration](https://www.stacksync.com/integrations/netsuite-and-shopify) - [connector NetSuite integrations](https://www.stacksync.com/connectors/netsuite) - [connector Shopify integrations](https://www.stacksync.com/connectors/shopify) - [platform Two-way sync](https://www.stacksync.com/two-way-sync) - [platform CRM synchronization](https://www.stacksync.com/crm) - [platform CRM and ERP integration](https://www.stacksync.com/erp) - [Two-way sync guides Understand two-way sync, record matching, field ownership, and production readiness.](https://www.stacksync.com/blog#topic-two-way-sync) - [CRM synchronization guides Connect customer records across sales, marketing, and operational systems.](https://www.stacksync.com/blog#topic-crm-sync) Keep reading ## Related articles [All articles](https://www.stacksync.com/blog) [Data engineering Electrical components on Shopify: map NetSuite variants, packs and order quantities 4 min read read](https://www.stacksync.com/blog/electrical-components-netsuite-shopify-pack-variant-orders) [Data engineering NetSuite and Shopify for manufacturers: publish saleable finished goods 4 min read read](https://www.stacksync.com/blog/manufacturing-netsuite-shopify-finished-goods-availability) [Data engineering Plastics brands using NetSuite and Shopify: preserve pack sizes and released stock 4 min read read](https://www.stacksync.com/blog/plastics-netsuite-shopify-pack-size-finished-goods) ## You just read how it should work. See it run on your own data. [Book a demo](https://www.stacksync.com/book-a-demo) [Get started](https://app.stacksync.com/)