FunnyBunnyHelena Posted August 4, 2010 Share Posted August 4, 2010 Hello!I use Prestashop, latest version.I had a few test customers in the shop. I deleted them and it looks good on the Customers page in back office.But elsewhere the customers are still lingering there. For example when I make vouchers the customer is still there in the roll down menu.And if I make newsletter csv file based on customer data the "deleted" ones still show up.What may be causing this issue?Thank you for reading! Link to comment Share on other sites More sharing options...
FunnyBunnyHelena Posted August 4, 2010 Author Share Posted August 4, 2010 Also when I am trying to register again with same email address as the deleted one it won't let me to register.So it is definitely still there, despite not showing up in the customers list.I could visit the database and remove the entries, but it is not a good solution. It is better to solve this issue of not deleting properly.Thanks for reading! (can't wait to open the shop to the masses) Link to comment Share on other sites More sharing options...
olea Posted August 4, 2010 Share Posted August 4, 2010 Yes, this is normal : a customer is never really deleted from database. Even deleted, some info for him are still needed to track orders he may have passed.you have to look for a module that clean up the database. Search here on the forum or on prestatools Link to comment Share on other sites More sharing options...
FunnyBunnyHelena Posted August 4, 2010 Author Share Posted August 4, 2010 Oh. I think it is bad really... I do not see why it should be like this? Still sending newsletter to a deleted customer? Etc.Thank you for informing me.I will try to look around for the tool.EDIT: The PrestaTools site (I googled) seems to be in French and I can't read French.. haha! I will try to search this forum. If you have suggestions I would be very thankful. Link to comment Share on other sites More sharing options...
ngruy Posted August 9, 2010 Share Posted August 9, 2010 You find a solution to this? Thank you! Link to comment Share on other sites More sharing options...
gdinari Posted August 10, 2010 Share Posted August 10, 2010 A sure way to remove a customer from your records would be to delete them from the database. In order to do this you would have to log into your hosting account and access you database and looking in the "ps_customers" tab and delete. NOTE: Please backup your store database (within Admin section > Tools > DB Backup) before deleting/changing anything just in case something bad happens.gdinari Link to comment Share on other sites More sharing options...
FunnyBunnyHelena Posted August 10, 2010 Author Share Posted August 10, 2010 Yes, I did that. Thanks anyway. Link to comment Share on other sites More sharing options...
MrMcQ Posted November 10, 2010 Share Posted November 10, 2010 I'm actually having this same problem...only when a user tries to re-register using the same email (even AFTER I delete them from the database) gets the error 'another user is already using that email'. I've tried clearing the cache (smarty), their browser cache, nothing seems to work! Any ideas? Link to comment Share on other sites More sharing options...
FunnyBunnyHelena Posted November 10, 2010 Author Share Posted November 10, 2010 That's bad really, if it still lingers even after the database delete....I still do not really understand why they did like this. "false" delete. Then it is better to remove the delete button altogether if it is not really working like this. Or rename it to "hide from this list" because that's what it does. Link to comment Share on other sites More sharing options...
MrMcQ Posted November 10, 2010 Share Posted November 10, 2010 In a big way, it makes sense why it would be wise to leave the information present, as brought up in this thread. On the other hand, there is nothing to identify a user's email as re-enabled if they want to subscribe again. In this case, they have no choice but to enter a different email address. This should be worked into the table structure in some way. Link to comment Share on other sites More sharing options...
archproject Posted November 25, 2010 Share Posted November 25, 2010 The way prestashop is designed is that they don't really delete those that are deleted I deleted a carrier in BO and created another one which changed the Carrier ID by an increment of 1 after the last carrier ID ... so I went into the database and looked the carrier was still there. .... prestashop team made prestashop this way I hate it ... it will make my database more bigger than it needs . means more cost in the backup storages. I wish the prestashop team would look into this ... maybe create a Recyclebin table where it can be flushed with a button in BO ... Link to comment Share on other sites More sharing options...
phar Posted April 8, 2011 Share Posted April 8, 2011 Hi guys.I'm trying to use the customers newsletter list, generated from customer datas modules>newsletter>cust, and i find in the csv list all deleted customers (deleted from BO).In ps_customer table, there are a lot of flags (1/0 values):newsletteractivedeletedAll "active" are setted to 1, all "deleted" (BO deletion) to 1, What really means "active"? How to set "active" to 0 or when is it setted to 0? Manually only (by fingers)?Regards.(PS 1.3.3.0) Link to comment Share on other sites More sharing options...
Recommended Posts
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 accountSign in
Already have an account? Sign in here.
Sign In Now