I need a way to get tabular data that includes (Day-wise):
2. Sales amount
3. Refund amount
4. Reward points spent
5. Reward points earned
6. Amount actually paid by customer (or to be paid if its a Cash on Delivery)
7. Store credits spent
8. Store credits given to customer
I can currently get some of these pieces in MySQL by running a query - but not sure where I can get all of this data from.
Any insight is greatly appreciated.