We are running our first club run in March with Wine Direct. We offer a really unique amount of discounts and benefits to our members. They can choose between being in a Mixed, White, Red, and sweet club and choose between 2,4,6, or a case per club run month. All of our clubs are customizable. Members that receive 2-11 bottles get 20% and members with a case get 25% off. Since WD is unable to stack promos in club runs, does anyone have a suggestion or an easier way to pull a report to show which of our members not in the 12 bottle clubs customize to over 12+ bottles.
Right now we know to run the user choice club season report and have to do a lot of Manuel manipulation on our excel report to figure out who got what to pull them out to make sure they receive the 25% discount. We are unable to see the cost of the club order on that report which would make it a whole lot easier to distinguish who got more than a case. Does anyone have a better way?