List Building: Members in Multiple Clubs

1

Does anyone know of a way to create a list builder that will only show me members who may be in 2 of my clubs?

I have two Wente Wine Clubs, and they have discount levels, and I have members who are in both. With the promo system, they get the best discount at the POS, but I am wondering if there is an easy way to process their club order and give them the appropriate discount. I am hoping that i don’t have to do these manually. :slight_smile:

thanks

2

  1. What method are you using to apply Club discount levels?

  2. How are you in Excel?

3

For the club batch, I thought that there is only way to set price, the price override. for POS and web sales, discount is given by club status.

I’m ok with excel. I was thinking pivot tables with customer number down the side and clubs on top and then using a count function to see how many people have a club count of 2. any other ideas?

4

Before every club run I do this, just an active club member report and count clubs. Sometimes people will end up signed up for two clubs when they really just wanted to change clubs.