Store virtual products sales at the separate database table

[Excelsior]

Good day.

 

How can I store sales data of my virtual products at the separate database table?

 

I need to generate sales reports only for this virtual products and display it at the dashboard.

So it will be very comfortable to have records at the table let's say "ps_virtualProducts".

 

After order confirmation I need to reduce amount of virtual products and make record to the database table "ps_virtualProducts" - product name, purchased by (name of customer), date, quantity, customer's contact address.

 

I understand that I need to generate another SQL query... Probably override class for some controller... 

But where can I edit the code for this?...

[musicmaster]

Try something like

Select * from ps_order_detail where download_hash != ""