How to see what orders used vouchers?

[tashrobinson]

I've created some discount voucher codes for different marketing campaigns to use.

 

How can I see what orders have used the voucher codes? Is there an easy way to see this?

[Ubuvolt]

This is a good question.

 

Is possible that form Orders/Invoices menu can cheack with voucher is assigned to transaction?

or what tables in DB are responsible for this.

[bellini13]

In the back office, go to Advanced Parameters > SQL Manager, and create a new query with the following

SELECT * FROM `ps_order_cart_rule`

That will show you all the raw records in the database that have used a voucher.

 

You can then add some filtering if you are looking for a specific voucher

[Ubuvolt]

SELECT  `shop_pres557`.`ps_order_cart_rule`.`name` ,  `shop_pres557`.`ps_customer`.`firstname` ,  `shop_pres557`.`ps_customer`.`lastname` ,  `shop_pres557`.`ps_customer`.`email` 

FROM  `shop_pres557`.`ps_order_cart_rule` 

LEFT OUTER JOIN  `shop_pres557`.`ps_orders` ON  `shop_pres557`.`ps_order_cart_rule`.`id_order` =  `shop_pres557`.`ps_orders`.`id_order` 

LEFT OUTER JOIN  `shop_pres557`.`ps_customer` ON  `shop_pres557`.`ps_customer`.`id_customer` =  `shop_pres557`.`ps_orders`.`id_customer` 

ORDER BY  `shop_pres557`.`ps_customer`.`firstname`;

 

 

I developed a little bit this query.

Now returns more useful data.

 

 - maybe someone has an idea how it can by optimize?

Edited February 19, 2016 by Ubuvolt (see edit history)

[hammerleit]

@Ubuvolt

Your query does not work for me

 

undefined "checkedFrom" error...

[bellini13]

@Ubuvolt

Your query does not work for me

 

undefined "checkedFrom" error...

his query does not have the word "checkedFrom" in it, so I suspect you changed his query. 

 

You also cannot use his query directly, since it has the name of the database in it shop_pres557.  I suspect your database name is different...

[kirubanidhi]

how to filter customer email in order page

Edited August 4, 2017 by kirubanidhi (see edit history)