We are currently using tomato cart ecommerce.
We need a script to generate sales report from the tomatocart database.
You are required to
- create login page
- page for choosing date range
- export generated report into xls format
- sales report format are :
1. Display the products sold , grouped based on categories, products name , product code , product description , product price.
2. Display customer name and quantity purchased.
3. Display total quantity sold & price for each products , each customer and grand total