Need list of customers only in specific state

[dcfxking]

Hey all,

I need to pull the email addresses for customers in a few specific states as we have a promotion that we want to inform them about that is only available ina few states. This is not something I have to do often so I dont mind running a query in phpMyAdmin. I am not too familiar with SQL and did notice that the customers email address is in one table (zen_customers) while their email address is in (zen_address_book).

Has anyone done this before and can anyone help me with the syntax or know if a way this can be done within the zencart admin? We do have the newsletter export mod so we can export all our customers but I do not belive there is a way to filter by states.

I have been playing with it but cant get it to work. I had something like this but it keeps pulling every cusomer not just the ones in the states I want:

SELECT `customers_email_address` FROM `zen_customers`, zen_address_book WHERE `entry_state` = "MA" or "NH" or "RI" or "ME" or "VT"

[elastic]

hi dcfxking.... try this. i got this to work on my db. you just have some quotes around things you don't need:

SELECT `customers_email_address`
FROM zen_customers, zen_address_book
WHERE entry_state = "MA"
OR "NH"
OR "RI"
OR "ME"
OR "VT"
LIMIT 0 , 30

[dcfxking]

Thanks Elastic,

That query runs but it doesnt filter out only customers in those states, it actually lists the email address for every single customer still.

[DrByte]

Zen Cart doesn't store a state name if the customer's address fits within a defined zone. Instead, it stores the zone number in entry_zone.
You could do a join on the zones table to match up with the state codes you desire.

[dcfxking]

Zen Cart doesn't store a state name if the customer's address fits within a defined zone. Instead, it stores the zone number in entry_zone.
You could do a join on the zones table to match up with the state codes you desire.

Thans that makes sense why nothing I was trying as working. Can you explain the ones a little more? Is there a zone # for each state? If I go into my customers section in admin and open up a customer it does have a state...where is this data stored?

Can you give an example of how that query would look in order to grab customers mail addresses only if they are in a certain group of states?