newsletter

[Guest fergz2005]

hey is is possible to see who is signed up to newsletters ?

[Guest EverythingWeb]

Hello,

Presumably you mean customers which have ticked the box to received updates from the Store Owner?

If so, there is an option to "Download" the list, which actually puts the list into a Text File for you.

Administration Panel >> Under the heading "Customers" there is an "Email Customers" link.

Then there are two options - one (on th left) is to download the customers, and you can choose whether to include the name of the customer, and the other option (on the right) is to send an email.

[Guest fergz2005]

Thanks see it now - do you where in the database this stored so i can make a page in admin for it to displlay them.

thanks

[Guest EverythingWeb]

Hi,

The details are stored in the CubeCart_customer table.

The column you want to be querying for wants to be 'optIn1st' and the value 1=On/0=Off.

SELECT * FROM ".$glob['dbprefix']."CubeCart_customer WHERE customer_id = %s AND type = 1 AND optIn1st =1

should work.

(untested code).

Cheers

[Guest EverythingWeb]

Just done another bit of quick digging, and the Type columns is set like follows:

0 = When someone uses the "Join Newsletter" option - Not a full customer account

1 = Full Customer Account created at Cart or Registration Stage.

So you may want to modify that code/page, so you can select customers that are signed upto the newsletter:

SELECT * FROM ".$glob['dbprefix']."CubeCart_customer WHERE customer_id = %s AND type = 1 AND optIn1st =1

Or, just regular visitors who are signed up:

SELECT * FROM ".$glob['dbprefix']."CubeCart_customer WHERE customer_id = %s AND type = 0 AND optIn1st =1

Or, Both Customers & Users who are signed up:

SELECT * FROM ".$glob['dbprefix']."CubeCart_customer WHERE customer_id = %s AND optIn1st =1

Hope this helps.

[Guest fergz2005]

thanks for your help i will start messing about it now.

Thanks

Stuart

[Guest EverythingWeb]

Okay, if you get stuck, let me know. Shouldn't take long to get something sorted.

:(

[Guest fergz2005]

thanks i manged to get some kind of system but can you help me with a way to add/remove customers using admin edit customer link.

thanks

[Guest EverythingWeb]

Hello,

If you could explain in details what you are wanting to achieve, this will help work out what is required of the system.

Thanks,

[Guest fergz2005]

the page like this.

Please edit this customer below:

Title

First Name:

Last Name:

Email:

Address:

Town:

County/State:

Postcode:

Country:

Phone:

news?

Edit Customer

- want to add news under phone - and accross from that to make a drop down list saying subcribed or unsubcribed and if admin was to change it, it would either subcribe then or unsubcribe them = hope this is better.

thanks