A Python tool for analyzing eBay sales export data with comprehensive visualizations and metrics.
- Data Cleaning: Automatically handles missing values, duplicates, and data type conversions
- Sales Trends: Monthly revenue and order count analysis with time-series visualizations
- Product Performance: Top products by revenue and quantity sold
- Summary Reports: Key metrics and statistics about sales
- Coming Soon:
- Customer Analysis: Customer lifetime value, repeat purchase behavior, and top customers
- Python 3.8 or higher
- pip (Python package installer)
-
Export your eBay sales data
- Log into eBay Seller Hub
- Go to Orders
- Click "Download" and select CSV format
- Save the file as
ebay_sales.csvin the project folder
-
Run the analysis
python ebay_analysis.py
-
View results
- Check the console output for detailed statistics
- Find generated charts in the project folder:
sales_trends.pngproduct_performance.pngbrand_trands.png
IMPORTANT: Never commit your actual sales data to GitHub!
- The
.gitignorefile is configured to exclude CSV files - Always keep your
ebay_sales.csvfile local - Consider using sample/anonymized data for testing
You can modify the EbaySalesAnalysis class to:
- Add custom metrics
- Change visualization styles
- Filter data by date ranges
- Add category-specific analysis
This tool is for personal analysis only. Ensure you comply with eBay's terms of service when using exported data.
- Run analysis monthly to track trends
- Compare different time periods
- Use insights to optimize inventory
- Identify your best-performing products