deleted customer

This topic was automatically closed 365 days after the last reply. New replies are no longer allowed.
1 anno tempo fa
Hello,

I've deleted a customer, but need a new registration with the new email address. I read about the suffix to fix this problem, but that doesn't fix the problem with the customer I've already deleted. Can I get the account back somehow or have another way to use the email adress?
1 anno tempo fa
Hi,

Please check this post might be it can help to you
https://www.nopcommerce.com/en/boards/topic/63631/recover-deleted-customers
1 anno tempo fa
As in nopCommerce
if you delete customer from the admin side it , can deleted set 1 ,
so it will not display into backed , but in database it is exist ,

to restore that record , you need to update from the database
update Customer
set deleted=0
where Id=your id

if you want to register with same email id , then you can delete that record from the DB
so it can allow to register
1 anno tempo fa
It's not typically 'safe' for truly DELETE the record from the DB. (Because the Customer Id may be referenced by other tables.)

As per above, if you want to use the same record, then
update Customer
set deleted=0
where Id=your id

Otherwise if you want  to create a new Customer, then use the 'Suffix' that you mention, so that the email won't conflict (duplicate) the new record  - i.e.
update Customer
set email = email + 'DELETED'
where Id=your id
This topic was automatically closed 365 days after the last reply. New replies are no longer allowed.