Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

### POINTS AND REWARDS MODULE V1.00 ###


Recommended Posts

Done!

I've just made a tes order at or site and used all the points you gave me (sorry :D ).

Good Luck.

and hope that my support is enough for you as i had to fix some errors that as got nothing to do with the points system module.

 

Dear Deep Silver,

 

How are you keeping ?

 

I have had a customer being able to use his Sign Up

points (100) for the very first purchase below the minimum required though a limit of

100 (i resume this is in the shop currency , in this case GBP)

was set as minimum puchase required.

 

+++++++++++++

1 x BLUEWIFLY TWO IN ONE COMBO WiFI-Bluetooth ADAPTER. 17.50% 57.85EUR 57.85EUR 57.85EUR 57.85EUR

Sub-Total: 57.85EUR

ECONOMY International RECORDED DELIVERY parcel (Delivery to IT : 0.2 Kg(s)): 9.52EUR

VAT to be charged for EU: 11.79EUR

Payment Type Discount: 0.29EUR

Points Redeemed(100 x 0.15EUR): -14.64EUR

Total: 64.22EUR

 

++++++++++++++++++++++++++++

 

Below is the admin setting

 

Enable Products Price Restriction false

If you wish to limit points before Redemptions, set points limit 100

If you wish to limit points to be use per order, set points Max 5000

 

++++++++++++++++++++++=

 

I have now raised the minimum to 200 but I guess

there is a bug as the order amount was well below the minimum of 100 GBP

 

Best regards

Shred

Link to comment
Share on other sites

Dear Deep Silver,

 

Below is the admin setting

 

Sorry Correct admin settings

++++++++++++++++++++++++++++

 

Below is the admin setting

++++++++++++++++++++++++++

If Points Exact amount enabled, set the exact amount 100

Restrict Points Redemption For Minimum Purchase Amount 100

++++++++++++++++++++++++++

 

I have now raised the minimum needed points to 200 but I guess

there is a bug as the order amount was well below the minimum of 100 GBP

and the customer should not be able to use his sign up points.

++++++++++++++++++++++++++++

Enable Products Price Restriction false

If you wish to limit points before Redemptions, set points limit 200

If you wish to limit points to be use per order, set points Max 5000

 

++++++++++++++++++++++=

Link to comment
Share on other sites

how difficult is it to integrate credit class & gift voucher with this contribution?

i am happy with points & rewards, but i would also like to use a coupon code so that i can offer discounts in magazine advertisements

 

i did a search on this topic for gift voucher and i see random fixes scattered throughout.

 

is there a possibility of somebody creating an addon for coupon codes to points & rewards, so that the installation of ccgv is not required to offer coupons?

Link to comment
Share on other sites

There is so much information in this thread about the Points and Rewards and I'm afraid that I may have missed why I've discovered a problem with my installation of the contribution.

 

Everything installed perfectly, and I was able to set everything. The ONLY thing I have run into so far, is when a "test customer" has points, and has selected product to purchase, there is an area to select how many points to spend, but it doesn't subtract from the amount of the purchase and doesn't deduct from the total. What have I missed along the way? I did an install from a clean install of osC.

 

Thank you!

Jewls :huh:

Link to comment
Share on other sites

There is so much information in this thread about the Points and Rewards and I'm afraid that I may have missed why I've discovered a problem with my installation of the contribution.

 

Everything installed perfectly, and I was able to set everything. The ONLY thing I have run into so far, is when a "test customer" has points, and has selected product to purchase, there is an area to select how many points to spend, but it doesn't subtract from the amount of the purchase and doesn't deduct from the total. What have I missed along the way? I did an install from a clean install of osC.

 

Thank you!

Jewls :huh:

 

You probably missed this part from the installation instructions:

*. Accses your admin page http://www.your_site_name /admin/index.php

under "Modules" choose Order Total Modules.

A new order total will appear called, " Points Redeemptions " make sure its installed and

that the sort order match yours. this option must appear after " Sub-Total " and before " Total".

When you first install " Points Redeemptions " the sort order no is 4, same as the " Total"

so you must change your value for " Total" sort order to any number higher then 4.

Link to comment
Share on other sites

Sorry Correct admin settings

++++++++++++++++++++++++++++

 

Below is the admin setting

++++++++++++++++++++++++++

If Points Exact amount enabled, set the exact amount 100

Restrict Points Redemption For Minimum Purchase Amount 100

++++++++++++++++++++++++++

 

I have now raised the minimum needed points to 200 but I guess

there is a bug as the order amount was well below the minimum of 100 GBP

and the customer should not be able to use his sign up points.

++++++++++++++++++++++++++++

Enable Products Price Restriction false

If you wish to limit points before Redemptions, set points limit 200

If you wish to limit points to be use per order, set points Max 5000

 

++++++++++++++++++++++=

Sorry but I don't see any bug here.

You set your shop for a minimum of 100 points before any redeemptions can take place.

That's mean that the customer need to save 100 points in is account before he can use his points.

now you gave him 100 points for sign up so he's clear to go.

Where is the problem?

When you set your store for for a minimum of 100 points before any redeemptions can take place,

the customers need 100 points not 101 points.

anyway this fuction has been tested again and it works fine at the demo shop. try it yourself if you so worried

Edited by deep-silver

Remember - - - "STRESSED" spelled backwards "DESSERTS"

Link to comment
Share on other sites

You probably missed this part from the installation instructions:

Thanks for that

P.S= long time no see.

How are you?

Is busines o.k?

wish you a happy New Year

Remember - - - "STRESSED" spelled backwards "DESSERTS"

Link to comment
Share on other sites

how difficult is it to integrate credit class & gift voucher with this contribution?

i am happy with points & rewards, but i would also like to use a coupon code so that i can offer discounts in magazine advertisements

 

i did a search on this topic for gift voucher and i see random fixes scattered throughout.

 

is there a possibility of somebody creating an addon for coupon codes to points & rewards, so that the installation of ccgv is not required to offer coupons?

I don't think I get it, do you have a problem using both modules together?

Remember - - - "STRESSED" spelled backwards "DESSERTS"

Link to comment
Share on other sites

Sorry but I don't see any bug here.

You set your shop for a minimum of 100 points before any redeemptions can take place.

That's mean that the customer need to save 100 points in is account before he can use his points.

now you gave him 100 points for sign up so he's clear to go.

Where is the problem?

When you set your store for for a minimum of 100 points before any redeemptions can take place,

the customers need 100 points not 101 points.

anyway this fuction has been tested again and it works fine at the demo shop. try it yourself if you so worried

 

HEllo Deep Silver,

 

Many thanks for the reply.

What I meant was though the customer had minimum

points needed in his account (given on sign up) he shouldn't

have been able to REDEEM these points for an order value

less than GBP 100 Which was set in the admin.

 

He was however able to order something for about EURO 77

(which is about GBP 50) and claim his points, effectively

getting a discount of GBP 10 without any incentive for

a second purchase.

 

Have I explained the problem clear enough ?

 

Cheers

Shred.

Link to comment
Share on other sites

I don't think I get it, do you have a problem using both modules together?

oh i have not installed it yet, i just wanted to make sure it would not interefere with the points & rewards module :)

 

does it work fine together?

 

if not, what is the possibility of a coupon add-on for points and rewards?

Link to comment
Share on other sites

HEllo Deep Silver,

 

Many thanks for the reply.

What I meant was though the customer had minimum

points needed in his account (given on sign up) he shouldn't

have been able to REDEEM these points for an order value

less than GBP 100 Which was set in the admin.

 

He was however able to order something for about EURO 77

(which is about GBP 50) and claim his points, effectively

getting a discount of GBP 10 without any incentive for

a second purchase.

 

Have I explained the problem clear enough ?

 

Cheers

Shred.

Wich ever way still work fine on the demo shop ,try it your self.

please check your coding and try again.

Remember - - - "STRESSED" spelled backwards "DESSERTS"

Link to comment
Share on other sites

oh i have not installed it yet, i just wanted to make sure it would not interefere with the points & rewards module :)

 

does it work fine together?

 

if not, what is the possibility of a coupon add-on for points and rewards?

as far as i know as well as wrote on the README.txt it dose work with CCV.

Good luck with installing CCV module, a bit triky and still not 100% bugs free,

Remember - - - "STRESSED" spelled backwards "DESSERTS"

Link to comment
Share on other sites

Hi, I am hoping someone can help.

 

Ive just installed the points and rewards module, and after a few minor teething troubles it's running but with one major problem .

 

The cart shows the points a person has (currently 13), but the option to use points to pay does not appear in the checkout area. I double checked that all files where installed and I cannot see anything missing.

 

Admin options set below

 

Enable Points system true Info

Enable Redemptions system true Info

Points per ?1.00GBP purchase 1 Info

The value of 1 point when Redeemed 0.1 Info

Auto Credit Pending Points true Info

Award points for shipping false Info

Award points for Tax false Info

Award points for Specials true Info

Award points for order with redeemed points true Info

Enable Products Restriction false Info

If Restriction enabled set model Allowed. DVD-FRAN Info

Or set Product ID Allowed. Info

Or set Category ID Allowed. Info

Enable Products Price Restriction false Info

If you wish to limit points before Redemptions, set points limit 1

If you wish to limit points to be use per order, set points Max 50 Info

Limit Points Redemptions to exact amount. false Info

If Points Exact amount enabled, set the exact amount Info

Restrict Points Redemption For Minimum Purchase Amount 1.00 Info

New signup customers Welcome Points amount 10 Info

Maximum number of points records to display 20 Info

Display Points information in Product info page true Info

Keep Records of Redeemed Points true Info

Link to comment
Share on other sites

as far as i know as well as wrote on the README.txt it dose work with CCV.

Good luck with installing CCV module, a bit triky and still not 100% bugs free,

sorry, i did not think to search the faq's to see if they were compatible :blush:

 

do you think you will ever create an add-on to use coupon's for your own contribution, without having to use ccgv?

 

also, i have another question. some people are confused by the "points". is it possible to eliminate that box on checkout and use only the tick box, so they use all of their available points (that are allowed to use) on the particular order?

Link to comment
Share on other sites

Happy it solve your problem.

Still your shop layout need some more fixing as the width is killing my browser and the left menu not set correctly on IE.60 as well as your infoBox corners.

 

Hello Deep Silver,

 

I am sorry to bother youagain on the Error 1065 Querry was empty

when opening My-points.php.

 

The problem was several other pages were causing 1064 error

with the modified split_page results.php in catalog and admin

though my-points.php was loading correctly.

Hence I had to restore the original file and revert to the non functioning

my-points.php.

 

Just one question . The split_page_results function needs 4 variables

function splitPageResults(&$current_page_number, $max_rows_per_page, &$sql_query, &$query_num_rows) {

 

Where as you are calling it with only 2

 

$points_split = new splitPageResults($points_query, MAX_DISPLAY_POINTS_RECORD);

 

As you know I am not a php expert. Wonder if this has to do with

the problem which is only happening with my_points.php

 

I shall be grateful as always for your help.

Shred

Link to comment
Share on other sites

Hi, I am hoping someone can help.

 

Ive just installed the points and rewards module, and after a few minor teething troubles it's running but with one major problem .

 

The cart shows the points a person has (currently 13), but the option to use points to pay does not appear in the checkout area. I double checked that all files where installed and I cannot see anything missing.

Make sure you did not miss the scound step in refer to catalog/checkout_payment.php

there are 2 steps and some users just miss it.

Remember - - - "STRESSED" spelled backwards "DESSERTS"

Link to comment
Share on other sites

sorry, i did not think to search the faq's to see if they were compatible :blush:

 

do you think you will ever create an add-on to use coupon's for your own contribution, without having to use ccgv?

 

also, i have another question. some people are confused by the "points". is it possible to eliminate that box on checkout and use only the tick box, so they use all of their available points (that are allowed to use) on the particular order?

maybe later as its not so urgent the mod works fine with CCV.

Now working on inproving the mod and adding reffral points.

with me good luck :thumbsup:

Remember - - - "STRESSED" spelled backwards "DESSERTS"

Link to comment
Share on other sites

Hello Deep Silver,

 

I am sorry to bother youagain on the Error 1065 Querry was empty

when opening My-points.php.

 

The problem was several other pages were causing 1064 error

with the modified split_page results.php in catalog and admin

though my-points.php was loading correctly.

Hence I had to restore the original file and revert to the non functioning

my-points.php.

 

Just one question . The split_page_results function needs 4 variables

function splitPageResults(&$current_page_number, $max_rows_per_page, &$sql_query, &$query_num_rows) {

 

Where as you are calling it with only 2

 

$points_split = new splitPageResults($points_query, MAX_DISPLAY_POINTS_RECORD);

 

As you know I am not a php expert. Wonder if this has to do with

the problem which is only happening with my_points.php

 

I shall be grateful as always for your help.

Shred

mmmmmmm :(

the fix for split_page results.php , provided by osCommerce team not me.

Now the module known to work well with or without the fix for split_page results.php

just for you to not get any douth.

I split the page result at the demo site(just for you)

so now it show 1 row per page with no problem at all.

you are free to check it up and play with it for a while...

http://www.deep-silver.com/shop/

I don't think that there is a problem with the code, as you would'nd be the only one with this problem.

now as your shop known to be a massy one i can think of many other things that can point to this problem.

as advised before, you should go over your files and fix the errors along the way and if by the time you finish doing it, if the problem still there let me know.

You should also post here your server invairoment info.

the demo shop work on.

Linux, apache

PHP Version 4.4.1

Remember - - - "STRESSED" spelled backwards "DESSERTS"

Link to comment
Share on other sites

maybe later as its not so urgent the mod works fine with CCV.

Now working on inproving the mod and adding reffral points.

with me good luck :thumbsup:

 

referral points (w00t) how will this work? i'm very interested.

 

 

do you happen to know what i can do to fix this?

some people are confused by the "points". is it possible to eliminate that box on checkout (the decimal) and use only the tick box, so they use all of their available points (that are allowed to use) on the particular order?

Link to comment
Share on other sites

I installed this contribution for the first time last night and I just have to say its one of the most well thought out and feature rich that I have seen. The gift voucher contribution had previously been installed and I found the extra notes for that situation particularly helpful.

 

With the exception of one minor issue which I was able to correct in about fifteen minutes, the installation went like clock work. Considering the number of files that must be modified I was quite pleased. In addition to a well written contribution that is also a testament to the excellent installation instructions.

 

Be well,

Tina

If you're not having fun you're not doing it right

 

Teach a person to fish rather than give them a loaf of bread or however that saying goes.

Link to comment
Share on other sites

I have installed the module and it works great. I am indebted to deep-silver for this module. One slight problem is when we update the Points from the pending Points link in the admin section, I wished a status sorting option. Its very difficult to go through each and every order to check if its points are updated or not.

 

For example with Order Statuses, we can sort it by Pending, Processing and delivered. Similarly, with Pending points we should have option to select all orders with the Points status - Pending and Confirmed .

 

Is it possible ? Can someone help.

 

Regards,

Link to comment
Share on other sites

I have installed the module and it works great. I am indebted to deep-silver for this module. One slight problem is when we update the Points from the pending Points link in the admin section, I wished a status sorting option. Its very difficult to go through each and every order to check if its points are updated or not.

 

For example with Order Statuses, we can sort it by Pending, Processing and delivered. Similarly, with Pending points we should have option to select all orders with the Points status - Pending and Confirmed .

 

Is it possible ? Can someone help.

 

Regards,

This is a request not a problem.!

I will work on this when time permit.

Remember - - - "STRESSED" spelled backwards "DESSERTS"

Link to comment
Share on other sites

referral points (w00t) how will this work? i'm very interested.

do you happen to know what i can do to fix this?

some people are confused by the "points". is it possible to eliminate that box on checkout (the decimal) and use only the tick box, so they use all of their available points (that are allowed to use) on the particular order?

Hi there.

1.

referral points (w00t) how will this work? i'm very interested.

well as people ask for it, read few post before.

 

2.

I belive that customer that earned enough points , deserve the right to choose the amount of points he or she would like to spend (points codsider cash when reddeem).

so i think that it will be the best if you leave it the way it is and add extra information in refer at the points rewards f&q page.

 

any way just incase, here is the hack for you (the scound one :-" )

 

backup catalog checkout_payment.php

then find this.....

			  <tr onClick="submitFunction()">
			<td><?php echo tep_draw_separator('pixel_trans.gif', '10', '1'); ?></td>
			<td><table border="0" width="100%" cellspacing="0" cellpadding="2">
				<td width="10"><?php echo tep_draw_separator('pixel_trans.gif', '10', '1'); ?></td>
				<td class="main" ><?php echo TEXT_REDEEM_SYSTEM_SPENDING . '??' .tep_draw_input_field('customer_shopping_points_spending', $customer_shopping_points_spending , 'onBlur="validate(this)" onFocus="clearText(this)" maxlength="7" style="width:70px"'); ?><br><?php printf(TEXT_REDEEM_SYSTEM_SPENDING_ALL, number_format($max_points,2)); ?></td>
				<td class="main" align="right"><br><?php echo tep_draw_checkbox_field('customer_shopping_points_spending', $max_points); ?></td>
				<td width="10"><?php echo tep_draw_separator('pixel_trans.gif', '10', '1'); ?></td>
			  </tr>
			</table></td>
		  </tr>

and replace with.....

			  <tr onclick="submitFunction()">
			<td><?php echo tep_draw_separator('pixel_trans.gif', '10', '1'); ?></td>
			<td><table border="0" width="100%" cellspacing="0" cellpadding="2">
				<td width="10"><?php echo tep_draw_separator('pixel_trans.gif', '10', '1'); ?></td>
				<td class="main" ><?php printf(TEXT_REDEEM_SYSTEM_SPENDING_ALL, number_format($max_points,2)); ?></td>
				<td class="main" align="right"><?php echo tep_draw_checkbox_field('customer_shopping_points_spending', $max_points,false); ?></td>
				<td width="10"><?php echo tep_draw_separator('pixel_trans.gif', '10', '1'); ?></td>
			  </tr>
			</table></td>
		  </tr>

save and close.

Now open catalog/includes/languages/english/checkout_payment.php

and edit TEXT_REDEEM_SYSTEM_SPENDING_ALL

to fit your needs.

Done!

Remember - - - "STRESSED" spelled backwards "DESSERTS"

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Unfortunately, your content contains terms that we do not allow. Please edit your content to remove the highlighted words below.
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...