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

[SpottyCupcakes]

Thank you so much Paul3648. I had only changed the one instance. Seems to be working now.

[mesnitu]

Well, probably it's the way it works.... but for i.e:

A 8.5 order gives 85 points. Ok.
Lets say that the customers redeems 100 points.
But on checkout_confirmation page:

Sub-Total: 8,50€
Shipping : 1,50€
-1,00€ ( the amount for 100 points ):
Total: 9,00€

And the customers gets 75 reward points.

So, I thought that the customers would use his points, and receive the actual 85 points. But it's subtracting 10 points from the 85 ( so the points that the customers used for this purchase. )

But maybe this is explain in some older threads... I haven't check.

Another thing, that it's happening and I think it's confused, it's even if I clear the basket, and add some other product, on checkout_payment
the 100 points (for this example the last 100 reward points used ) are still there. And I think, that when clearing the basket , all that info should be clear too. ( I think )..... or maybe not.

[chibipaw]

Are you using it in advanced mode?
I've played with it and didnt have issues with circular points since the customers only get pending points, not earned points until I manually change their products to the "delivered" status.

[paul3648]

A 8.5 order gives 85 points. Ok.
Lets say that the customers redeems 100 points.
But on checkout_confirmation page:

Sub-Total: 8,50€
Shipping : 1,50€
-1,00€ ( the amount for 100 points ):
Total: 9,00€

And the customers gets 75 reward points.

He's getting 75 points because he's actually paying 7,50€. I think this is correct.

Another thing, that it's happening and I think it's confused, it's even if I clear the basket, and add some other product, on checkout_payment
the 100 points (for this example the last 100 reward points used ) are still there. And I think, that when clearing the basket , all that info should be clear too. ( I think )..... or maybe not.

I think this is also correct, because the customer has already indicated he wants to redeem the points, so they are automatically selected in the same session.

[mesnitu]

There's another issue that I can't reproduce at xampp with PHP Version: 5.6.15 (Zend: 2.6.0) , and the online server with PHP Version: 5.6.28 (Zend: 2.6.0)

But if no advance Advanced Reward Point Calculation Rules are set , no modules are set there, it returns

[18-Nov-2016 10:40:29 Europe/Lisbon] PHP Warning:  Invalid argument supplied for foreach() in /home/public/includes/functions/extra_functions/reward_points_functions.php on line 314

function GetRewardPointAdvancedCalculateValue()
{
    $value=0;
    
    $module_list=GetRewardPointAdvancedCalculateTable();

        foreach($module_list as $module)
     if($module['action']=="Subtract")
      $value-=GetOrderTotalValue($module['module']);
     else
      $value+=GetOrderTotalValue($module['module']);
          
    return $value;
} 

Looks like surrounding this foreach to loop only if there are odules to calculate , solves the warnings.

function GetRewardPointAdvancedCalculateValue()
{
    $value=0;
    
    $module_list=GetRewardPointAdvancedCalculateTable();
    
     if (!empty($module_list)) {
     
        foreach($module_list as $module)
     if($module['action']=="Subtract")
      $value-=GetOrderTotalValue($module['module']);
     else
      $value+=GetOrderTotalValue($module['module']);
    }
      
    return $value;
} 

But, again, I can't reproduce on xampp...probably the php version.

[jmsnyder23]

I just installed this mod and it's working well EXCEPT that order notification emails aren't being sent out. I don't get a copy as the store admin and the customer isn't getting a copy, either.

What could've made this happen?

[jmsnyder23]

Hi again,

I've got this error:

[25-May-2015 15:22:01] PHP Fatal error:  1064:You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '2') 
				OR (p.products_id=p2c.products_id AND prp.scope_id=p2c.categories_id A' at line 3 :: SELECT prp.point_ratio*p.products_price AS reward_points, prp.point_ratio, p.products_price, p.products_priced_by_attribute 
				FROM reward_master prp, products p, products_to_categories p2c
				WHERE p.products_id='101'"'
				AND p2c.products_id='101'"'
				AND ((prp.scope_id=p.products_id AND prp.scope='2') 
				OR (p.products_id=p2c.products_id AND prp.scope_id=p2c.categories_id AND prp.scope='1')
				OR (prp.scope='0'))
				ORDER BY prp.scope DESC LIMIT 1; ==> (as called by) /var/www/vhosts/.../httpdocs/includes/functions/extra_functions/reward_points_functions.php on line 62 <== in /var/www/vhosts/.../httpdocs/includes/classes/db/mysql/query_factory.php on line 155

Check the file but it seem all fine... the line 51 to 62 of reward_points_functions.php look like this:

if(zen_get_products_price_is_free($products_id)==false || REWARD_POINTS_ALLOW_ON_FREE=='1') // Allow RP on free items (Admin settable)
    {
        $sql = "SELECT prp.point_ratio*p.products_price AS reward_points, prp.point_ratio, p.products_price, p.products_priced_by_attribute 
                FROM ".TABLE_REWARD_MASTER." prp, ".TABLE_PRODUCTS." p, ".TABLE_PRODUCTS_TO_CATEGORIES." p2c 
                WHERE p.products_id='" . $products_id . "'
                AND p2c.products_id='" . $products_id . "'
                AND ((prp.scope_id=p.products_id AND prp.scope='".SCOPE_PRODUCT."') 
                OR (p.products_id=p2c.products_id AND prp.scope_id=p2c.categories_id AND prp.scope='".SCOPE_CATEGORY."')
                OR (prp.scope='".SCOPE_GLOBAL."'))
                ORDER BY prp.scope DESC LIMIT 1;";

        $result=$db->Execute($sql); 

The specific of the server are:
Database: MySQL 5.1.73
Versione PHP: 5.3.3 (Zend: 2.3.0) PHP Memory Limit: 128M

I'm a little bit unsure of what that error could be... any guess would be helpful

I have this same error on a new installation of the Reward Points plugin.

Any reason why this appears?

[rbarbour]

Can't seem to get this to work the way I want it to :-(

Item cost $8.00
Reward Points should be 8

Each Reward point should have CASH VALUE of $0.10

Pending Value is CORRECT $0.80

But Available is 0%

What am I doing incorrect?

[jmsnyder23]

The points are PENDING until you approve them. You can set it up to approve them automatically, but the only way I managed to do that is by changing the Sunrise Period to 1 instead of 0.

In admin, go to Configuration / Reward Point Configuration. Look for "Reward Point Sunrise Period" and set this to 1.

All pending points will move to EARNED after 24 hours.

You can see the pending points by going to Customers / Reward Points and sorting by Points Pending.

Hope this helps!

[rbarbour]

Thanks, but doesn't make a difference.

I'll just hack it to make it work the way I want it too!

The points are PENDING until you approve them. You can set it up to approve them automatically, but the only way I managed to do that is by changing the Sunrise Period to 1 instead of 0.

In admin, go to Configuration / Reward Point Configuration. Look for "Reward Point Sunrise Period" and set this to 1.

All pending points will move to EARNED after 24 hours.

You can see the pending points by going to Customers / Reward Points and sorting by Points Pending.

Hope this helps!