Adding additional fields to Customer records?

[Ovaltine]

I would like to add a one-of-n field to a customer's record to differentiate different types of customers so I can send different, targeted newsletters to each customer type.

Ideally I'd do this with the help of an add-on module, and then be able to send using Zencart's Newsletter facility. But I could also do this using Constant Contact. But I'd need some way to add the extra field in the first place.

What's the easiest way to do this?

[kobra]

But I'd need some way to add the extra field in the first place.

Adding a recoed to the customer table is the easy part

Coding the frontend to display it, capture it, save it to the db , the admin to retrieve and display it etc etc are the harder parts

If this will be only for the admin to see/use and not foe the customer to enter....consider using the builtin groups function

[Ovaltine]

Thanks for the tip! Seems like the way to go. I've created 0% discount groups to delineate the different customer types. Any tips on how to get these exported?

I've installed the "Email Address Export for Newsletters" module and need to export just those customers who match one group at a time. Or to export the discount group as a field in the export CSV. Is there an elegant way to customize the email address export query, or do I fall back on a query through phpMyAdmin?

[Ovaltine]

OK, nevermind. I did some digging and discovered the query_builder table. I'm still new to this whole Zencart thing. A treasure trove of options here!