Display webshop order statistics
I would like to gather as much statistics as possible from a webshop database.
The database field names are unfortunately not in english, but I will translate everything for you.
Two of the tables are needed for this. (see attached txt-file for structure)
1. Get the number of sales and total order amount for each month and also yearly.
2. Get the average order value for each month and also yearly.
3. Display the results in diagrams/graphs
4. Display the expected number of orders the active month and year based on the previous orders so far.
5. Display in percentage how many that has used the different payment methods and average order value for each payment method.
Just let me know in PMB if you have any questions or have any previous work similar to this to show me.