close ad
WARNING PC USERS: Do Not Install the DREAMWEAVER CC 2017 Update »
open ad
View Menu

Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

rating

Is there a way to track what Coupon Code is used?

Thread began 8/05/2009 10:33 pm by heather373214 | Last modified 10/14/2009 5:18 pm by Jason Byrnes | 4547 views | 11 replies |

heather373214

Is there a way to track what Coupon Code is used?

We'd like to offer the same discount to several different client bases and use a different coupon code for each group. Will there be a way that we can track which code is used with each purchase? This allows us to establish which of our advertising dollars are being best spent! We have both ecart and powerstore to work with.

Sign in to reply to this post

Jason ByrnesWebAssist

Yes, The coupon code is stored in a session variable.

add a new column to the orders table to capture the coupon code.

On the Confirm page, double click the eCart store order Summary in database server behavior, and bind the new coupon code database column to the coupon code session variable.

Sign in to reply to this post

morc.mzw383871

How to track Coupon codes.

Please explain in detail - step by step. (i) how to insert "couponcode" in the db; (ii) how to track it.

Thank you.

Sign in to reply to this post

Jason ByrnesWebAssist

When you run the checkout wizard, there is a section for configuring how the order is stored in the database. This adds the eCart Store Order Summary and Store order Details server behaviors to the confirm page.

In your orders table, crate a column to hold the coupon code, in the store order summary server behavior, bind that column to the coupon code session variable.

in this way, when an order is placed, the coupon code will be stored in the database along with the other information about the order.


You can then query the orders table to return all of the coupon codes that have been used for tracking purposes. Exactly how that is done depends on *what* you are trying to track.

Sign in to reply to this post

morc.mzw383871

Powerstore Coupon Tracking

Thanks Jason.

When I attempt to go thru the eCart's "checkout wizard" - I noticed that all the fields are empty, i.e. I have to set up from scratch. Thus, I m concerned that if I fill up the entire "checkout wizard" - I might mess up the Powerstore.

Thus, is there an easier way to insert "Coupon Code" in the database via dreamweaver's "Databases-Binding-Server Behavior". Or can I do it the database via my hosting service provider?

Please explain step by step as I m concern abt messing up Powerstore - then I might have to come back to you to help reverse the "damage". Appreciate ur help. ;]

Sign in to reply to this post

Jason ByrnesWebAssist

Open the confirm page.

go to Window -> Server Behaviors.

In the list of server behaviors, find the eCart Store cart Summary server behavior, and double click it to edit it.

On the second page, select the coupon database column, click the Lightning bolt next to value and select the Coupon session variable.

Sign in to reply to this post

morc.mzw383871

Coupon Tracking Powerstore

Jason,

1. Do you mean "order.php" or "confirm.php"?

2. What do you mean by second (next) page? I am using Dreamweaver CS4. Is the "second" page applicable?

3. Sorry - but I do not really get it "step-by-step". Please explicate (in details) if possible.

Appreciate ur help! ;]

Sign in to reply to this post

Jason ByrnesWebAssist

The store order summary server behavior is applied to the confirm.php page.


open the confirm.php page.

In the server behaviors list, double click the Store Order Summary server behavior.

you dont need to change anything on the first step of the Store Order Summary Server Behavior, so click next to get to the second step.

On the second step, select the coupon column from the list of columns that are in the order table, and click the lightning bolt next to value.

Expand the Session Collection and select the Coupon session variable.

Sign in to reply to this post

morc.mzw383871

Coupon Tracking

Hi Jason,

Under the "Column", I could see "OrderID", "OrderUserID", etc, how do I add a "OrderPromoCode"?

Or should I just use "OrderID"?

Thanks.

Sign in to reply to this post

Jason ByrnesWebAssist

You need to add it to the Orders table in your database.

If it is a local database, you can use the MySQL GUI Tools to manage your database and add columns:
5.0.html


if it is a remote database, your host will have a tool such PHPMyAdmin in place that you can use to manage your database

Sign in to reply to this post
loading

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...