close ad
Databridge V2 with MySQLi support IS Now Available!
open ad
View Menu

Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

rating

Coupon Details in "View Order"

Thread began 12/10/2010 9:07 am by KiddaMan | Last modified 12/14/2010 9:35 am by Jason Byrnes | 960 views | 6 replies |

KiddaMan

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 ?

Sign in to reply to this post

info405361

Agree

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

Sign in to reply to this post

Jason ByrnesWebAssist

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:
<?php if(isset($_SESSION['WA_ECart_Coupons'])) echo $_SESSION['WA_ECart_Coupons']; ?>
Sign in to reply to this post

KiddaMan

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.

Sign in to reply to this post

Jason ByrnesWebAssist

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.

Sign in to reply to this post

KiddaMan

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.

Sign in to reply to this post

Jason ByrnesWebAssist

Server Behaviors list.


go to window -> Server behaviors to open it.


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

Sign in to reply to this post

Build websites with a little help from your friends

Your friends over here at WebAssist! These Dreamweaver extensions will assist you in building unlimited, custom websites.

Build websites from already-built web applications

These out-of-the-box solutions provide you proven, tested applications that can be up and running now.  Build a store, a gallery, or a web-based email solution.

Want your website pre-built and hosted?

Close Windowclose

Rate your experience or provide feedback on this page

Account or customer service questions?
Please user our contact form.

Need technical support?
Please visit support to ask a question

Content

rating

Layout

rating

Ease of use

rating

security code refresh image

We do not respond to comments submitted from this page directly, but we do read and analyze any feedback and will use it to help make your experience better in the future.

Close Windowclose

We were unable to retrieve the attached file

Close Windowclose

Attach and remove files

add attachmentAdd attachment
Close Windowclose

Enter the URL you would like to link to in your post

Close Windowclose

This is how you use right click RTF editing

Enable right click RTF editing option allows you to add html markup into your tutorial such as images, bulleted lists, files and more...

-- click to close --

Uploading file...