Capstone · Purchasing at a retail chain

Validate a supplier inventory feed

A supplier sends weekly inventory files with quantities, prices and country codes, plus monthly files that have changed format twice this year.

Build the validation and combination steps, and write the feedback the purchasing team will send to the supplier.

Checkpoints

1. Ordered validation with first failing reasons.
Validate quantities and prices against ranges
2. Monthly files appended under a declared schema.
Append monthly files under a declared schema
3. Dates parsed only with a declared locale.
Parse dates by declared locale
4. Timestamps with offsets; naive ones quarantined.
Timestamps need an offset

Final quality report

Write it in your private notes below (saved to your account) or in your own document. It isn't auto-graded; use it to practise the handoff interviewers ask about.

Exception counts by rule, ordered as declared.
Rejected files and the schema change that caused each.
Feedback to the supplier in plain language.
Rules you would add if the supplier can't fix the feed.