Bench & BranchFictional exercise · not a customer result

A supplier update lands in your inbox

Which price
actually changed?

Compare these two invented price lists. Find the changed price—and the items you cannot compare. The difference matters before anyone edits a catalog.

Two clues: SKUs match literally, so 0007 and 7 are different. Round each valid price HALF_UP to cents before comparing.

Your current feed

current.csv · USD prices exactly as supplied
SKUPriceSource record
00071.234current.csv:2
70current.csv:3
CURRENT-ONLY10.00current.csv:4

The supplier update

supplier.csv · USD prices exactly as supplied
SKUPriceSource record
00071.245supplier.csv:2
70supplier.csv:3
SUPPLIER-ONLY3.50supplier.csv:4

All data is invented. USD throughout. Original supplied values are shown above; no price has been invented for an item missing from one feed.

Reveal the source-linked answer

One changed price.
Two unavailable comparisons.

The original example report shows 0007 at $1.23 → $1.25, a +$0.02 change after the stated rounding. 7 stays at $0.00. Missing and new items remain review items with unavailable differences.

On a small screen, scroll the table horizontally. Keyboard users can focus the table region and use the arrow keys.

Original example report values · USD · source records link to the supplied inputs
SKUDifferenceFindingCurrent, roundedSupplier, roundedSource records
0007+$0.02CHANGED$1.23$1.25current.csv:2supplier.csv:2
7$0.00UNCHANGED$0.00$0.00current.csv:3supplier.csv:3
CURRENT-ONLYNot availableMISSING$10.00Not availablecurrent.csv:4
SUPPLIER-ONLYNot availableNEWNot available$3.50supplier.csv:4

Leading zeroes matter

0007 is not 7. Combining them would change the question you asked.

Unavailable is not zero

A known 0.00 difference means the rounded prices match. A null difference means no supported comparison is available.

A flag is not an instruction

MISSING does not mean delete. NEW does not mean create. Review the source records before acting.

Inspect the original example result (JSON) · Download the original comparison CSV

What this example does—and does not—cover

Six input records. Four preview rows.

The original example report accounts for all 3 current + 3 supplier records: 1 CHANGED, 1 UNCHANGED, 1 MISSING, 1 NEW and 0 INVALID preview rows. This is accounting for the two supplied feeds, not proof that a real catalog is complete or a full-catalog total.

No duplicate or invalid records occur in this fixture, so it does not demonstrate every exception. The comparison is preview-only: no store changes, import compatibility, price recommendation, guaranteed saving, audit or professional approval. Arbitrary mapping, PDF extraction, source repair, fuzzy matching and currency conversion are outside this supported comparison.

Have a supplier update
to make sense of?

Start with the approximate row counts, file formats and the result you need to understand. Send a description only—no files, confidential information, credentials or payment details. Scope and actual handling are agreed before files or payment.

Describe your question through our homepage ↗