E-dagang Ejen Untung Setiap Pesanan

import json, pandas as pd

def calc_margin(order):
    revenue = order["selling_price"]
    cogs = order["cogs"]
    commission = order["commission"]
    shipping = order["shipping_cost"]
    overhead = order.get("overhead", 0)
    total_cost = cogs + commission + shipping + overhead
    profit = revenue - total_cost
    margin_pct = (profit / revenue) * 100 if revenue else 0
    return {"profit": round(profit,2), "margin": round(margin_pct,2)}

orders = pd.read_csv("orders_export.csv")
results = []
for _, o in orders.iterrows():
    r = calc_margin(o.to_dict())
    r["order_id"] = o["id"]
    if r["margin"] < 10:
        print(f"ALERT: Order {o['id']} margin {r['margin']}%")
    results.append(r)

print(json.dumps(results))