ShopZone UK — 5 Sheet

ShopZone UK — 5 Sheet Ecommerce Merge, Returns Analysis & Automated Dashboard A UK online store came to me with orders, returns, customer details, product inventory and delivery partner data all sitting in 5 completely separate sheets with no connection between them.

Duplicate records throughout. Inconsistent status values and IDs across every sheet. Missing amounts on multiple orders. Returns data disconnected from the orders it belonged to.

Cleaned all 5 sheets independently then merged everything into one master orders table. Calculated all missing total amounts, net revenue after returns, profit per order and discount values applied.

Built a pivot view showing net revenue by product category per order status. Delivered an input sheet with dropdown validation for Order Status, Product, Delivery Partner and Discount Code.

Summary dashboard shows total revenue, total returns, net revenue after returns, total profit, delivered versus cancelled breakdown and two charts — Revenue by Category and Orders by Delivery Partner — all updating automatically with one refresh.