how to get customer transaction history in admin Dashboard?

[Yogesh Raghav]

Well i want to get this functionality in admin dasboard in orders tab like if we click particular order id for a particulat customer than his/her transaction history including refunds ,product purchased,quantity,date and type of payment done by him...a sequence of all this ..here what i mean

 

can i get any solutions please?

[Yogesh Raghav]

any reply please?

[Yogesh Raghav]

no one?

[Guest]

Don't be so impatient. This is a peer group forum. You could wait days for a reply, or not ever get one. Such is the nature of forums. 

 

Do you not get all that information when you look at the customer? In the top right of your screen print click the customer name

[Yogesh Raghav]

yeah sir but i need it separately in orders tab asi have mentioned 

[Guest]

Click a button, or click a name. Not sure I can see the difference really. 

 

Or do you mean you want the history there? So no button to click?

 

We have customers with hundreds of orders. To show all the detail there would be very slow to load. It is even very slow on the customer page

 

But good luck, I hope someone can answer your question

[Yogesh Raghav]

wel its like when some one clicks button all details like refunds,product name,date ordered and quantity shud be visible

[Yogesh Raghav]

its for only those customers when we select their order id

[Yogesh Raghav]

any suggestion would be appreciated.

[Yogesh Raghav]

well i managed to get Customer_Id,Order_Id,$Reference_No,Payment_Type,Total_pays,Current_status using query

$query='select * from

  '._DB_PREFIX_.'order_state_lang posl

  JOIN '._DB_PREFIX_.'orders po on po.current_state=posl.id_order_state

  JOIN '._DB_PREFIX_.'customer  pc on pc.id_customer=po.id_customer and po.id_order='.$id_order;
and in view.tpl file i written

<table border='1' style="color:grey">

   <TH style="padding:1%">{l s='Customer Id'}</TH>

<TH style="padding:1%">{l s='Order Id'}</TH>

<TH style="padding:1%">{l s='Reference No'}</TH>

<TH style="padding:1%">{l s='Payment Type'}</TH>

<TH style="padding:1%">{l s='Total Paid'}</TH>

<TH style="padding:1%">{l s='Current Status'}</TH>

 

<tr>

{foreach $my_order_id item}

<td>{$Customer_Id}</td>

<td>{$Order_Id}</td>

<td>{$Reference_No}</td>

<td>{$Payment_Type}</td>

<td>{$Total_pays|number_format:2}</td>

<td>{$Current_status}</td>

 

{/foreach}

but using this iam only manage to get 1 order per person and not total no of orders
example
On running i get in my Ordercontroller tab

iam getting only Single entry   
Customer Id Order Id Reference No Payment Type Total Paid Current Status 3 9 QSNDMLVUG Bank wire 600.00 Awaiting bank wire payment

 

I want result in below way like every orders  should be displayed for that particular customer 

Customer Id Order Id Reference No Payment Type Total Paid Current Status            3
___________
           3
___________
           3
       9
________
    10
________
    12
  QSNDMLVUG
____________
WSTRRTAAR
____________
DRAWWTTS
  Bank wire
_____________
Cod
_____________
Prepaid
  600.00
_________
1200.00
_________
800.00
  Awaiting bank wire payment
_____________________
Refunded
______________________
Shipped

 
Like what change do i need to make. kindly your help please???

[Yogesh Raghav]

any suggestions please?

[Yogesh Raghav]

any idea please?

[Yogesh Raghav]

kindly any reply on the same.i need it?

[muynck]

Hello Yogesh Raghav,

 

First of all, this is not a chatbox. You could put your updates in your previous replies so that it becomes a concise question. This way people know better what you are asking, and you can then expect a more quick and proper response. And punctuation is also appreciated by very much everyone.

 

I am also interested in this matter. But it is not likely that people will respond to this.