3. The Rewards system has the following features:

a) Points can be converted to gift certificate or discount coupon
b) Conversion rate of points to currency is set by the merchant
c) Customer can select the number of points to be converted
d) Customer can review number of points available to be converted
e) Mail is set to both customer and merchant when a conversion is made
f) The merchant must decide which type of reward, coupon or gift certificate.
g) Only one type of an award is allowed in a shop.
h) Points can be product specific or can be based on price
i) Merchnat can assign points manually after a order completes
j) Merchant can remove points

4. Able to make payment with points.

The full set of facilities of the Rewards add-on are
described in the Add-Ons section of the VP-ASP Help Notes -

http://helpnotes.vpcart.com

***********************************************************************************

B. FILE STRUCTURE
===================

Files included in the zip are:

- $READ_ME_FIRST_rewards900.html
- shoppointsredeem.asp
- hk_dateform.asp
- hk_paywithpoints.asp
- hk_paywithpointsubs.asp
- shopcartformat.asp
- shopcreateorder.asp
- shopformatorder.asp
- shopthankslinks.asp
- shopvbs.asp
- admin\shopa_pointsorder.asp
- admin\hk_dateform.asp
- admin\hk_paywithpointsreport.asp
- admin\sqlscripts\$rewards_access.txt
- admin\sqlscripts\$rewards_mysql.txt
- admin\sqlscripts\$rewards_sqlserver.txt
- templates\default\tmp_pointsredeemcoupon.txt
- templates\default\tmp_pointsredeemgift.txt

1. Back up the following VPASP files:
- shopcartformat.asp
- shopcreateorder.asp
- shopformatorder.asp
- shopthankslinks.asp
- shopvbs.asp
- shoppointsredeem.asp
- admin\shopa_pointsorder.asp
- templates\default\tmp_pointsredeemcoupon.txt
- templates\default\tmp_pointsredeemgift.txt

* If you DO NOT made any changes to the above files, please ignore below section.

***********************************************************************************

If you HAVE made significant changes to your above files,
then please use winmerge to compare your codes.

To do this, please follow these steps.

1. Download a program called WinMerge (http://winmerge.sourceforge.net/), which will allow you to compare your files with those in the patch.

2. Unzip the patch files to a folder on your computer

4. Download the files included in the patch from your live site into another folder on your computer.

5. Run WinMerge and compare the contents of 2 folders.

6. Save the patched files.

7. Back up the files to be patched on the server.

8. Upload the patched files to your server

9. Test your site to ensure there have been no problems.

***********************************************************************************

2. Upload all the files into your shopping cart folder.

3. Login to your VPASP administration, and run the convertsql.asp.
e.g. http://www.yoursite.com/admin/convertsql.asp

NOTE : You may have deleted the file in your site for security, you can get the file convertsql.asp from your default VPASP 7.00 pack.

4. For fresh installation of SEO Toolkit, in the convertsql.asp page, enter in the text box with value as mentioned below:

If using Access database, please enter : sqlscripts/$rewards_access.txt

If using mySQL database, please enter : sqlscripts/$rewards_mysql.txt

If using SQL Server database, please enter : sqlscripts/$rewards_sqlserver.txt

5. Reload configurations.
5a. Go to Advanced Settings > Software Configuration
5b. Click "Reload Shop Configuration".

6. Reload languages
6a. Go to Advanced Settings > International > Language
6b. Click Reset Language, and choose the language you want to reset. Eg. English.

NONE

NONE

NONE

2016.02.01 - Enhancement: Must always commit transaction if execute sql execute
2017.04.27 - Better handling on creating new records on huge tables
2017.09.12 - Bug Fix: Pay with points: Balance should be paid by other payment method if hkpaywithpointsonly and hkpaywithpointslimitproducts are set to Yes
2018.04.26 - Compatible with v9