--- title: "Amazon NetSuite sync for household multipack order counts" description: "Amazon Seller Central orders reach NetSuite with marketplace units and physical pouch counts side by side, each tied to an approved pack conversion." canonical: https://www.stacksync.com/blog/amazon-netsuite-sync-for-household-consumables-reconcile-marketplace-order-quantities last_modified: 2026-09-21 --- # Amazon–NetSuite Sync for Household Consumables: Reconcile Marketplace Order Quantities > 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 Four three-packs sold on Amazon land in NetSuite as four marketplace units and twelve pouches, with the conversion on record for the return or fee adjustment that comes later. Author Ruben Burdin · Founder & CEO Published September 21, 2026 Read time 5 min read DATA ENGINEERING ## The operating decision Preserve both Amazon order quantity and the number of physical household units in the seller’s offer. A marketplace unit may represent a multipack, case, or refill bundle. Match the seller-scoped offer to an approved ERP pack definition before calculating physical quantities or reconciling later returns. Explore the complete [household consumables integration and automation hub](https://www.stacksync.com/industry/cpg/household-consumables) for the systems and processes around this guide. ![Summary card: Amazon NetSuite sync for household multipack order counts](https://www.stacksync.com/images/blog-highlights/icp-amazon-netsuite-sync-for-household-consumables-reconcile-marketplace-order-quantities.webp) ## What this looks like in household consumables A household brand sells a three-pack of refills on Amazon while its ERP stocks individual pouches. An order quantity of four represents twelve pouches. A finance import that records four individual pouches can still carry the correct gross amount, hiding the physical mismatch until fulfillment or return reconciliation. ## Records, ownership, and update rules | Record | Owner | Operating rule | | --- | --- | --- | | Amazon offer | Marketplace operations | Retain seller, marketplace, seller SKU, and approved sellable-pack context. | | Order line | Operations | Keep the original order quantity and stable line reference. | | Pack conversion | Product operations | Approve physical units per marketplace sellable unit with effective dates. | | ERP comparison | Finance and operations | Compare monetary and physical totals independently rather than accepting one as proof of the other. | ![Record ownership diagram: Amazon offer, Order line, Pack conversion](https://www.stacksync.com/images/blog-diagrams/icp-amazon-netsuite-sync-for-household-consumables-reconcile-marketplace-order-quantities.webp) *Define the record owner and the rule before enabling updates.* ## Work through the process 1. 01 Identify the offer grain Inspect the seller offer and the order line together. A catalog title can mention several pack sizes; use the approved offer mapping instead of extracting a number from free text. 2. 02 Preserve both quantities Store marketplace units and the derived physical packages side by side. Record the conversion used so an analyst can reproduce the result when a return or fee adjustment arrives later. 3. 03 Reconcile the destination Check item, quantity, unit, currency, and source references in the ERP representation. A matching total value should not override a wrong pack count. 4. 04 Handle revisions deliberately Version pack changes and keep historical mappings available. A seller SKU reused for a new multipack must not reinterpret orders placed under the old configuration. 5. 05 Trace one three-pack order from Amazon into NetSuite line by line Pick an Amazon order for four units of the three-pack refill offer and follow it into NetSuite. The imported line should carry a quantity of four marketplace units, a derived physical count of twelve pouches, and the conversion record that produced twelve, including its effective date. Then pick a second order for a seller SKU whose pack factor is unapproved. That line should show an unreconciled physical quantity with a request open to product operations, even when the order total matches the ERP amount to the cent. A twelve that appears with no conversion reference, or a physical count filled in for the unmapped SKU, stops the rollout. ![5-step operating sequence: Amazon NetSuite sync for household multipack order counts](https://www.stacksync.com/images/blog-diagrams-mermaid/icp-amazon-netsuite-sync-for-household-consumables-reconcile-marketplace-order-quantities.webp) *Follow the operating sequence; unresolved exceptions return to a responsible reviewer.* ## Handle the exceptions explicitly ### Pack factor is absent Hold physical reconciliation and request the approved offer definition. ### Return quantity uses another unit Preserve the source unit and normalize only with a confirmed relationship. ### Overlapping import repeats the order Resolve to the original order and line identities without creating a second accepted transaction. ## What to verify before expanding - Four three-packs remain four marketplace units and twelve physical packages. - Each derived quantity records its approved conversion. - A missing pack factor leaves physical quantities unreconciled even when marketplace and ERP monetary totals agree. - A return expressed in another unit remains in its original unit until the approved offer-specific conversion is confirmed. ## 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 amazon offer example and the exception your team handles most often, for example pack factor is absent. - [Shopify–NetSuite Integration for Household Consumable Brands](https://www.stacksync.com/use-case/shopify-netsuite-integration-for-household-consumable-brands) - [Amazon–NetSuite Integration for Household Marketplace Quantities](https://www.stacksync.com/use-case/amazon-netsuite-integration-for-household-marketplace-quantities) - [Salesforce–NetSuite Sync for Household Brands Serving Janitorial Distributors](https://www.stacksync.com/blog/salesforce-netsuite-sync-for-household-brands-serving-janitorial-distributors) - [Household Product Replenishment Workflows: Prevent Duplicate Wholesale Orders](https://www.stacksync.com/blog/household-product-replenishment-workflows-prevent-duplicate-wholesale-orders) - [Household Product Return Workflows: Route Damaged and Unsellable Goods for Review](https://www.stacksync.com/blog/household-product-return-workflows-route-damaged-and-unsellable-goods-for-review) - [How to Sync Zendesk with Salesforce: A Two-Way Integration Guide](https://www.stacksync.com/blog/how-to-sync-zendesk-with-salesforce) - [Beat Shopify API Rate Limits with Stacksync Real‑Time Sync](https://www.stacksync.com/blog/beat-shopify-api-rate-limits-stacksync-realtime-sync) 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 Amazon Seller Central access](https://docs.stacksync.com/two-way-sync/connectors/amazon-seller-central) - [Stacksync NetSuite supported objects](https://docs.stacksync.com/two-way-sync/connectors/netsuite) FAQ ## Frequently asked questions Can Amazon sync correct a marketplace quantity error? The sync connector has read-only Amazon access. It can bring evidence into the investigation; any marketplace correction requires a separately verified action and authorization. A person fixes the order in Seller Central, the corrected order is read on the next pass, and the NetSuite line is updated from that read, never the other way round. Why import Amazon orders into NetSuite if nothing writes back? Because finance and operations need the marketplace record next to the inventory and the invoice, without a spreadsheet export. Read-only access is enough for reconciliation: the order line, seller SKU, and marketplace arrive as Amazon states them, and NetSuite owns everything derived from them. Anything you would want to push to Amazon, such as a listing edit or a cancellation, happens in Seller Central by a person who holds that permission. How does finance see the conversion behind a NetSuite line? Each imported line should carry the conversion it used as a reference field that points at the pack definition version in force on the order date, rather than a bare multiplied number. When a return or fee adjustment lands months later, the analyst opens that reference and reproduces twelve from four without asking product operations what the pack was at the time. A line with no reference is treated as unverified until someone attaches one. 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 Amazon Seller Central integration](https://www.stacksync.com/integrations/amazon-seller-central-and-netsuite) - [connector Amazon Seller Central integrations](https://www.stacksync.com/connectors/amazon-seller-central) - [connector NetSuite integrations](https://www.stacksync.com/connectors/netsuite) - [platform Two-way sync](https://www.stacksync.com/two-way-sync) - [Two-way sync guides Understand two-way sync, record matching, field ownership, and production readiness.](https://www.stacksync.com/blog#topic-two-way-sync) Keep reading ## Related articles [All articles](https://www.stacksync.com/blog) [Data engineering Amazon–NetSuite Sync for Beauty Brands: Match Variation Families to ERP Products 5 min read read](https://www.stacksync.com/blog/amazon-netsuite-sync-for-beauty-brands-match-variation-families-to-erp-products) [Data engineering Amazon–NetSuite Sync for Packaged Food Brands: Separate FBA and Merchant-Fulfilled Orders 5 min read read](https://www.stacksync.com/blog/amazon-netsuite-sync-for-packaged-food-brands-separate-fba-and-merchant-fulfilled-orders) [Data engineering Amazon–NetSuite Sync for Pet Brands: Reconcile Marketplace Returns and Original Orders 5 min read read](https://www.stacksync.com/blog/amazon-netsuite-sync-for-pet-brands-reconcile-marketplace-returns-and-original-orders) ## 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/)