Showing results for 
Search instead for 
Did you mean: 

Getting tabular data for Sales

Getting tabular data for Sales



I need a way to get tabular data that includes (Day-wise):


1. Sales

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.