Community Add-Ons

Add file to this package
Top » Credit Modules

## POINTS AND REWARDS MODULE V1.00 ##
for osCommerce Online Merchant v2.2

NOTE (2010-02-21): The last complete package V2.1rc2a is from October 8, 2008. DO NOT USE the installer.php in the root directory, use /sql_files/installer.php instead.

The idea comes from contributions...
http://www.oscommerce.com/community/contributions,2082
http://www.oscommerce.com/community/contributions,2221
but they are not required and its NOT an update to them .

Please note that even if this contribution carry the same title as contributions 2221,
they are NOT the same and you WON'T be able to merged this module with contributions 2221.
that's the reason i did not uploaded there, if you already installed contributions 2221 or cosidering
it, you will have to make your choice amoung the two.
(NOT like contributions 2221, this module does NOT require any of the functions required
by Credit Class & Gift Voucher so you can use it with or without Gift Voucher contribution(tested)

What does this module do ?
------------------------------------
I think that the title say it all.
This is a Points and Reawrds system,(more or like a cash back or discount system)
aimed to popup sales and get new usrs to signup.
The system awards shopping points to customers for the amount they spend.
Points consider as cash when redeemed, so points are in pending status untill approved by admin.(manually)
Once approved, customers can then use those points to pay for order druing checkout.

Admin features.
------------------------------------
1.Enable/Disable the Points System.
2.Enable/Disable the Redemptions System.(maybe you would like to offer a gift and not money back).
3.Set the number of points awarded for evry $1.00 spent(or whatever based on your currency system).
4.Set the value of each point(based on your currency system).
5.Enable/Disable points awarded for shipping fees.
6.Enable/Disable Products Restriction.
7.Set the model name allowed When Products Restriction enabled.(only one group)
8.Enable/Disable Points Limitation. and set the number. of points needed before they can be redeemed.
9.Enable/Disable Welcome Points. and set the Points amount to be auto-credited for New signup customers.
10.Admin can view/add/delete customers points with/without queuing customers points table(optimised the database).

Customes features.
------------------------------------
* New signup customers can be awarded with welcome points.
* Customers can earn points(cash back) for an item purchased at the store.
* Customers can choose the amount of points they would like to spend.
* Customers can view their shoping points account status.

The system designed to use minimum database space, customers points hold in customers table while
all other points hold in customers_points_pending table.
Once pending points approved by admin, pending points move to customers account so table used stay optimised.
Redeemed points recorded in customers order history only.

What this module does not do ?
------------------------------------
1.The system designed for a small to medium shops.
Since shopping points cosider as money when redeemed. awarded points default status is pending.
Customers shopping points account will never be auto-credited(except points for new signup if enabled).
if you own a large shop with lots of orders daily, it could be hard to keep track of points
then this system is NOT for you.
2.When admin delete order while points status for that order is still pending. those points will also be
deleted, however if admin already approved those points, admin must delete them manually(via admin panel).

This module as been tested on a fresh install of osCommerce Version 2.2MS2
as well as on a fully modified versions (includes Credit Class & Gift Voucher contribution).
Please use it at your own risk.

The full zip package includes...
* A folder contain all files and images required by this module .(sorry,only english language files provided).
* A folder contain all images, new and modified files required by this module (for a fresh install).
* A folder contain screenshots admin and catalog(I think that all contributions uploaded here should have).
* Step by step installation instrctions(corrently only in english).

Please Note: a light zip contains only files needed for this module uploaded here.

All support handled through the osCommerce forums. Please do not email directly.
http://forums.oscommerce.com/index.php?showtopic=152746

As a respect to the contributors and as part of GNU General Public License
You are not allowed to remove any of the comments/links to oscommerce web site.

Legend:  Download   Report

Expand All / Collapse All

#Fixed Redemptions with price greater than redeemable points# vishal161 1 May 2014  

This is NOT full package.

This fix is for error:

If total price of your shopping is greater than redeemable points you have in your account, you CAN NOT go further by just checking the checkbox at Redeem Points section. You need to select a payment method as well to pay rest of the amount.

This hack solves this problem.

Added "Install" file including instructions for updating step by step.

This is NOT full package.

This package is containing only updated "redemptions.php" file and an instructions file "INSTALL.txt"

Complete Package for 2.3x saiSoftIndia 12 Oct 2012  
Complete Package anisrehan 15 Mar 2012  
V2.1beta Full Packages Includes anisrehan 3 Feb 2011  
Potentail referreral point hack in checkout_confirmation.php - Typing Mistake Corrected C.J. 13 Aug 2010  
Potentail referreral point hack in checkout_confirmation.php C.J. 13 Aug 2010  
error 341 on redemptions.php neorf 19 Mar 2010  
Portugues boadboard 30 Dec 2009  
PayPal Standard Fix reflex-ocasion 26 Sep 2009  
PayPal Standard Fix PuffDandEd 30 Jul 2009  
redemptions.sql en español tacoro 6 Jul 2009  
french sql fix simtic 20 Mar 2009  
Possible hack fix Bjarke_goth 25 Feb 2009  
Remember referrer for V2.1rc2a te-deum 8 Jan 2009  
Remember referrer for V2.1rc2a te-deum 7 Jan 2009  
##POINTS AND REWARDS MODULE V2.1rc2a_1 Hotclutch 8 Oct 2008  
Bug found deep-silver 6 Oct 2008  
POINTS AND REWARDS MODULE [Session destroy fix] metacatdud 23 Sep 2008  
New Instructions - updated ssnb 8 Sep 2008  
Updated Installation Instructions ssnb 8 Sep 2008  
Points and Rewards & CCGV covers lildog 25 Mar 2008  
Add french files mesly 13 Oct 2007  
Comments points fix webviva 5 Oct 2007  
Minor fix bug amandloren 9 Apr 2007  
Register_globals MaNoLiA 28 Feb 2007  
Register_Globals=off; fix to show points on checkout_confirmation.php MaNoLiA 21 Feb 2007  
German translations norwac 26 Dec 2006  
Referral Points Once sashaben 23 Sep 2006  
Remember Referrer te-deum 11 Aug 2006  
minor bug fix efusion 11 Aug 2006  
## POINTS AND REWARDS MODULE V2.0d ## CORRECTED Phosky 19 Jul 2006  
V2.0d Phocea 18 Jul 2006  
Addon fif you are using Paypal IPN 3.1.5 Phocea 18 Jul 2006  
Missing gif added deep-silver 18 Jul 2006  
V2.0c deep-silver 17 Jul 2006  
Expire date on new signup. deep-silver 14 Jul 2006  
New redemptions_update.sql bug fixed. PicsOne 14 Jul 2006  
redemptions_update.sql bug fixed. deep-silver 13 Jul 2006  
## POINTS AND REWARDS MODULE V2.00 ## deep-silver 7 Jul 2006  
Auto installer wizard. deep-silver 26 Nov 2005  
upgrade from V1.50 installation instrctions updated. deep-silver 5 Nov 2005  
#### POINTS AND REWARDS MODULE V1.60 #### deep-silver 3 Nov 2005  
#### POINTS AND REWARDS MODULE V1.60 ##### deep-silver 3 Nov 2005  
Italian deep-silver 21 Oct 2005  
french_german deep-silver 19 Oct 2005  
Admin Sort deep-silver 15 Oct 2005  
fixed install.txt deep-silver 20 Sep 2005  
full support for Spanish language. deep-silver 20 Sep 2005  
Points & Gift Voucher fixed. deep-silver 12 Sep 2005  
obtain compatibilty with the latest Credit Class & Gift Voucher and XTML issues. deep-silver 11 Sep 2005  
No points for shipping dpbukltd 10 Sep 2005  
##POINTS AND REWARDS MODULE V1.50## deep-silver 9 Aug 2005  
upgrade from V1.30 installation instrctions updated. deep-silver 5 Aug 2005  
## POINTS AND REWARDS MODULE V1.40 ## deep-silver 5 Aug 2005  
How to remove unwanted decimal. deep-silver 24 Jul 2005  
## POINTS AND REWARDS MODULE V1.30 ## deep-silver 23 Jul 2005  
##POINTS AND REWARDS MODULE V1.30## deep-silver 23 Jul 2005  
History back button. DEEP SILVER ACCESSORY 30 Jun 2005  
upgrade from V1.10 installation instrctions updated. DEEP SILVER ACCESSORY 28 Jun 2005  
Paypal IPN Modifications DEEP SILVER ACCESSORY 27 Jun 2005  
## POINTS AND REWARDS MODULE V1.20 ## DEEP SILVER ACCESSORY 26 Jun 2005  
Wrong files name. DEEP SILVER ACCESSORY 22 Jun 2005  
Bug fixed. DEEP SILVER ACCESSORY 22 Jun 2005  
Updated installation instrctions DEEP SILVER ACCESSORY 17 Jun 2005  
SPAM FIXED!!!!! DEEP SILVER ACCESSORY 16 Jun 2005  
SPAM REPORT!!!!! DEEP SILVER ACCESSORY 16 Jun 2005  
## POINTS AND REWARDS MODULE V1.10 ## DEEP SILVER ACCESSORY 15 Jun 2005  
##POINTS AND REWARDS MODULE V1.00## DEEP SILVER ACCESSORY 6 Jun 2005  
POINTS AND REWARDS MODULE V1.00 BEAT DEEP SILVER ACCESSORY 3 Jun 2005  
POINTS AND REWARDS MODULE V1.00 BEAT DEEP SILVER ACCESSORY 3 Jun 2005  
Points and Rewards v1.21 - now it works :D Fatmcgav 3 Jun 2005  
POINTS AND REWARDS MODULE v1.2 - WORKING Fatmcgav 3 Jun 2005  
*Points & Rewards Module BETA* DEEP SILVER ACCESSORY 3 Jun 2005  
correction DEEP SILVER ACCESSORY 1 Jun 2005  
## POINTS AND REWARDS MODULE V1.00 ## DEEP SILVER ACCESSORY 1 Jun 2005