Forums / All Other Contributions/Addons / Reward Points Full Suite v2.5 (for ZC v1.5x) Support Thread

Reward Points Full Suite v2.5 (for ZC v1.5x) Support Thread

Views: 72,389

Results 141 to 160 of 364
20 Dec 2015, 4:53 PM
#141
mvstudio avatar

mvstudio

Zen Follower

Join Date:
Apr 2008
Posts:
447
Plugin Contributions:
1

Reward Points Full Suite v2.5 (for ZC v1.5x) Support Thread

Hello. I've upgraded to the newest version thinking it would fix the issues I had but they didn't get resolved with the upgrade.

  1. If customer uses his/her reward points to pay for the order, the reward points given for that order are 0. Is there any way to give reward points to the customer on scenarios like this?
  2. If customer uses his/her reward points to pay for the order, there is a difference of exactly $0.01 cent added to the total value of points used. Example below.

Subtotal: $33.30
Shipping: $6.00
Membership discount: -$3.33
Value of Reward Points: -$29.98 <- should be -$29.97
Total: $5.99 <- should be $6.00

I'm not using edit orders.
If anyone could shed some light on these issues I would really appreciate it.

M.Valenti
Contemporary Artist - Entrepreneur
http://www.manuelavalenti.com - http://www.byvalenti.com

5 Jan 2016, 1:19 PM
#142
shiftypow avatar

shiftypow

Zen Follower

Join Date:
Jan 2006
Posts:
120
Plugin Contributions:
0

Re: Reward Points Full Suite v2.5 (for ZC v1.5x) Support Thread

Hi, I am looking to introduce a points system to our site. What I want to do is when I sell a bike you get so many points to put towards accessories. Is there a way to do it in a points way or is it always physical money? An example someone buys a bike you get 30 points to spend. so you could spend e.g 15 on shoes etc.............

9 Jan 2016, 7:53 AM
#143
emmathepoly avatar

emmathepoly

New Zenner

Join Date:
Dec 2015
Posts:
9
Plugin Contributions:
0

Re: Reward Points Full Suite v2.5 (for ZC v1.5x) Support Thread

Hello, I was wondering if there would be a way to view how many points a customer has on their account by going to the 'my account' page? Is there a PHP script I can use to call the value? Thanks :)

14 Jan 2016, 2:31 PM
#144
lindasdd avatar

lindasdd

Zen Follower

Join Date:
Jun 2007
Posts:
474
Plugin Contributions:
0

Re: Reward Points Full Suite v2.5 (for ZC v1.5x) Support Thread

Shiftypow:

Hi, I am looking to introduce a points system to our site. What I want to do is when I sell a bike you get so many points to put towards accessories. Is there a way to do it in a points way or is it always physical money? An example someone buys a bike you get 30 points to spend. so you could spend e.g 15 on shoes etc.............

Isn't the point spending scenario you described the same as 'physical money'?

14 Jan 2016, 2:46 PM
#145
lindasdd avatar

lindasdd

Zen Follower

Join Date:
Jun 2007
Posts:
474
Plugin Contributions:
0

Re: Reward Points Full Suite v2.5 (for ZC v1.5x) Support Thread

EmmaThePoly:

Hello, I was wondering if there would be a way to view how many points a customer has on their account by going to the 'my account' page? Is there a PHP script I can use to call the value? Thanks :)

This isn't built in.

I wanted the same thing so I created it. I can give you some basics, but keep in mind this is specific to the Tableau template.

Also keep in mind I am not a 'programmer'. I hacked this together. It has been working for a couple months with no error logs, but it could be garbage :smile:

Here is a quick run down for my site: :

  1. add the link to the My Account Page
    on includes\templates\tableau\templates\tpl_modules_account_menu.php insert the following after line 11:
<li class="communications"><?php echo ' <a href="' . zen_href_link(FILENAME_ACCOUNT_REWARDS, '', 'SSL') . '">' . MY_ACCOUNT_REWARDS . '</a>'; ?></li>
  1. In includes\languages\english\extra_definitions\account.php
    Add something like the following after line 23:
    define('MY_ACCOUNT_REWARDS','Rewards/Store Credit');

  2. Create a file includes\templates\tableau\templates\tpl_account_rewards_default.php and put this in it:

<?php /** * Page Template * * Loaded automatically by index.php?main_page=account_rewards.<br /> * View or change Customer Account Information * * @package templateSystem * @copyright Copyright 2003-2005 Zen Cart Development Team * @license <http://www.zen-cart.com/license/2_0.txt> GNU Public License V2.0 * @version $Id: tpl_account_rewards_default.php 3848 2006-06-25 20:33:42Z drbyte $ * @copyright Portions Copyright 2003 osCommerce */ ?> <div class="centerColumn" id="accountPassword"> <h1 class="back"><?php echo HEADING_TITLE; ?></h1> <div class="required alert forward"><?php echo FORM_REQUIRED_INFORMATION; ?></div> <?php require($template->get_template_dir('tpl_modules_account_menu.php',DIR_WS_TEMPLATE, $current_page_base,'templates'). '/tpl_modules_account_menu.php'); ?> <div class="account-info-wrapper"> <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>';
echo '<br class="clearBoth" />';
echo '<a href="https://www.lindasdietdelites.com/pages/rewards-48.html">Rewards Info</a>';

?>
<br class="clearBoth" />

</fieldset> </div> </div>
  1. Make sure includes/extra_datafiles/reward_points_filenames.php includes the following:
    define('FILENAME_ACCOUNT_REWARDS','account_rewards');

  2. Create a folder includes/modules/pages/account_rewards

  3. Create a file includes/modules/pages/account_rewards/header_php.php and put this in it:

<?php /** * Header code file for the Account History page * * @package page * @copyright Copyright 2003-2005 Zen Cart Development Team * @copyright Portions Copyright 2003 osCommerce * @license <http://www.zen-cart.com/license/2_0.txt> GNU Public License V2.0 * @version $Id: header_php.php 3160 2006-03-11 01:37:18Z drbyte $ */ // This should be first line of the script: $zco_notifier->notify('NOTIFY_HEADER_START_ACCOUNT_REWARDS'); if (!$_SESSION['customer_id']) { $_SESSION['navigation']->set_snapshot(); zen_redirect(zen_href_link(FILENAME_LOGIN, '', 'SSL')); } require(DIR_WS_MODULES . zen_get_module_directory('require_languages.php')); $breadcrumb->add(NAVBAR_TITLE_1, zen_href_link(FILENAME_ACCOUNT, '', 'SSL')); $breadcrumb->add(NAVBAR_TITLE_2); // This should be last line of the script: $zco_notifier->notify('NOTIFY_HEADER_END_ACCOUNT_REWARDS'); ?>
15 Jan 2016, 1:45 PM
#146
shiftypow avatar

shiftypow

Zen Follower

Join Date:
Jan 2006
Posts:
120
Plugin Contributions:
0

Re: Reward Points Full Suite v2.5 (for ZC v1.5x) Support Thread

I have installed the mod and set up the points what works absolutely great but I have a few questions. When I bought an item and got points as a pretend customer I couldn't spend them straight away? Is there a way to change this at all? Also in the admin section I had to assign the pretend customer a "pricing group" for the reward points is this correct or am I doing it wrong? Finally last question when I logged back in as a customer once I had been given the points I tried to get an item purely with my points but it would not allow me and said I had to choose a payment option can this be bypassed also? Thank you

3 Feb 2016, 7:52 AM
#147
dragonlady avatar

dragonlady

Zen Follower

Join Date:
May 2010
Posts:
145
Plugin Contributions:
0

Re: Reward Points Full Suite v2.5 (for ZC v1.5x) Support Thread

I just installed this, and it seems to be working fine. But I'm a bit fuzzy about how to set it so 25 points = $1.00 off the subtotal only?

Also, what happens when the old reward transaction period ends? Do those points just "expire"? If so, does the customer get a warning notice before it happens?

14 Feb 2016, 12:32 AM
#148
hubert avatar

hubert

Zen Follower

Join Date:
Mar 2005
Posts:
229
Plugin Contributions:
0

Re: Reward Points Full Suite v2.5 (for ZC v1.5x) Support Thread

Hello,

I had an old version installed on ZC 1.5.0, as I'm in the process of upgrading to 1.5.4, I've installed the 2.5e version.
I didn't do any deep testing but as far as I've been I have a calculation problem.

My checkout confirmation page shows me :
$70.25 | Sub-Total:
-$2.30 | Value of Redeemed Reward Points:
$5.20 | FL TAX 7.0%:
$7.77 | Tip:
$4.00 | Delivery Area (Green Zone):
$84.92 | Total:
68 Reward Points earned:

Of course my subtotal is right, then why my taxes are 5.20 ?
Tax 70.25*0.07 = 4.9175

Let's imagine tax are on subtotal-points, i.e. 70.25-2.30=67.95
67.95*0.07=4.7565

Let's do that math the other way
5.20/0.07=74,285714286

I don't see any combination of 70.25+ ?? that gives me 74.28.

Points earned are ok since you get points on SubTotal-Points 70.25-2.30=67.95 rounded = 68.

Taxes should be calculated on the same amount, no ? so taxes should be (70,25-2,3)*0,07= 4.7565 and not 5.20.
If I try with delivery
(67,95+4)*0,07 = 5.0365
with tip
(67,95+7,77)*0,07 = 5.30

What I would line is point and taxes calculated on SubTot-RedeemedPoints cause there's no taxe on tips neither on delivery.
So my checkout should be
$70.25 | Sub-Total:
-$2.30 | Value of Redeemed Reward Points:
$4.76 | FL TAX 7.0%:
$7.77 | Tip:
$4.00 | Delivery Area (Green Zone):
$84.48 | Total:
68 Reward Points earned:

I'm lost.

15 Feb 2016, 12:16 AM
#149
hubert avatar

hubert

Zen Follower

Join Date:
Mar 2005
Posts:
229
Plugin Contributions:
0

Re: Reward Points Full Suite v2.5 (for ZC v1.5x) Support Thread

hubert:

Hello,

I had an old version installed on ZC 1.5.0, as I'm in the process of upgrading to 1.5.4, I've installed the 2.5e version.
I didn't do any deep testing but as far as I've been I have a calculation problem.

My checkout confirmation page shows me :
$70.25 | Sub-Total:
-$2.30 | Value of Redeemed Reward Points:
$5.20 | FL TAX 7.0%:
$7.77 | Tip:
$4.00 | Delivery Area (Green Zone):
$84.92 | Total:
68 Reward Points earned:

Of course my subtotal is right, then why my taxes are 5.20 ?
Tax 70.25*0.07 = 4.9175

Let's imagine tax are on subtotal-points, i.e. 70.25-2.30=67.95
67.95*0.07=4.7565

Let's do that math the other way
5.20/0.07=74,285714286

I don't see any combination of 70.25+ ?? that gives me 74.28.

Points earned are ok since you get points on SubTotal-Points 70.25-2.30=67.95 rounded = 68.

Taxes should be calculated on the same amount, no ? so taxes should be (70,25-2,3)*0,07= 4.7565 and not 5.20.
If I try with delivery
(67,95+4)*0,07 = 5.0365
with tip
(67,95+7,77)*0,07 = 5.30

What I would line is point and taxes calculated on SubTot-RedeemedPoints cause there's no taxe on tips neither on delivery.
So my checkout should be
$70.25 | Sub-Total:
-$2.30 | Value of Redeemed Reward Points:
$4.76 | FL TAX 7.0%:
$7.77 | Tip:
$4.00 | Delivery Area (Green Zone):
$84.48 | Total:
68 Reward Points earned:

I'm lost.

I'm answering myself, and first sorry guys, Reward Point was not the culprit. The thing is the tax class parameter of each shipping and order total module appearing in the invoice, in fact everything which is not to be included in tax calculation has to have its tax class to None.

Thanks myself

15 Feb 2016, 12:32 AM
#150
hubert avatar

hubert

Zen Follower

Join Date:
Mar 2005
Posts:
229
Plugin Contributions:
0

Re: Reward Points Full Suite v2.5 (for ZC v1.5x) Support Thread

Hello,

I've just notice a problem and I would like to know if it's my ZC 1.5.4 doing that or a general behavior.

Just login, build a cart then go to checkout and ask for reward points rebate, go till checkout confirmation but don't confirm, then go back to your cart and back to checkout.

On step 2, the Your frame show total with the reward points from your previous run, and then the reward points frame shows available points on this new Sub-Total. If you go to step 3, everything goes back to normal, i.e. the reward points are not over-calculated but in step 2 the infos given are wrong.

Let me give you the scenario,
-Run 1-
you buy $100, you have enough to get 20 % (the max) reward points rebate.
Checkout step 2 shows you that you're eligible to 20$ reward points rebate.
You ask for your rebate and go to step 3.
-Run 2-
On step 3 you don't confirm the order but instead you go back...say to a product page.
You go to checkout.
On checkout step 2 the Your total frame shows (Sub-Total) 100 - (Reward points) 20 (= 80)
The reward points frame show $ 16 rebate available (which is 20% of 80).


If you let the checkbox checked (I'm in automatic mode), on step three you get back to 100-20.
If you uncheck the box, you get 100 with no reward points at all.

Do you have the same behavior on your site ?

28 Mar 2016, 6:00 AM
#151
bettysbargainbin avatar

bettysbargainbin

New Zenner

Join Date:
Jun 2015
Location:
Arkansas
Posts:
5
Plugin Contributions:
0

Re: Reward Points Full Suite v2.5 (for ZC v1.5x) Support Thread

Stupid question.

Just installed the module and went through directions step by step. However when trying to do the "Switch on the 'Shopping Cart with Rewards' sidebox using Admin->Tools->Layout Box Controller. There is also a "Reward Points" sidebox which displays points in cart and points earned (if logged in)" this is not even showing up in the layout controller. I have tried changing to a different layout and then coming back, still nothing. I am using the template "responsive_classic" and even re-copied the entire template folder into it thinking that maybe something was missing.

Any suggestions?

Todd
ZenCart v1.5.5

Todd Patterson
Bettys Bargain Bin, LLC
ZenCart v1.5.5

12 Apr 2016, 2:18 PM
#152
mesnitu avatar

mesnitu

Totally Zenned

Join Date:
Aug 2014
Location:
Lisbon
Posts:
597
Plugin Contributions:
0

Re: Reward Points Full Suite v2.5 (for ZC v1.5x) Support Thread

solo_400:

I'm trying to upgrade from 2.5b to 2.5e and after running Upgrade-to-2.5e.sql I have the following error:

INSERT INTO configuration
(configuration_id ,configuration_title ,configuration_key ,configuration_value ,configuration_description ,configuration_group_id ,sort_order ,last_modified ,date_added ,use_function ,set_function)
VALUES (NULL , 'Show Reward Points on Product Info Display Page', 'SHOW_REWARD_POINTS_PRODUCT', '0', 'Display Reward Points on product info display page?<br />0= No<br />1= Yes', @cgi, '1', NULL, now(), NULL , 'zen_cfg_select_option(array(''0'', ''1''), ');

#1062 - Duplicate entry 'SHOW_REWARD_POINTS_PRODUCT' for key 'unq_config_key_zen'

What should I do now ?

I'm facing the same issue.
Upgraded fromzc 151 to 155. Uploaded the new files. Running the sql patch: BUM !

Have you work this out ?

“Though the problems of the world are increasingly complex, the solutions remain embarrassingly simple.” ― Bill Mollison

12 Apr 2016, 2:28 PM
#153
mesnitu avatar

mesnitu

Totally Zenned

Join Date:
Aug 2014
Location:
Lisbon
Posts:
597
Plugin Contributions:
0

Re: Reward Points Full Suite v2.5 (for ZC v1.5x) Support Thread

Looking into admin pages table and the update sql, they are equal, so I guess it should be fine.

“Though the problems of the world are increasingly complex, the solutions remain embarrassingly simple.” ― Bill Mollison

12 Apr 2016, 6:21 PM
#154
drbyte avatar

drbyte

Sensei

Join Date:
Jan 2004
Posts:
63,513
Plugin Contributions:
176

Re: Reward Points Full Suite v2.5 (for ZC v1.5x) Support Thread

#1062 - Duplicate entry 'SHOW_REWARD_POINTS_PRODUCT' for key 'unq_config_key_zen'That means that particular entry is already in your database.

.
Zen Cart - putting the dream of business ownership within reach of anyone!
Donate to: DrByte directly or to the Zen Cart team as a whole

Remember: Any code suggestions you see here are merely suggestions. You assume full responsibility for your use of any such suggestions, including any impact ANY alterations you make to your site may have on your PCI compliance.
Furthermore, any advice you see here about PCI matters is merely an opinion, and should not be relied upon as "official". Official PCI information should be obtained from the PCI Security Council directly or from one of their authorized Assessors.

13 Apr 2016, 8:17 AM
#155
mesnitu avatar

mesnitu

Totally Zenned

Join Date:
Aug 2014
Location:
Lisbon
Posts:
597
Plugin Contributions:
0

Re: Reward Points Full Suite v2.5 (for ZC v1.5x) Support Thread

Thanks
But this should be a upgrade... not a new install, so those entry's most certainly are there.
I did compare "manually" the upgrade sql and the already present entry and there's no changes. But one never know...

“Though the problems of the world are increasingly complex, the solutions remain embarrassingly simple.” ― Bill Mollison

25 Apr 2016, 5:13 AM
#156
darkflame808 avatar

darkflame808

New Zenner

Join Date:
Aug 2012
Posts:
4
Plugin Contributions:
0

Re: Reward Points Full Suite v2.5 (for ZC v1.5x) Support Thread

Hi there, is there a way to modify the code so that I could add reward another user for when a purchase is made? Even if I have to manually add the user to a new table I can do that. I was thinking it would be something like create a new table called rewardID and add the name or customer number that is associated to that account and when userA makes a purchase, userB gets the reward. Sorta like the referral plugin but I like this one better because I don't have to worry about cookies expiring to or getting cleaned out.

Thanks!

20 May 2016, 2:36 PM
#157
gigi3 avatar

gigi3

New Zenner

Join Date:
Oct 2015
Location:
BC, Canada
Posts:
41
Plugin Contributions:
0

Re: Reward Points Full Suite v2.5 (for ZC v1.5x) Support Thread

Hi guys,

Quick question (and hopefully a quick, easy answer).

I use edit_orders.php and I'd like to have the customer's points total show on the edit_orders.php file. Is there a way to get this done?

TIA!

23 May 2016, 8:06 PM
#158
gigi3 avatar

gigi3

New Zenner

Join Date:
Oct 2015
Location:
BC, Canada
Posts:
41
Plugin Contributions:
0

Re: Reward Points Full Suite v2.5 (for ZC v1.5x) Support Thread

No one? Maybe I need to be more specific. I don't simply want the reward points earned for that one order to show, I want the total reward points the customer has to show.

What would be super great, would be to have the following box that shows up in the checkout process to show in Edit Orders.

Attachment 16345

But, I would definitely settle for a simple snip that pulls the customers total Reward Points Earned to date.

Anyone at all?

23 May 2016, 8:20 PM
#159
lat9 avatar

lat9

Administrator

Join Date:
Sep 2009
Location:
Stuart, FL
Posts:
14,110
Plugin Contributions:
56

Re: Reward Points Full Suite v2.5 (for ZC v1.5x) Support Thread

@gigi3, I haven't had need to look at the Reward Points plugin's file-structure so I don't know what it will take to "integrate" with Edit Orders.

If the plugin is created as a true order-total module (that is, it makes its decisions based on the ***order ***rather than the storefront shopping-cart and/or customer session), then it should "just work" with EO.

23 May 2016, 8:31 PM
#160
gigi3 avatar

gigi3

New Zenner

Join Date:
Oct 2015
Location:
BC, Canada
Posts:
41
Plugin Contributions:
0

Re: Reward Points Full Suite v2.5 (for ZC v1.5x) Support Thread

Hi lat9,

Thanks so much for the quick response. The developer did integrate it with EO on several fronts, but I seem to be struggling with getting them to work. The earned points and redeem points functions are listed in the drop down along with the coupons, shipping etc.....and they will show up on the order when added, but the totals are not affected, at all.

My request for having a customer's point total showing in the edit orders screen is an add on that I would like.

Things are a little more complicated for me because I use ZC, for the most part, to function as a POS script by using both Edit Orders, and Admin New Order. We do take orders online, and that is fuctioning fine.