Skip to content

School Specialty EDI
integration guide.

Plan your School Specialty EDI integration using 4 listed document types across 1 channel. Compare channels, map business records and test the operational handoff.

Book an EDI demo Explore EDI documents
Listed documents
4
Partner document references
Listed channels
1
School Specialty (via Mercury Gate)
Implementation
Plan
Map, validate and reconcile

Adopted by fast-scaling companies moving mission-critical data in real time

Case study
Migrated from MuleSoft
Case study
Migrated from Celigo
Migrated from Heroku Connect
Migrated from Matillion
Case study
Migrated from Fivetran
Case study
Migrated from Celigo

Implementation guide

School Specialty: EDI implementation plan

Build a reliable EDI workflow for School Specialty. Use 4 document types across 1 channel to plan record mapping, prevent duplicate processing and reconcile results in your business systems.

The document list is based on the linked partner reference. Confirm the required messages, versions and directions for your account.

Map records and test the business result
Document or decisionRecord and matching IDsWhat to test
X12 210 Motor Carrier Freight Details And InvoiceListed on 1 channel: School Specialty (via Mercury Gate) freight invoice

carrier invoice, shipment reference and charge line
  • Separate line-haul, fuel and accessorial charges before comparing the invoice with the agreed rate.
  • Test a second invoice for the same shipment and distinguish a revision from a duplicate.
X12 214 Transportation Carrier Shipment Status MessageListed on 1 channel: School Specialty (via Mercury Gate) shipment status event

shipment reference, event code, event time and location
  • Deliver an older status after a newer one and retain event history without moving the current status backward.
  • Send one milestone twice and avoid duplicate customer notifications.
X12 204 Motor Carrier Load TenderListed on 1 channel: School Specialty (via Mercury Gate) load tender

load reference, pickup and delivery stop identifiers
  • Send an amended pickup appointment and retain the previous tender decision.
  • Test a multi-stop load whose stop sequence differs from address sorting.
X12 990 Response To A Load TenderListed on 1 channel: School Specialty (via Mercury Gate) load-tender response

original load reference, carrier and response
  • Associate acceptance with the correct version of the load tender.
  • Test a declined tender and ensure it returns to dispatch for reassignment.

Implementation steps

  1. Choose the trading account and channel

    Choose among School Specialty (via Mercury Gate). Confirm the business unit and account before copying a mapping from another channel.

  2. Map records and assign owners

    Start with freight invoice, shipment status event, load tender. For each document, assign the source system, destination record, stable identifiers and person responsible for exceptions. Agree whether a change updates an existing record or creates a new event.

  3. Test a complete exchange

    Run a successful exchange and the failure cases in the mapping table. Track delivery, document validation and processing in your business system separately. Agree on the School Specialty production handoff and save the results of each approved test.

  4. Check results after launch

    Match records between systems using carrier invoice, shipment reference and charge line. Assign an owner to missing responses, duplicates and rejected records. Test recovery before enabling automatic retries.

Go-live checklist

  • The required X12 documents, versions and sample files are agreed.
  • Sender and receiver IDs, test connections and production connections are agreed with the channel owner.
  • Delivery receipts, document validation and business responses have monitoring and a named owner.
  • Tests cover duplicates, partial processing and reconciliation with realistic business records.

Document catalog

EDI documents listed for School Specialty

4 transactions across 1 channel.

Document flow

Example document relationships for School Specialty

Where each document sits in its trading cycle, based on the 4 document types listed for School Specialty across 1 channel. These are example relationships; the trading agreement determines the required sequence.

Network context

School Specialty channel references for MercuryGate

These network names are derived from the listed School Specialty channels. Confirm routing, enrollment and contractual requirements for your account before selecting a connection method.

LEGACY EDI MIGRATION FUND

Still with a legacy EDI vendor? We cover the buyout.

Stacksync buys back your current contract with SPS Commerce, Cleo, TrueCommerce, or OpenText. No migration cost, no overlap billing.

Check your eligibility for the EDI migration fund
Migrate from SPS Commerce
Migrate from Cleo
Migrate from TrueCommerce
Migrate from OpenText
SECURITY

Security teams trust Stacksync

As a data company, we understand the importance of keeping your data secure. Stacksync is built with security best practices to keep your data safe at every layer, and is DPF-certified for US, EU, UK and CH data transfers.

Learn more about security
SOC 2 Type II
ISO 27001
HIPAA BAA
GDPR
CCPA
DPF US-EU-UK-CH
→ SECURITY WITH BENEFITS

SSO & SCIM

Let your users access Stacksync from your centralized user management systems. Works with Okta, Azure, Google SSO and more.

Alerts

Immediately get alerted about record syncing issues over email, Slack, PagerDuty and WhatsApp. Resolve issues from a centralized dashboard with retry and revert options.

Secure connection options

Securely connects to your systems with:

OAuth 2SSH TunnellingSSL certificatesIP WhitelistingVPN gatewayVPC peeringand more

Related references

Partners with related document listings

Compare document requirements for similar business processes.

E2open, LLC 143 docs · 37 channels Costco 55 docs · 12 channels Ryder 49 docs · 21 channels The Home Depot 48 docs · 11 channels Mercury Gate 45 docs · 12 channels Walmart 32 docs · 8 channels Target 23 docs · 4 channels United Natural Foods, Inc. (UNFI) 17 docs · 4 channels Aldi 16 docs · 2 channels Rivian Automotive, Inc 11 docs · 1 channel Shoe Carnival 10 docs · 2 channels HP (Ryder) 9 docs · 4 channels Staples Inc. 9 docs · 2 channels GNC Holdings, LLC (via Manhattan Associates) 8 docs · 2 channels White Cap 8 docs · 1 channel Fiji Water / OTM 8 docs · 2 channels Redwood Logistics 8 docs · 2 channels Ripple Foods 8 docs · 2 channels XPO Logistics Freight, Inc. 8 docs · 2 channels GlobalTranz 7 docs · 2 channels Schneider National Carriers, Inc. 6 docs · 2 channels

Showing 21 of 48 references

Browse the full directory

FAQ

School Specialty EDI questions

Which EDI documents are listed for School Specialty?

X12 210 Motor Carrier Freight Details And Invoice; X12 214 Transportation Carrier Shipment Status Message; X12 204 Motor Carrier Load Tender; X12 990 Response To A Load Tender. Confirm which documents, directions and versions apply to your account.

How should I choose the School Specialty EDI channel?

The directory lists 1 channels for School Specialty, including School Specialty (via Mercury Gate). Match the channel to your actual trading relationship and compare its document list before reusing a mapping.

Which identifiers should the School Specialty mapping preserve?

For X12 210 Motor Carrier Freight Details And Invoice, plan around carrier invoice, shipment reference and charge line. For X12 214 Transportation Carrier Shipment Status Message, use shipment reference, event code, event time and location. Use the partner guide to locate these values and check their allowed formats.

Does a successful EDI receipt mean School Specialty accepted the business document?

Track delivery, document validation and business processing separately. An AS2 message disposition notification (MDN) confirms transport receipt; an X12 997 or 999 reports technical validation. Use the agreed business response or reconciliation report to confirm that the order, shipment or invoice was processed.

What should be tested before launching School Specialty EDI?

Separate line-haul, fuel and accessorial charges before comparing the invoice with the agreed rate. Test a second invoice for the same shipment and distinguish a revision from a duplicate. Also test missing responses and recovery after a destination failure. Assign an owner to each failure and obtain partner approval before launch.

Coworkers laughing in front of a laptop in a casual office setting

Your last integration took months.
Your next one takes a prompt.

Book a demo Get started