Manufacturing · Plumbing, Water, HVAC and Appliances
EDI and API Integration for Metal Pipe, Valve and Fitting Manufacturers
Metal pipe, valve and fitting makers sell to industrial, plumbing and waterworks distributors, with material traceability and test reports. ECOM connects orders, heat and lot data, test results, freight and invoices to your ERP.
What this covers
Products and business models in metal pipe, valve and fitting
Products
- Steel, copper and brass pipe
- Valves and actuators
- Fittings and flanges
- Industrial and waterworks products
Business models
- Manufacturers selling to distributors
- Industrial MRO supply
- Project and utility programs
Scenarios
Where metal pipe, valve and fitting manufacturers lose time and margin
Recurring problems for this kind of business, how ECOM connects the systems and documents involved, and what you gain. Bring your own example and we will work through it with you.
-
Material and heat traceability
- The problem
- Customers need traceability to material heats for project work.
- How ECOM helps
- ECOM carries heat or lot identifiers from your ERP or quality system onto the 856.
- What you gain
- Project customers can trace material to its heat.
Talk to an EDI/API Expert about material and heat traceability Share a sample 856 Advance Ship Notice and 863 Report of Test Results, or describe what goes wrong, and we will show how it would map to your ERP.
-
Test reports and certificates
- The problem
- Material test reports accompany shipments.
- How ECOM helps
- ECOM sends material test report data (863) with the shipment where the customer asks.
- What you gain
- Test reports travel with the order they belong to.
Talk to an EDI/API Expert about test reports and certificates Share a sample 863 Report of Test Results and 856 Advance Ship Notice, or describe what goes wrong, and we will show how it would map to your ERP.
-
Many specifications
- The problem
- Size, schedule, grade and rating create large catalogs.
- How ECOM helps
- ECOM maps size, schedule, grade and rating to each distributor’s item numbers and sends updates (832).
- What you gain
- A specification-heavy catalog stays accurate.
Talk to an EDI/API Expert about many specifications Share a sample 832 Price/Sales Catalog and 850 Purchase Order, or describe what goes wrong, and we will show how it would map to your ERP.
Who you connect with
Trading relationships for metal pipe, valve and fitting manufacturers
Typical relationships. Which of them apply, and how each one wants to connect, depends on your business.
- Industrial and waterworks distributors
- Order stock and project items.
- Contractors and engineering firms
- Specify items.
- Steel mills and foundries
- Supply raw material.
- Test labs
- Provide results.
- Carriers
- Move heavy freight.
Partner guides: Distributor guides · Carrier guides · Manufacturer guides
Typical workflow
Where ECOM connects your systems and trading partners
The pattern below is typical for metal pipe, valve and fitting manufacturers, not one partner's confirmed requirements. Each trading partner publishes its own guide; confirm the details with that partner.
- Distributor→Your plant and ERP 850 Purchase Order The customer order: items, quantities, prices, ship-to and requested dates.
- Distributor→Your plant and ERP 860 Purchase Order Change Request Changes to open orders: quantities, dates or cancellations.
- Your plant and ERP→Distributor 855 Purchase Order Acknowledgment The order acknowledgment: confirms the order or reports differences from what was requested, including dates.
- Your plant and ERP→Distributor 856 Advance Ship Notice Heat or lot identifiers per item for traceability.
- Your plant and ERP→Distributor 863 Report of Test Results Material test results where a customer asks for them electronically.
- Your plant and ERP→Distributor 810 Invoice Bills for what was shipped, tied to the order and the ship notice.
- Your plant and ERP→Distributor 832 Price/Sales Catalog Sends item, description and price data for the customer to set up.
- Your plant and ERP→Mill or foundry 850 Purchase Order Purchase orders for bar, tube, castings and forgings with quantities and requested delivery dates.
- Mill or foundry→Your plant and ERP 856 Advance Ship Notice Bar, tube, casting and forging shipments with heat or lot identifiers, so incoming material can be matched to mill test data.
The diagram draws the exchanges between the lanes shown. Motor-carrier and warehouse documents (204, 990) are listed in the table below with the direction each travels.
Orders
Orders (850), changes (860).
Confirm lots
Acknowledgments (855) with heat or lot.
Ship notice
The 856 lists items and lots.
Send test results
Test reports (863) follow where requested.
Invoice
The 810 follows.
EDI and API exchanges
The documents behind the workflow
X12 transaction sets typical for this workflow, with what each carries here. Select a code for the full transaction reference.
| Document | Direction | What it carries for metal pipe, valve and fitting manufacturers |
|---|---|---|
| 850 Purchase Order | You receive | The customer order: items, quantities, prices, ship-to and requested dates. |
| 860 Purchase Order Change Request | You receive | Changes to open orders: quantities, dates or cancellations. |
| 855 Purchase Order Acknowledgment | You send | The order acknowledgment: confirms the order or reports differences from what was requested, including dates. |
| 204 Motor Carrier Load Tender | You send | Tenders a truck shipment to a motor carrier. |
| 990 Response to a Load Tender | You receive | The motor carrier’s acceptance or decline of the tender. |
| 856 Advance Ship Notice | You send | Heat or lot identifiers per item for traceability. |
| 863 Report of Test Results | You send | Material test results where a customer asks for them electronically. |
| 810 Invoice | You send | Bills for what was shipped, tied to the order and the ship notice. |
| 832 Price/Sales Catalog | You send | Sends item, description and price data for the customer to set up. |
| 850 Purchase Order (supplier side) | You send | Purchase orders for bar, tube, castings and forgings with quantities and requested delivery dates. |
| 856 Advance Ship Notice (supplier side) | You receive | Bar, tube, casting and forging shipments with heat or lot identifiers, so incoming material can be matched to mill test data. |
Other exchanges you may meet
- Distributor portals
- Certificate document exchange
Where a trading partner offers an API, a portal or file exchange instead of EDI, ECOM scopes that connection alongside the EDI ones. Functional acknowledgments (997 or 999) report validation results, including rejection; they do not prove business acceptance or ERP posting. Which acknowledgments and business responses each partner expects is confirmed with that partner.
Operational detail
Heats, certs and specifications
A heat number links an item to its material test report. The identifier on the notice should match the one on the certificate and on the item, and that data originates in production and quality systems.
Distributor and contractor channels
Plumbing, HVAC and appliance products reach contractors through wholesale distributors, retailers and builders, each with its own order and item data.
Material, size and pressure class
Pipe, valves and fittings are specified by material, size and pressure class. Item numbers and descriptions on orders, ship notices and invoices must agree with what the distributor set up.
Connected systems
Systems that send and receive this data
Documents are only useful when they reach the systems that run the business.
- ERP
- Quality management
- Warehouse management
- Distributor portals
ERP integration guides: SAP S/4HANA · Oracle NetSuite · Microsoft Dynamics 365 Business Central · Infor CloudSuite Industrial (SyteLine) · Epicor Prophet 21 · QAD MFG PRO · All ERP guides
Onboarding and monitoring
From first requirement to daily exception handling
Confirm the requirement
Obtain each partner's implementation guide or specification, for example from your distributor, and agree which documents, versions and data are in scope.
Map to your systems
Map each document to the fields in your ERP and quality management so the data posts without re-keying.
Test with the partner
Exchange test documents and review the results with the partner before go-live, including changes, cancellations and error cases, not only the simple order.
Validate, acknowledge and monitor
A 997 or 999 reports the validation result of the document as received, including rejection; it does not show that the business accepted the content or that your ERP posted it. Business responses are separate: an 855 for orders, an 824 for application errors. Monitoring can show what is late, missing or rejected, once it is set up with you.
Resolve exceptions
Which failures and late documents are watched, who is alerted and how each is resolved are agreed during onboarding. Rejected or unacknowledged documents can then go to the people who can fix them, with the document and the reason in view.
Example exceptions for metal pipe, valve and fitting manufacturers
| Exception | Example handling, once configured |
|---|---|
| Certificate or heat number missing for a lot | The shipment can be held for review until the lot has the documentation the customer expects. |
| Specification mismatch on an order line | The line can be held for review so the wrong schedule, grade or rating is not shipped. |
Illustrative examples of exceptions a team in this industry may need to review. Each check compares data from your ERP, WMS, trading partner documents or scans, where those are available. Which conditions are checked, who is alerted and what happens next are configured with you during onboarding. This is not a screenshot of a live system or a list of built-in checks.
How ECOM helps
ECOM products and services that apply
Each partner connects in the way it can support. These products cover the connections and visibility manufacturers need most.
-
PRISM-EDI
Exchange of schedules, orders, ship notices and invoices with customers and suppliers in X12 or EDIFACT, translated to and from your ERP.
-
PRISM-WebEDI
Browser-based purchase orders, acknowledgments, ship notices and invoices for suppliers without EDI systems.
-
PRISM-SmartConvert
Supplier confirmations, invoices and customer orders that arrive as PDFs, emails or scans converted into ERP-ready data.
-
PRISM-SCV
Monitoring of transactions and exceptions across customer and supplier documents.
Services: Trading partner onboarding · ERP integration · API integration · Fully managed EDI · Supply chain visibility · Mapping and translation
Frequently asked questions
Can test reports be exchanged electronically?
Where the customer asks for them in electronic form and your quality system produces them, yes. They are mapped from your quality records and tied to the lot or heat on the shipment.
Does ECOM verify material certifications?
No. Quality and certification remain with your teams. The integration carries the data your customers agree to receive.
Do you need our trading partner's implementation guide to start?
It helps, but you can start without one. Tell us who you trade with and which systems you run, and we will help obtain and review each partner's requirements. The guide, not this page, decides the exact documents, versions and rules for that partner.
Talk to an EDI/API expert about metal pipe, valve and fitting manufacturers
Share your trading partners, your ERP, a sample document or the problem that keeps recurring. A completed specification is not needed: a partner guide, a rejected document or a description of the issue is enough to start.