30-min call with RobBook a proof-of-concept call
Job 02 · E-commerce and contracts

// Industrial distributors · Punchout catalogs

Plant catalogs and contract price files, built the way each buyer's system loads them.

A plant awards you a contract, or sends next year's prices, and someone on your team rebuilds it as the file that plant's purchasing system takes: a CIF for Ariba, a CSV in Coupa's template, or the price list behind your punchout site. In a free AI proof of concept, AI drafts those files again from copies of 20 to 30 updates your team already built, with every unit, code and contract price traced to its source. Your reviewer, the person who knows your plant catalogs best, compares each draft with the file that was actually loaded.

Book a proof-of-concept call30 minutes with Rob
Updates tested
20 to 30, already loaded
Customer portals opened
None
Before any contract file
An NDA

// The one job

From a plant's contract to a catalog file ready to upload

The plant's buyer sends a spreadsheet: the items for their catalog, the agreed price for each or a discount off list by brand, and an effective date. Someone matches each line to your item, converts the price to the plant's unit, adds part numbers, codes and lead times, retires items you no longer sell, and builds the file in that buyer's layout.

For the test, AI does the same from copies and drafts each catalog file, line by line, with a short list of the lines it couldn't settle and why. It opens no portal, uploads nothing and changes nothing on your punchout site.

Contract price listFrom the plant's buyer
Plant
Contract no.
Effective
Price basis
Their item / mfr. no.Buy unitAgreed price
Made-up example contract
Rebuilt in
the buyer's layout
Catalog fileDraft, not uploaded
Format
Load mode
Unit codes
Lines retired
Supplier part IDUNSPSCPrice per unit
Made-up example file

// The hard parts

Why a catalog file comes back

Every buyer's system wants its own file. Ariba's CIF 3.0 file opens with a header your team rarely touches, and two lines in it matter on every update: LOADMODE F replaces the whole catalog, while I changes only the lines in the file, and UNUOM set to TRUE means United Nations unit codes where FALSE means ANSI ones. SAP's supplier guide requires a Supplier ID, a Supplier Part ID unique to each item, a Manufacturer Part ID, a description, a UNSPSC code, a unit price and a unit of measure, with prices written with a dot for decimals and no currency symbol or thousands comma. Coupa's CSV template wants its column headers left exactly as they are, and limits pricing type to a fixed price.

The unit decides whether the price is right. Coupa will only save an item whose unit matches one the customer has already set up, preferably in ISO codes, and carries a Pack Quantity beside it: a box of 100 has a Pack Quantity of 100. Your ERP may sell gloves by the pair and price cap screws per hundred while the plant's contract says each or box. On an SAP buyer's OCI punchout, a price unit travels next to the price and the item unit. A price copied across without converting it is a catalog that loads cleanly and is wrong on every line it touches.

Part numbers, codes and lead times. Coupa's Supplier Part Num may differ from the manufacturer's number, and its Supplier Aux Part Num can carry something like a quote number onto every PO the plant sends. Its UNSPSC field accepts a segment or family code when no item-level code fits, even one segment for a whole catalog if the customer agrees. Lead time is a single number in both systems; SAP's guide defines it as working days from receipt of the PO to shipping. Over OCI, the product group can carry an ECLASS or a UNSPSC code, with another field naming which, and most OCI fields stop at 255 characters, so a long bearing or hose description needs the long-text field.

Two checks before a plant sees it, and items that never die. On Ariba Network, a catalog first gets a broad check for zero prices, UNSPSC codes and units. Then the customer audits it with rules of its own, which may be stricter, and can send it back. In Coupa an item can't be deleted at all: an item you stop selling has to be marked inactive, or it stays buyable at the old price. So the draft lists what each update adds, changes and retires, not only the new lines.

Punchout carts have to agree with the contract. In Coupa, the buyer clicks your logo, shops on your site, and the cart comes back as a PunchOutOrderMessage that becomes a requisition; the purchase order follows later as a separate OrderRequest. With a level 2 punchout, which SAP Ariba and Jaggaer both offer, your items are also searchable inside the buyer's system while prices and stock stay on your site. Your reviewer, usually the e-commerce or catalog coordinator, checks that the contract, the static file and the price list behind the punchout all say the same price per unit.

// What you send

Copies from your catalog and contracts desk

Copies and exports
No portal logins
01

20 to 30 past updates

Each plant's request as it arrived, a new contract, a price change or an item list, with the file your team uploaded. Include one the buyer sent back and its error list.

02

Each buyer's template

The blank CIF or CSV template, the unit list and any catalog instructions each plant gave you, for the plants in the sample.

03

Item and price exports

Your item file with manufacturer part numbers, units, pack sizes and any UNSPSC or ECLASS codes you keep, plus the contract prices for those accounts.

04

An NDA, then the files

Contract prices stay confidential, so the NDA comes first. We never sign in to a customer's portal or your punchout site. If files can't leave, we build look-alike contracts with your reviewer.

// Before it starts

Settled before the first contract file moves

A wrong price in a plant's catalog repeats on every order until someone notices, so the owner decides these first.

Catalog test termsOwner signs off
Your reviewer
Named by the owner, usually the e-commerce or catalog coordinator
Buyer systems
One or two in scope, such as Ariba and Coupa, chosen by your reviewer
Success criteria
Written and agreed: price per unit, unit codes, part numbers, codes and retired items
Sample
Picked by your reviewer, with a rejected upload and a price change in it
Price
A range for keeping plant catalogs live
NDA
Signed before any contract or price file is shared

// How it's judged

Each drafted file beside the one your team loaded

Update by update
Every line priced per unit
On the same 20 to 30 updatesWhat your team uploadedThe AI draft
Layout and load mode the buyer's system expectsMeasured on your updatesMeasured on your updates
Contract lines matched to your item numbersMeasured on your updatesMeasured on your updates
Units and pack quantities in the buyer's codesMeasured on your updatesMeasured on your updates
Price per unit against the contractMeasured on your updatesMeasured on your updates
Supplier and manufacturer part numbers on every lineMeasured on your updatesMeasured on your updates
UNSPSC or ECLASS code, and lead timeMeasured on your updatesMeasured on your updates
Items added, changed and retiredMeasured on your updatesMeasured on your updates
Lines left for a person, and whyMeasured on your updatesMeasured on your updates
Nothing marked yet. These cells wait for catalog updates your own team built.Your reviewer grades every row and makes the call.

// After a yes

About 30 days on new contract changes

Once your reviewer says yes against the success criteria, the job drafts files for new contracts and price changes for about 30 days.

Your coordinator checks every file and uploads it the way they do now, and each buyer's acceptance or rejection goes onto the same side-by-side sheet.

That live month is priced as a fixed figure before you sign. A next job is its own decision.

// What could come next

Possible next jobs, in order

Ideas to check with you
One job at a time
  1. 01

    Portal POs against the contract

    Purchase orders that arrive from a plant's e-procurement system checked against the contract price and catalog before your team enters them.

    Next
  2. 02

    Cross-reference quotes

    Plant requests with worn part numbers, old brands or photos matched to your items and drafted as quotes for your counter.

    Also open
  3. 03

    Vendor-managed bins

    Bin counts and scans in the storerooms you stock, turned into replenishment orders for your rep to confirm.

    After that

// One hard limit

It never opens a customer's portal.

The test works only from copies. It never signs in to Ariba, Coupa, Jaggaer or a buyer's SAP system, never uploads or publishes a catalog, and never changes your punchout site or a price on it. Drafted files land on a review sheet for your coordinator, who decides what is uploaded.

Plant catalogs are priced as a separate job: you get a range before the test and a fixed figure before you sign.

What moves the range: how many plant catalogs you keep, how often their contracts change, and how many buyer systems and layouts they span.

// Questions

Questions from catalog coordinators

Do you log in to Ariba or Coupa for us?
No. The test works from copies of the contract, the buyer's template and the files your team uploaded before. Your coordinator still uploads every file, in the test and in a live run.
Can it build a CIF file or a Coupa CSV?
It drafts the file in the layout of the template you send, header lines and column names included. Your coordinator reviews it and decides whether to upload it, and the buyer's own validation still applies.
Does it change our punchout site?
No. The test compares the contract with the drafted files and, if you send one, a copy of the price list behind your punchout. The site itself is never touched.
Our item file has no UNSPSC codes. Is that a problem?
No. The draft proposes a code for each item and marks it unconfirmed, and your reviewer checks a sample of them. Where a buyer accepts a segment or family code, the draft uses that and says so.
Who should our reviewer be?
Whoever builds and uploads plant catalogs today, often an e-commerce or contract coordinator, or the pricing analyst who owns contract prices. The owner picks that person before the test, and their verdict settles it.
Rob Eason

Rob Eason, founder

// Book a call with Rob

Bring the last catalog a buyer sent back.

Thirty minutes with Rob. He asks about your company and role, which job you'd test, and roughly how many plant catalogs and contract updates your team handles in a month. Hold contracts and price files until the NDA is signed.

  • Co-owned a 60-employee financial services firm and sold his share to his partner.
  • Ran GOSO Technologies, a Boston solar company rated 5/5 across 24 Google reviews.
  • 5/5 across 83 reviews in HighLevel's Certified Admin Directory.
  • 4.3/5 from 6 Google reviews of Massmarket AI.
  • Every directory and Google review, critical ones included, is shown word for word at massmarket.ai/reviews.
  • Takes every proof-of-concept call himself.