A workflow that reads a CSV export of marketplace orders for a fictional online shop, checks it and turns it into a profit summary by channel and product.
A small shop selling on several marketplaces gets a different order export from each one. Working out what was actually earned after product costs, fees, shipping and refunds means hours of spreadsheet work every month, and mistakes are easy to miss.
The workflow takes the order export as it is, checks every row and sets aside rows it cannot use, with the reason, instead of silently dropping them.
It then works out the profit of every order and rolls it up by sales channel and by product, with the assumptions written down next to the numbers.
This demo runs entirely in your browser. If you load your own file, it is read on your device and never uploaded. A client build would pull orders from each marketplace automatically and send the report on a schedule.
Demo project: fictional business, sample data
This demo runs in your browser and needs JavaScript. The sample data it uses is listed below.
order_id,date,channel,product,qty,unit_price,unit_cost,fee,shipping,status
1001,2026-10-01,Marketplace A,Ceramic mug,2,14.00,5.20,4.20,3.90,shipped
1002,2026-10-01,Web shop,Oak serving board,1,39.00,16.50,1.35,5.50,shipped
1003,2026-10-02,Marketplace B,Scented candle,3,12.50,4.10,5.63,4.20,shipped
1004,2026-10-03,Marketplace A,Linen tea towel,4,9.00,3.00,5.40,3.90,shipped
1005,2026-10-04,Marketplace A,Oak serving board,1,42.00,16.50,6.30,5.50,refunded
1006,2026-10-05,Web shop,Cotton tote bag,2,16.00,4.80,0.98,3.90,shipped
1007,2026-10-06,Marketplace B,Ceramic mug,1,14.50,5.20,2.18,3.90,shipped
1008,2026-10-07,Marketplace A,Scented candle,2,12.00,4.10,3.60,3.90,shipped
1009,2026-10-08,Web shop,Linen tea towel,3,8.50,3.00,0.92,3.90,shipped
1010,2026-10-09,Marketplace B,Cotton tote bag,1,17.00,,2.55,3.90,shipped
1011,2026-10-10,Marketplace A,Ceramic mug,6,13.50,5.20,12.15,6.90,shipped
1012,2026-10-11,Web shop,Scented candle,2,13.00,4.10,0.94,3.90,shipped
1013,2026-10-12,Marketplace B,Oak serving board,2,41.00,16.50,12.30,7.50,shipped
1014,2026-10-13,Marketplace A,Cotton tote bag,3,15.50,4.80,6.98,4.20,shipped
1015,2026-10-14,Web shop,Ceramic mug,2,14.00,5.20,0.97,3.90,refunded
1016,2026-10-15,Marketplace B,Linen tea towel,2,9.50,3.00,2.85,3.90,shipped
1017,2026-10-16,Marketplace A,Oak serving board,1,42.00,16.50,6.30,5.50,shipped
1018,2026-10-17,Web shop,Oak serving board,1,39.00,16.50,1.35,5.50,shipped
1019,2026-10-18,Marketplace B,Scented candle,0,12.50,4.10,0.00,0.00,shipped
1020,2026-10-19,Marketplace A,Linen tea towel,2,9.00,3.00,2.70,3.90,shipped
1021,2026-10-20,Web shop,Cotton tote bag,1,16.00,4.80,0.62,3.90,shipped
1022,2026-10-21,Marketplace B,Ceramic mug,3,14.50,5.20,6.53,4.20,shipped
Tell us about the workflow you want to improve. We’ll reply with how we would approach it.