1. There is a running e-commerce website with more than million orders coming per day and more than billion search and browse request on various products. You have to display the top selling products of the category that user is currently searching for. There should be a new endpoint to provide top selling product for specific category.
2. The new point should able to support billion+ requests per day.
3. Based on the daily orders generated, a sales report should get generated in specified format and get inserted in any storage from where it can be picked, parsed and analyzed by the various concerned teams.
4. Extend the existing system to facilitate/integrate with product sellers and to periodically tell them their product sales rank.
5. System should be built for hourly update of top product result.
6. Generated orders data could be batch (hourly, 15 minutes, 30 minutes, etc.) or real time. Should support both type of ingest.
7. There shouldn’t be any data loss and system should be scalable enough to handle higher load in peak hours or sale hours.
8. Seller should be notified for new reports via email, SMS and App based notification. Notification can be sent in batches via file ingest or real time.
