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.