# How to reset lead/s points

**URL:** <https://forum.mautic.org/t/how-to-reset-lead-s-points/2677>\
**Category:** Product Support\
**Created:** [November 1, 2015, 11:41am UTC](https://forum.mautic.org/t/how-to-reset-lead-s-points/2677 "2015-11-01T11:41:56Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![rangeva](https://avatars.discourse-cdn.com/v4/letter/r/858c86/32.png) [@rangeva](https://forum.mautic.org/u/rangeva)\
**Post date:** [November 1, 2015, 11:41am UTC](https://forum.mautic.org/t/how-to-reset-lead-s-points/2677/1 "2015-11-01T11:41:56Z")

</div>

I want to be able to reset a lead point or all leads points altogether - any way of doing so?  
  
If not from the UI from the DB?  
  
  
  
Thanks

---

<div class="post-metadata">

**Author:** ![rangeva](https://avatars.discourse-cdn.com/v4/letter/r/858c86/32.png) [@rangeva](https://forum.mautic.org/u/rangeva)\
**Post date:** [November 1, 2015, 11:41am UTC](https://forum.mautic.org/t/how-to-reset-lead-s-points/2677/2 "2015-11-01T11:41:56Z")

</div>

I want to be able to reset a lead point or all leads points altogether - any way of doing so?  
If not from the UI from the DB?

Thanks

---

<div class="post-metadata">

**Author:** ![escopecz](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.mautic.org/escopecz/32/370_2.png) [@escopecz](https://forum.mautic.org/u/escopecz)\
**Post date:** [November 2, 2015, 10:46am UTC](https://forum.mautic.org/t/how-to-reset-lead-s-points/2677/3 "2015-11-02T10:46:06Z")

</div>

There is no UI right now, but this feature request is similar to what you want:

[https://github.com/mautic/mautic/issues/967](https://github.com/mautic/mautic/issues/967)

You can comment on it.

To delete user points from database, make a backup first(!), then truncate the [PREFIX]lead\_points\_change\_log table, clear points column in the [PREFIX]leads table. I didn’t test this, just looking into my database.

---

<div class="post-metadata">

**Author:** ![mellsaid](https://avatars.discourse-cdn.com/v4/letter/m/a8b319/32.png) [@mellsaid](https://forum.mautic.org/u/mellsaid)\
**Post date:** [January 13, 2017, 4:42pm UTC](https://forum.mautic.org/t/how-to-reset-lead-s-points/2677/4 "2017-01-13T16:42:02Z")

</div>

[quote=4478:@escopecz]

To delete user points from database, make a backup first(!), then truncate the [PREFIX]lead\_points\_change\_log table, clear points column in the [PREFIX]leads table. I didn’t test this, just looking into my database.[/quote]

Hi @escopecz - We need to do that at the moment. We tried editing the records in that table, however that didn’t change the points stored on the user account. Is there other fields that may need changing. ? We waited for the cron task to run perhaps it does a recount, however the lead points total was still the same. we edited the time stamp to make it recent in case the cron checks the time stamp, but no luck.

Appreciate your input on this.

---

<div class="post-metadata">

**Author:** ![silavapi](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.mautic.org/silavapi/32/7424_2.png) [@silavapi](https://forum.mautic.org/u/silavapi)\
**Post date:** [February 2, 2020, 10:57pm UTC](https://forum.mautic.org/t/how-to-reset-lead-s-points/2677/5 "2020-02-02T22:57:26Z")

</div>