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.