Vendor Management Skill

This skill helps manage wedding vendors in TheFesta Events platform, including vendor registration, profile management, service listings, and communication.

Core Vendor Operations

1. Vendor Registration & Onboarding

When adding a new vendor to the platform:

Required Information:

• Business name and legal entity
• Contact details (email, phone, address)
• Vendor category (venue, catering, photography, etc.)
• Business registration/license numbers
• Tax information (if applicable)
• Service areas/locations covered
• Years in business
• Portfolio/previous work samples

Database Fields to Consider:

{
  name: string;
  email: string;
  phone: string;
  category: VendorCategory;
  description: string;
  services: Service[];
  location: Location;
  pricing: PricingInfo;
  availability: Availability;
  portfolio: Media[];
  reviews: Review[];
  status: 'pending' | 'active' | 'suspended';
}

2. Vendor Profile Management

Profile Components:

• Business overview and description
• Service offerings and packages
• Pricing tiers and packages
• Availability calendar
• Portfolio/gallery (images, videos)
• Reviews and ratings
• Certifications and awards
• Social media links
• Terms and conditions

Best Practices:

• Validate all contact information
• Ensure high-quality portfolio images
• Verify business credentials
• Set clear service descriptions
• Include transparent pricing

3. Service & Package Management

Service Listing Structure:

{
  serviceName: string;
  description: string;
  category: string;
  basePrice: number;
  pricingType: 'fixed' | 'hourly' | 'package' | 'custom';
  features: string[];
  addOns?: AddOn[];
  maxCapacity?: number;
  duration?: string;
  customizable: boolean;
}

Package Types:

• Basic/Standard/Premium tiers
• Custom packages
• Seasonal offers
• Bundle deals
• Add-on services

4. Vendor Categories

Common vendor categories for wedding events:

Venues:

• Wedding venues
• Reception halls
• Outdoor spaces
• Destination venues

Catering:

• Full-service catering
• Dessert/cake specialists
• Bar services
• Food trucks

Photography & Videography:

• Wedding photographers
• Videographers
• Drone operators
• Photo booth services

Decor & Flowers:

• Florists
• Event decorators
• Lighting specialists
• Rental companies

Entertainment:

• DJs
• Bands/musicians
• MCs/hosts
• Dancers/performers

Planning & Coordination:

• Wedding planners
• Day-of coordinators
• Event designers

Beauty & Fashion:

• Hair stylists
• Makeup artists
• Bridal boutiques
• Tuxedo rentals

Other Services:

• Transportation
• Invitations/stationery
• Favors/gifts
• Honeymoon planning

Vendor Communication

Email Templates

Welcome Email:

Subject: Welcome to TheFesta Events - Vendor Partnership

Dear [Vendor Name],

Welcome to TheFesta Events! We're excited to have you join our platform
connecting couples with exceptional wedding vendors.

Your vendor profile is now live at: [Profile URL]

Next steps:
1. Complete your profile with portfolio images
2. Set up your service packages and pricing
3. Configure your availability calendar
4. Review and respond to inquiries promptly

Our team is here to support you. Contact us at vendor-support@thefestaevents.com

Best regards,
The TheFesta Team

Inquiry Response Template:

Subject: New Event Inquiry - [Event Date]

Dear [Vendor Name],

You have a new inquiry for:
- Event Type: [Wedding/Reception]
- Date: [Event Date]
- Location: [Location]
- Guest Count: [Number]
- Budget: [Budget Range]

Client Message:
[Message]

Please respond within 24 hours to maintain good response metrics.

[Respond to Inquiry Button]

Communication Best Practices

• Respond to inquiries within 24 hours
• Maintain professional tone
• Provide clear pricing and availability
• Ask relevant questions to understand needs
• Send follow-up communications
• Request reviews after completed events

Data Validation

Required Validations

Email Validation:

• Valid email format
• Domain verification
• Unique email per vendor

Phone Validation:

• Valid phone format
• Country code verification
• SMS verification (optional)

Business Validation:

• Business license verification
• Tax ID validation
• Insurance verification
• Background checks (if applicable)

Content Validation:

• Portfolio images: max size, proper format
• Descriptions: minimum/maximum length
• Pricing: valid ranges
• Availability: valid date ranges

Database Operations

Common Queries

Find vendors by category:

SELECT * FROM vendors
WHERE category = ?
AND status = 'active'
AND location IN (?)
ORDER BY rating DESC;

Find available vendors:

SELECT v.* FROM vendors v
LEFT JOIN bookings b ON v.id = b.vendor_id
WHERE b.event_date != ?
OR b.id IS NULL
AND v.category = ?;

Get vendor statistics:

SELECT
  COUNT(*) as total_bookings,
  AVG(rating) as avg_rating,
  SUM(revenue) as total_revenue
FROM vendor_metrics
WHERE vendor_id = ?;

Prisma Schema Examples

model Vendor {
  id          String   @id @default(cuid())
  email       String   @unique
  name        String
  category    VendorCategory
  description String?
  phone       String?
  location    Location?
  services    Service[]
  bookings    Booking[]
  reviews     Review[]
  portfolio   Media[]
  status      VendorStatus @default(PENDING)
  createdAt   DateTime @default(now())
  updatedAt   DateTime @updatedAt
}

model Service {
  id          String   @id @default(cuid())
  vendorId    String
  vendor      Vendor   @relation(fields: [vendorId], references: [id])
  name        String
  description String
  basePrice   Float
  category    String
  features    String[]
  bookings    Booking[]
}

Vendor Metrics & Analytics

Key Performance Indicators (KPIs)

Response Metrics:

• Average response time
• Response rate
• Conversion rate (inquiries to bookings)

Performance Metrics:

• Total bookings
• Revenue generated
• Average booking value
• Repeat customer rate

Quality Metrics:

• Average rating
• Number of reviews
• Customer satisfaction score
• Complaint rate

Engagement Metrics:

• Profile views
• Inquiry volume
• Portfolio engagement
• Social media following

Reports to Generate

1. Monthly Performance Report

   • Total bookings and revenue
   • New vs. returning customers
   • Top-performing services
   • Rating trends

2. Vendor Comparison Report

   • Performance vs. category average
   • Pricing competitiveness
   • Response time benchmarks

3. Availability Report

   • Upcoming availability
   • Peak booking periods
   • Capacity utilization

Vendor Portal Features

Dashboard Components

Overview Section:

• Total inquiries (pending/active)
• Upcoming bookings
• Recent reviews
• Revenue summary

Calendar Section:

• Availability calendar
• Booked dates
• Pending bookings
• Blocked dates

Messages Section:

• Inbox (client inquiries)
• Sent messages
• Automated notifications

Analytics Section:

• Performance metrics
• Booking trends
• Revenue analytics
• Rating history

File Structure for Vendor Data

vendors/
├── {vendorId}/
│   ├── profile.json
│   ├── services.json
│   ├── portfolio/
│   │   ├── image1.jpg
│   │   ├── image2.jpg
│   │   └── videos/
│   ├── contracts/
│   │   └── agreement.pdf
│   └── documents/
│       ├── license.pdf
│       └── insurance.pdf

Error Handling

Common Error Scenarios:

1. Duplicate Vendor Registration

   • Check: Email already exists
   • Action: Prompt to log in or recover account

2. Invalid Business Information

   • Check: Business license validation
   • Action: Request manual verification

3. Portfolio Upload Issues

   • Check: File size, format, content
   • Action: Provide clear error messages and guidelines

4. Availability Conflicts

   • Check: Double bookings
   • Action: Alert vendor and suggest alternatives

5. Payment/Pricing Errors

   • Check: Valid pricing ranges
   • Action: Validate before saving

Security Considerations

Authentication:

• Secure password requirements
• Two-factor authentication (optional)
• Session management

Authorization:

• Role-based access control
• Vendor can only access own data
• Admin override capabilities

Data Protection:

• Encrypt sensitive information
• Secure file uploads
• Audit logs for data changes
• GDPR compliance for personal data

Integration Points

Payment Processing:

• Vendor commission calculation
• Payout schedules
• Transaction history

Calendar Integration:

• Google Calendar sync
• iCal export
• Availability sync

Communication:

• Email notifications
• SMS alerts
• In-app messaging

Analytics:

• Google Analytics integration
• Custom tracking events
• Performance dashboards

Quick Reference Commands

Add new vendor: Check for required fields, validate business info, create vendor record

Update vendor profile: Validate changes, update database, notify vendor of changes

List vendors by category: Query database with filters, apply sorting, return paginated results

Generate vendor report: Aggregate metrics, calculate KPIs, format report, export as PDF/Excel

Send vendor notification: Select template, personalize content, queue for delivery, track status

Manage vendor availability: Update calendar, check conflicts, send confirmations, sync with external calendars