Member merchandise sales query

Nina Cunningham

Has anyone run a merchandise sales by member report? I'm trying to determine what % of our merchandise sales are to members vs non-members, and wonder if someone has done this and would be willing to share their query parameters? Thanks in advance!

Margaret Matteson

The trouble you'll run into is that any sales order query won't include member's status at the time of the transaction. You can pull in their current membership status by Constituent\\[Membership Program]\\Status but they may or may not have been members at the time of the sales order. The other thing I have never had much luck with is dealing with refunds in Sales Order queries. They never seem to work right.

Nina Cunningham

Good point about the active membership, Margaret, thanks!


We don't do refunds on merchandise, so that would not be an issue.