Sellinor Expiration Dates for WooCommerce
| 开发者 | sellinor |
|---|---|
| 更新时间 | 2026年9月12日 23:01 |
| PHP版本: | 7.4 及以上 |
| WordPress版本: | 7.1 |
| 版权: | GPLv2 or later |
| 版权网址: | 版权信息 |
详情介绍:
Sellinor Expiration Dates for WooCommerce adds expiration date tracking to WooCommerce, so a shop selling perishable or time-sensitive stock always knows what is about to go out of date — and never sells something past it.
Whether you call it an expiration date, an expiry date, a best before date, a use by date, or simply shelf life, it works the same way: set the date on a product or an individual variation, choose what should happen when that date arrives, and let the plugin handle the rest — hiding expired products from your catalog or marking them out of stock automatically.
It is built for food shops and grocery stores, bakery and fresh produce, dairy and meat, drinks, supplements and cosmetics, pharmacy and medical supplies — or anything else with a limited shelf life.
Features
- Expiration date tracking — Add expiration dates to any simple or variable product from a dedicated Expiration tab in the product editor.
- Automatic expiry actions — Automatically hide expired products, set them to out of stock, or both. Configurable days-before threshold so the action triggers ahead of the actual date.
- Cart and checkout protection — When an expiry action is enabled, expired items are blocked from being added to the cart and are removed at checkout, so customers can't purchase products past their date. (With the action set to "Do nothing", no cart guarding is applied.)
- Product list column — Sortable, color-coded expiration column in the WooCommerce product list for at-a-glance status.
- Dashboard widget — See your soonest-expiring products right from the WordPress dashboard.
- Reports — Overview page with an expiration calendar, an at-a-glance product list, and Expired / Expiring soon filter tabs.
- CSV import/export — Bulk manage expiration dates via a dedicated CSV import / export page.
- Activity log — Track all automatic plugin actions (stock changes, edits, imports); entries older than 90 days are cleaned up automatically.
- Quick edit & bulk edit — Update expiration dates directly from the product list without opening each product.
- Frontend display — Optionally show the expiration date on the product page, with a configurable display threshold.
- WooCommerce HPOS compatible — Full compatibility with High-Performance Order Storage.
- Batch & lot tracking (FEFO) — track stock by batch/lot with per-batch expiry dates and earliest-expiry-first deduction, with the fulfilled lot shown on orders and emails.
- Automatic expiry discounts — apply tiered discounts as products approach their expiration date.
- Per-category rules & shelf life — different expiry actions, lead times, and minimum shelf life per category, with automatic dating from a default shelf life.
- Clearance category — short-dated, discounted stock gathers itself into a self-maintaining storefront category.
- Waste, recovery & forecast reports — value written off vs recovered, monthly trends, category breakdown, and what expires in the next 7/30/60 days, with CSV export.
- One-click stock actions — extend dates, re-date, or write stock off straight from the Overview, per product or in bulk.
- Email alerts & digests — scheduled emails listing products expiring soon, including your waste and recovery numbers.
- Event webhooks — signed JSON to Slack, Zapier, Make, or your own systems whenever expiry events happen.
- WooCommerce CSV integration — read/write expiration dates in WooCommerce's native product importer and exporter.
安装:
- Upload the
sellinor-expiration-dates-for-woocommercefolder to the/wp-content/plugins/directory, or install the plugin through the WordPress Plugins screen. - Activate the plugin through the Plugins screen in WordPress.
- Make sure WooCommerce is installed and active.
- Navigate to Products > Expirations to configure your settings.
- Edit any product and open the Expiration tab to set an expiration date.
屏幕截图:
常见问题:
Can I use it for best before, use by or sell by dates?
Yes. The plugin stores one date per product or variation and acts on it — what you call that date is up to you. Whether your stock is labelled "best before", "use by", "sell by" or "expires on", the behaviour is identical: the date drives whichever expiry action you configure.
Does this plugin require WooCommerce?
Yes. WooCommerce must be installed and active for this plugin to work.
What happens when a product expires?
You can choose from several actions in the plugin settings: hide the product from the catalog, set it to out of stock, or do nothing (manual control). You can also configure a "days before" threshold so the action triggers before the actual expiration date.
Can I set different expiration dates for product variations?
Yes. Each variation can have its own expiration date. If a variation does not have a date set, it inherits the parent product's expiration date. The product is only hidden when all variations are expired.
Can I import expiration dates in bulk?
Yes. The plugin includes a dedicated CSV import/export page under Products > Expirations > Import / Export where you can download every product with its current expiration date and re-upload the edited file.
Is the plugin compatible with WooCommerce HPOS?
Yes. The plugin declares full compatibility with WooCommerce High-Performance Order Storage (HPOS).
What does the activity log track?
The log records all automatic plugin actions: stock changes, imports, and manual date edits. Logs older than 90 days are automatically cleaned up.
Will my data be removed when I uninstall?
Only if you opt in. By default, settings and the activity log are preserved on uninstall in case you reinstall later. You can enable a "delete all data on uninstall" option in settings if you want a full cleanup.
更新日志:
1.5.4 - 2026-09-12
- Tested up to WordPress 7.1.
- Refreshed the plugin directory assets: new screenshots, banner and icon.
- Fixed: a momentary product-load failure during the hourly expiry sweep no longer skips a variable product's expired variations for the rest of the day — it retries on the next run.
- Improved: the Overview "inventory at risk" estimate now consistently excludes variable products whose variations use batch/lot tracking (Pro) from the single-date sum, since those lots are already valued precisely.
- Fixed: batch/lot-tracked products (Pro) could be hidden from the catalog while later lots were still sellable — the derived visibility dates now respect batch tracking everywhere and clear themselves.
- Fixed: expiration-date writes to batch-tracked products via quick edit, CSV imports, the REST API, and WP-CLI are now cleanly skipped or rejected instead of being silently reverted by the next batch sync.
- Fixed: the Overview "inventory at risk" figure now values batch-tracked products by their actually-expiring lots instead of their entire stock.
- Fixed: quick-set date preset chips now compute from the store's timezone rather than the browser clock.
- Security: CSV exports (Activity Log, Pro Waste & Recovery) now neutralize spreadsheet formula injection in free-text cells.
- Performance: the hourly expiry sweep no longer re-scans every previously-expired variable product on every run.
- Performance: the Products-list expiration column and the Overview calendar each dropped their per-row/per-page query overhead on large catalogs.
- Improved: the Pro features page, comparison table, and settings previews now describe the full current Pro feature set; screen-reader labels on the waste/recovery trend cards.
- Dev: uninstall cleanup now covers the event-webhook options and the waste-sweep cron.
- Improved: a report search with no matches on the current tab now links straight to the matches on the other tab ("Found 2 in Expired") instead of dead-ending at zero.
- Added: search the Overview report by product name or SKU, and sort it by product name or expiration date (click the column headers).
- Added: the WooCommerce REST API products endpoint accepts edfw_expires_before / edfw_expires_after filters, so external systems can pull everything expiring in a window in one call.
- Added: WP-CLI commands — wp edfw get / set / clear / list (with expiring-window flags and table/csv/json/ids/count output) for hosting automation and bulk scripting.
- Added: product-editor quick-set date chips (+1 week / +1 month / +3 months / +1 year) and, on variable products, one-click "apply this date to all variations" / "clear all variation dates" tools (batch-tracked variations are respected and skipped).
- Added: export the Activity Log as CSV, respecting the on-screen filters.
- Added: a maintenance tool that previews and moves long-expired products to the trash (reversible; variable products only qualify when every variation has long expired), with each product logged.
- (With the Pro add-on) the digest email now includes the value at risk in the next 7/30 days alongside its waste summary, and a new event webhook POSTs signed JSON (Slack/Zapier-compatible, batched per request) whenever expiry events happen.
- Improved: the Activity Log lists entries in a fully deterministic order, and search/sort/filters carry correctly across pagination.
- Added: a getting-started guide on the Overview for new installs — choose your expiry action, add your first dates (product editor, quick edit, or CSV import), and track everything from the dashboard. It disappears on its own once real data exists (dismissible per user, and controllable via the edfw_show_onboarding filter).
- Added: the expiration date is now a first-class field (edfw_expiration_date) on the WooCommerce REST API products and variations endpoints, so POS/ERP systems and scanner workflows can read and write dates programmatically. The field appears in the endpoint schema, invalid dates are rejected with a clear error on every route (batch endpoints included), null or an empty string clears the date, and every change is recorded in the Activity Log as "API: date set/cleared".
- Improved: the Activity Log filter now offers every recorded action type (including stock write-offs), and API entries carry their own icon.
- (With the Pro add-on, the Reports tab additionally gains a 6-month waste-vs-recovery trend, a per-category loss breakdown, and a CSV export of the raw waste and recovery events.)
- Added: the Activity Log now records expiration-date changes made via quick edit and on individual variations (previously only product-editor edits were logged), with the edit source stored on every entry.
- Added: extension points that let add-ons set per-product expiry behaviour — an effective-policy filter consulted by purchasability, cart validation, the out-of-stock sweep and the catalog hide logic, a per-product frontend display filter, page-tab registration, and Overview hooks for extra report cards. (These power the Pro add-on's new per-category rules, clearance category, waste reporting and Reports tab; without the add-on, behaviour is unchanged.)
- Improved: catalog hiding now uses a precomputed per-product "hide from" date (maintained automatically and backfilled on update), keeping shop queries fast and exact — including for variable products — and self-healing hourly if it ever drifts.
- Improved: related-products filtering now uses the exact same hide date as the shop catalog, so the two can never disagree.
- Improved: the Overview products card no longer reserves excess empty space below short filtered lists.
- Hardening: includes all WordPress.org review hardening from 1.2.2–1.2.4 (fully prepared activity-log queries, plugin-API-based add-on detection, broadened input sanitization and output escaping). No change to features or behavior.
- Hardening: rewrote the activity-log queries to use fixed, fully prepared statements (no interpolated SQL), switched plugin-presence detection to WordPress's plugin API instead of filesystem path construction, and clarified that the Pro add-on is a separate plugin with no license check in the free plugin. No change to features or behavior.
- Hardening: broadened input sanitization (file uploads, request URI, settings POST), output escaping, and prepared-statement coverage on the activity-log queries, and switched to FILE-based path resolution, for WordPress.org review compliance. No change to features or behavior.
- Maintenance: version kept in sync with the separately distributed Pro add-on release; no functional changes in the free plugin. (The Pro add-on's one-click "install the free base plugin" helper now falls back to the publisher-hosted download when the WordPress.org listing isn't reachable.)
- Maintenance: version kept in sync with the separately distributed Pro add-on release; no functional changes in the free plugin.
- Added: theme-proof on-product display — when a customized theme doesn't fire the standard product summary hook, the expiration date now renders via the add-to-cart form area instead (never duplicated on standard themes).
- Added: an [edfw_expiration_date] shortcode for manual placement in page builders and fully bespoke templates (optional id attribute; suppresses the automatic placement on that product's page; works even with the display toggle off).
- Improved: the "Show on product page" setting now explains placement and points to the shortcode for heavily customized themes.
- Improved: consistent wording across the Pro hints — every mention now says "the Pro add-on" instead of a bare "Pro" as the sentence subject (product editor, Overview hint, Import/Export note, Pro Features page).
- Improved: clearer wording on the Overview email hint ("Get this report by email — Pro sends you an expiring-products digest daily, weekly, or monthly.").
- Improved: the page title and header Upgrade button are now centered by flex layout instead of pixel offsets, so the header renders identically regardless of other plugins' admin styles, fonts, or zoom level.
- Added: an
edfw_hide_single_date_fieldfilter so add-ons that derive the expiration date themselves can start the manual date field hidden in the product editor.
- Maintenance: version kept in sync with the separately distributed Pro add-on release; no functional changes in the free plugin.
- Fixed: the help "?" icon next to the expiration date field is now vertically centered with the input (WooCommerce's default tip offset is sized for its shorter fields).
- Improved: every "Upgrade to Pro" button now renders at exactly the same size as the header upgrade button — the preview-panel and Pro Features page buttons previously used larger WordPress button sizes.
- Improved: the Pro preview panels (Notifications/Discounts) now span the full content width and start flush with the tab bar, exactly like the regular settings cards — previously they were capped at 640px and offset 16px lower.
- Improved: wider, hard-enforced equal tabs in the settings navigation (200px minimum on every tab, asserted with priority so nothing can shrink the Pro preview tabs below the others).
- Fixed: the settings tabs now keep their equal widths at every window size — below 960px wide they previously collapsed back to unequal natural widths; the tab rail now scrolls horizontally instead when space runs out.
- Fixed: the equal-width settings tabs now render identically in every browser — the previous approach relied on a CSS grid behavior that differs between Chrome, Safari, and Firefox.
- Improved: the settings tabs now render as a segmented control — every tab has the same width with a centered label, on free and Pro installs alike (natural-width pills wrap on small screens).
- Improved: the settings tab row now keeps every tab at the same height (the PRO preview pills no longer sit ragged against the plain tabs), and the Pro panel icon chip and buttons share the header button's corner radius for a consistent look.
- Improved: polished the Pro preview panels (icon now sits inline with the section title in a gradient chip), the header Upgrade button aligns with the page title, and all upsell buttons keep their gradient on hover instead of falling back to the admin color scheme.
- Improved: button icons (Copy, Download, Clear all logs) are now inline SVGs instead of icon-font glyphs — exact geometric centering on every display, no more font-baseline alignment drift.
- Improved: all admin button icons now render on the Dashicons-native 20px grid with flex centering — sub-native sizes landed glyphs on fractional pixels, which read as misalignment (System Info, Activity Log, and settings buttons).
- Improved: crisper button icons on the System Info and Activity Log screens (straight "copy" glyph, consistent sizing and optical alignment).
- Maintenance: version kept in sync with the separately distributed Pro add-on release; no functional changes in the free plugin.
- Fixed: the Overview's "inventory at risk" query no longer depends on a relaxed MySQL mode, so it works on hosts that enforce ONLY_FULL_GROUP_BY.
- Fixed: changing the "expiring soon" threshold for the first time now refreshes the cached Overview counts immediately.
- Improved: dropping a CSV onto the import box now stages the file for review — the import runs when you click Import CSV, never on the drop itself.
- Improved: the activity-log clear action fails quietly on a missing security token instead of stopping the whole page.
- Improved: the Overview statistics are now cached briefly and the inventory-value calculation is bounded, so the dashboard loads noticeably faster on large catalogs.
- Improved: dropping a CSV onto the import box now submits through the standard form flow, which is more reliable across browsers.
- Improved: clearing the activity log now redirects after the action, so refreshing the page can no longer re-submit it.
- Security: the CSV importer now also inspects the uploaded file's content (not just its extension) and rejects files that are clearly not CSV.
- Fixed: the uninstall cleanup matches the plugin's own post meta exactly and skips WooCommerce-specific cleanup when WooCommerce's tables are already gone.
- Added: preview pages for the Pro add-on's Notifications and Discounts settings sections (shown only when the separate Pro add-on is not installed).
- Fixed: the admin "Site timezone" status now reads correctly (e.g. "UTC" or "America/New_York") instead of a doubled "UTCUTC", and the "expiring soon threshold" status reads "1 day" instead of "1 days".
- Added: the on-product expiration date now also displays on block themes that use WooCommerce's block-based single-product template (for example the default Twenty Twenty-Four / Twenty Twenty-Five themes) — it appears just after the product price. Classic WooCommerce themes are unchanged.
- Security: the "Expiring products" dashboard widget is now shown only to users who can manage WooCommerce, so other roles can no longer see product stock levels.
- Maintenance: a malformed import row's date value is now truncated in the error notice, removed some dead admin CSS, and minor internal cleanups.
- Fixed: the "Clear all logs" confirmation prompt now works in translated languages whose text contains an apostrophe (previously the confirmation could be skipped in, for example, French).
- Improved: the dashboard widget skips impossible stored dates, and the active tab and settings section are announced to screen readers.
- Maintenance: small internal cleanups.
- Improved: the System Info report and the dashboard "with dates"/"expired" counts now ignore impossible stored dates (e.g. a corrupt "2025-02-29"), so every screen agrees.
- Improved: a variation whose stored date is corrupt now shows no date rather than a wrong one on the product page, consistent with the rest of the plugin.
- Maintenance: refreshed the translation template, removed dead code, and fixed a misleading code comment.
- Fixed: upgrading from a much older version now reliably carries a previously enabled "automatically hide expired products" setting over to the current expiry-action control.
- Maintenance: documentation, internationalization, and accessibility polish.
- Fixed: changing a variable product to a simple product now clears its leftover synced expiration date so it no longer shows a date it doesn't really have.
- Improved: a clearer cap on long import error lists; small accessibility, consistency, and security-log refinements.
- Maintenance: removed dead code and consolidated duplicated logic across the plugin.
- Improved: corrupt stored dates are handled consistently across display, reports, and import; the weekday initials in the calendar header now translate independently per day.
- Maintenance: accessibility, internationalization, security, and documentation polish; removed dead code and consolidated duplicated logic.
- Improved: dashboard report counts and the calendar load more efficiently and consistently exclude impossible stored dates.
- Improved: a corrupt stored date can no longer produce a wrong reformatted date or an empty badge; recipient and settings values are validated and clamped defensively.
- Maintenance: accessibility (announced toasts), documentation, and security log-hygiene fixes; removed dead code. The full changelog, including the separate Pro add-on, is available at sellinor.dev.