In the previous lesson, we implemented the ability to manually activate auctions whose scheduled start time had arrived. That completed the first half of the auction lifecycle.

Now it’s time to implement the second half.

When an auction reaches its scheduled end time, it should no longer accept bids. Instead, it should automatically move from Active to Closed.

In this lesson, we’ll build the first version of that functionality using a manual administrator action. Later, we’ll automate the entire process using WP-Cron.

What You Will Learn

By the end of this lesson, you will know how to:

• Create a function to close expired auctions.
• Update multiple auctions using a single SQL query.
• Add a “Close Expired Auctions” button to the dashboard.
• Secure administrator actions using WordPress nonces.
• Display success messages after processing.
• Prepare your plugin for automatic auction management.

Why Closing Auctions Matters

Every auction platform needs a clearly defined lifecycle.

Draft
   │
   ▼
Active
   │
Auction End Reached
   ▼
Closed

Once an auction is closed:

• No more bids should be accepted.
• The winner can be determined.
• Escrow payment can begin.
• Ownership transfer can be initiated.

Without a closing mechanism, auctions would remain active indefinitely.

What We Will Build

We’ll implement a new manager function:

Flipnzee_Auction_Manager::close_expired_auctions();

This function will:

• Find auctions where:
  • Status = Active
  • Auction End has passed
• Update their status to:

closed

Dashboard Improvements

The Flipnzee Auctions dashboard will receive another administrator tool.

Activate Scheduled Auctions

Close Expired Auctions

This allows administrators to manually manage the auction lifecycle during development.

Security

Like previous admin actions, this feature will include:

• Capability checks
• WordPress nonces
• Safe redirects
• Administrator-only access

Following WordPress security best practices keeps the plugin production-ready.

Why Manual Closing First?

Eventually, this process should happen automatically.

However, implementing manual closing first offers several advantages:

• Easier debugging
• Faster testing
• Immediate verification
• No dependency on scheduled cron events

This incremental approach reduces complexity while ensuring each component works correctly.

Database Changes

No database changes are required.

We already have everything needed:

• Auction Status
• Auction End
• Current WordPress time

We’ll simply update qualifying rows.

Expected Workflow

Administrator clicks

Close Expired Auctions
        │
        ▼
Plugin checks all auctions
        │
        ▼
Auction End <= Current Time?
        │
      Yes
        │
        ▼
Status changes:
Active → Closed

Production Benefits

By completing this lesson, the plugin will support nearly the entire auction lifecycle:

• ✅ Draft auctions
• ✅ Scheduled auctions
• ✅ Active auctions
• ✅ Closed auctions

This is another major milestone toward transforming Flipnzee Auctions into a production-grade marketplace plugin.

Implementation Lesson 36: Automatically Close Expired Auctions in Flipnzee Auctions

What Comes Next?

In the next lesson, we’ll improve the administrator experience by adding auction statistics to the dashboard, including:

• Total Auctions
• Draft Auctions
• Active Auctions
• Closed Auctions
• Scheduled Auctions

These live statistics will give administrators an instant overview of marketplace activity and prepare the dashboard for future analytics and reporting.

Over the past few lessons, we’ve transformed Flipnzee Auctions from a simple CRUD plugin into something that feels much closer to a production-ready auction system. Auctions can now store start and end dates, and those dates are visible throughout the admin interface.

However, there is still one important limitation.

Even if an auction’s scheduled start time has already passed, it remains in Draft status until an administrator manually edits it and changes the status to Active.

In a real auction platform, this would quickly become unmanageable. Administrators should not need to monitor dozens or hundreds of auctions throughout the day.

In this lesson, we’ll begin automating the auction lifecycle.

What We’ll Build

By the end of this lesson, Flipnzee Auctions will automatically activate auctions when:

• the auction is currently Draft
• a valid Auction Start date exists
• the scheduled start time has already passed

No manual intervention will be required.

Why This Matters

Automation is one of the defining characteristics of a professional auction platform.

Instead of relying on administrators to remember when auctions should begin, the software makes the decision automatically.

Benefits include:

• fewer administrative tasks
• fewer human errors
• auctions always start on time
• improved buyer confidence

Understanding the Workflow

Current workflow:

Create Auction
      ↓
Status = Draft
      ↓
Administrator edits auction
      ↓
Changes status to Active

After this lesson:

Create Auction
      ↓
Status = Draft
      ↓
Scheduled start time arrives
      ↓
Plugin activates auction automatically

How WordPress Makes This Possible

WordPress includes a scheduling system called WP-Cron.

Rather than requiring access to the server’s operating system scheduler, WordPress performs scheduled tasks whenever someone visits the website.

Examples include:

• publishing scheduled posts
• clearing caches
• sending emails
• updating plugin data

We’ll use the same idea for auctions.

Our Strategy

Instead of checking every second, we’ll create a function that periodically searches for auctions that meet all of these conditions:

Status = Draft

AND

Auction Start <= Current Time

For every matching auction:

Draft
      ↓
Active

Simple, reliable, and scalable.

SQL Logic

Conceptually, our database query will look something like:

SELECT *
FROM wp_flipnzee_auctions
WHERE status = 'draft'
AND auction_start <= CURRENT_TIME;

Each returned auction will then be updated to:

status = active

Where We’ll Add the Code

To keep the plugin organized, we’ll place this functionality inside the auction manager rather than mixing business logic into the admin interface.

That keeps responsibilities separated:

• Database → stores auction data
• Auction Manager → controls auction lifecycle
• Admin Pages → display forms and tables

Testing Strategy

We’ll create a draft auction with:

Start Time:
2 minutes from now

Then we’ll wait until that time passes.

Expected result:

Before:

Status
Draft

↓

After:

Status
Active

without editing the auction manually.

Future Improvements

This lesson lays the foundation for additional automation.

In upcoming lessons we’ll also automate:

• closing auctions automatically
• determining winners
• preventing bids after auction ends
• countdown timers
• bid history
• email notifications
• Escrow.com integration

Each of these features will build upon the scheduling mechanism introduced here.

What You’ll Learn

In this lesson, you’ll learn how to:

• use scheduled tasks in WordPress
• automate changes based on time
• update auction status programmatically
• separate business logic from presentation logic
• build a more production-ready auction platform

Conclusion

Manually changing auction statuses may work during early development, but it doesn’t scale for a real marketplace. By introducing automatic activation based on the scheduled start time, Flipnzee Auctions becomes significantly more autonomous and dependable.

In the next lesson, we’ll build on this automation by automatically closing auctions when their end time is reached, bringing the auction lifecycle one step closer to a fully hands-free experience.

Series: Building the Flipnzee Auctions WordPress Plugin
Lesson: 33
Difficulty: Intermediate

Introduction

Up to this point, our Flipnzee Auctions plugin allows administrators to create, edit, search, filter, and manage auctions from the WordPress dashboard. However, every auction becomes active immediately after it is created.

In a real-world marketplace, auctions usually begin and end at specific times. Sellers may wish to schedule an auction several days in advance, while buyers expect to know exactly when bidding starts and when it closes.

In this lesson, we’ll extend our auction system by adding Start Date/Time and End Date/Time fields. These scheduling options will become the foundation for many future features, including countdown timers, automatic activation, automatic closing, winner selection, and Escrow.com integration.

What You’ll Learn

After completing this lesson, you’ll know how to:

• Add datetime fields to the auction database.
• Update the database schema safely.
• Modify auction forms to support scheduling.
• Store start and end times securely.
• Display scheduling information in the admin table.
• Prepare the plugin for automatic auction management.

Why Auction Scheduling Matters

Without scheduling, every auction becomes active as soon as it is created.

This creates several limitations:

• Sellers cannot prepare future auctions.
• Buyers do not know when bidding begins.
• Auctions cannot close automatically.
• Countdown timers are impossible.
• Escrow workflows cannot be triggered automatically.

Scheduling solves all of these problems.

Real-World Example

Imagine a premium website is scheduled for auction.

Instead of starting immediately, the seller configures:

Auction Starts:
15 August 2026
10:00 AM

Auction Ends:
22 August 2026
10:00 AM

Visitors can view the auction before it starts, while bidding automatically opens at the scheduled time and closes exactly one week later.

Files We’ll Modify

During this lesson we’ll update:

includes/class-database.php

includes/class-auction-manager.php

admin/class-admin.php

admin/class-auctions-table.php

Database Changes

We’ll extend the auctions table by adding two new columns:

start_datetime

and

end_datetime

Both fields will store the auction schedule using MySQL’s DATETIME data type.

Admin Form Changes

The Add Auction screen will include two new fields:

• Start Date & Time
• End Date & Time

The Edit Auction screen will also allow administrators to update the auction schedule whenever necessary.

Auction List Improvements

The All Auctions table will display:

• Start Date
• End Date

This allows administrators to quickly see when each auction begins and ends without opening the edit screen.

Data Validation

We’ll also introduce validation rules such as:

• End date cannot be earlier than the start date.
• Both fields must use valid date/time values.
• Empty schedules should be handled gracefully.

These checks help prevent invalid auction configurations.

Future Features Enabled

Although this lesson focuses only on scheduling, it lays the groundwork for several upcoming capabilities.

Upcoming lessons will build upon these fields to implement:

• Automatic auction activation.
• Automatic auction closing.
• Live countdown timers.
• Winner selection.
• Email notifications.
• Escrow.com transaction creation.

Expected Result

After completing this lesson, administrators will be able to:

• Schedule auctions in advance.
• Specify exact opening and closing times.
• Edit auction schedules.
• View auction schedules from the listing table.

The plugin will be one major step closer to becoming a production-ready auction platform.

Security Considerations

Throughout this lesson we’ll continue following WordPress best practices by:

• Sanitizing all user input.
• Validating date and time values.
• Escaping output before displaying it.
• Updating the database safely without affecting existing auction records.

Conclusion

Auction scheduling is one of the most important features of any professional auction platform. Rather than activating auctions immediately, administrators can now define exactly when bidding begins and when it ends.

This enhancement not only improves the user experience but also establishes the technical foundation for automation throughout the remainder of the project.

With scheduling in place, Flipnzee Auctions will be ready for features such as automatic status changes, countdown timers, winner selection, and seamless Escrow.com integration.

Lesson 33 Implementation: Adding Auction Scheduling (Start & End Date/Time)

In the Next Lesson

In Lesson 34, we’ll use the newly added scheduling fields to automatically determine the auction status. Instead of manually choosing between Draft, Active, or Closed, the plugin will calculate whether an auction is Scheduled, Active, or Ended based on the current date and time, bringing the system one step closer to a fully automated auction marketplace.