Hey all was bleeding money on Meta ads because I couldn't tell which products were actually profitable after returns and shipping. Pretty sure I'm not the only one.
Built a quick fix last weekend (free):
1. Make a Google Sheet called "True Profit" Columns: Product Name, Selling Price, Cost to Make, Shipping Cost, Average Returns %.
2. Fill in your top 20 products. Even rough numbers are fine.
3. Sign up for n8n which is a free tool that grabs data from your store automatically
4. Build a workflow that runs every Sunday night: pull last week's orders and returns from Shopify → match each sale to your sheet → email you a summary of which products actually made money and which lost money.
5. Final column in the email: "kill or keep" based on whether profit margin is above 20%.
Killed 4 products that looked great on revenue but were losing money. Hope this helps 🙏