Oracle NetSuite × Landed Cost Sync
NetSuite Landed Cost for Shopify Plus Order Margin
NetSuite landed cost sync for Shopify Plus: freight, duty, insurance, and handling flow into Agentis so every order's net margin is checked on true cost before it ships.
The Problem
Most Shopify Plus merchants who sync COGS from NetSuite only sync the item-level unit cost (the cost on the Item record). But unit cost is not true cost. True cost is landed cost: the unit cost plus inbound freight allocation, customs duty, insurance, broker fees, and warehouse handling. For imported goods, the gap between unit cost and landed cost is often 18-35%. A product that costs $12 on the PO lands at $15.80 after freight, duty, and handling. If your margin calculation uses the $12 number, you are overstating margin on every order containing that SKU. NetSuite has sophisticated landed cost tracking: it allocates freight, duty, and insurance across PO line items using configurable methods. But that landed cost data rarely makes it to the commerce side. Standard sync flows often pull only the base item cost field, leaving the landed cost components stranded in NetSuite. The result is a margin picture that thinks it is holding a 25% floor while orders are actually shipping at 18% true margin.
How Agentis Solves This
Agentis uses the full landed cost from NetSuite, not just the unit cost field: the allocated freight, duty, insurance, broker fees, and handling components that make up the true cost of each SKU. It resolves the fully burdened cost per unit and uses that number (not the base item cost) as the COGS input when it computes each Shopify Plus order's net margin, within 60 seconds of the order being placed. When a new container arrives and NetSuite recalculates the landed cost allocation (because freight was higher than estimated, duty rates changed, or the broker invoice came in), Agentis picks up the updated landed cost and applies it to the next orders it checks. Orders that fall below your floor on true landed cost are flagged or held before fulfillment.
Benefits
- Close the gap between item cost and true landed cost in per-order margin calculations
- Automatically reflect updated landed cost allocations when freight, duty, or handling actuals replace estimates
- Stop overstating margin on imported goods where landed cost components are a significant share of total cost
- Give finance teams an order margin number that matches the fully burdened cost in NetSuite, not just the PO price
Technical Details
Agentis reads NetSuite landed cost data and resolves the fully allocated cost per item. It supports NetSuite's landed cost allocation methods: by quantity, by value, and by weight. When inbound shipment records are updated in NetSuite (for example, actual freight replaces estimated freight), Agentis picks up the recalculated landed cost. The landed cost is stored per item per lot/receipt, and when an order is evaluated Agentis resolves the cost using the costing logic configured in your NetSuite account. This keeps the per-order margin aligned with the cost your accountant would calculate.
Frequently Asked Questions
What landed cost components does Agentis pull from NetSuite?
Agentis reads the landed cost categories configured in your NetSuite instance: inbound freight, customs duty, insurance, broker fees, warehouse handling, and any custom cost categories you have defined. Each component is tracked separately in the Agentis cost model for reporting, and the sum is used as the COGS input for each order's margin check.
How does Agentis handle estimated vs actual landed costs?
NetSuite often records estimated landed costs when a PO is received and updates them when actual invoices arrive. Agentis uses whatever value is current in NetSuite. When the estimate is replaced by an actual, Agentis picks up the change and updates the margin engine. Orders evaluated between estimate and actual are marked in the Evidence Ledger for reconciliation.
Does this work for domestic products that don't have duty or freight allocations?
Yes. For domestic items, the landed cost equals the item cost (no additional allocations). Agentis reads whatever landed cost NetSuite has calculated, whether that includes six cost categories or none.
What if our NetSuite instance does not use the landed cost module?
If you do not use NetSuite's native landed cost tracking, Agentis falls back to the item-level cost field (Average Cost, Last Purchase Price, or Standard Cost). You can also configure landed cost percentages per product category in Agentis as a stop-gap until you enable the NetSuite module.
How does NetSuite landed cost reach the Shopify Plus order margin check in practice?
Agentis resolves the fully allocated landed cost per item from NetSuite, picks up changes whenever a landed-cost allocation changes, and stores the result keyed by SKU and receipt. When a Shopify Plus order is placed, the margin engine pulls the current landed cost (not the raw item cost) and uses it as the COGS input for the profit-floor check, within 60 seconds of the order. The number Agentis uses is the same number your NetSuite landed cost allocation calculated, with no manual step between the two.
Related Oracle NetSuite Features
Feature
Live Margin Sync
NetSuite Shopify Plus margin sync. Agentis checks every order against live NetSuite COGS within 60 seconds and flags or holds losers before they ship.
Feature
Automated COGS Sync
NetSuite COGS automation for Shopify Plus. Replace manual cost imports so every order's net margin is checked against current NetSuite unit costs before it ships.
Feature
Margin Reporting
NetSuite margin reporting that ties Shopify Plus orders to live ERP costs. See per-order, per-SKU, per-channel net margin without manual reconciliation.
Feature
Multi-Currency COGS
NetSuite multi-currency COGS for Shopify Plus. Agentis applies current FX to every order's net margin within 60 seconds and flags or holds losers before they ship.
Feature
ERP Shopify Sync
NetSuite-to-Shopify Plus cost pipeline for margin governance. Live COGS and landed cost feed per-order net margin checks within 60 seconds, before orders ship.
Free Audit, No Commitment
Protect Every Order's Profit Margin
See exactly how much margin Agentis can recover for your store in 7 days, no commitment required.