Custom Email Address Export recipient list

[RixStix]

I didn't find a support thread for Email Address Exporter plugin, so here is my question.

I need (if it doesn't require an enormous amount of coding)

Additional Email Address Export Recipient List

Dormant Customers (> 90 days)(Subscribers) AND Order Total > $0

Manytimes, I am able to look at the code and figure out how to make minor changes. I've looked and can't find anything that jumps out as within my capabilities.

[lruskauff]

Hi Rick
I only looked at briefly, but in general you need to
1. Add the query to table query_builder using myphpadmin
2. I think the code will pull it in as a drop down but didn't get to test.

Follow the email examples in query_builder table. I don't know if you know SQL or not but I will assume that ou know some.

I hope this gets you started.
Linda

[RixStix]

TNX Linda,

Since there are several existing options, my hope was to be able to duplicate (or modify) the existing dormant option and add an ordertotal condition.

I'll have a look at that table. TNX for pointing it out.

Anything more involved than that is beyond my comfort level.

[lruskauff]

Yes, I think there are several that have conditions set, one w current customer < 30 days which you could reverse to make it what you need. Then add an "and" condition for order total part. You should be able to replicate. Each query has a name so u might need to add that name to the code (I'm not at computer but it is the .php code in module under admin.

[RixStix]

Woo Hoo

just inserted to the Dormant selection query

o.order_total > 10 AND

TNX again for pointing me in a favorable direction.

[lruskauff]

Glad you got it to work.