--- title: "Shopify NetSuite sync for beauty shades and gift sets" description: "Shopify variant IDs map to NetSuite items so each shade, size and gift-set revision stays distinct through orders and partial returns." canonical: https://www.stacksync.com/blog/shopify-netsuite-sync-for-personal-care-brands-align-shades-sizes-and-gift-sets last_modified: 2026-09-21 --- # Shopify–NetSuite Sync for Personal Care Brands: Align Shades, Sizes, and Gift Sets > 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 Travel sizes, full sizes and seasonal sets stay separate NetSuite items, so a Shopify order or a partial set return still resolves to what the customer bought. Author Ruben Burdin · Founder & CEO Published September 21, 2026 Read time 5 min read DATA ENGINEERING ## The operating decision Personal-care two-way sync must preserve the exact shade, size, and set purchased on Shopify. Map stable variant IDs to approved ERP items or components, keeping merchandising names separate from product identity. A gift set needs its own versioned composition so orders and returns remain explainable after a seasonal assortment changes. Explore the complete [personal care integration and automation hub](https://www.stacksync.com/industry/cpg/personal-care) for the systems and processes around this guide. ![Summary card: Shopify NetSuite sync for beauty shades and gift sets](https://www.stacksync.com/images/blog-highlights/icp-shopify-netsuite-sync-for-personal-care-brands-align-shades-sizes-and-gift-sets.webp) ## What this looks like in personal care A beauty brand offers a shade in travel and full sizes plus a holiday set containing both. The names share a product family, but the physical items and price differ. A loose catalog match can ship the wrong size and later make a partial gift-set return look like a standalone product return. ## Records, ownership, and update rules | Record | Owner | Operating rule | | --- | --- | --- | | Shopify variant | Ecommerce | Preserve stable variant ID and purchased shade and size options. | | ERP item | Product operations | Own the exact product and package relationship used for operational processing. | | Gift-set recipe | Merchandising | Version component items and quantities for each sellable set. | | Return context | Support operations | Retain original set and component relationships when reviewing a later request. | ![Record ownership diagram: Shopify variant, ERP item, Gift-set recipe](https://www.stacksync.com/images/blog-diagrams/icp-shopify-netsuite-sync-for-personal-care-brands-align-shades-sizes-and-gift-sets.webp) *Define the record owner and the rule before enabling updates.* ## Work through the process 1. 01 Enumerate the product matrix Review shade and size combinations rather than mapping only product families. Include discontinued variants because customers can return products after the current catalog changes. 2. 02 Approve set composition Record each gift set’s components and effective version. Decide whether the ERP represents the set as a parent item, component lines, or another approved structure while preserving the original purchase. 3. 03 Test mixed carts Use an order with two sizes of the same shade and a gift set. Compare original line references, physical units, and financial totals before accepting the transformed order. 4. 04 Protect historical meaning Treat a packaging or set-content change as a reviewed mapping event. Marketing can improve a display title without altering the product that a historical order represents. 5. 05 Check two sizes of one shade and a retired set in NetSuite Place a Shopify test order with the travel and full size of one shade and open it in NetSuite. Each line must reference a different item record; if both point at the same item, stop and fix the variant mapping. Next, pull a gift-set order from a previous season and confirm the NetSuite lines name the components sold then, not the current assortment. Then rename a shade in Shopify. The NetSuite item should keep its internal ID with only the display name changed. A new item after a rename means identity is keyed on the name, and the rollout pauses until it is keyed on the variant ID. ![5-step operating sequence: Shopify NetSuite sync for beauty shades and gift sets](https://www.stacksync.com/images/blog-diagrams-mermaid/icp-shopify-netsuite-sync-for-personal-care-brands-align-shades-sizes-and-gift-sets.webp) *Follow the operating sequence; unresolved exceptions return to a responsible reviewer.* ## Handle the exceptions explicitly ### Shade name changes Keep stable identity and review whether the underlying product actually changed. ### Set contains a limited-edition item Require the correct component mapping instead of substituting the nearest permanent item. ### Customer returns part of a set Use the original set context and approved return policy rather than treating it as a standalone sale. ## What to verify before expanding - The same shade in two sizes remains two distinct operational items. - A historical gift set resolves to its purchased components. - A partial gift-set return uses the purchased component revision after the current seasonal assortment changes. - A limited-edition component without an approved ERP match stays unresolved instead of being replaced with a permanent-range item. ## 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 shopify variant example and the exception your team handles most often, for example shade name changes. - [Shopify–NetSuite Integration for Personal Care and Beauty Brands](https://www.stacksync.com/use-case/shopify-netsuite-integration-for-personal-care-and-beauty-brands) - [Amazon–NetSuite Integration for Beauty Marketplace Operations](https://www.stacksync.com/use-case/amazon-netsuite-integration-for-beauty-marketplace-operations) - [Amazon–NetSuite Sync for Beauty Brands: Match Variation Families to ERP Products](https://www.stacksync.com/blog/amazon-netsuite-sync-for-beauty-brands-match-variation-families-to-erp-products) - [HubSpot–Acumatica Sync for Personal Care Brands Selling to Salons and Retailers](https://www.stacksync.com/blog/hubspot-acumatica-sync-for-personal-care-brands-selling-to-salons-and-retailers) - [Personal Care Sample and Tester Workflows: Track Requests Through Warehouse Fulfillment](https://www.stacksync.com/blog/personal-care-sample-and-tester-workflows-track-requests-through-warehouse-fulfillment) - [Product Exchange Checks: Refunds, Stock, and Customer Choice](https://www.stacksync.com/blog/product-exchange-checks-refunds-stock-and-customer-choice) - [Manage Shopify Exchanges Through Zendesk and NetSuite](https://www.stacksync.com/blog/manage-shopify-exchanges-through-zendesk-and-netsuite) The shared architecture guide covers record matching, ownership, and recovery across systems. ## Technical references - [Stacksync two-way sync quick start](https://docs.stacksync.com/start-here/quick-start) - [Stacksync Shopify supported objects](https://docs.stacksync.com/two-way-sync/connectors/shopify) - [Stacksync NetSuite supported objects](https://docs.stacksync.com/two-way-sync/connectors/netsuite) - [Shopify product variant model](https://shopify.dev/docs/api/admin-graphql/latest/objects/productvariant) FAQ ## Frequently asked questions Is a product-family match sufficient? No. Shade, size, and sellable configuration can each change the item that should be shipped, priced, or returned. Which system should own the gift-set recipe, Shopify or NetSuite? Decide before the first sync runs. Holding the recipe in NetSuite as a parent item with versioned component lines keeps it where finance and the warehouse consume it, with Shopify carrying only the sellable set variant. If merchandising builds bundles in a Shopify app, export that component list into the ERP as a reviewed record rather than treating the app's live definition as the source of truth. Either choice works; switching midway does not. If a product is mapped, are its stock levels mapped too? No. Products, variants, orders and customers are the Shopify objects mapped in this process. Available quantity and shipment confirmation are separate actions with their own permissions, so a mapped item reserves no units and triggers no pick. Decide which system owns sellable stock before you expose a quantity field to Shopify, and keep NetSuite write access limited to the objects your team has reviewed. 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 Shopify integrations](https://www.stacksync.com/connectors/shopify) - [connector NetSuite integrations](https://www.stacksync.com/connectors/netsuite) - [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 Shopify–NetSuite Sync for Beverage Brands: Align Bottles, Cases, and Variety Packs 5 min read read](https://www.stacksync.com/blog/shopify-netsuite-sync-for-beverage-brands-align-bottles-cases-and-variety-packs) [Data engineering Shopify–NetSuite Sync for Household Brands: Map Refills, Concentrates, and Multipacks 5 min read read](https://www.stacksync.com/blog/shopify-netsuite-sync-for-household-brands-map-refills-concentrates-and-multipacks) [Data engineering Shopify–NetSuite Sync for Nutrition Brands: Map Flavors, Serving Sizes, and Bundle SKUs 5 min read read](https://www.stacksync.com/blog/shopify-netsuite-sync-for-nutrition-brands-map-flavors-serving-sizes-and-bundle-skus) ## 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/)