What it does
For an e-commerce seller: sales exports from four marketplaces are cleaned, put into the same categories and rolled up into monthly reports per platform.
The problem
Each marketplace exports in its own format, so the monthly numbers were rebuilt by hand in spreadsheets.
Approach
One mapping per marketplace turns its export into a shared format. Categorisation and monthly roll-ups run on the combined data.
- Input
- Rules or code
- Person decides
- Result
Screens
Swipe sideways to see the whole screen.
Client work is shown under confidentiality agreements: no client names, and screens are recreated with sample data.
Stack
- Python
- pandas
- Spreadsheet reports
Impact
80 to 90%less time spent building the monthly numbers
10 to 15 hrsof manual spreadsheet work removed each month
Typical for systems like this.
