Skip to Content

One Source of Truth: Putting AS400 Data to Work

Dwight Zahringer

November 16, 2026

Share:

Perfect Afternoon Detroit Digital Agency

How PA is Bringing Terminal Supply’s Data into AI

A lot of manufacturers and distributors in Michigan and throughout the United States still run their business on an IBM ISeries software, better known as the AS 400 I-Series computer system. Pricing, stock, customers, and a businesses’ orders all live in the AS/400. When it was time for a modern website, the usual assumption is that the AS400 mainframe needed to be replaced, or that everything will end up typed into two systems. This is further from the truth.

Terminal Supply Company (TSC) came to PA with that exact setup, and replacing the AS400 operating system was never on the table. So we’re building their new B2B store to work from the AS400 data instead of keeping a second copy of it. Here’s how the data moves, what it powers, and what we’d tell anyone looking to extract and share the AS/400 data to their website or with a future MCP server.

Before Web Integration

Before the AS400 website integration, web orders came in as emails. An employee on the TSC team then entered each one into the AS 400 by hand, filling out its data tables line by line. Every order was typed twice, once by the customer and once by staff. Inefficient and leave the door open for mistakes.

The AS400 Stays in Charge

The AS400 remains the system of record. The new website reads from it through a small integration layer PA designed and built, so the site never touches the AS 400 computer system directly, and Terminal Supply Co.’s IT team controls exactly what that layer can see.

Almost all the data pulled from the AS 400 is read only. New orders go to a staging area where a TSC analyst reviews them before anything enters the ERP. Nothing that already lives in the AS400 ever gets typed into the website.

One Part Number Ties It All Together

The part number has to match the AS400 exactly. That one rule keeps the whole system honest, because every product page draws from three places:

  • Product sheets: the descriptions, specs, and other content the TSC team writes.
  • The AS400: price, order multiple, stock, and item status.
  • Media files: photos and PDFs, named by part number.

If a part number doesn’t match, the site can’t find the price, order multiple, or stock for that product.

What the AS400 Data Powers on the Website

  • Customer pricing: once live pricing is turned on at launch, each signed-in customer will see their own AS400 price. Visitors who aren’t signed in won’t see prices until they create an account.
  • Price changes: all are made in the AS/400, and the website reads them to populate the web data customers see.
  • Stock: the site shows available stock with a safety margin held back, so the warehouse always keeps a buffer.
  • Order multiples and pack sizes: customers order in the multiples the AS400 sets, and pack quantities come from the item record.
  • Item status: active and inactive come straight from the AS400 computer system.
  • Accounts: a web account links to the AS400 customer by email. Once TSC staff approve, the customer number is copied onto the account and the customer gets an email.
  • Order history: signed-in customers can see their past orders, pulled out and displayed from the AS400.

Getting Orders Back Into the AS400

Orders from the site are written to a staging layer, and the TSC team moves them into the live order system. Each order is checked before it’s written, can be retried without creating duplicates, and never leaves half an order behind.

Orders arrive already structured; this replaces retyping emailed orders by hand.

Reusing the Data Beyond the Storefront

The store is only one place the data goes. Because everything is keyed to the part number, the same data also makes the team’s day-to-day product work faster.

  • Product updates in place: TSC builds product sheets, and our importer updates products by part number, so photos, PDFs, AS400 data, order history, and Google listings all stay put.
  • Exports in their own format: products can go back out as an Excel file that matches TSC’s sheets cell for cell, for one category or many. An edited export can be imported again as is.
  • QA by comparison: a check lists every difference between the site and an import sheet, cell by cell, instead of someone checking thousands of products by hand.
  • New products: coming soon, a product added in the AS400 will show up on the site as a draft, and the team will get an email about it.

After launch, the TSC team will run the import, export, and QA check on their own.

Using the AS400 Today

  • Keep one system of record: make everything else read from it.
  • Pick one key and protect it: for TSC, that’s the part number.
  • Let your IT control access: when IT decides what the website can see, security and the web project aren’t fighting each other.
  • Put a person in the loop: anything that writes to the ERP should have a review process first.
  • Plan for data cleanup: getting the business data ready usually sets the pace more than development does.

Ready to Put Your AS400 Data to Work?

You can see the whole project in our Terminal Supply Co. case study. If your business runs on an AS400 or another older system, you don’t have to replace it to get a modern B2B website.

Start a conversation with Perfect Afternoon, and we’ll show you how to connect the system you already have.

FAQs

Do we have to replace our AS400 to get a modern B2B website?
No. The AS400 can stay the system of record while the website reads pricing, stock, and customer data from it through a controlled integration layer.

Can customers see their own pricing online?
Yes. Each signed-in, approved customer sees the price on their AS400 account, and visitors who aren’t signed in don’t see prices at all.

What happens to a web order before it reaches the AS400?
It lands in a staging area first. A person reviews it there, and only then does it move into the live order system.