NetSuite EDI Integration with Celigo: A Practical Guide

NetSuite EDI integration means automatically exchanging business documents — purchase orders, advance ship notices, and invoices — between NetSuite and your retail trading partners or suppliers. With Celigo, this runs through Celigo B2B Manager, which handles both the EDI side (trading partner profiles, X12 and EDIFACT parsing and validation, connectivity) and the NetSuite side, mapping documents into sales orders, item fulfillments and invoices. Distributors who already use an EDI provider such as SPS Commerce or TrueCommerce can also keep it and use Celigo for the NetSuite side. For a full overview of what Entech delivers on Celigo for NetSuite EDI, see our Celigo NetSuite EDI integration service page.

How Celigo connects to NetSuite for EDI

Celigo B2B Manager runs inside the Celigo platform. According to Celigo’s B2B Manager documentation, it is made up of VAN connectors (with ECGrid), trading partner connectors, EDI profiles with validation rules, and an EDI parser and file generator. Each trading partner profile holds the format (X12 or EDIFACT), qualifiers and identifiers, control numbers and validation rules; X12 validation follows the X12 standards and EDIFACT validation follows the UNECE standard. Celigo also provides NetSuite EDI templates for X12 and EDIFACT order-to-cash and an X12 procure-to-pay flow.

In practice, an inbound 850 purchase order arrives from the retailer, B2B Manager parses and validates it against that partner’s profile, and the flow creates a NetSuite sales order. Outbound documents such as the 856 advance ship notice and the 810 invoice are generated from NetSuite records and sent back to the partner.

You can still pair Celigo with an EDI provider. Many distributors already have a contract with SPS Commerce, TrueCommerce, DiCentral or a VAN such as OpenText, and some prefer a provider that manages partner onboarding and compliance for them. In that setup the provider handles translation and partner connectivity, and Celigo moves the documents into and out of NetSuite. Which route fits depends on how many trading partners you have, your existing contracts, and how much partner management you want to own.

EDI document types in a NetSuite wholesale environment

Six EDI transaction sets cover the majority of wholesale distribution flows. Each maps to specific NetSuite record types that Celigo creates or updates.

850 Purchase Order → NetSuite Sales Order. When a retailer places an order, their system sends an EDI 850. Celigo maps each line item to a NetSuite sales order, applying item cross-references from the trading partner configuration. This is the highest-volume inbound transaction for most distributors, and the one where item-code mismatches cause the most failures.

856 Advance Ship Notice → NetSuite Item Fulfillment. After you ship, NetSuite creates an item fulfillment record. Celigo reads that record and generates an EDI 856, sending it back to the retailer. Timing matters: the 856 must fire after the shipment is confirmed in NetSuite, not when the order is picked or packed. Retailers penalize late or early ASNs — configure the trigger carefully.

810 Invoice → NetSuite Invoice. Some retailers expect an EDI 810 invoice rather than a PDF. Celigo reads the NetSuite invoice record after fulfillment and generates the 810. Payment terms on the NetSuite invoice — Net 30, Net 60 — map directly to the 810 invoice terms field.

855 PO Acknowledgement. When you receive an 850, many retailers require an 855 confirming receipt and whether you can fulfill each line. Celigo can generate the 855 from NetSuite automatically after the sales order is created, or after a manual review step if your team needs to check available stock first.

940/945 Warehouse Orders (for 3PL distributors). If you use a third-party warehouse, the 940 (warehouse shipping order) goes from your system to the 3PL when you need to ship, and the 945 (warehouse shipping advice) comes back confirming the shipment. Celigo maps the 940 from a NetSuite item fulfillment and writes the 945 back into NetSuite to update the fulfillment record with actual ship quantities and tracking.

997 Functional Acknowledgement. The 997 is an automatic confirmation that a document was received without structural errors. 997 generation is usually automatic once configured per trading partner, in B2B Manager or in your EDI provider if you use one, and it then fires for every inbound transaction. If a 997 is not received, the sending party retransmits, which causes duplicate order problems downstream.

Setting up NetSuite EDI integration with Celigo

Setup follows a consistent sequence regardless of how many trading partners you're onboarding. The most common mistake is trying to onboard multiple trading partners simultaneously before the first one is stable.

Step 1: Decide how you connect to trading partners. Either run EDI in Celigo B2B Manager, connecting through a VAN or directly over AS2 or SFTP, or keep your existing EDI provider and let Celigo handle the NetSuite side. Collect each retailer’s EDI implementation guide at this stage, because every retailer’s 850 has slightly different field requirements.

Step 2: Install Celigo B2B Manager in NetSuite. Install the Celigo SuiteApp from the NetSuite marketplace. Create a dedicated integration role in NetSuite with read/write permissions on customers, items, sales orders, item fulfillments, and invoices. Do not use an administrator account for integration access — a scoped role limits blast radius if credentials are ever compromised.

Step 3: Configure trading partner profiles in Celigo. Each trading partner gets its own profile in Celigo B2B Manager. This profile contains the field mappings for that retailer's specific 850 format, their item identifier conventions (UPC, internal item code, vendor item number), and their acknowledgement requirements. Trading partner configuration is the most time-consuming part — each new partner adds roughly one week to the project timeline.

Step 4: Build the item cross-reference table. This is the most important and most commonly skipped step. Retailers use their own item codes in EDI files; NetSuite uses your internal IDs or SKUs. If Celigo cannot match a retailer's item code to a NetSuite item record, the sales order creation fails. Build a complete cross-reference lookup table before going live — one row per item per trading partner. Missing entries cause silent failures that only surface during production order processing.

Step 5: Test in sandbox with real EDI files. Run actual 850 files — not synthetic test data — through Celigo's sandbox environment connected to your NetSuite sandbox account. Verify that sales orders are created correctly, line items map accurately, and 856s and 810s generate and reach the partner (or your EDI provider) as expected. Real EDI files expose edge cases that test files miss: unusual item codes, multi-line orders, split shipments.

Step 6: Go live with one trading partner, then expand. Activate one trading partner at a time. Monitor the first 10–20 EDI cycles closely before adding the next partner. Most production issues appear in the first few real orders, not later. Sequential onboarding also makes it easier to attribute failures to a specific trading partner configuration rather than troubleshooting a global issue.

For a broader view of how Entech scopes and delivers these projects alongside other NetSuite integration work, see our Celigo implementation guide. If your environment also involves wholesale ecommerce or 3PL alongside EDI, the Celigo for wholesale distributors guide covers how those flows interact.

Common NetSuite EDI errors and fixes

Item code mismatch — "Item not found" on sales order creation. The most common error. The retailer's item code in the 850 does not match anything in the cross-reference table. Fix: add the missing mapping to the cross-reference table in Celigo. If a retailer uses multiple item identifiers across different order types, map all variants. Retailers periodically add new item codes without notice; build a monitoring alert for unmapped item failures rather than discovering them days later.

856 firing before fulfillment is confirmed. The advance ship notice is sent before the shipment is actually picked and confirmed in NetSuite, causing the retailer's system to mark the order as shipped while it is still in your warehouse. Fix: configure the 856 trigger to fire on item fulfillment status "Shipped" only. Do not trigger on sales order creation or picking status — the fulfillment record must exist and be marked shipped first.

Duplicate sales orders from re-transmitted 850s. Retailers sometimes retransmit 850s after a technical failure, and Celigo creates a new sales order for each transmission. Fix: configure a unique PO number check before creating a new sales order. If the retailer's PO number already exists in NetSuite as an external ID, update or skip the record rather than creating a duplicate. This deduplication step belongs in the flow logic, not as a manual cleanup task.

997 not received — the partner reports unacknowledged documents. 997 acknowledgements are not being generated for inbound 850s, so the retailer’s system retransmits. Fix: confirm that 997 generation is enabled in the trading partner profile, in B2B Manager or in your EDI provider if you use one. It is configured per partner and not always on by default.

Timeline and cost

For a standard wholesale distributor connecting one or two retail trading partners, budget $12,000 to $20,000 in implementation services through a certified Celigo partner, with a 4 to 8 week timeline from kickoff to go-live on the first trading partner. Celigo B2B Manager is quoted by Celigo based on your plan and trading partners. If you also keep an EDI provider or VAN, its fees are separate and vary by provider.

What pushes the timeline out: heavily customized NetSuite item records, trading partners with unusual PO requirements, more than three new trading partners onboarding simultaneously, or a 3PL workflow requiring the 940/945 transaction set alongside the standard 850/856/810 flows.

For distributors with five or more trading partners to onboard, expect 8 to 16 weeks and $25,000 to $50,000 in implementation services. Trading partner onboarding is sequential — each partner requires its own configuration, item cross-reference mapping, test cycle, and sign-off — so the timeline scales linearly with partner count, not logarithmically.

Ongoing maintenance after go-live — new trading partner onboarding, retailer schema changes, Celigo version updates, and item record additions — typically runs $1,500 to $4,000 per month on a managed retainer. Treating the integration as set-and-forget is the most reliable way to accumulate production failures over time; retailers update their EDI requirements more frequently than most distributors expect.

Frequently Asked Questions

Does Celigo have a native EDI connector for NetSuite?

Yes. Celigo B2B Manager runs inside the Celigo platform with trading partner profiles, an EDI parser and file generator, X12 and EDIFACT validation and VAN connectivity, and Celigo provides NetSuite EDI templates for order-to-cash and procure-to-pay. It creates NetSuite sales orders, item fulfillments and invoices from EDI documents and generates the outbound documents.

Do I need a separate EDI hub if I use Celigo for NetSuite?

Not necessarily. Celigo B2B Manager can handle EDI translation, validation and partner connectivity itself. Many distributors keep an existing EDI provider such as SPS Commerce or TrueCommerce because they are already under contract or want the provider to manage partner onboarding; in that case Celigo handles the NetSuite side.

What EDI documents does Celigo support with NetSuite?

Celigo B2B Manager supports the full range of standard wholesale EDI transactions: 850 PO → Sales Order, 856 ASN → Item Fulfillment, 810 Invoice, 855 PO Acknowledgement, 940/945 Warehouse Shipping Orders for 3PL flows, and 997 Functional Acknowledgements. The specific transactions configured depend on what your trading partners require.

How long does NetSuite EDI integration setup take with Celigo?

A standard setup for one or two trading partners typically takes 4 to 8 weeks from kickoff to go-live. Each additional trading partner adds roughly one week of configuration and testing. A full network of five or more partners typically runs 8 to 16 weeks. Custom NetSuite configurations — custom item records, multi-subsidiary, complex pricing logic — add two to four weeks.

How much does NetSuite EDI integration with Celigo cost?

Implementation through a certified partner runs $12,000 to $20,000 for a standard one-to-two trading partner project. Celigo B2B Manager is quoted by Celigo. EDI provider or VAN fees, if you use one, are separate. Larger projects covering five or more trading partners run $25,000 to $50,000 in implementation services.

Entech Solutions has delivered NetSuite EDI integrations on Celigo B2B Manager for wholesale distributors, CPG brands, and 3PL-dependent retailers. If you are onboarding a new retail trading partner, migrating from legacy EDI middleware, or troubleshooting an existing flow, get in touch — we'll give you a straight read on timeline, scope, and cost before any commitment. If EDI is one piece of a larger integration project, see our guide to ERP integration for wholesale distributors for the full picture — ecommerce, CRM, and 3PL alongside EDI.

Updated October 28, 2026: corrected how Celigo B2B Manager handles EDI (it parses and validates X12 and EDIFACT itself; an EDI provider is optional), based on Celigo’s B2B Manager documentation.