03 / Repeatable reporting

Three updates.
One checked master.

Append new orders, update existing ones, and keep a record of what changed.

Consolidate the weekly files

Edit the master and three batch CSVs

Required columns: order_id, date, channel, amount. Dates: YYYY-MM-DD. Amounts: non-negative USD with up to two decimals. Maximum 1,000 rows per source.

Master records
New records
Update events
Order amounts (USD)

Update log

Source batch · Before · After

Validate first

A malformed date, amount or duplicate key inside a source rejects the run before changes are applied.

Repeat safely

Re-running a batch with the same record leaves that record unchanged. The original pasted inputs are preserved.

Keep the rules explicit

Order IDs are exact keys. This prototype updates whole records; conflict resolution by timestamps and live integrations need a separate scope.