Como eliminar masivamente usuarios registrados fraudulentos en PrestaShop
How to Remove Fraudulent Customers from PrestaShop Database
Introduction to the Issue
- Enrique from Factoría Digital explains the problem of fraudulent customers in PrestaShop, where URLs are incorrectly entered as last names.
- These fraudulent entries can number between 400 to 1000, complicating newsletter sending and customer management.
Steps to Eliminate Fraudulent Entries
- Access phpMyAdmin for database management; use the search function with "www" as a common identifier for these fraudulent last names.
- Focus on the
ps_customertable where these records are stored. Search within the 'name' column for entries containing "www".
Reviewing and Deleting Records
- After finding 119 matches, examine them carefully to ensure they belong to fraudulent accounts before proceeding.
- Select all identified records and confirm deletion. The process may show results in batches of 50, allowing for thorough review.
Finalizing Deletion Process