Ecommerce Returns Tracker.

Build an ecommerce returns tracker for the operations team at Tidewater Apparel, an online clothing brand handling a steady stream of returns. Layout. Across the top, a compact strip of four small stats: Open returns (31), Return rate over the last 90 days (6.8 percent), Median days from request to close (6), Refunded this month (about $1,480). The centerpiece is a pipeline board with four columns: Requested, Received, Inspected, Resolved. Each card shows the order number, product name, a reason badge, the refund amount, and days in the current stage; Resolved cards carry a green Restocked or red Refunded outcome badge. Cards sitting in a stage more than 7 days get an amber age marker, more than 14 days red. Above the board, filter chips for reason (Wrong size, Damaged in transit, Changed mind, Defective, Wrong item shipped) and a product select; both filter the board and the charts together. Beside the board on wide screens, stacking below on narrow ones, two charts: a line chart of weekly return rate for the last 13 weeks climbing from about 5.5 percent to 8 percent, and a bar chart of the top five products by return count over the last 90 days. Data. Seed 31 open returns spread across the four stages, roughly 10, 8, 7, and 6, with realistic order numbers, product names, reasons, and refund amounts from $18 to $140. Seed about 55 closed returns over the last 90 days with reason and outcome, roughly 60 percent refunded and 40 percent restocked, plus 13 weekly order-and-return count records that drive the rate line. The story: the Havana Linen Pants account for nearly 30 percent of all returns, almost entirely Wrong size, and they alone explain the rising rate; the bar chart should show them at about double the next product. Behavior. Return rate, days in stage, and the top offender ranking are computed. Members can move a card to the next stage from a small menu on the card and add a new return through a dialog capturing order number, product, reason, and refund amount; the board and charts must look complete and alive for read-only visitors. Within each column, sort cards oldest first. Visual identity: use a muted crimson accent for primary actions, chart emphasis, and stage highlights, on a clean light neutral base.