WPPizza – A Restaurant Plugin for WordPress › Support › General Support › Rewards points
- AuthorPosts
- 25 January, 2022 at 6:48 pm #58752
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
27 January, 2022 at 7:00 pm #58782the 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 arraythat 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
31 January, 2022 at 2:19 pm #58811Perfect, thanks Olly
- AuthorPosts
- The topic ‘Rewards points’ is closed to new replies.