My test store spent more covering shipping than it kept as profit, so I built a free tool that shows

Shopify shows you sales. It doesn’t really show what each product earns once you subtract what it cost you, discounts, refunds, and the shipping you end up paying for yourself. So I built True Profit. How it works: export your orders and products from Shopify (two CSV files, about 5 minutes), upload them, and enter roughly what you pay per shipping label. You get net profit for every product plus a breakdown of where the money went. No sign-up, and your files aren’t saved. What it found on my test store (demo data, not a real business): $102.58 in sales, but only $21.95 actually kept Assuming $5.50 per shipping label, the store paid $34.01 of shipping out of its own pocket, more than it kept as profit The same $2 item made $0.60 when the customer paid for shipping, and lost $4.40 when shipping was free One product was priced below cost, so every sale lost money One 10% discount code cost more than 12 of the 14 products earned The rough parts: Shopify only for now Shipping cost is your own estimate, since Shopify doesn’t know what your labels actually cost Partial refunds on multi-item orders are approximated It’s on free hosting, so if nobody has used it for a few days it takes about 30 seconds to wake up Built with Python, pandas and Streamlit, on my own. I’d love feedback, especially: If you run a Shopify store, does anything in your results look wrong? Was anything confusing about getting the exports? Try it: https://trueprofit.streamlit.app   submitted by   /u/Pavan_nani [link]   [comments]