Hey gals, mind if I drop by?
I was thinking to keep a customer a member as long as there total purchases in the past 12 month window have been above the mark. And the window shifts, one month each month. With a minimum membership duration of 1 year, so that customers who qualify now because of one big order almost a year ago aren't kicked out after one or two months.
Entries or exits to the club are in the first week of each month only, when I run the report of who qualifies. Currently there is a bit of manual work involved to make this work.
Shipping cost and purchased gift vouchers are excluded but once you use your gift voucher balance to pay for your order, those purchased items do count.
I will check back later to see how the idea develops in here.