Skip to main content
All CollectionsCreating a Custom Club In Offset Commerce
Setting Up a Customization Offer for a Custom Club
Setting Up a Customization Offer for a Custom Club
Bobby Gibson avatar
Written by Bobby Gibson
Updated this week

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

  1. Create a new Group with the same name as your Club

    1. Go to the Groups Page to create a new Club Group

    2. Select the +New Group button

    3. Enter your Club Group Name

      1. NOTE: This name can not be seen by your customers. Using the same name as your club is recommended.

    4. Enter your Internal Description

      1. Add an internal description like "Club Customizations" or "Club Allocation"

    5. Select the Type dropdown and Choose Allocation

      1. NOTE: The Standard type is for segmenting that doesn’t require an allocation like a Group for Employees.

    6. Select the Create Group button

    7. Repeat steps 1.a through g until all the Club Groups are created

  2. Create a Test Club Group

    1. Repeat Steps 1.a through g

    2. Name the Group “Test Group”

    3. Go to Customers

    4. Enter your name or email in the search bar at the top right of the screen

      1. NOTE: If you don't already have a customer account, you will need to create one under the customers tab.

    5. Open your Customer account by clicking on your name in the results

    6. Scroll down and select Groups & Segments

    7. Under Groups, check the box for the Test Group and uncheck any other allocation Groups

    8. Select the Update button

    9. 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.

  1. Go to the Clubs page

  2. Click the elipses to the right of the club

  3. In the dropdown, select Edit Club Details

  4. Scroll to the bottom of the page to the Groups Added to Upon Signup section

  5. Check the box for the corresponding Club Group

  6. Select Save Changes

    1. 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

  1. Export a list of your customers by going to the Clubs page

  2. Select the Actions dropdown

  3. Choose the Export All Members .CSV

  4. Use Column A of the spreadsheet to get the customer_id data

  5. Use Column B to get the Club data

    1. NOTE: If you want to import using the same sheet, delete ALL other columns and save the Sheet with just Columns A and B

  6. Use the Find and Replace function in your spreadsheet editor to replace the Name of the club with the Group ID

    1. EXAMPLE: On the Groups page, the Group ID is the number to the left of the Group Name.

      1. On the Group import spreadsheet, I would replace "Pinot Club" with "17" so it would look like this:

  7. 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

  1. Go to the Customers page

    1. 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.

  2. Select the Filters button at the top of the page

  3. Enter the name of your club in the Clubs field

  4. Select the Filter Customers button to generate your results.

    1. 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.

  5. Select all Displayed customers by clicking the checkbox in the upper right corner next to ID

  6. Select or deselect customers individually as needed

  7. Select the Choose an Action dropdown

  8. Under the Move to Group header, choose Move to “Example Group”

    1. 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.

    2. 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.

  9. When the process is complete, you will see a green banner at the top of the page that says ✓ 1 customer moved to group.

  10. To check your work, go to the Groups page

  11. Select the ellipses to the right of the desired group

  12. Choose View Customers

  13. 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

  14. Select the Choose an action… dropdown

  15. Choose Export > Customer Data Export [.CSV]

Configure Your Group Allocation Offer

  1. Select the Groups tab

  2. Click on the name of the group where you want to set up an allocation

    1. 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.

    2. IMPORTANT: You may want to disable the Test Group when your allocation is live, so you don’t see a double display.

  3. Click the Status dropdown and change the Test Group to Active

    1. DEFINITION: Active allows group members to view the allocation when they reach the start time. Inactive turns off the allocation regardless of time.

    2. IMPORTANT: The Status setting can start as Inactive but needs to be set to Active for you to preview your work.

  4. Scroll down to Timeline, click on the Start button

    1. Select today’s date and time

    2. Click the End button

    3. Select a future date and time

    4. Click the Save Changes button to save your work

      1. 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.

  5. Scroll down to the Messaging Section

    1. Enter your Allocation Title

      1. NOTE: This title appears to customers at the top of the allocation page.

    2. Enter the Messaging

      1. 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.

      2. (Optional) Purchase Confirmation Message This is the message that will appear on the allocation receipt page. It will override the default message.

      3. Click the Save Changes button to save your work

  6. Scroll down to Products in this Allocation Group to add products one by one

    1. Select the Add Products button

    2. Choose the Select Product For Allocation dropdown

    3. Pick a product you want to include in the allocation

      1. NOTE: If you have a lot of products, you can use keywords to narrow down the results

      2. 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

    4. Enter the number of bottles that are required for the Club Shipment in the Purchase Minimum field.

      1. EXAMPLE: If the Club requires 3 bottles if they didn't customize, you would enter a 3 in this field.

      2. 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

    5. Enter the highest amount a customer can purchase outright in the Purchase Maximum field.

      1. IMPORTANT: You must enter a value. That value must be the same as the Purchase Minimum or higher.

    6. Enter the highest amount a customer can wish for outright in the Wish Maximum field.

      1. 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.

      2. 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.

    7. Select the Add to Allocation button

      1. Adjust quantities as needed and select the Update Quantities button to save any additional changes to the Minumum or Maxumum amounts.

  7. (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.

    1. Enter the appropriate product data without altering any of the headers and save the file in its default format of MS-DOS.csv.

    2. Select the Import Products

    3. Select Choose File and attach the completed file

    4. Select the Upload button

    5. Confirm the settings are correct.

      1. 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.

  8. (Optional) Scroll down to Allocation Checkout Requirements

    1. Enter a Cart Minimum

      1. 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.

      2. IMPORTANT: If you are using the Cart Minumum, you may want to reduce the individual product minimums to avoid any conflicts.

      3. 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.

    2. Enter a Cart Maximum

      1. 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.

    3. Enter a Dollar Minimum

      1. Customers cannot check out unless their subtotal is equal to or greater than the number in this field.

  9. (Optional) Group Discount

    1. Enter a value in the Percentage Discount

      1. 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.

  1. Go to Orders > Wish Requests

  2. Select the checkbox next to ID to select all

  3. Select the Choose an Action dropdown

  4. (Optional) Select Export Wish Requests [.csv] to export a copy of your non-granted wishes and save the file as a backup.

  5. Select all or select individual wishes by checking the box on the left side of the individual wish

  6. Select the Choose an Action dropdown

  7. Choose the Delete selected Wish Requests option

    1. 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

Did this answer your question?