Community Add-Ons

Maintainers:	kgt
Add file to this package

Top » Order Total Modules

Discount Coupon Codes
for osCommerce Online Merchant v2.2

Create coupon codes for your customers to use for discounts on orders.

Discounts are applied before tax and are displayed as one order total line for each applicable tax class. You can configure whether to display the order subtotal including the discount, or before the discount is applied.

Coupon codes may be configured with a start or ending date, number of times they may be used, and an order minimum.

Legend:

Download

Report

Expand All / Collapse All

Missing line of Code in file /public_html/admin/includes/database_tables.php

At or Around Line 16 add:

define('TABLE_ADMINISTRATORS', 'administrators');

I precisely followed all of the installation instructions, twice, and still ran into the same problem.

When everything was updated and I attempted to log into the admin, the menu would not load correctly causing the rest of the admin not to load. It ended up being an issue with the updates required for the files admin/includes/boxes/catalog.php and admin/includes/boxes/reports.php

For admin/includes/boxes/catalog.php the update should should be,

//kgt - discount coupons
'<a href="' . tep_href_link(FILENAME_PRODUCTS_EXPECTED, '', 'NONSSL') . '" class="menuBoxContentLink">' . BOX_CATALOG_PRODUCTS_EXPECTED . '</a><br>' .
'<a href="' . tep_href_link(FILENAME_DISCOUNT_COUPONS, '', 'NONSSL') . '" class="menuBoxContentLink">' . BOX_CATALOG_DISCOUNT_COUPONS . '</a>' );
/***************
'<a href="' . tep_href_link(FILENAME_PRODUCTS_EXPECTED, '', 'NONSSL') . '" class="menuBoxContentLink">' . BOX_CATALOG_PRODUCTS_EXPECTED . '</a>' );
***************/
//end kgt - discount coupons

For admin/includes/boxes/reports.php the update should should be,

//kgt - discount coupons report
'<a href="' . tep_href_link(FILENAME_STATS_CUSTOMERS, '', 'NONSSL') . '" class="menuBoxContentLink">' . BOX_REPORTS_ORDERS_TOTAL . '</a><br>' .
'<a href="' . tep_href_link(FILENAME_STATS_DISCOUNT_COUPONS, '', 'NONSSL') . '" class="menuBoxContentLink">' . BOX_REPORTS_DISCOUNT_COUPONS . '</a>');
/*************
'<a href="' . tep_href_link(FILENAME_STATS_CUSTOMERS, '', 'NONSSL') . '" class="menuBoxContentLink">' . BOX_REPORTS_ORDERS_TOTAL . '</a>');
*************/
//end kgt - discount coupons report

Both instances were missing a period after the first updated piece of code with the link. It caused the rest of the code to not execute.

After having a sale and realizing we just lost money on a purchase (product came to below wholesale cost) I devised a little snip of code to exclude any items on sale from being processed through the sale. But regular items will still receive discount.

You can use the code below or just replace the discount_coupon.php with the one in the zip file. Which ever is easier for you.
Good Luck!
------------------------------------------------
///// In the classes/discount_coupon.php file
Replace the calc function (last function of the file) with this:

function calculate_discount( $product, $product_count ) {
//Start [Central50] sale exclusion
//check if this product ($product['id'] on sale
$specials_query = tep_db_query("select specials_new_products_price from " . TABLE_SPECIALS . " where products_id = '" . $product['id'] . "' and status = '1'");
if (tep_db_num_rows($specials_query) > 0) {
$specials = tep_db_fetch_array($specials_query);
$specialprice = $specials['specials_new_products_price'];
}
// End [Central50] sale exclusion
//if there's a maximum order amount to apply the discount to, determine the percentage of this product's final price we should apply the discount to
$max_applied_percentage = ( $this->coupon['coupons_max_order'] == 0 ? '1.00' : $this->coupon['coupons_max_order'] / ( tep_add_tax( $product['final_price'] * $product['qty'], $product['tax'] ) * $product_count ) );
//Start [Central50] sale exclusion
if ($specialprice > 0) {
//This item is on sale, do not apply ANY discount
$applied_discount = 0;
} else {
//This item is of regular value, let the system proceed with applied discount
$applied_discount = tep_add_tax( $product['final_price'] * $max_applied_percentage * $this->coupon['coupons_discount_percent'], $product['tax'] ) * $product['qty'];
}
//End [Central50] sale exclusion
//don't allow the discount amount to be more than the product price
if( $applied_discount > ( tep_add_tax( $product['final_price'], $product['tax'] ) * $product['qty'] ) ) $applied_discount = tep_add_tax( $product['final_price'], $product['tax'] ) * $product['qty'];
return $applied_discount;
}

-------------------------------------
What I have done is used the code the check for specials from the shopping_cart class file. What I originally did was checked if any item was on sale and just shut off the coupons, but thats not fair to the customer if they have other items that are of regular price.

This will be included in the for loop in the classes/order.php file and if that product is on sale, will not apply the sale to it. If it is not on sale, it will act of regular function.

I am still learning in coding, I have done some extensive custom coding to both of my sites but if anyone sees any problems with this or can improve on it, by all means please do.

And my staff and I have checked the outcome and it does work for me as far as I can tell.

USE AT YOUR OWN RISK, NOT RESPONSIBLE FOR ANYTHING.

Small update to get usage checking working. The fixed upgrade instructions and install instructions are included along with the fixed files.

checkout_confirmation.php line 74 after
$this_coupon = new discount_coupon( $HTTP_POST_VARS['coupon'] );

add
$this_coupon->verify_code();

includes/classes/discount_coupon.php line 68-78 replace

function check_coupons_max_use( $code = '' ) {
$check_use_query = tep_db_query($sql = "SELECT COUNT(*) AS cnt
FROM ".TABLE_ORDERS." AS o
INNER JOIN ".TABLE_DISCOUNT_COUPONS_TO_ORDERS." dc2o
ON dc2o.orders_id=o.orders_id
AND o.customers_id = '".$customer_id."'
AND dc2o.coupons_id='".tep_db_prepare_input( $this->code )."'");
$use = tep_db_fetch_array( $check_use_query );
//show error message if coupons_max_use is equal to the number of times this customer has used the code
if( $this->coupon['coupons_max_use'] <= $use['cnt'] ) $error_message[] = sprintf( ENTRY_DISCOUNT_COUPON_USE_ERROR, $use['cnt'], $this->coupon['coupons_max_use'] ); //display the error message for number of times used
}

with

function check_coupons_max_use() {
global $customer_id;
$check_use_query = tep_db_query($sql = "SELECT COUNT(*) AS cnt
FROM ".TABLE_ORDERS." AS o
INNER JOIN ".TABLE_DISCOUNT_COUPONS_TO_ORDERS." dc2o
ON dc2o.orders_id=o.orders_id
AND o.customers_id = '".(int)$customer_id."'
AND dc2o.coupons_id='".tep_db_prepare_input( $this->code )."'");
$use = tep_db_fetch_array( $check_use_query );
//show error message if coupons_max_use is equal to the number of times this customer has used the code
if( $this->coupon['coupons_max_use'] <= $use['cnt'] ) $this->error_message[] = sprintf( ENTRY_DISCOUNT_COUPON_USE_ERROR, $use['cnt'], $this->coupon['coupons_max_use'] ); //display the error message for number of times used
}

our success? individual commitment to a group effort

Community Add-Ons

Discount Coupon Codesfor osCommerce Online Merchant v2.2

Discount Coupon Codes
for osCommerce Online Merchant v2.2