The network for creativity
Join 1.25M professional creatives like you
Connect with clients, get discovered, and run your business 100% commission-free
Creatives on Contra have earned over $150M and we are just getting started
Back to feedPost
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.
The network for creativity
Join 1.25M professional creatives like you
Connect with clients, get discovered, and run your business 100% commission-free
Creatives on Contra have earned over $150M and we are just getting started
Related posts
Hello ,we are hiring freelancers to work on remote jobs
Transformation
Data entry
Retyping
Google review
Drop a comment if interested
Hiring 4,000 applicants every month isn't the hard part.
Managing them manually is.
Think about what happens when every candidate needs a response.
• Someone reviews applications.
• Someone sends interview invitations.
• Someone sends rejection emails.
• Someone assigns skills tests.
• Someone updates the CRM.
• Someone schedules interviews.
Now multiply that by thousands of applicants every month.
That's not recruitment.
Reject them? They receive a professional response while the CRM updates instantly.
Instead of relying on manual follow-ups, this recruitment workflow automates the entire process.
Approve a candidate? They automatically receive the next steps.
Reject them? They receive a professional response while the CRM updates instantly.
Need a skills assessment? It's sent automatically.
Ready for an interview? The invitation goes out without anyone writing another email.
The result isn't just faster hiring.
It's a hiring process that's consistent, scalable, and gives recruiters more time to focus on choosing the right people, not managing repetitive tasks.
The best automation isn't always the most impressive.
It's the one your team relies on every single day.
aiautomationbusinessautomationhrandrecruitmentEmail AutomationAI AutomationBusiness Workflow AutomationGo High LevelGoogle SheetsMake
This honestly saves time
HR dashboards don't have to feel overwhelming.
what feature would you want to see in a modern HR platform?
The warm tones are doing a lot to make this feel less sterile than most HR tools. Feature-wise, a unified timeline view per employee (requests, reviews, notes) would be the one thing I'd want to see.
Trending
Claude
Claude has entered the design space. How are you using Claude Design?
Contra University
Learn from expert creatives how to earn more using next-gen AI tools.
MagicPath
The canvas is infinite, and exploration is becoming the workflow. How are you using MagicPath?
creativeaiflow
Creative AI workflows are evolving. What tools do you use, and what are their strengths and weaknesses?
freelancerlife
Freelancer life is wins, pivots, and everything in between. What’s yours right now?