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

Advanced Coupon system advice

Thread began 2/07/2013 10:29 am by Christopher West | Last modified 2/07/2013 1:03 pm by Christopher West | 333 views | 1 replies

Christopher WestCommunity Expert

Advanced Coupon system advice

Hi, I already have a "gift voucher" system in place on an existing website...but client now requires an additional "coupon system" thats seperate so they can create special promotions that may include certain items to be $$$ discounted, or shipping to be free for a week, or a particular item % discounted for a 3 days etc etc, or all items in a basket to be discounted in some way.

I have created a potential table in the database to hold the following fields:

1.Coupon Code – create a unique code to give to your customers.
2.Coupon Value - sets the value of the coupon in pounds (£)
3.Coupon Shipping – stores a binary value to state if the shipping cost is effected by the coupon, and then will base shipping discount on either the value stored in points 2 or 4.
4.Coupon Discount - sets the value of the coupon in percentage (%)
5.Coupon Type – sets the coupon to be used for total products in the shopping cart OR to only effect one particular product or category of your choosing and then uses either the value stored in points 2 or 4 above to discount.
6.Coupon Category – stores the category ID value for use of the Coupon Type if set to categories.
7.Coupon Product – stores the product ID value for use of the Coupon Type if set to products.
8.Coupon Used - each time a customer uses this coupon, then the value here will be incremented so you know how many customers have used this coupon.
9.Coupon Valid From – sets the date from for the use of an expiry OR to allow it to be used for a particular day if same as valid to.
10.Coupon Valid To – sets the date to for the use of an expiry OR to allow it to be used for a particular day if same as valid from.
11.Coupon Status – activates or deactivates the coupon if you chose to temporarily take it out of use.

so for above for example i would store the product category in this record if the coupon discount will ONLY effect a particular category on the theres lots of flexability for the client to create all sorts of discounts for their products.

I just need help on creating the various ecart trigger rules. if you could give me some guidelines on that and of course if i am missing anything from the above table.

The coupon system (together with the gift voucher system AND the International shipping system will ALL take place on the websites CHECKOUT form so session variables would be set as soon as the customer filles out all the address details etc and then clicks on PAYPAL the paypal button.


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





Ease of use


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