Page 248 of 248 FirstFirst ... 148198238246247248
Results 2,471 to 2,475 of 2475
  1. #2471
    Join Date
    Jan 2007
    Location
    Los Angeles, California, United States
    Posts
    10,023
    Plugin Contributions
    32

    Default Re: ReReward Points Module does not update with paypal

    Two points..
    1. All those "tep_db_*" functions are OS Commerce functions.. (as is this code..) I hope you are aware that you can't just drop this into the Zen Cart module..
    2. If the issue you are having is with PayPal Standard, disable it, and activate PayPal Express, and see if the issue persists..
    My Site - Zen Cart & WordPress integration specialist
    I don't answer support questions via PM. Post add-on support questions in the support thread. The question & the answer will benefit others with similar issues.

  2. #2472
    Join Date
    Jul 2010
    Location
    L'Aquila
    Posts
    113
    Plugin Contributions
    1

    Default Reward Points Module does not update with paypal

    Thanks for the answer, but I had asked if there was a solution for zen cart, and or adapt the query to the DB zen, and I will not turn paypal express. Thank you

  3. #2473
    Join Date
    Jan 2007
    Location
    Los Angeles, California, United States
    Posts
    10,023
    Plugin Contributions
    32

    Default Re: Reward Points Module does not update with paypal

    Quote Originally Posted by giancalr View Post
    Thanks for the answer, but I had asked if there was a solution for zen cart, and or adapt the query to the DB zen, and I will not turn paypal express. Thank you
    Right.. so let me put it another way.. Outside of Rewards Points, the PayPal Standard module has ISSUES in general.. and the recommended solution for all of those issues is to NOT use PayPal Standard ever, and use PayPal Express module.. So, it is possible that your issue will go away if you simply turn on the PayPal Express module.. If you choose not to that is certainly your choice.. but you should know the issue you report is not a known issue with Rewards Points, which leads me to believe that the issue could be resolved by simply using PayPal Express vs PayPal Standard..

    As for the code you posted, if a community member knows how to convert that osCommerce code, hopefully they will share their solution.. otherwise you could look for a developer to help you with that..

    Happy Zenning..
    Last edited by DivaVocals; 9 Mar 2015 at 02:04 PM.
    My Site - Zen Cart & WordPress integration specialist
    I don't answer support questions via PM. Post add-on support questions in the support thread. The question & the answer will benefit others with similar issues.

  4. #2474
    Join Date
    Sep 2012
    Posts
    254
    Plugin Contributions
    0

    Default Re: Reward Points Module does not update with paypal

    I have a question on customization. Not confident enough to through this up on a live site. Unfortunately we are in a slow move from one server to the next. But with free migration I can't complain.
    Anyways I want to not write points to the table_reward_customer_points if the email address contains a certain domain. I'm pretty sure I would change the catalog/includes/functions/extra_functions/reward_points_functions.php file. Specifically
    Code:
    function UpdateCustomerRewardPoints($customer_id,$reward_points,$pending_points)
    {
    	global $db;
    
    	$sql="INSERT INTO ".TABLE_REWARD_CUSTOMER_POINTS." VALUES ('".$customer_id."', '".$reward_points."', '".$pending_points."') ON DUPLICATE KEY UPDATE reward_points=reward_points+".$reward_points.", pending_points=pending_points+".$pending_points.";";
    	$db->Execute($sql);
    }
    I'm thinking something like
    Code:
    function UpdateCustomerRewardPoints($customer_id,$reward_points,$pending_points)
    {
    	global $db;
           if (strpos($order->info['customer_email_address'],'@domain.com') == false) {
        $sql="INSERT INTO ".TABLE_REWARD_CUSTOMER_POINTS." VALUES ('".$customer_id."', '".$reward_points."', '".$pending_points."') ON DUPLICATE KEY UPDATE reward_points=reward_points+".$reward_points.", pending_points=pending_points+".$pending_points.";";
    	$db->Execute($sql);
    }	
    }
    Can someone verify my logic here and let me know if I'm on the right track? Is the variable "$order->info['customer_email_address']" even available at this point? Thank you.

  5. #2475
    Join Date
    Jan 2007
    Location
    Los Angeles, California, United States
    Posts
    10,023
    Plugin Contributions
    32

    Default Re: Reward Points Module does not update with paypal

    Quote Originally Posted by southshorepizza View Post
    I have a question on customization. Not confident enough to through this up on a live site. Unfortunately we are in a slow move from one server to the next. But with free migration I can't complain.
    Anyways I want to not write points to the table_reward_customer_points if the email address contains a certain domain. I'm pretty sure I would change the catalog/includes/functions/extra_functions/reward_points_functions.php file. Specifically
    Code:
    function UpdateCustomerRewardPoints($customer_id,$reward_points,$pending_points)
    {
        global $db;
    
        $sql="INSERT INTO ".TABLE_REWARD_CUSTOMER_POINTS." VALUES ('".$customer_id."', '".$reward_points."', '".$pending_points."') ON DUPLICATE KEY UPDATE reward_points=reward_points+".$reward_points.", pending_points=pending_points+".$pending_points.";";
        $db->Execute($sql);
    }
    I'm thinking something like
    Code:
    function UpdateCustomerRewardPoints($customer_id,$reward_points,$pending_points)
    {
        global $db;
           if (strpos($order->info['customer_email_address'],'@domain.com') == false) {
        $sql="INSERT INTO ".TABLE_REWARD_CUSTOMER_POINTS." VALUES ('".$customer_id."', '".$reward_points."', '".$pending_points."') ON DUPLICATE KEY UPDATE reward_points=reward_points+".$reward_points.", pending_points=pending_points+".$pending_points.";";
        $db->Execute($sql);
    }    
    }
    Can someone verify my logic here and let me know if I'm on the right track? Is the variable "$order->info['customer_email_address']" even available at this point? Thank you.
    I don't have an answer as much as a suggestion which has helped me get answers to things.. Create a clone of your live site to use as your test bed.. That way you can test your code and if it works, you share.. and if it doesn't, then you can say, "this is what I tried".. "this is the result"..
    My Site - Zen Cart & WordPress integration specialist
    I don't answer support questions via PM. Post add-on support questions in the support thread. The question & the answer will benefit others with similar issues.

 

 

Similar Threads

  1. v139h Reward Points module display order totals including reward points
    By irsarahbean in forum All Other Contributions/Addons
    Replies: 0
    Last Post: 23 Jun 2013, 01:19 AM
  2. Reward points module : 0 points earned
    By jonnyboy22 in forum Addon Payment Modules
    Replies: 5
    Last Post: 5 Jun 2012, 09:52 AM
  3. Reward Points module- points not calculated correctly
    By cpoet in forum All Other Contributions/Addons
    Replies: 0
    Last Post: 9 Sep 2010, 05:02 PM
  4. Reward Points Module - Hide message when 0 points offered
    By expresso in forum All Other Contributions/Addons
    Replies: 0
    Last Post: 11 Dec 2008, 06:58 PM
  5. Experimental Reward Points Module
    By precursor999 in forum Addon Payment Modules
    Replies: 7
    Last Post: 2 Apr 2007, 09:32 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
disjunctive-egg
Zen-Cart, Internet Selling Services, Klamath Falls, OR