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 SKU (optional passthrough)

Inventory is used only to list unsold items (items in inventory that never appear in purchase list).

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

Results

Include breakdown Include unsold

Unique Items

—

Total Units Sold

—

Inventory Items

—

Unsold Items

—

Summary (click headers to sort)

ItemNumber	ItemName	SoldQty

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

Breakdown (select an item)

Color	Size	SoldQty

Unsold Items (upload inventory to enable)

ItemNumber	ItemName

Items that exist in Inventory but never appear in Purchase List.