Linux 软件免费装
Banner图

Bulk Edit Posts and Products in Spreadsheet

开发者 wpsheeteditor
vegacorp
josevega
更新时间 2025年5月23日 03:11
PHP版本: 3.6 及以上
WordPress版本: 6.8
版权: GPLv2
版权网址: 版权信息

标签

woocommerce events bulk edit easy digital downloads spreadsheet

下载

2.25.7 2.24.12 2.25.14 2.24.5 2.25.18 2.25.6 2.25.9 2.24.3 2.24.1 2.24.20 2.25.10 2.24.19 2.24.2 2.25.17 2.25.2 2.25.3 2.24.10 2.24.9 2.23.0 2.24.11 2.24.14 2.24.4 2.24.18 2.24.8 2.24.13 2.24.17 2.24.6 2.24.7 2.25.1 2.25.4 2.25.5 2.24.15 2.24.16 2.24.21 2.25.0 2.25.11 2.25.12 2.25.13 2.25.15 2.25.16 2.25.8 2.24.0

详情介绍:

A Spreadsheet created specially for WordPress. Edit posts in bulk using Spreadsheet. [youtube https://www.youtube.com/watch?v=QW5zRv9dwDY]

安装:

Automatic installation Automatic installation is the easiest option as WordPress handles the file transfers itself and you don’t need to leave your web browser. To do an automatic install log in to your WordPress dashboard, navigate to the Plugins menu and click Add New. In the search field type WP Sheet Editor and click Search Plugins. Once you’ve found our plugin you can install it by simply clicking “Install Now”. Manual installation The manual installation method involves downloading our plugin and uploading it to your webserver via your favourite FTP application. The WordPress codex contains instructions on how to do this here.

屏幕截图:

  • settings page

常见问题:

What kind of posts can I edit using the spreadsheet?

Only posts, pages, and woocommerce products with the free plugin. WooCommerce Products include LIMITED support, you can edit only simple products and you can edit prices only. The premium plugin allows you to edit ANY custom post types, including WooCommerce products with all their fields.

What post information can I edit using the spreadsheet?

You can edit all the information of your posts and pages, including post title, post content, post status, post excerpt, featured image, publish date, comment status, page parent, post categories, and post tags.

Can I edit WooCommerce products using the spreadsheet?

The free plugin includes limited support for WooCommerce Products, you can edit only simple products and you can edit prices only. You need the premium version for editing all types of WooCommerce products and all product fields. Read more about the extension.

Can I edit easy digital downloads products using the spreadsheet?

You need the premium version for editing easy digital downloads products. Read more about the extension.

Can I edit custom post types using the spreadsheet?

The free plugin only allows to edit posts and pages. But we have the premium version that allows you to edit any custom post type, for example, media attachments, posts , pages , courses , jobs , projects , or any other post type added by other plugins. Read more about the extension.

Can I run formulas on the spreadsheet?

You need the premium version for running formulas to update all your posts at once. Read more about the extension.

Can I hide the spreadsheet columns that I dont need?

You need the premium version for this. Read more about the extension.

Can I rename the spreadsheet columns?

You need the premium version for this. Read more about the extension.

Can I add custom columns to the spreadsheet?

Yes. The plugin contains several actions and filters for developers. You can add custom columns , modify the spreadsheet behaviour , etc.

Can I use this plugin on cheap / shared servers?

Yes. You can set up the number of posts to save per batch and the waiting between batches. Tweaking those settings you can make it work with any server.

更新日志:

V 2.25.18 - 2025-05-23 V 2.25.17 - 2025-01-28 V 2.25.16 - 2025-01-07 V 2.25.15 - 2024-10-26 V 2.25.14 - 2024-08-01 V 2.25.13 - 2024-03-28 V 2.25.12 - 2024-03-28 V 2.25.11 - 2024-03-27 V 2.25.10 - 2024-03-22 V 2.25.9 - 2024-01-26 V 2.25.8 - 2023-12-13 V 2.25.7 - 2023-11-02 V 2.25.6 - 2023-09-13 V 2.25.5 - 2023-07-23 V 2.25.4 - 2023-07-13 V 2.25.3 - 2023-07-06 V 2.25.2 - 2023-04-13 V 2.25.1 - 2023-02-03 V 2.25.0 - 2022-12-15 V 2.24.21 - 2022-11-11 V 2.24.20 - 2022-09-29 V 2.24.19 - 2022-08-19 V 2.24.18 - 2022-07-31 V 2.24.17 - 2022-06-23 V 2.24.16 - 2022-05-25 V 2.24.15 - 2022-04-19 V 2.24.14 - 2022-04-06 V 2.24.13 - 2022-03-02 V 2.24.12 - 2022-01-26 V 2.24.11 - 2021-12-08 V 2.24.10 - 2021-10-20 V 2.24.9 - 2021-09-10 V 2.24.8 - 2021-08-18 V 2.24.7 - 2021-07-14 V 2.24.6 - 2021-06-19 V 2.24.5 - 2021-06-03 V 2.24.4 - 2021-05-19 V 2.24.3 - 2021-04-21 V 2.24.2 - 2021-03-12 V 2.24.1 - 2021-02-24 V 2.24.0 - 2021-02-10 V 2.23.0 - 2020-12-19 V 2.22.0 - 2020-11-21 V 2.21.3 - 2020-10-22 V 2.21.2 - 2020-10-11 V 2.21.1 - 2020-10-07 V 2.21.0 - 2020-10-07 V 2.20.3 - 2020-09-08 V 2.20.2 - 2020-07-22 V 2.20.1 - 2020-06-26 V 2.20.0 - 2020-05-20 V 2.19.0 - 2020-04-20 V 2.18.1 - 2020-03-17 V 2.18.0 - 2020-03-16 V 2.17.0 - 2020-02-19 V 2.16.0 - 2020-01-13 V 2.15.4 - 2019-11-24 V 2.15.3 - 2019-11-18 V 2.15.1.2 - 2019-10-18 V 2.15.0 - 2019-10-01 ------ V 2.13.1 - 2019-08-11 ------ CHANGE - CORE - Make the fancy taxonomy dropdown opt-in as many people prefer the old dropdown to be able to copy paste FIX - CUSTOM COLUMNS LITE - Sometimes meta columns were allowed but they were still locked by mistake FIX - CORE - Fatal error on REST API endpoints, which breaks the normal post editor FIX - CORE - Taxonomy terms can't be updated ------ V 2.13.0 - 2019-08-08 ------ NEW - CORE - Freeze column titles at the top when scrolling down NEW - ADVANCED FILTERS - Add "Length >" and "Length <" operators NEW - ADVANCED FILTERS - Add "ends with" operator NEW - ADVANCED FILTERS - Add "regex" operator NEW - ADVANCED FILTERS - Add "starts with" operator NEW - CORE - Fancy multiselect dropdown with autocomplete for taxonomy columns (Added option to settings page to revert to the old type of cell) NEW - FILTERS - Accept custom search parameters in the wpse_custom_filters query string NEW - FORMULAS - Allow to append files for gallery columns NEW - FORMULAS - Allow to prepend files for gallery columns NEW - WC Products - Add "edit in spreadsheet" shortcut to the variations list in the normal product editor to quickly launch the spreadsheet editor for those specific variations INTERNAL - CORE - Allow to disable the image cell zoom by adding ?wpse_no_zoom to the image URL CHANGE - Wc Products - Allow to rename the "Download files" column CHANGE - Wc Products - Allow to rename the "Variation description" column CHANGE - Wc Products - Allow to rename the "Variation enabled?" column CHANGE - Wc Products - Allow to rename the "Default attributes" column CHANGE - Bulk Edit - When a batch failed and we chose to retry, don't show the server error message CHANGE - CORE - Add tip about the taxonomies spreadsheets CHANGE - CORE - Automatically update the .pot file for all plugins during the build process for every release CHANGE - CORE - Cache the list of taxonomy terms used for cell dropdowns to improve speed on big sites, clear cache when a term is added or the term name, parent, or taxonomy is updated CHANGE - CORE - Fix the top bar when we scroll right CHANGE - CORE - If the page is RTL, force english as language on the sheet page because the sheet doesn't support RTL CHANGE - CORE - Improved the loading of rows. Loading 200 rows takes 40 seconds less. CHANGE - CORE - Save - When a batch failed and we chose to retry, don't show the server error message CHANGE - CUSTOM POST TYPES - Exclude the post types that have their own spreadsheet to prevent errors CHANGE - FORMULAS - After successful execution, if there aren't unsaved changes in the sheet, reload the sheet automatically to show the bulk edits CHANGE - FORMULAS - when the popup closes. go back to step 1 CHANGE - IMPORT - Add an "Unselect all" option above columns mapping CHANGE - UNIVERSAL SHEET - IMPORT - After closing the popup from a successful import, auto-reload the sheet if there aren't unsaved changes CHANGE - WC Products > copy variations - The progress log becomes too long CHANGE - YOAST - Load the primary category dropdown via ajax to make the sheet load faster CHANGE- CORE - Moved all the media library code to a separate spreadsheet plugin FIX - CORE - Clear the object cache automatically when the data source changes (i.e. when categories are added or created) to prevent issues with persistent object cache setups FIX - CORE - It doesn't load more rows when we scroll to the bottom FIX - CORE - The sheet doesn't save changes if the post IDs are too high (i.e. 999988878978) FIX - CORE - make it work with the classic editor plugin (our compatibility broke with the recent update of the classic editor) FIX - FORMULAS - When editing a taxonomy column using append/prepend, use the taxonomy term separator from the settings page FIX - WC Products - Bulk Edit tool doesn't show the "Default attributes" column FIX - WC Products - Bulk Edit tool doesn't show the "downloadable files" column FIX - WC Products - Bulk Edit tool doesn't show the "product attributes" column FIX - WC Products - When creating new rows in the spreadsheet, create it with draft status FIX - WC Products - When editing multiple attribute taxonomies for the same product in the cells, it only attaches to the product the last taxonomy edited FIX - WC Products - When publishing drafts, automatically generate the URL slug FIX - WC Products - When saving multiple gallery images, it saves them as URLs instead of IDs FIX - WC Products > copy variations - it allows to submit without accepting the "I understand..." checkbox FIX - CORE - It doesn't save the menu order column ------ V 2.12.0 - 2019-07-01 ------ NEW - CORE - Add "share" tool to faciliate user collaboration NEW - CORE - Add the option to select the user roles who can access our spreadsheet. NEW - CORE - Added option to deactivate the data prefetch NEW - CORE - Allow to disable the meta data scan programmatically NEW - CORE - allow to rename columns using contextual menu NEW - CORE - Allow to rename columns using the columns visibility popup NEW - MEDIA - Add column showing the parent post title as readonly NEW - UNIVERSAL SHEET - EXPORT - Added option to add CSV compatibility with excel NEW - UNIVERSAL SHEET - EXPORT - Added option to select all active columns NEW - WC Products - Allow to edit custom fields on variation rows CHANGE - CORE - When a toolbar is disabled, automatically stop rendering the related popup content CHANGE - MEDIA - Remove the "add new" tool CHANGE - USERS - If the current user can edit, the default query shouldn't have the role__in query parameter, it should load all roles CHANGE - WC Products - Import - Automatically map the "meta: " columns CHANGE - WC Products - Import - When there is an error, indicate the row that contains the error FIX - CORE - Disable wpautop when using gutenberg because it breaks the block markup FIX - FILTERS - Search by author doesn't work (the author dropdown has wrong user ids) FIX - FORMULAS - The column placeholders don't work for columns that use the get_value callback FIX - GLOBAL - Sometimes when we use the free plugin and activate the premium plugin, the license activation screen doesn't appear and the user doesn't know how to activate it FIX - MEDIA - fix the preview column to show the thumbnail and large image on hover FIX - UNIVERSAL SHEET - CSV reading - It doesn't work when "fopen(): data:// wrapper" is disabled in the server FIX - UNIVERSAL SHEET - Export - It fails when column headers count doesn't match the column values count in a row FIX - UNIVERSAL SHEET - EXPORT - It links directly to the CSV file which just displays the content instead of downloading it FIX - UNIVERSAL SHEET - IMPORT - CSVs that contain &quot can't be read FIX - WC Products - Export - The columns coming from the WC CORE api are duplicated starting from batch 2 FIX - WC Products - Import - Optimize the auto mapping of columns to avoid using too much memory when we have too many columns FIX - WC Products - Import - Sometimes we end up with ghost products created by WC Core, auto delete them FIX - WC Products - Import - The "Import as meta" option in the columns mapping wasn't working See full changelog.