ETCC Logo

Silent Auction Manager

East Tennessee Corvette Club
ETCC Logo

Silent Auction Manager

East Tennessee Corvette Club

Welcome to your new Auction Management site!

This is your home base for running the whole show — from items rolling in automatically off email, to printing bidding forms, tracking winners, and getting invoices out the door without you lifting a finger. No database skills needed, nothing to maintain, just a tool built to take the busywork off your plate so you can focus on running a great auction. Glad to have you trying it out!
Auction Workflow
1
Load Item Emails
Scan the auction inbox and import items from Gmail
2
Create Bid Sheets
Print bid sheets for each auction item
3
Register Bidders
Add bidders and assign bidder numbers
4
Record Winning Bidders
Enter the winning bidder number for each item
5
Print Invoices
Print invoices for all winning bidders
6
Announce Winners
Display and email the list of winning bidders
7
Pay & Pickup
Record payments and item pickup for each winner
8
Post Auction
Post-auction tasks and reporting
Total Emails
0
New Items
0
Total Items
0
Total Value
$0
Not connected to Gmail
Note: The first time emails are scanned, you will be required to log in to the auction email account . Please obtain the credentials from your administrator.
Inbox Emails
Email Date From Subject Preview
Loaded Items
Item # Email Date Category Description Value Reserve Donor Name Donor Email Donor Phone Date Loaded Preview
Item # Submission Date Category Description Value Reserve Donor Name Donor Email Donor Phone Date Loaded
Bidder # Bidder Type Last Name First Name Email Phone
🖨 Item # Description Value Reserve Winning Bid Bidder
Bidder # Bidder Name Items Won
Click Bidder # or Last Name column header to sort
Bidder # Last Name First Name # Items Winning Bid Item # — Description Cash/Check Check # CC Trans. CC Total Paid Pay Method Other Amt Other Reason Invoice
Reports
🖨
Auction Summary
Bidders, items, winners, total income
🖨
Winning Bidder
Each winner's items and amount due
🖨
Donor Report
Items donated and income per donor
🖨
Club Financial Summary
Cash, check, credit card, other
Email
Email Bidders
Select bidders and open email client
Auction Location
Auction Setup
Percentage of item value used as the starting bid amount on bid sheets.
Percentage of item value used as the final (highest) bid amount on bid sheets.
Number of bid rows on each bid sheet. Bids are evenly incremented from Starting Bid to Final Bid.
Starting bidder number assigned to walk-in (non-pre-registration) bidders. Default: 1000.
Email Field Mapping

Define how to extract fields from each email. The Email Label is the text prefix in the email body (e.g. "Category:"). The Table Column is the database field name to populate.

Email Label Select By Database Column Loaded Items Column Edit Remove
Square Card Processing
Square percentage fee charged per transaction (e.g. 2.6).
$
Square flat fee charged per transaction in dollars (e.g. 0.10).
Member Database

Import club members from a Club Express Additional Member Data CSV export. Expected columns: member_number, last_name, first_name, primary_email, cell_phone.

Registration Database

Import pre-registration bidders from a Club Express Registrant Data CSV export. Expected columns: member_number, last_name, first_name, email, cell_phone.

Bidder Database
Developer Tools
Show the process log panel during scan and email loading operations.
Opens the automated test suite in a new tab.
Clear all scanned inbox emails from the current session.
Clear all loaded auction items from the database.
Gmail OAuth
Create a Web Application credential in Google Cloud Console → APIs & Services → Credentials. Add http://localhost:3000 to Authorized JavaScript Origins.
Gmail label/folder to scan (e.g. INBOX, or a custom label name).

📖 ETCC Silent Auction Manager — User Manual

This application manages the silent auction for the East Tennessee Corvette Club. Follow the six steps in order for each auction event.

Step 1 — Item Load

Scans etccwebsite.auction@gmail.com for donation emails. Extracts item fields and loads them into the items database. Duplicate emails are skipped. Each item receives a unique item number based on its category.

Step 2 — Create Bid Sheets

Generates a printable bid sheet for each item showing item number, description, starting bid, bid increment, and a table of bid rows.

Step 3 — Bidder Registration

Register attendees as bidders. Import member numbers from a Club Express file. Send emails to individual or all bidders.

Step 4 — Auction Close

After the auction closes, enter the winning bidder number for each item using bulk entry mode.

Step 5 — Winner Announcement

Generates a list of all winning bidders and items that can be announced to attendees.

Step 6 — Payment & Pickup

Payment report listing each winning bidder, items won, and payment details. Sortable by bidder number or last name.

Settings

Enter your Google OAuth Client ID to enable Gmail scanning. Configure the field mapping table to match your email format.

Item Categories

  • 100 — General Auto Repair / Car Items
  • 200 — Corvette Items
  • 300 — Men's Items
  • 400 — Women's Items
  • 500 — General Household
  • 600 — Framed Artwork or other Artwork to be Hung
  • 700 — Baskets / Gift Sets
  • 800 — Gift Certificates
  • 900 — Miscellaneous / Other