Sales Stream

Step 1 (Optional): Master Inventory

Catalog of everything sellable (includes items that may have 0 sold).

Drop Inventory CSV here or click to choose

Not loaded

Step 2 (Required): Master Purchase List

The sales stream (orders). This is the file we aggregate.

Drop Purchase CSV here or click to choose

Not loaded

Column Mapping

Sales Stream tries to auto-detect columns. Verify them here. If anything looks wrong, change it. Processing is blocked until required fields are mapped.

Purchase List Mapping (required)

Item Number (required) Quantity (required) Item Name (optional) Color (optional) Size (optional)

Inventory Mapping (optional)

Item Number Item Name Color Size SKU (optional passthrough)

Lenient mode (treat invalid quantity as 0) — OFF by default

Results

Unique Items

—

Total Units Sold

—

Inventory Items

—

Unsold Items

—

Summary (click a row to view breakdown)

ItemNumber	ItemName	SoldQty

Tip: click headers to sort. Click a row for variant breakdown.

Breakdown (select an item)

Color	Size	SoldQty

Unsold Items (upload inventory to enable)

ItemNumber	ItemName

Shows items found in Inventory that never appeared in the Purchase list.