Five jobs, all between systems you already pay for
We don't sell software and we don't build web stores. We write and maintain the code that moves wine club, reservation and accounting data between the platforms your winery runs today. Each service below lists what's in, what's out, what you receive and how long it usually takes.
01
DTC platform to QuickBooks Online or Xero
A scheduled job that reads the day's activity from Commerce7 or WineDirect and posts it to your accounting file the way your accountant books it.
Typical timeline: 3–5 weeks
Included
- Orders, club batch charges, refunds, tips, tasting fees, shipping and sales tax
- Mapping to your chart of accounts, classes or tracking categories, split by tasting room location
- A daily totals check against the platform before anything posts
- Backfill of a period you choose, usually the current fiscal year
Not included
- Bookkeeping, month-end close or sales tax filing
- Inventory and wholesale or distributor orders
You receive
- Source code in your repository
- Account mapping document signed off by your accountant
- Runbook: re-run a day, add a location, rotate a key
02
Reservations to customer records
Tock and OpenTable visits written into the customer record in your DTC platform, with tags your club and marketing staff can filter on.
Typical timeline: 2–4 weeks
Included
- Matching guests by email and flagging records that can't be matched
- Tags such as First visit, Tasted, not a member, Repeat visitor and No-show
- Visit date, experience name and party size on the customer record
- A daily exceptions sheet for walk-ins and duplicate records
Not included
- Setting up or replacing your reservation system
- Email campaigns built on the tags
You receive
- Source code in your repository
- Tag rules document
- Runbook
03
Platform data migration
Moving customers, club tiers, order history, gift cards and payment tokens when you change DTC platforms, with a trial run before the real one.
Typical timeline: 4–8 weeks; card token transfers alone can take 1–6 weeks
Included
- Cleanup before the move: duplicates, bad addresses, inactive club members
- Field mapping for customers, club memberships, orders, gift card balances and notes
- Trial migration into a sandbox tenant with an error report
- Coordination of the card token transfer between processors
- Final push, delta push after go-live and a two-week review
Not included
- Your new platform's subscription or onboarding fees
- Rebuilding your web store or product pages
You receive
- Field mapping sheet
- Trial migration report
- Pre-launch reconciliation checklist
- List of records that could not be moved, with reasons
Field map, customers and clubs
| Source field | Target field | Status |
|---|---|---|
| Contact.Email | customer.emails[0] | Mapped |
| ClubMembership.Level | clubMembership.clubId | Mapped |
| GiftCard.Balance | giftCard.balance | Check |
| Product.Varietal | product metadata | Manual |
Commerce7's own WineDirect migration covers customers, clubs, orders, gift cards and tokens, but not advanced product attributes such as varietal, vintage and appellation, or bundles. We map those by hand and say so in the report.
04
Custom reports and dashboards
Data from your DTC, reservation and accounting systems collected in Google BigQuery or Google Sheets and charted in Looker Studio, refreshed weekly.
Typical timeline: 2–4 weeks
Included
- Club churn by tier and by quarter
- Club shipment counts and declined cards per release
- Tasting room conversion: visits to orders to club sign-ups
- Weekly automatic refresh and access for the people you name
Not included
- Forecasting or financial statements
- Reports for systems outside the DTC, reservation and accounting group
You receive
- Looker Studio report owned by your Google account
- Data dictionary for each metric
- Runbook
05
Monitoring and maintenance
Integrations break when a platform changes its API or someone renames a club. We watch every run and fix it.
Typical timeline: Month to month
Included
- A check of every run each morning before 9:00 a.m. Pacific
- Automatic failure alerts and same-business-day re-sync
- Code changes when Commerce7, WineDirect, Tock, QuickBooks or Xero change their APIs
- A monthly run report: runs, failures, re-syncs and changes made
Not included
- New features, new reports or new integrations (quoted separately or billed hourly)
You receive
- Monthly run report
- Updated runbook after every code change
Work we leave to others
- Winery website design and online store builds.
- Tasting room POS hardware, card readers and installation.
- General inventory and wholesale or distributor order systems.
- Interstate shipping compliance and excise tax filings: your compliance advisor's job.
- Bookkeeping and tax returns: your accountant's job. We give them clean data and the reports they ask for.
See what each step needs from you, or what each service costs.