Reward Points Module for ZC v13x

DarrenQ:

Where did you find version 1.32a to?

Also my points are adding up incorrectly for each product.

It should be £1 is equal to 1 point. however an item that is worth £32.99 is coming up as being worth only 28 points. It was not doing this yesterday, it was correct. ANyone got any ideas?

I have now found 1.32a and have also worked out that the display points on the product info page is calculating the points minus the added VAT. However if you go to checkout then the points are calculated on the sub total including the VAT.

So my quesiton is how do i get the points on the product info pages to calculate the points based on the total price and not the price minus VAT.

http://www.gamebeta.co.uk/index.php?main_page=product_info&cPath=1_3_27&products_id=8

Heres a link for an example. It should be showing 28 points not 24 which is the base price minus VAT

DarrenQ:

I have now found 1.32a and have also worked out that the display points on the product info page is calculating the points minus the added VAT. However if you go to checkout then the points are calculated on the sub total including the VAT.

So my quesiton is how do i get the points on the product info pages to calculate the points based on the total price and not the price minus VAT.

http://www.gamebeta.co.uk/index.php?main_page=product_info&cPath=1_3_27&products_id=8

Heres a link for an example. It should be showing 28 points not 24 which is the base price minus VAT

I have fixed it now, just made each point worth 1.175 to account for the 17.5% UK VAT and it is fine now :D

Hope this helps anyone if they have a similar problem

Sorry could not edit abpve post.

It isn't fixed like this as it then adds the points to the Total aswell. SO somethign that costs 14.99 is acually giving 18 points.

Anyone got any ideas how to fix this issue

Ok, I've tested version 1.32a and it indeed fixes the zero value checkout bug :clap:

Can you tell me if it's possible to make the Reward Points information on the checkout screen a bit clearer for the customer?
Rather than having this....

Current Reward Points: 428 points earned
Value of Redeemed Reward Points: £3.00

I'd like to show both the number and value of points for both so the customer knows how many points will be used for the order and the current value of the points they hold. Something like this.....

Current Reward Points earned: 428 points (£4.28)
Reward Points to Redeem For This Order: 300 points (£3.00)

Hem:

Installed RP Version 1.32a. Clean new install. Ran rpd.php. No errors. Just the version report as follows:
Zencart version: Zen Cart v1.3.8a
PHP version: 5.3.1
MySQL version: 5.1.41
(running on XAMPP localhost for testing before installation on live server.)

Everything works, except that no points are shown in the Admin/Customers/Reward Points. No pending, no earned. I can award customers points in the Admin, and they can be redeemed as normal. Points accrued show in sideboxes, shopping cart, checkout and order confirmation. Points "earned" show up in customer account for each past order.

But the points don't really exist, unless I award them thru the Admin. The cart is simple - no shipping, no taxes, no on-line payment systems. (purchase orders and off-line CC only).

I read all 147 forum pages, and checked around in the PHP. Everything seems normal. No error messages or DB errors or anything. It's just that the points are not transferred to either "pending" or "earned" in the Admin/Customers and cannot be used on subsequent orders, because they do not exist.

Only mods are Super Orders (points show up there) and Purchase Orders.

Got any ideas? I tried everything before posting.....

I'm not sure if this question was asked already... i did surf through several pages (but not all of them) and can't seem to find it.

Is there a possible way to display the accumulated rewards points each customer earns on their "My Account" page?
Because right now, the only way to keep track of how much reward points earn is to go to checkout...

In the readme.txt it said there was an update for that on v. 1.26, but it doesn't seem to show up...

Cdkl,
Have you taken the My Account Information Link in the My Account page?
If memory serves correctly it's the first link.
I've installed version 1.32a of this mod and I can see accumulated points on that page

damiantaylor:

Cdkl,
Have you taken the My Account Information Link in the My Account page?
If memory serves correctly it's the first link.
I've installed version 1.32a of this mod and I can see accumulated points on that page

Unfortunately, yes. I have clicked on the "View or change my account information" and all the other links, but there is no information about reward points....

Another strange thing is, the "Shopping Cart with Rewards" sidebox does not exist in: Admin->Tools->Layout Box Controller, BUT my shopping cart does display the reward points.

I have the reward points module installed. and in admin, under configuration, there is a an option "reward points" that I can go through to edit and so forth... But under the catalog category, there is no rewards option. In fact I don't see it under the modules/order total, or in the tools/layout box controller. How do I get those to show? thanks!

Cdkl,
Try uploading tpl_account_edit_default.php in includes/templates/yourtemplate/templates again. Or, if you have already made changes to that file, add the rewards section to your version:

<fieldset>
<legend><?php echo REWARD_POINT_TITLE; ?></legend>
<?php
	$total_points=getCustomersRewardPoints($_SESSION['customer_id']);
	if(defined(MODULE_ORDER_TOTAL_REWARD_POINTS_STATUS) && MODULE_ORDER_TOTAL_REWARD_POINTS_STATUS==true)
	{
		$redeem_ratio=GetRedeemRatio($_SESSION['customer_id']);
		$points_value=$currencies->format($total_points*$redeem_ratio);
	}
	else
	 if(defined(MODULE_ORDER_TOTAL_REWARD_POINTS_DISCOUNT_STATUS) && MODULE_ORDER_TOTAL_REWARD_POINTS_DISCOUNT_STATUS==true)
	 {
		$row=GetRewardPointDiscountRow($total_points);
		$value=($row!=null?$row['discount']:0);
		 
		if(MODULE_ORDER_TOTAL_REWARD_POINTS_DISCOUNT_TYPE==0)
		 $points_value=$value."%";
		else
		 $points_value=$currencies->format($value);
	 }
	
	echo '<label class="inputLabel">'.REWARD_POINT_PROMPT.'</label>'.'<label class="inputLabel">'.$total_points.'</label>'; 
	echo '<br class="clearBoth" />';
	echo '<label class="inputLabel">'.REWARD_POINT_VALUE_PROMPT.'</label>'.'<label class="inputLabel">'.$points_value.'</label>';
?>
<br class="clearBoth" />
</fieldset>

......that should do it.

Are we able to show "potential reward points" on product pages, right under the prices etc?

This may be useful for marketing/promotion purpose. i.e. encouraging sales of certain categories, by upping the reward points for that category/categories, customers will be able to view the potential reward points for that item right away.

Another question, anyone using "edit orders 2"? I use this mod, and it has been very useful, especially that I offer customized services, and at times, I do need to edit the order/prices etc.

The problem is that after installing Reward Points mod, when I try to edit the order, the points are no longer in the order, and I am unable to input directly because it will be converted to money value and add on to the order total.

I have installed the Reward Points 1.32a and I am running ZenCart 1.3.9d.

When I run rpd.php I get the following errors:

zen_reward_customer_points- table found.
customers_id- field missing in zen_reward_customer_points!!!
reward_points- field missing in zen_reward_customer_points!!!
pending_points- field missing in zen_reward_customer_points!!!

zen_reward_status_track- table found.
rewards_id- field missing in zen_reward_status_track!!!
customers_id- field missing in zen_reward_status_track!!!
orders_id- field missing in zen_reward_status_track!!!
date- field missing in zen_reward_status_track!!!
reward_points- field missing in zen_reward_status_track!!!
status- field missing in zen_reward_status_track!!!

zen_configuration_group- table found.
Allow Redeem of Reward Points on Order Total or Subtotal- record missing in zen_configuration!!!

When I check my db tables they show that the fields are there. Any suggestions as to what may be wrong?

I ran rpd.php and I uploaded some of the missing files and now I can't log in to my admin, its just a blank white page. what can be causing that?

In includes/modules/order_total/ot_reward_points.php the section to draw a text box so the customer can input the numer of points they wish to redeem has been commented out.
Has this been commented out during testing and left commented by mistake or is there a problem with it?
I'm tempted to try uncommenting it to see if it works but I'm worried about writing junk to the database as I only have a live site at the moment!
If anyone has a test site and fancies giving it a try, please post the results back on here.
Just scan the ot_reward_points.php file for 'Automatic' and you'll find the section of code that has been commented out with double slashes.

Version 1.33a now available for download at http://www.omnicia.com/Zencart%20Reward%20Points%20Module.zip. The two fixes are the reinstatement of manual reward points entry and the removal of the "Better Together" test code. If you have already installed a recent version, the only two files that have changed are:

includes/modules/order_total/ot_reward_points.php

and

includes/templates/custom/templates/tpl_document_product_info_display.php

Fantastic :clap:
Thanks Andrew!

Hi Andrew,
I've tested the new includes/modules/order_total/ot_reward_points.php but there are still some bugs.

Firstly, in the ot_rewards_points.php file itself at line 113 you have

$prompt=zen_input_field('redeem_flag',true,isset($_SESSION['redeem_value'])).' '.zen_draw_hidden_field('redeem_checkout_flag',true);

My Zen Cart couldn't find the function zen_input_field, so I think this should be

$prompt=zen_draw_input_field('redeem_flag',true,isset($_SESSION['redeem_value'])).' '.zen_draw_hidden_field('redeem_checkout_flag',true);

That allows the page to render correclty, but it doesn't matter what value I type in to the box, on the checkout_confirmation page it still takes all the points I have available from the order total, ignoring what I type in the redeem points box

Okay, I have "Freshened" the zip file, so could you give it another try- thanks.

Hi

Where does the link in the "Admin>Configuation>Reward Points" come from?

I have a spare link in my config menu, and I was wondering how to get rid of it. The url is configuration.php?gID=31 if that means anything.

That link goes to a basically blank page (I gues it is from a previous version). It isn't a problem as such, I just wanted to tidy things up a bit and remove the link/code/file/database entry or whatever it is.

Thanks

Paul