cancel
Showing results for 
Search instead for 
Did you mean: 

Getting tabular data for Sales

Getting tabular data for Sales

Hi,

 

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.