1. Requirement Overview

The client’s website is developed on the WordPress platform and utilizes the Ultimate Auction Pro plugin to manage auction-based products and bidding activities. Over time, as auctions expire, a large amount of bid data gets accumulated in the system. This can lead to increased database size and may impact overall website performance, especially on auction-related pages.

To address this, the client requires a custom functionality that enables the removal of unnecessary bid data specifically for expired auctions. The goal is to optimize data storage and improve performance while ensuring that critical business data—such as orders and winning bid information—remains unaffected and intact.

  1. Customer Requirements

The client is looking for a structured and flexible solution that allows administrators to manage and delete bid data efficiently from the backend (admin panel). The feature should be easy to use, filter-based, and safe in terms of preserving important records.

Add a new feature on the admin side to delete bids, which includes:

  • Deleting bids for auction products that ended before a specified time period
     (e.g., after 10 days, 20 days, 30 days… up to 90 days, etc.)
  • Filtering by product type:
     (Simple, Proxy, or Silent)
  • Filtering by auction categories:
     (Category selection)

Bid Deletion Logic
 Once the admin submits the form with the selected filters:

  • All bids associated with the selected auctions should be deleted
  • The winning bid must be retained and should not be deleted under any condition

 Condition for Execution
 This functionality should only be applied to auctions where a winner has already been declared.

  • Auctions without a declared winner must be excluded from this process

 

  1. Technical Approach

We will develop a new custom plugin to enable deletion of bid history for won auctions. The implementation will be designed to function independently, ensuring it does not impact the existing auction plugin, while also maintaining compatibility with updates to the latest version of the plugin.

  1. Effort — Development

4.1 Development

  • Develop a new custom plugin to introduce the required functionality.
  • Ensure the feature is accessible from the admin (backend) panel.
  • Create a form that allows administrators to delete bid data based on selected criteria.
  • Implement logic to process and delete bids according to the configured filters.

Estimated effort: 9 hours

4.2 Testing

  • Test the bid history deletion functionality thoroughly.
  • Verify that all parameters are correctly passed and processed during form submission.
  • Ensure that the winning bid remains unaffected after the deletion process.

Estimated effort: 2 hours

  1. Effort Snapshot

 

# Activity Hours
1 Development 9 hours
2 Testing 2 hours
TOTAL 11 hours

 

  1. Deliverables

The following deliverables will be provided as part of this task:

  • Install, test and deployed it on client’s server

 

  1. Commercials & Payment

Final Cost

  • Total Estimated Effort: 11 hours
  • Hourly Rate: USD 45 / hour
  • Total Cost: USD 495