Reserved Inventory Normalizer

Use this skill when inventory exports from different marketplaces use different names for sellable and held quantities.

Inputs

• - A local JSON file with records containing platform, warehouse, SKU, snapshot time, total, available, locked, reserved, and reason fields.

Outputs

• - normalized_reserved_inventory.json with canonical quantities, reason breakdowns, source rows, and missing-field flags.

Rules

• - Preserve the snapshot time and never call it real-time.
• Do not infer a lock reason from a number or silently convert units.
• Keep unknown reasons and duplicate reasons visible.
• Never include passwords, cookies, tokens, customer raw personal data, or live API responses.

Acceptance

Run the sample and confirm canonical quantities, reason totals, and missing-reason flags. Negative quantities must be reported, not corrected silently.