WPMelon Advanced Bulk Edit for WooCommerce
| 开发者 | wpmelon |
|---|---|
| 更新时间 | 2026年8月24日 21:03 |
| PHP版本: | 8.0 及以上 |
| WordPress版本: | 7.1 |
| 版权: | GPLv2 or later |
| 版权网址: | 版权信息 |
详情介绍:
WooCommerce’s built-in product editor was not designed for bulk editing hundreds or thousands of WooCommerce products. Every price change, every stock update, every tiny fix means opening a product, scrolling, clicking, saving, and waiting for the page to reload.
WPMelon Advanced Bulk Edit replaces that workflow with a single spreadsheet-style grid. You filter to the products you care about, edit cells inline like in Excel or Google Sheets, and save everything at once.
It is built for people who manage their own catalog — shop owners, agencies, and freelancers who are tired of clicking through hundreds of product pages to update a price or fix a typo.
Why another WooCommerce bulk product editor?
This plugin takes a different approach — a fast, modern grid that lives inside your WordPress admin and talks directly to your WooCommerce data.
No rebuilding of your catalog on a third-party server. No syncing. Less waiting.
What you get in the free version
- Spreadsheet grid with inline editing — click a cell, type, move on
- Variations inline — expand any variable product and edit its variations as child rows, with the parent–child grouping preserved when you sort
- Fill handle — drag a cell down (or up) to copy its value to neighboring cells, Excel-style
- Bulk operations — apply percentage price adjustments, find-and-replace, text append and prepend, and bulk category and tag assignment across many products at once
- Wide field coverage — prices, stock, SKUs, statuses, categories, tags, shipping class, menu order, upsells and cross-sells, product URL and button text for external products, and more
- Saved views — save filter sets and column layouts as named views for one-click recall, and share them between sites with view import/export
- Filters — filter by category, tags, product type, stock status, name and SKU (with exact/contains match modes and CSV SKU lists), description, dates created, modified, on sale, or image uploaded, and more
- Column management — show, hide, reorder, resize, and pin columns; each user's layout is saved separately
- Keyboard shortcuts — navigate and edit without touching the mouse
- Product operations — duplicate and change status right from the grid
- Image and gallery management — set featured images and manage product galleries directly from the grid
- CSV export — export the current filtered view to CSV in one click, including large catalogs
- Dark mode — switch between light and dark themes
- Fast loading — virtualized rendering handles thousands of products without the browser choking, with a configurable page size
- Plays well with others — products from third-party type plugins (such as bundles or subscriptions) appear in the grid with their common fields editable, and an optional setting re-fires WordPress save hooks so sync and cache plugins stay in step
- WordPress 6.0+
- WooCommerce 10.0+
- PHP 8.0+
安装:
- In your WordPress admin, go to Plugins → Add New.
- Search for "WPMelon Advanced Bulk Edit for WooCommerce".
- Click Install Now, then Activate.
- Go to WooCommerce → Bulk Edit to open the grid.
- Download the plugin ZIP from WordPress.org.
- Go to Plugins → Add New → Upload Plugin and upload the ZIP.
- Activate the plugin.
- Go to WooCommerce → Bulk Edit.
屏幕截图:
常见问题:
Does this plugin modify my database directly?
No. All edits go through WooCommerce's standard CRUD API, so your data is handled the same way the core WooCommerce admin handles it. Hooks fire, caches are invalidated, and anything your other plugins do on product save continues to work.
Will it work with my theme?
Yes. The plugin runs inside the WordPress admin, so your front-end theme is not involved. It only loads its interface inside the WordPress admin and does not enqueue front-end assets.
Does it work with variable products and variations?
Yes. Variations appear as child rows under their parent product. You can edit variation prices, stock, SKUs, and other fields inline, the same way you edit simple products. Sorting preserves the parent–child grouping.
How many products can it handle?
The grid is virtualized, so it renders only the rows currently visible. In practice, stores with tens of thousands of products work fine on normal hosting. If you hit a performance wall, filter down to the subset you actually need — the grid works on whatever the filters return.
Can I undo changes?
Edits are staged as pending changes in the grid before you save, so you can undo them or discard them entirely while they're unsaved. Once saved, the free version can't undo them — keep a backup, as you would with any bulk operation. The Pro version adds Operation History, which records each save so you can review and restore previous field values (see below).
Is there a Pro version?
Yes. Pro adds paste from Excel/Google Sheets, Operation History with restore, regex find-and-replace, price rounding, custom and ACF meta field editing, custom taxonomies, bulk variation creation, variation attribute editing, WPML support, fine-grained selection tools for the current grid page, and more. It's available at wpmelon.com. The free version is a complete, standalone tool — Pro extends it, it doesn't gate it.
What does Operation History store? (Pro)
Operation History is a Pro feature, currently in beta and off by default. When you turn it on, each bulk save is recorded locally so you can review it later and restore previous field values. Each record stores the before and after values of the fields that save changed, the product and variation IDs involved, the user who made the change, and timestamps. The data lives in custom database tables on your own site and is never sent off-site. Records are kept for 30 days by default (configurable) and pruned automatically. You can turn recording on or off, clear the history at any time, and optionally have all history data removed when you uninstall Pro. The free version records nothing and creates no history tables.
Does it support custom post types?
The plugin targets WooCommerce products (including variations) specifically. Other post types are not supported.
Does it support ACF?
ACF field editing is a Pro feature. The free version edits WooCommerce core fields.
Does it talk to external servers?
No. The free version runs entirely inside your WordPress site. It does not send data to any third-party server.
What happens if I deactivate the plugin?
Nothing. No data is lost, no cleanup is needed. The plugin only reads and writes WooCommerce product data through standard APIs; deactivating removes the bulk-edit UI and nothing else.
更新日志:
1.2.0
- Added Cost of Goods (COGS) as an editable product column when WooCommerce's Cost of Goods Sold feature is enabled. Edit it inline or with the bulk-edit panel, filter products by a Cost of Goods range, and include it in CSV exports.
- Added a Published on column — show it in the grid, edit its full date and time inline, and bulk-edit it — plus a read-only Modified on column. Both are available in CSV export.
- Products with a future Published on date now appear in the grid as "Scheduled" (and can be filtered by that status) instead of being hidden from the default view.
- The Title filter now matches all words by default, with a choice of how multi-word searches behave. When you type two or more words, a mode dropdown appears: "All words" (the default) finds titles containing every word in any order, "Any word" matches titles containing at least one word, and "Exact phrase" matches the words exactly as typed.
- You can now include product attribute columns (such as Color or Size) in the CSV export. Open the Export dialog and tick the attribute columns you want — each cell lists the product's terms separated by " | ".
- Your column layout and filters are now remembered automatically across page reloads and navigation — no need to save a view first. If you have a default view, it's still applied on load; otherwise your last working layout is restored.
- Added a Default view at the top of the Views menu that resets your columns and filters to their defaults in one click. The old per-view "Set as default" star is retired — your working layout now persists on its own, and any existing default view is still applied on load.
- Switching views (or to Default) with unsaved column or filter changes now asks whether to Save, Disregard, or Cancel, so a modified layout isn't lost by accident. On the Default view the prompt lets you name and save the changes as a new view before switching.
- The Views button now shows "· Modified" when your columns or filters differ from the selected view (or the Default). Use Update to save the changes back to the view, or Revert to discard them; on the Default view, "Save as new view" lets you keep them as a brand-new view.
- Added Menu order as a product column. View it in the grid, edit it inline or with the bulk-edit panel, filter products by a menu order range, sort the whole catalog by menu order, and include it in CSV exports.
- Added Upsells and Cross-sells as editable product columns. Pick linked products from a searchable modal (by title, SKU, GTIN, or product ID), reorder them — WooCommerce shows them in the order you set — and bulk-edit them across a selection with Replace all, Add, or Remove. Both columns are available in CSV export. Links pointing at deleted products are shown as a warning rather than silently discarded, so you decide when to remove them, and a link to a draft or disabled product is flagged so you know it won't appear on your storefront. Cross-sells are editable on simple and variable products only, matching WooCommerce, which hides the field on grouped and external products because cross-sells are promoted in the cart.
- More products-per-page choices (250, 500 and 1000), plus a "Custom…" option for any page size up to 10,000. Your page size is now saved as part of your views, so it comes back with a saved view and survives a reload.
- Added Sale From and Sale To date-range filters. Variable products are included when one of their variations matches the sale schedule you filtered for, and only the matching variations are shown.
- Added a Tags filter. Pick one or more product tags to narrow the grid to products carrying any of them; it combines with all other filters and applies to CSV exports too.
- Added the Button text field for External/Affiliate products. View and edit the add-to-cart button label inline, change it with the bulk-edit panel (set, prepend, append, find & replace, clear), and include it in CSV exports.
- Added an "Image uploaded" filter and grid/CSV column showing when each product's featured image was uploaded. Filter by a date range to find products whose images changed since a given date — useful when syncing images between sites. Variations are matched on their own images, and the column is available in the column picker and CSV exports.
- Export any saved grid view as a JSON file or copyable text, and import a view exported from another account or site.
- Added support for third-party product types. WooCommerce Product Bundles products now appear in the grid with full inline and bulk editing (prices, stock, categories, images, and more), and other plugin-registered types (subscriptions, composites, etc.) show up with a safe set of editable fields. The Type filter and the grid's type badges show every registered product type under its own plugin-provided name. Variable-style third-party products (such as variable subscriptions) expand to show their variations, just like native variable products.
- Added a "Refresh list after saving" setting. Turn it off to keep edited products visible in the grid after saving — even when they no longer match the active filters — until you reload the list.
- Added a Product URL column for External/Affiliate products — show it in the grid, edit it inline and in bulk (including find & replace for affiliate domain migrations), and export it to CSV. A new Product URL filter finds products by their link, with contains, does not contain, starts with, ends with, is empty and is not empty modes.
- The SKU filter now has a match-mode dropdown: Contains, Is exactly, Does not contain, Starts with, and Ends with. Comma-separate several SKUs to match any of them under the chosen mode (or none of them, for "Does not contain"), up to 200 values. The dropdown starts on Auto, which keeps the original behavior — a single SKU is a partial match, comma-separated SKUs are exact matches — so existing saved views and searches are unchanged. Also fixed: searching for the SKU "0" now filters products correctly instead of being ignored.
- Added a compatibility setting that triggers the standard WordPress save hooks after each save, so sync and integration plugins detect changes made in the editor. Find it under "Notify other plugins of changes" in Settings — it is off by default, and the info button beside it lists exactly which hooks are fired.
- Added Shipping class as a product column. View it in the grid, edit it inline or with the bulk-edit panel — including a "Same as parent" option on variations — filter products by shipping class, and include it in CSV exports.
- Renamed the Created product filter to Published on to align with WordPress/WooCommerce publishing terminology, and renamed Modified to Modified on for consistency.
- The Published on, Modified on, Sale from, and Sale to filters now appear in the filter panel only when their columns are shown in the grid, like the other filters. A date filter that has a value set stays visible even when its column is hidden.
- Updated the Pro upgrade dialog with the latest Pro features (undo & rollback, paste from Excel, WPML support) and current early-bird pricing for annual and lifetime licenses.
- Fixed searching by a variation's SKU returning no results. When variations are shown in the grid, a SKU search now matches variation SKUs and displays the matching variation under its parent. Searching a product's own SKU keeps all of its variations visible.
- Fixed bulk-edit searches and saves failing after the page was left open for a long time. The page now refreshes its security token automatically, and shows a clear "session expired or permissions changed — reload" message in the rare case it can't recover.
- Fixed several Default-view and layout issues: selecting Default now restores columns you had hidden back to their factory visibility; deleting the view you're currently on returns you to Default and flags the layout as modified when it differs, instead of leaving a stale layout mislabeled as clean; and switching views no longer shows columns from your previous layout when "auto-load products" is turned off.
- Fixed the Views "· Modified" indicator disappearing when you chose "Update with current state" on a view other than the one currently selected.
- Fixed the Views "· Modified" indicator misbehaving: reverting a column change now clears it (previously it could stay stuck on), and re-selecting the same categories or filters in a different order no longer flags the layout as modified.
- Fixed the selected view being lost after a page reload — the active view is now correctly remembered instead of quietly reverting to Default on the next load.
- Fixed saving a new view before the product grid has loaded (with auto-load off) storing an empty column layout — a new view now captures your current columns in that case.
- Fixed column layout changes being silently discarded when updating a view while product auto-loading is turned off — the view now saves your columns, and the layout no longer keeps showing as modified afterward.
- Cancelling a bulk save (or restore) while a batch was mid-request no longer reports that in-progress batch as a failed save. For saves, the items in it are now shown as not attempted.
- Deleting the plugin now removes its settings and per-user interface preferences from the database, instead of leaving them behind.
- Clicking Stop during a save now cancels the in-progress request immediately, instead of only skipping the batches that hadn't started yet. Rows that still finished saving on the server are reconciled afterward, so they no longer linger as unsaved.
- Pressing Stop during a save no longer hides a real login or permission failure. If your session expired or your permissions changed mid-save, you now get the reload prompt instead of a misleading "save stopped" message, so you know the remaining products weren't saved and why.
- Save-stopped notifications are now translatable. The messages shown when you stop a save part-way through — including the counts of what was saved, what's still pending, and any per-product errors — now appear in your site's language.
- When a save (or a Pro Operation History restore) is rejected because you are no longer authenticated and the site replies with an HTTP 401 error (e.g. Application Passwords or an authentication plugin), the session-expired warning now appears — including when Stop was pressed mid-operation — instead of the failure looking like a cancelled run. Rejected save/restore requests also now show the actual server error message instead of the generic "Unknown server error" text, which is now translatable.
- Turning off "Manage stock" now discards any staged Stock quantity / Backorders edits for that product no matter how the change is made — inline edit, fill handle, bulk edit, or paste — so stale stock values can no longer be saved once stock management is switched off.
- Fixed an error thrown when clicking "Clear all filters" on the "No products match your filters" screen.
- Switching to another app or browser tab while editing a cell no longer closes the editor. When you come back, the cell is still in edit mode with the cursor where you left it — you can keep typing, or paste a copied value straight into the cell.
- Enter-to-edit-the-next-row and the variation Select/Deselect buttons no longer stop working after a load error, an empty filter result, or when auto-loading is disabled.
- Fixed a Cost of Goods filter issue where a product that had been converted from variable to simple could wrongly appear in the filtered results when a leftover hidden variation matched the filter.
- Fixed the Menu order filter, SKU search, and Description search wrongly including a product that had been converted from variable to simple when a leftover hidden variation matched the filter.
- Fixed date picker calendar popups following the operating system's light/dark theme instead of the plugin's selected theme.
- Fixed toggling "Include Variations" reverting the grid's column layout (hidden columns, widths, pinning) to an older state and incorrectly marking the loaded view as "Modified". Also fixed Settings → "Reset layout" not restoring the default column visibility (previously hidden columns could stay hidden after a reset).
- Fixed CSV exports failing on large product sets with many columns selected. The file is now built page by page and caches are released as it goes, so the export uses far less server memory. When an export does fail, the error now names the cause and status (for example "Export failed (500): …") instead of a generic "Export failed".
- Added a Bulk Edit shortcut to the WordPress admin bar for quick access to the editor from anywhere in wp-admin. It can be turned off per user from the Settings menu and is on by default.
- Fixed tall popovers overflowing past the bottom of the screen on short browser windows; they now fit within the visible area and scroll internally.
- Fixed the bulk edit page not scrolling on short browser windows, which left the toolbar, pagination, and lower admin menu items clipped and unreachable.
- Fixed form fields rendering with light backgrounds in dark mode inside popover panels (filters, Selection Manager, dropdowns), and dark-mode styling for date and time inputs — native calendar/clock icons and picker popups now follow the dark theme too.
- Fixed the horizontal scrollbar floating in the middle of the grid instead of staying at the bottom after collapsing or expanding the Filters or Bulk Edit panel.
- Initial release.