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.

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.

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

Thank you.

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.

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

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.

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! ;]

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.

Hi Jason,

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

Or should I just use "OrderID"?

Thanks.

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