System Specification – Building a New Site

Problem

Before Gladstone builds your new database (Plus2, 360 and Go), you need to make the decisions collected in the system specification document: core settings, users, statuses, user fields, price levels, payment methods, products and bookable areas.

Resolution

  1. Agree the core settings

    SettingGuidance
    Database / site prefix3–4 characters (for example, an abbreviation of the organisation). Internal only. For multi-site databases also agree a unique site code per site for resource and product IDs (see Naming Conventions for Plus2 IDs and Descriptions).
    Booking sheet opening periodHow far ahead bookings can be scheduled; usually one year (longer if, for example, elections are booked years ahead). Recurring classes extend a day at a time as the window rolls forward.
    Bank account, sort code, service user number (SUN)Supplied by finance.
    DD collection runsNumber of runs per month and the collection date(s) (for example, the 1st).
    GB Group (address, bank, email/phone validation)Enter credentials in live only; leave test without, to save credits and allow fake details. A bank-validation licence is needed if the site sells DD; email/phone validation is optional.
    Create card when adding membersUsually No (only for card printers); cards are added when scanned.
    Show priority subscriptionYes: orders a member's subscriptions by priority (for example, paid membership above a gym-induction access subscription).
    Display mugshotYes: photo on the record; the webcam freeze frame takes the picture after about 5 seconds.
    Duplicate receipt for refundsOptional; receipts can always be reprinted.
    POS readings by payment methodStaff declare each method (for example, card, cheque) so the PDQ total can be matched. Keep cheque or cash available for any exceptions (for example, a block booker paying by cheque).
    Overs and undersAllowed till variance (for example, £5).
    Receipts for no-sales / zero transactionsUsually No, to save till roll.
    Plus2 licencesNumber of concurrent Plus2 users. Plus2 cannot use a shared generic login, so count everyone who needs the booking sheet.
    Account/help email and phoneShown on Go for customer queries; choose a monitored mailbox. Booking and membership queries can have separate contacts.
    Alert listSwitch on if waiting lists will be used; choose which classes later.
  2. Define user groups and users

  3. Tidy the titles

  4. Choose the statuses

    • See Setting Up Member Statuses in Plus2.
    • Status controls how a record is treated (booking and entry restrictions, online joining behaviour); price level controls what they pay. Typical set:
      • Live / Current member, Non-member / Pay as you go, Ad hoc booker (one-off hires such as parties, same rights as a non-member but reportable separately), Block booker, Swimming lessons and Private swimming lessons (a record has one status, so use the primary relationship, for example a gym DD member keeps the member status).
      • Lapsed (cancelled at the bank or given notice, still paying until the end date), Cancelled, Expired (annual not renewed), Deceased (for example, from a bank rejection; delete bank details).
      • Frozen (one level if there is no charged holiday freeze), Suspended (for example, after a three-strike no-show rule). For 360 freeze workflows the Plus2 freeze status (for example, ID FREEZ, "Current – Freeze") must have Freeze Subscriptions and Collect Sales both ticked; 360 supports freezes only when a freeze workflow is configured (see Building a Gladstone 360 Freeze Contact Workflow).
      • DD enquiry: set when a DD fails; a debt is created that the customer can pay online. The status does not reset itself when the debt is paid unless a script is set up (see Notes).
      • Pending eligibility: for discounted memberships needing proof (see Gladstone Go – Joining Online, Pay-as-You-Go and Eligibility Checks).
      • Lead, Prospect, Purge: for the Prospects module (see step 5).
    • Give each status a colour; use bright colours (for example, red) for problem statuses.
  5. Plan the Prospects module (if applicable)

    • The 360 Prospects module is a task list: leads are assigned to staff (or left unassigned for anyone), followed up, and given an outcome (for example, dropout reason such as price or competitor, or a follow-up like a site tour).
    • Status flow: Lead → Prospect → current member, pay as you go, or Purge (dropped out). Purge records can be deleted periodically in a data cleanse.
    • Leads and prospects can still book as pay-as-you-go; a one-off purchase does not change their status, but you can report on prospects who have bought something and follow them up.
    • Creating leads automatically from a website enquiry form needs an API integration (bespoke, chargeable unless included in the contract).
  6. Choose the user fields

    • Up to about 50 user fields. Typical: emergency contact name and number, cancellation reasons and freeze reasons (use pick-lists, not free text, so they are reportable), how did you hear about us, medical conditions/disability, health declaration, photography consent, and customer segmentation (for example, local group, parent, alumni, commercial hirer).
    • User fields cannot be limited to certain subscription types; they exist on every record but need not be completed.
    • For discounted memberships needing proof, add an eligibility field plus a review/expiry date so renewals can be reported on.
    • For block bookings, record photography consent against the block booker and make them responsible for individual attendees' consent.
    • Terms and conditions and marketing consent are already built in.
  7. Set the price levels

    • One default price level (usually Adult), which unknown customers pay. Add others by age, for example Concession (60+), Junior (for example, 1–17), Infant (under 1, free).
    • Discounts for students, corporate groups and similar come from the membership via price level overrides, not from separate customer price levels. Create the override levels (for example, Inclusive, Staff, Blue light, spare Discount 1/2) at build time: adding a price level later means ticking it on every product (including every resource product).
    • Order the IDs so customer levels (1 …) sit above override levels (2 …). Override levels are never assigned to a record. See Planning and Creating Price Levels in Plus2 and Price Level Override (PLO).
  8. Set the payment methods

    • See Setting Up Payment Methods in Plus2.
    • Typical: card, cheque, direct debit, invoice, BACS / bank transfer (paying invoices, usually block bookings; non-banked), vouchers/complimentary, and GSP (Gladstone Pay, replacing a "web" method, for online transactions). Cash can be removed if the site is cashless.
    • Discounts are applied at the till by item or basket and can be restricted to senior roles by permission.
    • If the site will use Go Operator Block Bookings, tick Default for Hosts on the Invoicing payment method (Plus2 Configuration > Financials > Payment Methods, double-click Invoicing). Without it every block booking fails with "Payment method Cash is not an invoicing account…" (see Fixing "Payment method Cash is not an invoicing account").
  9. Set up products, departments and add-ons

    • Finance supplies the departments and cost centres; every product maps to a department, which maps to a cost centre. See Setting Departments, Cost Centres and Tax in Plus2.
    • For hires, add variable-price buttons for add-ons such as staffing, set-up or catering (default £0 or a typical price, editable), each with its own department.
  10. Decide bookable areas, resources and block bookings

Notes

This page as markdown · All pages · llms.txt