Rewards Configuration

The following configuration option controls how the rewards system works.

Xpointsredeem	Yes Turns on rewards system
Xpointsredeemrate	.10 The number multiplied against the points to obtain a $ amount or a percentage if using couponpercent
Xpointsredeemtemplategift	tmp_pointsredeemgift.txt
xpointsredeemtemplatecoupon	tmp_pointsredeemcoupon.txt
Xpointsredeemtype	Gift or Coupon or PercentCoupon The type of reward to be created. Only one type is allowed per shop
xpointsredeemcouponproducts	List of product numbers for which coupon can be used For example: 1,77,88
xpointsredeemcouponcategories	List of categories for which product can be used For example: 2,3
Xpointsredeemminpoints	Minimum number of points that can be redeemed
Xpointsredeemmaxpoints	Maximum that can be redeemed at one time
Xpointsequalcurrency	Yes means that the points are calculated using the price rounded to an integer. For example $5.55=5 points $6.85 = 7 points

    

Shopa_pointsorder.asp

A new administrative utility shopa_pointsorder.asp allows you to add or subtract points from a customer easily. To use this new facility, assign it to one or more administrator userids manually.

1. Login to VP-ASP Administration

2. Go to User Control Menu

3. Edit a userid

4. At the bottom of the menus in the left column check Points Administration     

Difference between Coupons and Gift Certificates

This section will help you decide which rewards system you may wish to use.

Coupons can be used only once.
They deduct the face value from the amount of purchase for products only. If a customer purchases say a $40 product and $10 shipping and the coupon has a face value of $60, they do not pay anything for the product but have to pay the $10 shipping but they also cannot use the remaining $20 of the coupon.
Coupons are automatically available for use.

Gift certificates act more like cash and can be reused.
If a person has a $60 gift certificate, and purchases $40 worth of goods plus $10 shipping, the remaining $10 can be used again at some later time. Shipping is always paid for automatically by gift certificate. Gift certificates are not automatically available for use unless the merchant has set set xgiftautoenable=Yes.

    

Difference between a Coupon and PercentCoupon

A coupon generates a fixed currency amount. This is done by multiplying the redeemrate by the number of points. So 1000 points at .01 redeem rate gives a coupon value of $10. A coupon percent gives a percent discount and not a fixed amount. So 1000 points at .01 = 10% discount.     

Coupon and Gift Certificate names

The certificate/coupon is generated with the following name:
Points-hhmmss-n

The hhmmss is the time of purchase
The n is the customer id
The word points is a constant name.     

Mailing

Mailing is done by either of two templates depending on which reward is allowed. You should edit the template to add your own store details.

Xpointsredeemtemplategift	tmp_pointsredeemgift.txt
xpointsredeemtemplatecoupon	tmp_pointsredeemcoupon.txt

Only fields in the coupons table can be used for the coupon template. Only fields in the gifts table can be used for the gift certificate template.     

Handling Fraud

New fraud checks have been added to the points system. 
 
If a person does not pay using one of the valid payments set in shop configuration xendofordervalidpayments, the points are recorded with the order but they are not automatically added to the customer record. This prevents a person from fraudently buying something and then redeeming the points to buy something else.
 
If the order will be processed, it is up to the merchant to manually add the points to the customer record. The point value is stored in the order record. A note is placed into the order record in the “other1” field that the points have not been added.  We supply a utility called shopa_pointsorder.aps that can be used to add and subtract points from the customer record.
 
Points remaining 100
 
This tells you that 100 points were accumulated for the order but not added to the customer record.    

Handling Coupons and Gift Certificates

Any purchase made with gift certificate or coupon that has the word “points” in it, will not accumulate new points. This prevents the doubling up of points.     

How do I limit products that can be purchased using points

Only coupons can limit purchase to specific products or category of products. Suppose you only want customers to be able to purchase certain items using points. Put in a value like “redeem” into the field pother1 of the product record and then create a hyperlink on your site such as

p>a href="shopquery.asp?pother1=redeem">Product for points/a>/p>

This will display all products that have redeem in the pother1 field Then use the following Shop Configurattion value to limit purchase to those products. These numbers will be site specific.

Xpointsredeemcouponproducts	List of product numbers for which coupon can be used For example: 1,77,88
Xpointsredeemcouponcategories	List of categories for which product can be used For example: 2,3

    

Setting points per product

To set your own points per product, edit each product record and put the number of points in the points field of the record.     

Using Price to set points

Instead of setting a value for each product individually, the product price can be used to automatically calculate the points.
Use the following shop configuration value

Xpointsequalcurrency

Yes means that the points are calculated using the price rounded to an integer. For example $5.55=5 points $6.85 = 7 points

 

    

End of Order Payment Checking

To prevent hackers from accumulating points and then using them, a check is made against a list of valid payment methods that you trust.

Xendofordervalidpayments

Visa,Authorizenet

 
This is a list of payment methods, which VP-ASP will check. If a payment is made using one on the list, the points are immediately added to the customer record. Otherwise the points are stored with the order record but not automatically added to the customer record and therefore cannot be used by the customer.

    

Redeeming Points

A new menu appears on the Customer Service menu (shopcustadmin.asp). Link #9 in this example.
 

A new page is displayed showing the customer the number of points remaining and allowing them to
select the number of points to be redeemed

 

The customer clicks continue, a coupon or gift certificate is created and an email is sent to both the
merchant and the customer.

    

Manually adding/deleting Points

Once an order has gone through, you wish to now add the points to the customer record. This can be done
using a new file shopa_pointsorder.asp. This form allows you to add points or remove points from the
customer record.

 

Once an order number is entered, a confirmation screen will be displayed

 

This says that the order was worth 100 points. Do you want to proceed? If not use the back button. There
is no error indication in the order. This means that the order may have already added the points to the
customer during the order process.