Jump to content

Clean the table ps_loyalty


Recommended Posts

Good morning

in my shop I have been active for years:


Price and Promotions

Customer loyalty and prize v1.2.9 - from PrestaShop


After years the accumulated loyalty points are so many and the user to see the last has to scroll through the pages. I would like to delete the old ones and see that they are written in the table:




Do I make a mistake if I delete records from the past? Does anyone have experience?


Thank you

Share this post

Link to post
Share on other sites

I've never actually used the loyalty module before, and I do not believe it is a supported module anymore.


However looking at the module code, I believe the module does a sum of all the records for the given customer in that table.  So if you remove all the old ones, then it will effect how many points the customer has.  You can also change the module so that it does not show all of the points.


Perhaps instead you can show the points from the last 6 months, and then show a sum of all the points older than 6 months.

Share this post

Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

  • Create New...

Important Information

Cookies ensure the smooth running of our services. Using these, you accept the use of cookies. Learn More