Exporting Customer Mailing Addresses?

[gezzyka]

Hello,

I've been trying to figure out how to export my customer mailing addresses (not email addresses) for a postcard campaign. I'm not seeing an option anywhere on the admin menus and couldn't figure out how to do it via phpmyadmin, either. I know the data's in there ;-) and just need a way to export it into something I can use. (I'll be addressing the cards by hand at this point, so the file format doesn't matter.)

Thanks!
Gezzyka

[gezzyka]

I found the customer mailing addresses using phpmyadmin in the zen_address_book table and was able to export them from there so I now have a spreadsheet with all the mailing addresses in it.

If there's an easier way to do it within zencart, I'd love to know what it is, but wanted to post this roundabout solution to anyone who might want their database.

Many, many thanks for such an outstanding program!
Gezzyka

[wolfsz]

Hi there
I think that's the only way. Eg run a SQL quey and then export it to whatever format you require.
Anyhow that's what I do too.

[gezzyka]

Thank you so much, wolfsz! I really appreciate the reply. I was starting to feel like I must be missing something really obvious (especially when my google searches didn't turn up any clues). Thank you very, very much!

Gezzyka

[mydanilo]

I am looking to do something similar.

I want to export all customer date and need to filter the ones that registered but never ordered. I manage to export the customers but I can not find where the flag is for Number of Orders.

I tried to find the table that holds the "Number of Orders: 0" but could not find it. It is not in the customer table. Does anybody know how I can generate a list of customers that have "Number of Orders: 0"?

Maybe there is data available for last order date and I can go from there?

[gezzyka]

That's a great question! Unfortunately, I have no idea how to do it :-(. I found the table I needed by doing a search for a first name I knew was in there, but I'm not sure how you'd search out order numbers since there would be numbers in so many of the tables (so, searching for 0 would turn up all the tables that had 0s in them...).

I hope you find someone with the answer!

Gezzyka