Coupon Details in "View Order"

Hello,

I would like to track the numerous coupons that are used on items sold.

When viewing the orders, the discount shows up but no record of which coupon was used.

Can we modify the order results to show the coupon used ?

Hi

We would also like to see on the orders the discount and coupon if used. Also this should be shown in the cart to customer to make it very clear that a coupon has been applied.

Merry Xmas

In the orders table, the applied coupons ID is stored in the orderCoupon column.


you would need to modify the recrdset on the orders-details.php page to return the coupon information:

SELECT *
FROM ps4_orders 
LEFT OUTER JOIN ps4_users ON OrderUserID = UserID
INNER JOIN ps4_coupons ON couponCode = CouponID
WHERE OrderID = ParamOrderID OR ( -1= ParamOrderID2 AND OrderID= ParamSessionOrderID)

you could the show the copon code vale in the prder information.


the entered coupon code is stored in a session variable, you coulfd display that on the cart page:

<?php if(isset($_SESSION['WA_ECart_Coupons'])) echo $_SESSION['WA_ECart_Coupons']; ?>

where do I find the orders-details.php

Is this code a replacement for what is already there ?

SELECT *
FROM ps4_orders
LEFT OUTER JOIN ps4_users ON OrderUserID = UserID
INNER JOIN ps4_coupons ON couponCode = CouponID
WHERE OrderID = ParamOrderID OR ( -1= ParamOrderID2 AND OrderID= ParamSessionOrderID)you could the show the copon code vale in the prder information.

If so, what line would I find this code ?

Will these changes allow for the Coupon Code to show up in the order details for each order ?

Thanks !

Seems we all keep your rather busy, we appreciate it.

the order_details.php page is in the admin folder.


the code is replacement SQL for the WADAorders recordset.


in the server behaviors list, double click the WADAorders recordset to edit the sql with what I gave you previously.


then go to the bindings panel, you should have a binding for the coupon code column that you can add to the orders display.

Ok, this is were the amature really shows in me.

What is the server bahaviors lit ? and where is that ?

and will the binding panel be obvious ?

Sorry my friend, I thank you for you time and effort.

Server Behaviors list.


go to window -> Server behaviors to open it.


for the bindings panel, go to window -> Bindings to open it.