Skip to main content
J
Jonathan_Fortis
Inspiring
March 6, 2013
Question

discount voucher how to set up using php

  • March 6, 2013
  • 1 reply
  • 3680 views

what is the best way to setup a discount voucher so when the user inputs a set number provided by us it will give a % discount. and this is pllied to the the total of the shopping cart

i know my question is vague but i dont know where to start

thanks

This topic has been closed for replies.

1 reply

Rob Hecker2
Rob Hecker2
Legend
March 6, 2013

For this kind of feature I use a table with the following fields:

promo_code (the promo or voucher text/number the customer will enter)

promo_deduction (the percentage of the deduction)

promo_expiration (a date you want the offer to end)

promo_id (auto increment primary key)

feature_id (if you want the offer to apply to only a specific product or service, this prevents it being applied to any product/service)

Then, if PHP is performing the calculation, in your POST data you would first check to see if they entered a voucher code, then compare it to your table of valid codes and if there is a match, return the deduction amount as a variable. This is accomplished with a simple WHERE clause in your query  (...WHERE promo_code=:promo_code_entered AND promo_expiration <=:currentdate AND feature_id =:feature_id)

Then multiply the variable by the total, like so:

$total = $pretotal * $promo_deduction;

You could alternatively use Javascript to create a live response, so that when they enter a code in the voucher field, it will update the total or respond with a message that the voucher was not valid.

J
Jonathan_FortisAuthor
Inspiring
March 8, 2013

Thanks for that, i will see if i can use your idea and link it in with my existing cart

L
Luke-Optima
Participating Frequently
March 25, 2013

ok

i have the following now

$editFormAction = $_SERVER['PHP_SELF'];

if (isset($_SERVER['QUERY_STRING'])) {

  $editFormAction .= "?" . htmlentities($_SERVER['QUERY_STRING']);

}

if ((isset($_POST["MM_update"])) && ($_POST["MM_update"] == "form2")) {

  $updateSQL = sprintf("UPDATE LOTTIE_voucher SET vouchCode=%s WHERE vouchID=%s",

                       GetSQLValueString($_POST['vouchCode'], "text"),

                       GetSQLValueString($_POST['vouchID'], "int"));

and the form

          <form action="<?php echo $editFormAction; ?>" method="post" name="form2" id="form2">

<input type="text" name="vouchCode" value="<?php echo htmlentities($row_rsVoucher['vouchCode'], ENT_COMPAT, 'utf-8'); ?>"/>

<input type="submit" value="update" />

<input type="hidden" name="MM_update" value="form2" />

<input type="hidden" name="vouchID" value="<?php echo $row_rsVoucher['vouchID']; ?>" />

          </form>

is this correct so far?

>so when this form is used the customer will have entered a promo code, if the text field is blank return an error message,

i can do this with srpy

> if the promo code is not matched to a database code return an error message

do i echo an error out?

> if the code matches a code in the database then you'll return the discount amount and that will be used in your calculations and the $XCart_sumTotal will be reduced by that amount

then can i echo this out then put the results in the equation you showed in a previous post?

thanks in advance


nope ...

i think you still don't have the concept right in your head

The above code has the customer updating the dtabase with a voucher code, the form does not update your voucher code table.

Your database table holds pre-set info you've entered and doesn't need to be updated so a voucher code held in the database table might be code1234 and discount 20

the form you have made then simply checks the code the customer has entered against those held in the database, it doesn't get stored in the database.

so when the form is submitted to enter a voucher promo code the PHP simply gets all the stored codes first from the database, then it checks if the form feild the user has entered a code in matches any code in the database, if it does it will return the discount amount to a variable to be used in the cart totals calculation

the form doesn't update any database unless in the order you want to record what promo code was used (but thats another issue!)

Terms & ConditionsAccessibility statement
Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices