Rewards points

Forum Forums General Support Rewards points

Viewing 3 posts - 1 through 3 (of 3 total)
  • Author
    Posts
  • #58752
    yaykenny
    Participant

      Hi Olly,

      Rewards system is working really well. We had an old points system before we became a delivery service and I was hoping to manually add the points from that onto the new system. I had thought I could just edit the customer record and add the points manually but I don’t see any way to do that. Is there an field these points are stored where I could maybe use phpmyadmin at the backend and manually add them that way?

      Thanks

      #58782
      Olly
      Admin & Mod

        the relevant data is in the [your_table_prefix]_usermeta table stored with a meta key of wppizza_rewards_x (where ‘x’ is your blogid – typically 1 if it’s not a multisite setup) associated to the user id .
        it’s a serialized array

        that will look *something like* this – depending on your settings:

        (
            [points] => Array
                (
                    [first_order] => Array
                        (
                            [timestamp] => 1643293592
                            [points_expire] => 1674829592
                            [value_per_point] => 0.01
                            [points_total] => 250
                            [points_value] => 2.5
                            [points_redeemed] => Array
                                (
                                )
        
                            [points_unredeemed] => 250
                            [points_value_unredeemed] => 2.5
                            [settings] => Array
                                (
                                    [points_type] => cart_subtotal
                                    [points_per_unit] => 1
                                    [points_per_unit_pickup] => 0
                                    [points_rounding] => natural
                                    [value_per_point] => 0.01
                                    [award_points_user_registration] => 125
                                    [award_points_first_order] => 250
                                    [points_expire_days] => 365
                                )
        
                        )
        
                    [order_7] => Array
                        (
                            [timestamp] => 1643293592
                            [points_expire] => 1674829592
                            [value_per_point] => 0.01
        ............. more data ................
        
        

        i suppose you could amend the point total and related (points (un)redeemed, (un)redeemed value etc ) for the “first_order” array but I would strongly advise you to make a backup first before doing anything there – it’s entirely at your own risk editing this. This thing is not really that trivial

        #58811
        yaykenny
        Participant

          Perfect, thanks Olly

        Viewing 3 posts - 1 through 3 (of 3 total)
        • The topic ‘Rewards points’ is closed to new replies.