Ahmed AlShami Posted March 15, 2017 Share Posted March 15, 2017 Hello, I want to restore the data of our newsletter subscribers! Dose anyone where the data of the subscribers is stored in the database so we can restore that table? Link to comment Share on other sites More sharing options...
rocky Posted March 16, 2017 Share Posted March 16, 2017 The newsletter data is stored in the ps_customer table, so if you've backed up your customers, you should have backed up the newsletter information too. There is the newsletter field that has 1 if they are subscribed, the ip_registration_newsletter field and the newsletter_date_add field. Link to comment Share on other sites More sharing options...
Ahmed AlShami Posted March 16, 2017 Author Share Posted March 16, 2017 The newsletter data is stored in the ps_customer table, so if you've backed up your customers, you should have backed up the newsletter information too. There is the newsletter field that has 1 if they are subscribed, the ip_registration_newsletter field and the newsletter_date_add field. Hello Rocky, Thanks for answering but I have a question. Can I only restore the customers who only subscribed throw the newsletter block and not all the customer who already registered to my website? Link to comment Share on other sites More sharing options...
rocky Posted March 17, 2017 Share Posted March 17, 2017 Unfortunately, you cannot. There is no way to distinguish between customers who entered their email in the newsletter block and those who clicked the newsletter checkbox when signing up. Both methods end up with the newsletter column changing to 1 for the customer. 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