Work / Completed case study

Unifying Retail E-Commerce and Club Allocations on Commerce7

How a self-pour tasting room moved from a patchwork of disconnected tools to Commerce7 as its system of record, with a companion app that keeps the counter fast.

Unifying Retail E-Commerce and Club Allocations on Commerce7
Venue Uncorked Wine Tastings
Type Commerce7 implementation
Platform Commerce7
What I Built A Commerce7 migration, an online bottle shop, club tiers, and a companion app connected to Commerce7
Status Completed
Built By My Pub Marketing LLC

In short: When member billing, retail inventory, tasting allowances, and bar tabs live in separate tools, ownership spends hours auditing spreadsheets while staff behind the bar can’t see who they’re serving. My Pub Marketing moved Uncorked Wine Tastings to Commerce7 as the system of record and connected the companion app to it.

The problem: four places for one guest

Uncorked launched with a lightweight digital membership that did its job: it showed that guests wanted a structured, recurring relationship with the venue. As the venue added a physical bottle club and retail sales, that early set of tools showed its limits:

  1. Guest records in four places. Billing, website accounts, tasting allowances, and bar purchases each lived in a different tool.
  2. Spreadsheets before every release. Preparing a club release meant exporting records and cross-referencing them by hand.
  3. No integrated online bottle shop for browsing, ordering, and in-store pickup.
Before and after diagram: guest records spread across four tools versus one Commerce7 system of record with the companion app and bar POS alongside
Before and after: one record of each member that staff can see at the bar.

What changed

My Pub Marketing acted as the venue’s fractional digital lead and Commerce7 implementation specialist.

  • An online bottle shop with in-store pickup and order notifications.
  • Club tiers in one place. Billing, packing lists, and member privileges are handled in Commerce7.
  • A clear line between two inventories. The bar’s POS stays the system of record for pours and food. Commerce7 is the record for retail bottles and club inventory. When bottles move from retail stock to the bar, staff make a short manual adjustment. I chose this over a live sync because two cloud systems fighting over counts during service is the failure to avoid.
  • A companion app at the counter. Members open a digital pass, staff scan it, and the flight benefit is checked against the member’s Commerce7 profile so it can’t be redeemed twice.
  • Branded, deliverable email. Welcome, allocation, and pickup messages use the venue’s look, with domain authentication records set so they reach the inbox.
The Uncorked Wine Tastings online bottle shop on Commerce7 showing wines with descriptions and add to cart buttons
The online bottle shop: browse, add to cart, choose in-store pickup.
The Uncorked Wine Tastings club page on Commerce7
The club page, where members choose a tier and pick up monthly in store.
The Uncorked Wine Tastings storefront home page
The storefront home page. Screenshots taken from the live shop on 2026-10-20; no guest data shown.

The tradeoff

An industry-standard platform means a migration investment and a commitment to standard procedures, including that short manual inventory transfer. The payoff is fewer weekends spent reconciling spreadsheets and staff who spend their shifts hosting guests.

Is your stack holding your club back?

If your staff spends hours every month wrestling with spreadsheets to get club releases out, or your online store doesn’t connect to your tasting room, start with a free intro call.

Book an Intro Call

Have a similar challenge?

Every engagement starts with a free intro call, then a scoped audit if it makes sense.

Book an Intro Call
WhatsApp Chat on WhatsApp