User Choice Club Seasons
Written by Edi Sipkas
Updated at June 19th, 2025
This report will allow you to view your club members' product choices. You will be able to filter by the specific season, membership status, as well as a date range.
You can use several parameters to get the most accurate Sales by Customer report. You can:
| Club (Required Field) | Select the Club you want to search by, or select All Clubs. |
|---|---|
| Season (Required Field) | Select the season to search by. |
| Status | Select the Status (All Members/Active/Cancelled/On Hold) |
| Sort By | Sort the report by Last Name or Club |
| Signup From | Signup From the date range for the information. |
| Signup To | Signup To date range for the report. |
Reports are exported in a CSV format.
Here are the definitions of what will populate your User Choice Club report:
| Club | Club name that the customer belongs to. |
|---|---|
| Cust # | Customer number of the club member. |
| Birth Date | Birthdate of the club member. (MM/DD/YY) |
| First Name | First name of the club member. |
| Last Name | Last name of the club member. |
| Company | Company name of the club member. |
| Address | Address of the club member. |
| Address 2 | The second address of the club member. |
| City | A city that the club member lives in. |
| State | State that the club member lives in. (XX) Ex: California - CA |
| Zip | Zip code/Postal of the club member. |
| Phone | Phone number of the club member. |
| Email address of the club member. | |
| ShipTo | Option selected for the shipping of the order. (Billing Address, Pickup, other address) |
| Ship Birth Date | Birthdate of the customer to whom the order is being shipped. (MM/DD/YY) |
| Ship First Name | First name of the customer that the order is being shipped to. |
| Ship Last Name | Last name of the customer that the order is being shipped to. |
| Ship Company | Company name of the customer to whom the order is being shipped. |
| Ship Address | Address of the customer that the order is being shipped. |
| Ship Address 2 | The second address of the customer that the order is being shipped to. |
| Ship City | A city that the customer lives in that the order is being shipped to. |
| Ship State | State that the customer lives where the order is being shipped to. (XX) Ex: California - CA |
| Ship Zip Code | Zip code/Postal of the customer that the order is being shipped to. |
| Ship Country | Country of the customer that club orders are being shipped to. |
| Ship Phone | Phone number of the customer to whom the order is being shipped. |
| Ship Email | Email address of the customer that the order is being shipped. |
| Shipping Strategy | Shipping Strategy was chosen for club membership. |
| Shipping Type | Shipping Type is chosen for club membership. |
| Credit Card Type | The type of card used for the transaction. (Visa/MasterCard/AmericanExpress/Discovery) |
| Credit Card | The number of the card used for the transaction. (XXXX XXXX XXXX 5454) This is encrypted; only the last four digits will be visible. |
| Expiry Mo | The month that the card expires. (MM) |
| Expiry Yr | The year that the card expires. (YYYY) |
| Name On Card | Name of the cardholder. |
| Last Processed | Date their credit card was last processed. |
| PrePay | Is the membership a Prepay membership? (Yes (Number of Prepay SKU)/No) |
| Shipments | How many Shipments have they received, and whether the membership is ongoing or prepaid? (Ie. 2 / 3 = Two out of three prepay shipments have been sent, 1 / Ongoing = One shipment has been sent on an ongoing membership) |
| Sign Up Date | Date for signing up for the club. |
| On Hold Start | Start date of a hold if there is a hold on the membership. |
| On Hold End | End date of a hold if there is a hold on the membership. |
| Retain Privileges | Yes/No - Indicates if the club member still receives club discounts and promotions but does not qualify for club shipments. |
| Cancel Date | Date of membership cancellation. |
| Product Discount | Discount on products chosen for Club Processing. (This does not apply to average website orders) |
| Shipping Discount | Discount on shipping chosen for Club Processing. (This does not apply to average website orders) |
| Pickup | Yes/No |
| Pickup Location | The location is chosen for the club member to pick up. |
| Pickup Location Code | Location code of the pickup location. |
| Sales Associate | Name of the associate that sold the membership. |
| Source Code | Free-form text to track club members. |
| Gift | Yes/No - Indicates if membership is a gift membership. |
| Gift Message | A gift message sent to the gifted recipient (appears on the packing slip) |
| Notes | Any additional notes added to this club membership. |
| Cancel Reason | Reason for membership cancellation. |
| (Product Name) | Amount of products in User Choice Club chosen. Additional columns past this will display each product name and the amount selected. |
| (Additional Products) | Additional products and amounts chosen are displayed in their rows. |