Auctions for WordPress

Adds an Items CPT along with an Auction taxonomy. Together, these provide the means for displaying auction catalogs with WordPress.

Description

This plugin supports the display of large, multi-item auctions. Each Item post features a gallery of high-resolution images allowing site visitors to easily view and assess auction items.

Changelog

3.2.0

• New: Auction Importer Audit tool - Review and fix auctions for image sets that are missing a clear ordering of images.

3.1.0

• New: background auction importer. Imports now run on the server via a job queue (WP_Background_Process) instead of the browser, so a large sale (200+ lots, 15–30 images each) can be started and then left to finish on its own — the admin tab no longer has to stay open. This replaces the previous browser-driven importer, which fired all of a lot's image requests in parallel and could exhaust the PHP-FPM worker pool (HTTP 499s) on large imports. Each queued job does one unit of work at a time (import an item, then one image), so processing is sequential and gentle on the server. Imports are idempotent — re-running safely updates existing items and skips already-attached images.
• New: live progress card on the Import Auction screen — a two-phase progress bar (items, then images), Items / Images / Skipped / Failed counters, a live "now processing" line, elapsed time, and an expandable list of any failures. The card updates in place (no flicker) and auto-resumes if the page is reloaded, or opened on another device, while an import is running.
• New: Pause / Resume and Cancel controls. Pause preserves the queue and Resume continues exactly where it left off (elapsed time excludes the paused span); Cancel abandons the remainder of the queue. Work already imported is always kept.
• Note: relies on a real system cron (WP-Cron disabled) so the queue's health-check can restart a stalled import. The UI styling follows the WordPress admin palette.

3.0.3

• WordPress 6.9 compatibility: fixed next/previous lot navigation on single Item pages (the .item-nav-fixed links were rendering empty). WordPress 6.9 moved the post_date comparison in get_adjacent_post() into a leading parenthesized group with a new p.ID tie-breaker (WHERE (p.post_date <op> 'D' OR (p.post_date = 'D' AND p.ID <op> N)) AND p.post_type = ...). The previous WHERE-stripping regex in AuctionItem::item_nextprev_item_sql() no longer matched that group, so the date filter survived and excluded the lot-adjacent item; rewrote it to anchor on the )) AND p.post_type boundary and drop the date group, leaving navigation ordered purely by _lotnum.
• Fixed the ORDER BY alias in AuctionItem::item_orderby_sql(). get_meta_sql() aliases a single meta clause as the meta table name itself (e.g. wp_postmeta), not mt1 — referencing mt1 produced an "Unknown column" SQL error and a null result. Restored the $wpdb->postmeta alias.
• Hardened the adjacent-post SQL filters with defensive guards (empty()/isset() checks, returning an empty string instead of false).

3.0.2

• Updating npm build process.
• Updating README.md build. Now we run npm run readme.
• Adding mobile styling adjustments for DataTables GUI at resolutions <= 500px.

3.0.1

• Updating plugin_row_meta filter to detect new root filename of this plugin.

3.0.0

• Breaking change: Renaming root file to match WordPress naming conventions (auctions.php to auctions-and-items.php). After you update this plugin, it will be deactivated in the WordPress admin. You will need to reactivate it.
• Updating plugin author meta data.

2.1.3

• Adding custom meta data links to the plugin's display in the WordPress Plugins admin listing.

2.1.2

• Propertly handling isHighlight values when importing Auction Item CPT CSVs. Previously, if the isHighLight column existed, the _highlight meta field would be set to true.

2.1.1.1

• Updating id value to auction-importer-upload-instructions-help so that "Upload Instructions" section will load for "Import Auction" contextual help.

2.1.1

• Adding "Upload Instructions" documentation.
• Updating source code documentation for "NO LOT" entries.

2.1.0

• Handling "dirty data" in Auction Import CSVs.

2.0.1

• Allowing AuctionsAndItems::init_options() to be called statically so as to prevent an error on activation.

2.0.0

• Auction Importer improvements:
  • Refactoring import to ignore missing columns. If a column is missing when updating an auction item, no processing is performed for that particular column.
  • The importer now treats columns in a case-insensitive fashion.
  • Adding "Item No." as a unique key for auction items.
• Adding "Hammer Price" as Item CPT meta.
• Checking if Composer autoloader has already been loaded

1.9.0

• Adding LotBiddingURL option for CSV imports.

1.8.7

• Adding data-filter attr to highlights table to enable filtering.* Loading images from production when viewing on .local.

1.8.6

• BUGFIX: Auction Importer was checking for isHighLight (with a capital "L") instead of isHighlight.

1.8.5

• Updating importer's docs.

1.8.4

• Accomodating CategoryName or Categories as the column heading for "Categories".

1.8.3

• Updating CSV column name from CategoryName to Categories.

1.8.2

• Updating CSS pre-processor to SCSS, moving build process to NPM.
• Building README via grunt readme.
• Adding auction viewer overlay logo.

1.8.1.1

• Checking if Provenance and Condition fields have content before adding to Item description.

1.8.1.0

• Removing StartPrice from Item Importer.* Updating importer to work with Caspio CSV export.

1.8.1

• Removing Genesis Theme dependency when retrieving first attachment image for an Auction Item.
• Setting has_archive to true for Auction Items so that we can build archives for auctions in Elementor.
• Removing email from Auction Highlights note, adding link to Selling page.

1.8.0

• Adding wp items unsold for managing "Unsold" items.

1.7.1

• Removing legacy Auction Taxonomy Option fields.

1.7.0

• Adding "Realized" column to Item CPT admin listing.

1.6.0

• Adding show_search and show_notes options for [highlights] shortcode.

1.5.0

• Replacing Flare Lightbox with Featherlight.

1.4.1

• Updating AuctionShortcodes::get_gallery_image() to use wp_get_attachment_image_src() to retrieve the Auction Item's first attachment image source URL.

1.4.0

• Adding LiveAuctioneersID column to Auction Items CSV import.

1.3.0

• Deleting item image attachments during item delete

1.2.0

• Adding Item Tags custom taxonomy
• Adding Bidsquare lot numbers to auction import

1.1.0

• Adding Next/Previous navigation to items.
• Table and List view options for Auction archives.
• Enhanced table view for Auction Highlights shortcode.

1.0

• Initial version ported from code integrated inside a WordPress theme.

Misc

Reminder: Generate the Markdown version of this readme by running npm run readme.