Your Cart

Shopping Cart Items: 0   Sub-Total : $0.00    View Cart    Checkout
Welcome, Guest ( Customer Panel | Login )


Home | Profile | Register | Active Topics | Members | Search | FAQ


Forgot your Password?
 All Forums
 VPCart Forum
 VP-ASP 7.0 Questions
 Where is my mailing list?		  New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

ahineman
Starting Member

USA
19 Posts
Posted - March 09 2011 :  22:13:37  Show Profile  Reply with Quote
When a person registers they can check 'Join our mailing List.' Where can i find this list in the admin pages? How can I export it to excel?

jhoiland
Starting Member

36 Posts
Posted - March 10 2011 :  16:35:35  Show Profile  Reply with Quote
Hello,

You can pull this information directly from the database or you can do it easily in your cart admin as follows:

Login to admin and click on the Misc tab

Click on Query and Export

Select Table Newsletter and All fields

Click on Generate Query

For most queries you can also enter criteria...but this one struggles with the true false field datatype. You can either filter those that have opted out/unsubscribed in Excel or you can modify the query like this:
select * from newsletter where nletterauthorized = -1


The value for true will depend upon what database you are using...try -1 1 and 0 until you find the true subscribers.

Run Query or Export

You can also save it so you don't have to repeat all the steps next time around.

Best Regards,

JH
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
Snitz Forums 2000
0 Item(s)
$0.00
  • Your Cart Is Empty