Jump to content

Help, Need to visualize in every customer their vouchers and the total and discount


chris_gsj

Recommended Posts

That is not so easy.

 

The table ps_cart_rule contains the vouchers with their code and customer id and a flag whether they have been used.

The table ps_order_detail contains the order lines (and ps_order the orders) and whether there was any discount on them. But I am not sure whether there is any recording of which voucher resulted in which discount.

Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...