Configuring a Customization Offer for Custom Clubs in Offset is in many ways the same as setting up Allocations. You are creating an offer so that members can log in and purchase their normal curated bottles as well as add on additional quantities and SKUs. The customization process adds convenience for the customer by allowing those who want to make changes to log in and purchase their custom shipment without having to call on the phone or send an email request to your staff. Anyone who wants to receive their default shipment can simply wait for you to run the batch order.
Before you create your Custom Club allocation, you will need to create Groups for each of your clubs.
Create Your Groups Based on Your Club Members
Create a new Group with the same name as your Club
Go to the Groups Page to create a new Club Group
Select the +New Group button
Enter your Club Group Name
NOTE: This name can not be seen by your customers. Using the same name as your club is recommended.
Enter your Internal Description
Add an internal description like "Club Customizations" or "Club Allocation"
Select the Type dropdown and Choose Allocation
NOTE: The Standard type is for segmenting that doesn’t require an allocation like a Group for Employees.
Select the Create Group button
Repeat steps 1.a through g until all the Club Groups are created
Create a Test Club Group
Repeat Steps 1.a through g
Name the Group “Test Group”
Go to Customers
Enter your name or email in the search bar at the top right of the screen
NOTE: If you don't already have a customer account, you will need to create one under the customers tab.
Open your Customer account by clicking on your name in the results
Scroll down and select Groups & Segments
Under Groups, check the box for the Test Group and uncheck any other allocation Groups
Select the Update button
Repeat this process for any other employees who will be logging in to test or review your setup
Add New Club Members to Groups Upon Signup
When new members sign up, rather than adding them manually to the Custom Club Groups, you can check a setting in your Club Details so all new members will be placed in the corresponding group.
Go to the Clubs page
Click the elipses to the right of the club
In the dropdown, select Edit Club Details
Scroll to the bottom of the page to the Groups Added to Upon Signup section
Check the box for the corresponding Club Group
Select Save Changes
NOTE: Any new member who joins a Club will also be automatically added to the Group selected in the Groups Added to Upon Signup
Bulk Shift Customers Into Group Segments
Now that your groups are created, you will need to assign your Club Members. There are a few options to shift customers using spreadsheets or the front-end user interface.
Bulk Shift Customers - Spreadsheet Import Option
Export a list of your customers by going to the Clubs page
Select the Actions dropdown
Choose the Export All Members .CSV
Use Column A of the spreadsheet to get the customer_id data
Use Column B to get the Club data
NOTE: If you want to import using the same sheet, delete ALL other columns and save the Sheet with just Columns A and B
Use the Find and Replace function in your spreadsheet editor to replace the Name of the club with the Group ID
EXAMPLE: On the Groups page, the Group ID is the number to the left of the Group Name.
On the Group import spreadsheet, I would replace "Pinot Club" with "17" so it would look like this:
For detailed instructions on Group Bulk Shifting via spreadsheet, select the following article: Bulk shifting customers from one group to another
Bulk Shift Customers - Customer Filter Option
Go to the Customers page
IMPORTANT: Before you begin, download a backup of your customer assignment for reference by going to Actions > Exports > All Customers .csv and save the file for future reference.
Select the Filters button at the top of the page
Enter the name of your club in the Clubs field
Select the Filter Customers button to generate your results.
IMPORTANT: As I write these instructions, the Clubs filter currently includes ALL members of this club. This includes canceled members. We are working on a solution for this, but if you have many canceled members, the spreadsheet option may be a better way to go.
Select all Displayed customers by clicking the checkbox in the upper right corner next to ID
Select or deselect customers individually as needed
Select the Choose an Action dropdown
Under the Move to Group header, choose Move to “Example Group”
NOTE: When you Move a customer, it will assign a customer to a new Group and remove them from ALL other assignments. This is the recommended process for most setups as you only want a customer to be in one allocation at a time. Assigning a customer to multiple groups will cause display issues when they log into the allocation.
IMPORTANT: The Move process starts immediately, so be patient while the customers are filed into their new group and wait for the process to complete.
When the process is complete, you will see a green banner at the top of the page that says ✓ 1 customer moved to group.
To check your work, go to the Groups page
Select the ellipses to the right of the desired group
Choose View Customers
You can view the Customers in the Group directly on the page or from a .csv export. To export, you can select all by checking the box to the left of ID
Select the Choose an action… dropdown
Choose Export > Customer Data Export [.CSV]
Configure Your Group Allocation Offer
Select the Groups tab
Click on the name of the group where you want to set up an allocation
NOTE: I recommend starting with your Test Group. Only people added to the group will be able to log into the allocation, which is why we recommend starting with the Test Group so you can identify any issues in a closed environment.
IMPORTANT: You may want to disable the Test Group when your allocation is live, so you don’t see a double display.
Click the Status dropdown and change the Test Group to Active
DEFINITION: Active allows group members to view the allocation when they reach the start time. Inactive turns off the allocation regardless of time.
IMPORTANT: The Status setting can start as Inactive but needs to be set to Active for you to preview your work.
Scroll down to Timeline, click on the Start button
Select today’s date and time
Click the End button
Select a future date and time
Click the Save Changes button to save your work
NOTE: Configuring the Start/End Dates can be set in advance to a future date in the actual allocation. Even if it is active, nobody will see the allocation until you reach the date.
Scroll down to the Messaging Section
Enter your Allocation Title
NOTE: This title appears to customers at the top of the allocation page.
Enter the Messaging
The Messaging appears below the Allocation Title and is a great place to write a brief welcome message to your group and let them know any essential details about the allocation.
(Optional) Purchase Confirmation Message This is the message that will appear on the allocation receipt page. It will override the default message.
Click the Save Changes button to save your work
Scroll down to Products in this Allocation Group to add products one by one
Select the Add Products button
Choose the Select Product For Allocation dropdown
Pick a product you want to include in the allocation
NOTE: If you have a lot of products, you can use keywords to narrow down the results
IMPORTANT: If you don’t see the product you are looking for in the dropdown selection, go to that individual product, add inventory, and try again
Enter the number of bottles that are required for the Club Shipment in the Purchase Minimum field.
EXAMPLE: If the Club requires 3 bottles if they didn't customize, you would enter a 3 in this field.
IMPORTANT: You must set a Purchase Minimum for a product if you want to require customers to purchase a particular product as part of their Membership. If it is a total number, rather than an individual product minimum, skip to Step 8a for Cart Minimum
Enter the highest amount a customer can purchase outright in the Purchase Maximum field.
IMPORTANT: You must enter a value. That value must be the same as the Purchase Minimum or higher.
Enter the highest amount a customer can wish for outright in the Wish Maximum field.
NOTE: Wishes are logged in the system and can be seen in Customer accounts by clicking on the Wish Requests tab or the Orders > Wish Requests page.
IMPORTANT: Wishes should be batched after the close of the allocation. Make sure to grant wishes before sending orders to fulfillment. Granting wish requests rolls the wish quantities into the original order, so if you send them over before the wish grant, there will be missing order info.
Select the Add to Allocation button
Adjust quantities as needed and select the Update Quantities button to save any additional changes to the Minumum or Maxumum amounts.
(Optional) After adding at least one product, you can select the Export Products button for a spreadsheet template and upload the remaining items via spreadsheet.
Enter the appropriate product data without altering any of the headers and save the file in its default format of MS-DOS.csv.
Select the Import Products
Select Choose File and attach the completed file
Select the Upload button
Confirm the settings are correct.
NOTE: If you have multiple allocations with the same or similar products, you can export this template and import it into other groups to save time.
(Optional) Scroll down to Allocation Checkout Requirements
Enter a Cart Minimum
NOTE: Customers can add a mix of products totaling at least the amount in this field to the cart to checkout. Customers who try to purchase less will see an error message at the top of the page.
IMPORTANT: If you are using the Cart Minumum, you may want to reduce the individual product minimums to avoid any conflicts.
IMPORTANT: You may also want to alert customers in your allocation messaging that there are cart-based minimums so they know what to expect if they try to check out with less wine than the minimum requirements.
Enter a Cart Maximum
NOTE: Customers cannot purchase more than this amount of total product to checkout. Attempts to check out with more than the maximum will result in an error message.
Enter a Dollar Minimum
Customers cannot check out unless their subtotal is equal to or greater than the number in this field.
(Optional) Group Discount
Enter a value in the Percentage Discount
NOTE: All Customers in this Group will receive this discount on ANY order. If you already have Subsequent Non-Club Order Discounts set for the Club, you can skip this step.
Clean Up Old Wish Requests
If there are declined or non-granted wishes from your previous allocation, you should back up and delete them so you don’t accidentally grant them when you batch this release’s wishes.
Go to Orders > Wish Requests
Select the checkbox next to ID to select all
Select the Choose an Action dropdown
(Optional) Select Export Wish Requests [.csv] to export a copy of your non-granted wishes and save the file as a backup.
Select all or select individual wishes by checking the box on the left side of the individual wish
Select the Choose an Action dropdown
Choose the Delete selected Wish Requests option
NOTE: The wishes will be deleted immediately and there is no un-do. You will see a green banner at the top of the page that says X Saved order deleted
For a list of other articles on this topic, please view Offset Commerce: Custom Clubs