Jump to content
deep-silver

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

Recommended Posts

I am using V2.1rc2a

Most of the functions works well - Referral, Review and Orders - Points get added and shows under pending.

What I dont see is the redeem system not working even though its enabled. During payment checkout option, I am able to see only refferal box getting displayed for new customer checkout but for customers who have points, the redeem box doesnt show up even though they have enough points for redemption.

 

Where would be the problem to get the redemption system working.

Same is at the confirmation page, I am not able to see redemption amount not shown.

 

Any help would be greatly appreciated.

Share this post


Link to post
Share on other sites

I have the Points/RewardsV2.1rc2a system installed on our site and it is working perfectly. The only problem we are having is that we give FREE shipping for orders $60.00 and over but want this only to be for this amount when it is paid in real $$, not in points. EG..a customer purchases $65.00 of goods, uses $12.00 of points so their order is now under the FREE shipping threshold - we don't want them to receive free shipping in this instance but don't know how to automatically stop this from happening. Can we change something in the Points system to stop this? Or does it need to be changed in the Shipping module??

 

Many thanks,

Adrienne

Share this post


Link to post
Share on other sites

Whenever I confirm the points in the admin section, in my email box it shows a

 

"Mail failure - malformed recipient address"

 

I'm guessing in one of the files the coding was incorrect which is not actually sending the emails to the customers, however I'm not sure where to find the problem to fix it. Can anyone point me in the direction in helping me resolve this issue?

 

Thanks

Share this post


Link to post
Share on other sites

Hi all,

I've just started searching for solutions, but was wondering if anyone has any suggestions?

 

I am running a MS2 shop, and have had points/rewards running on my shop for about 3 years, working brilliantly, thanks :)

 

My site's server recently changed from PHP4/MYSQL4/register_globals on to PHP5/MYSQL5/register_globals off, and I thought it had gone ok, but I was wrong. Everything on the admin side is working (I can manually add points, adjust points, delete points etc), but customers are unable to redeem points when checking out. The box to tick "use points" is still there, it still correctly says how many points are available, but it doesn't allow the points to be used. If the points total is less than the order total, it just completes the checkout without redeeming the points. If the points total is more than the order total, it throws the error "REDEEM POINTS ERROR You do not have that many Points to spend."

 

I had a look at the newer versions that have been submitted to the contributions, but it appears that they are for a RC2 shop rather than the MS2 shop. Any ideas on what to look for to fix this?

Edited by bobsi18

Share this post


Link to post
Share on other sites

For some reason, when a customer checks out and has both a discount coupon(CCGV) and Points/rewards module this is what I receive from paypal. Does anyone know how I can fix this so that the points/rewards does not show as a Discrepancy.

 

1 Discount Coupon (5% off)

Item # SHARE5 -$2.09 USD

 

1 Order Total Discrepancy

Item # - -$9.46 USD

 

It occurs using the Paypal Payment Pro Intergration.

 

Thanks in advance.

Share this post


Link to post
Share on other sites

My Points & rewards is working fine. I see few issues.

 

1. I get only a check box to redeem full points against orders and no box to enter the points manually to be redeemed. is this possible?

2. In Admin under customer points section, I was trying to use the search option to filter the birthday of customers by month or any drop down option, it takes me to the login option again and bring back to the customer point page but its doesnt filter as per drop down option. In simple words, the drop option doesnt work. Is there a way to make it work and filter as per drop option.

 

Any help would be appreciated.

 

Thanks & Regards

Sukumar

Share this post


Link to post
Share on other sites

I still haven't been able to figure out the problem with the email issue:

 

Whenever I confirm the points in the admin section, in my email box it shows a

 

"Mail failure - malformed recipient address"

 

I'm guessing in one of the files the coding was incorrect which is not actually sending the emails to the customers, however I'm not sure where to find the problem to fix it. Can anyone point me in the direction in helping me resolve this issue?

 

Thanks

Share this post


Link to post
Share on other sites

Sorry, I cannot edit my post in the last..

 

Please help

 

Below is an example for the checkout payment problem

 

 

When the order is over $1000.00, in the checkout payment page, select payment with redeem points:

 

then,

 

In checkout confirmation page:

 

Sub-Total: $1199.97

Flat Rate (Best Way): $5.00

Points Redeemed: -$75.00

Total: $1.00

 

The order can successfully checkout but the customer just has to pay $1.00 instead of $1129.97

 

 

When the order is below $1000.00, there is not problems at all.

Share this post


Link to post
Share on other sites

The problem is solved. I got this tip from "sashaben", it was posted few years ago, on page 100. Thanks so much sashaben.

 

 

Below is the original code changed from sashaben

 

FIND:

includes/modules/order_total/ot_redemption.php

 

Replace this:

$order->info['total'] = number_format($order->info['total'] - tep_calc_shopping_pvalue($customer_shopping_points_spending), 4);

 

With the following:

$order->info['total'] -= tep_calc_shopping_pvalue($customer_shopping_points_spending);

Edited by Lumbridge

Share this post


Link to post
Share on other sites

Hello all,

 

I'm trying to install this contribute..... on step 5 (first part) i need to find:

  if ( ( is_array($payment_modules->modules) && (sizeof($payment_modules->modules) > 1) && !is_object($$payment) ) || (is_object($$payment) && ($$payment->enabled == false)) ) {
   tep_redirect(tep_href_link(FILENAME_CHECKOUT_PAYMENT, 'error_message=' . urlencode(ERROR_NO_PAYMENT_MODULE_SELECTED), 'SSL'));
 }

in checkout_process.php

 

I can't find it in my checkout_process.php........ so who can help me with this issue???

 

Thnx

Tjappie W (NL)


osC version: 2.2 MS2 060817

 

Own addons installed:

iOSC3 v4.01 - Discount Coupon Codes for iSOC3 - Points and Reward for iOSC3 - Purchase witouth Account for iOSC3

 

Installed addons:

will follow.....

Share this post


Link to post
Share on other sites

When I tick the redemption box, it doubles the redemption amount on the checkout_confirmation.php page. If I then hit my browser back button, and return to my checkout_payment.php page. It then shows the correct redemption calculation in the product(s) edit area.

 

Within this support thread, in post #1871, there is a solution for the confirmation page. Although, this solution did not work for me, because the code "$order_total_modules->process();" was already removed.

 

I am using v2.2rc2a. And am using V2.1rc2a of this contribution, the version To be used with osCommerce-2.2rc2a. I have reviewed my installation and could find no errors, and could find no other solution within the support thread. All other functions work perfectly. I am using Credit Class Gift Voucher, latest version and the weave was quite simple per the instructions. I have looked at my order_total modules as well as my payment modules and my checkout_process.php page, but have yet to find a solution. :-"

 

Has anyone had this problem and been able to fix it? Please let me know of that solution. :-"

 

Thank you

Larry

 

This is a very nice contribution

Share this post


Link to post
Share on other sites

I seem to be having a couple of issues with this contrib.

 

The 1st has been mentioned before but i haven't seen a fix for it....

 

issue 1....

Points are being deducted at the checkout confirmation page. If customers change their mind and back out of the checkout they have lost their points.

 

issue 2....

emails don't seem to be sending to customers when points are added to their account via Admin. a message is shown saying the email was sent successfully but the customer never receives it.

 

Other than the issues above, everything else seems to be working perfectly.

 

Any help on these would be really appreciated.

 

Thanks,

Steven

Share this post


Link to post
Share on other sites

When I tick the redemption box, it doubles the redemption amount on the checkout_confirmation.php page. If I then hit my browser back button, and return to my checkout_payment.php page. It then shows the correct redemption calculation in the product(s) edit area.

 

Within this support thread, in post #1871, there is a solution for the confirmation page. Although, this solution did not work for me, because the code "$order_total_modules->process();" was already removed.

 

I am using v2.2rc2a. And am using V2.1rc2a of this contribution, the version To be used with osCommerce-2.2rc2a. I have reviewed my installation and could find no errors, and could find no other solution within the support thread. All other functions work perfectly. I am using Credit Class Gift Voucher, latest version and the weave was quite simple per the instructions. I have looked at my order_total modules as well as my payment modules and my checkout_process.php page, but have yet to find a solution. :-"

 

Has anyone had this problem and been able to fix it? Please let me know of that solution. :-"

 

Thank you

Larry

 

This is a very nice contribution

I was able to solve this problem. Everything works as expected, with no errors.

Share this post


Link to post
Share on other sites

Hello,

 

on my customer order screen i am now unable to change the status of orders.

 

i get the the following error

 

1054 - Unknown column 'status' in 'field list'

 

select orders_id, status from customers_points_pending where status = 1 and orders_id = 2159

 

[TEP STOP]

 

i tried using the search but i could not find anything.

 

i am using the V2.1rc2a version

 

can anyone help me?

 

thanks

Edited by DarrenHoldaway

Share this post


Link to post
Share on other sites

If your thinking of using this contrib...I highly recommend it!!! It is a great way to get customers to keep coming back to you instead of your competition!!!

 

I only have one problem that I can't seem to fix....

 

We have Free Shipping on Items over $75 - If someone buys something for $100, and use $50 in points, it currently gives them free shipping as it adds the total before the points. I want it to look at the total after points as I need the customers to pay $75 out of their pocket to get free shipping. Any ideas?

Share this post


Link to post
Share on other sites

Hi all, I have installed this contribution. Everything seems okay, but on the payment page there is no option for the points to be used. I am using this with One Page Checkout.

One Page checkout uses a payment_Meethod.php which is in /includes/checkout/, there is a code for points in there.

 

Any help will be appreeciated.

Share this post


Link to post
Share on other sites

Hi all, I have installed this contribution. Everything seems okay, but on the payment page there is no option for the points to be used. I am using this with One Page Checkout.

One Page checkout uses a payment_Meethod.php which is in /includes/checkout/, there is a code for points in there.

 

Any help will be appreeciated.

Hi,

I have the same problem. Can you help?

Share this post


Link to post
Share on other sites

I'd like to have a total accumulated points calculation as we are offering special one time rewards for different levels of achievement. Such as 2000 points, 5000 points, 10000 points, etc... Kind of like an airline where they have various levels of achievement within their rewards systems.

Share this post


Link to post
Share on other sites

I'd like to have a total accumulated points calculation as we are offering special one time rewards for different levels of achievement. Such as 2000 points, 5000 points, 10000 points, etc... Kind of like an airline where they have various levels of achievement within their rewards systems.

 

Looks like I've got it. Basically just takes the customers current points and adds (well, subtracts the negative) the redeemed points to get the total accumulated points. Below is for what the customers see in their account. Just finishing up the report in the admin section so we can track these people easily. Next up will be to make loyalty groups at the different point levels and an automated system to alert those who qualify.

 

The query:

 

<?php $accumulated_points_query = tep_db_query("select c.customers_id, c.customers_shopping_points, pp.customer_id, sum(pp.points_pending) as points_redeemed from " . TABLE_CUSTOMERS . " c, " . TABLE_CUSTOMERS_POINTS_PENDING . " pp where points_status = 4 and c.customers_id = pp.customer_id and customers_id = '" . (int)$customer_id . "'"); 

$accumulated = tep_db_fetch_array($accumulated_points_query);?>

 

And to display the data:

 

Lifetime Accumulated Loyalty Points: <?php echo number_format($accumulated['customers_shopping_points'] - $accumulated['points_redeemed'],POINTS_DECIMAL_PLACES); ?>

Share this post


Link to post
Share on other sites

For the report I had to do it a little differently. In order to do a proper sort by accumulated points I had to get the math done in the query instead. Now I can sort by customers name, current points, accumulated points, etc... I also added their emails to the report and next will figure out how to export the report with selected parameters to excel.

 

The query:

 

$customers_query_raw = "select c.customers_id, c.customers_firstname, c.customers_lastname, c.customers_email_address, c.customers_points_expires, c.customers_shopping_points, pp.customer_id, (c.customers_shopping_points - sum(case when pp.points_status = 4 then pp.points_pending else 0 end)) as points_accumulated from " . TABLE_CUSTOMERS . " c, " . TABLE_CUSTOMERS_POINTS_PENDING . " pp where c.customers_id = pp.customer_id group by c.customers_firstname, c.customers_lastname order by $sort "; 

 

The output:

 

<?php echo number_format($customers['points_accumulated'],POINTS_DECIMAL_PLACES); ?>

Share this post


Link to post
Share on other sites

Hi,

I have the same problem. Can you help?

 

I am still trying to fix, but not working up to now.

Share this post


Link to post
Share on other sites

Any ideas how to make a report to show the total new points for the day and for the month? I was trying to use a modified version of this to account for the date, but the problem is the points store in the customers table don't have an "added" date attached to them like the points in the pending table do!

 

$customers_query_raw = "select c.customers_id, c.customers_firstname, c.customers_lastname, c.customers_email_address, c.customers_points_expires, c.customers_shopping_points, pp.customer_id, (c.customers_shopping_points - sum(case when pp.points_status = 4 then pp.points_pending else 0 end)) as points_accumulated from " . TABLE_CUSTOMERS . " c, " . TABLE_CUSTOMERS_POINTS_PENDING . " pp where c.customers_id = pp.customer_id group by c.customers_firstname, c.customers_lastname order by $sort ";

Share this post


Link to post
Share on other sites

Hello everyone. :)

 

I hope you apologize my English, I do not speak well.

I need your help, if possible, please.

 

I have installed this module, but I need to make me discount points on the sub-total and not the final total.

 

As I have it now:

 

____________________________

 

Product: 20 €

____________________________

 

 

sub-total: 16, 95 €

Other discounts: 0 €

18% VAT: € 3.051

Shipping costs: 5 €

----------------------------

discount coupons: - 10 €

____________________________

____________________________

 

TOTAL: 15 €

____________________________

____________________________

 

 

 

But it would have to be this way:

 

____________________________

 

Product: 20 €

____________________________

 

 

sub-total: 16, 95 €

discount coupons: - 10 €

Other discounts: 0 €

18% VAT: € 1.251

Shipping costs: 5 €

____________________________

____________________________

 

TOTAL: 13.20 €

____________________________

____________________________

 

 

I tried to change the disposition of all modules in OrderTotal and not get the expected results.

I appreciate any help. please.

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

×