The store owner spent 3 hours a week manually reconciling sales from Prom and the Excel cost price. There was a problem understanding the actual net profit due to returns and commissions.
Solution: A script was developed in Python (Pandas) that:
Automatically merges the order statement and the purchase price list.
Filters out canceled orders.
Calculates Net Profit and margin for each product.
Generates a PDF dashboard with customer activity graphs.
Result: Processing time was reduced to 1 minute. 15% of unprofitable products were identified. Stack: Python, Pandas, Matplotlib, FPDF.
Solution: A script was developed in Python (Pandas) that:
Automatically merges the order statement and the purchase price list.
Filters out canceled orders.
Calculates Net Profit and margin for each product.
Generates a PDF dashboard with customer activity graphs.
Result: Processing time was reduced to 1 minute. 15% of unprofitable products were identified. Stack: Python, Pandas, Matplotlib, FPDF.