Individual changelogs
If you want to see the changelog for individual products and services, check the links below:
- Automations Changelog
- Comments and Reviews Spreadsheet Changelog
- Courses Spreadsheet Changelog
- Custom Database Tables Spreadsheet Changelog
- EDD Products Spreadsheet Changelog
- Events Spreadsheet Changelog
- Frontend Editor Changelog
- GiveWP Spreadsheet Changelog
- Google Sheets Service Changelog
- Media Files Spreadsheet Changelog
- Taxonomy Terms Spreadsheet Changelog
- Users Spreadsheet Changelog
- WooCommerce Coupons Spreadsheet Changelog
- WooCommerce Customers Spreadsheet Changelog
- WooCommerce Orders Spreadsheet Changelog
- WooCommerce Products Spreadsheet Changelog
Main Changelog
= V 2.25.15 - 2024-10-26 = * CHANGE - CORE - Performance improvements * CHANGE - WC Products - General improvements * CHANGE - ACF - Improve the relationship saving * FIX - YOAST - Wrong values in columns of post type when a taxonomy uses the same key as the post type * FIX - WPML - Wrong language when running scheduled tasks = V 2.25.14 - 2024-08-01 = * CHANGE - CORE - General bug fixes * CHANGE - CORE - Improve the search tool * CHANGE - CORE - Improve the handling of date values * CHANGE - WPML - Improve the compatibility * CHANGE - CORE - Improve RTL compatibility = V 2.25.13 - 2024-03-28 = * FIX - CORE - Minor issues = V 2.25.9 - 2024-01-26 = * CHANGE - CORE - General UI improvements * FIX - CORE - Small bug fixes = V 2.25.8 - 2023-12-13 = * FIX - WC Products - General bug fixes * FIX - CORE - General bug fixes = V 2.25.7 - 2023-11-02 = * FIX - CORE - Small bug fixes = V 2.25.6 - 2023-09-13 = * CHANGE - CORE - General improvements = V 2.25.5 - 2023-07-23 = * CHANGE - CORE - General improvements * FIX - CORE - General bug fixes = V 2.25.4 - 2023-07-13 = * CHANGE - CORE - General improvements * FIX - CORE - Some sheets initialized with the wrong columns = V 2.25.3 - 2023-07-06 = * CHANGE - CORE - Performance improvements * CHANGE - CORE - General improvements * CHANGE - Updated Freemius SDK to 2.5.10 * CHANGE - FIX - Bug fixes = V 2.25.2 - 2023-04-13 = * FIX - CORE - Several bug fixes = V 2.25.1 - 2023-02-03 = * CHANGE - CORE - Several improvements * CHANGE - FILTERS - General improvements * CHANGE - FORMULAS - General improvements * FIX - CORE - Several bug fixes = V 2.25.0 - 2022-12-15 = * NEW - CORE - Allow to change column backgrounds * CHANGE - CORE - Performance improvements * FIX - CORE - Small bug fixes = V 2.24.21 - 2022-11-11 = * CHANGE - WPML - Improve the integration * CHANGE - CORE - Improvements to the columns manager * CHANGE - CORE - Improve the usability of some popups * FIX - CORE - Small bug fixes * FIX - IMPORT - it breaks when zero columns are auto mapped = V 2.24.20 - 2022-09-29 = * CHANGE - CORE - Improve performance * CHANGE - CORE - Improve popups navigation * CHANGE - CORE - Improve the handling of locked values * CHANGE - WC Products - General improvements * FIX - CORE - Sanitization issue that was breaking some Gutenberg blocks * FIX - WPML - Error when saving media translations and the WPML Media plugin was not installed = V 2.24.19 - 2022-08-19 = * NEW - CORE - Add global sort option for post types * CHANGE - WC Products - Improvements for variations * CHANGE - CORE - General improvements * CHANGE - CORE - Improve the cell format of taxonomy columns * CHANGE - CORE - Performance improvements * CHANGE - CORE - Improve the sorting of rows = V 2.24.18 - 2022-07-31 = * FIX - CORE - Several bug fixes = V 2.24.17 - 2022-06-23 = * FIX - WC Products - The inventory stats aren't showing * FIX - CORE - Bug fixes = V 2.24.16 - 2022-05-25 = * CHANGE - WC Products - Improve the handling of attributes * FIX - IMPORT - It's importing only the first batch * FIX - CORE - Small bug fixes = V 2.24.15 - 2022-04-19 = * CHANGE - CORE - Code refactoring and more sanitizations * FIX - WC Products - Variation titles don't show attributes in the free version sometimes * FIX - EXPORT - The export file doesn't download sometimes = V 2.24.14 - 2022-04-06 = * CHANGE - CORE - Bug fixes * CHANGE - CORE - Allow to activate licenses network wide * CHANGE - CORE - Improve the saving of taxonomy terms = V 2.24.13 - 2022-03-02 = * CHANGE - CORE - Small improvements * CHANGE - CORE - Upgraded Freemius SDK to v2.4.3 = V 2.24.12 - 2022-01-26 = * CHANGE - WC Products - Small bug fixes * CHANGE - CORE - Added support for PHP 8 * FIX - CORE - Small bug fixes = V 2.24.11 - 2021-12-08 = * CHANGE - CORE - Small bug fixes = V 2.24.10 - 2021-10-20 = * CHANGE - ACF - Improve compatibility * FIX - CORE - Small bug fixes = V 2.24.9 - 2021-09-10 = * FIX - WC Products - Small bug fixes = V 2.24.8 - 2021-08-18 = * CHANGE - WC Products - Minor changes * CHANGE - CORE - Minor changes = V 2.24.7 - 2021-07-14 = * CHANGE - CORE - Improve the handling of special characters * CHANGE - CORE - Improve the wpml workflows * CHANGE - CORE - Minor changes = V 2.24.6 - 2021-06-19 = * CHANGE - CORE - Minor bug fixes * FIX - WC Products - Improve the handling of custom attributes = V 2.24.5 - 2021-06-03 = * CHANGE - WC Products - Improve the handling of variations * CHANGE - FORMULAS - Improve the handling of duplicates * FIX - CORE - Improve the restrictions = V 2.24.4 - 2021-05-19 = * CHANGE - WC Products - Improve the handling of attributes * CHANGE - CORE - Improve the taxonomies handling * CHANGE - CORE - Improve currency handling * CHANGE - ACF - Improve the compatibility * CHANGE - FILTERS - Improve the "characters length" operators * CHANGE - YOAST - Improve the compatibility * CHANGE - WC Products - Improve compatibility with Polylang * CHANGE - WC Products - Improve compatibility with WPML * CHANGE - FORMULAS - Minor improvements = V 2.24.3 - 2021-04-21 = * CHANGE - IMPORT - Improve performance * CHANGE - ACF - Improve the ACF compatibility * CHANGE - WC Products - Improve the export * FIX - SEARCH - Sometimes date searches don't work * FIX - CORE - Fancy taxonomy selector doesn't work well * FIX - FORMULAS - Small bugs * FIX - CORE - Sometimes the tinymce editor appears empty = V 2.24.2 - 2021-03-12 = * CHANGE - EXPORT - Improve UI * CHANGE - WC Products - Improve the handling of variations * CHANGE - CORE - Productivity improvements * FIX - WC Products - Small bug fixes * FIX - CORE - Small bug fixes = V 2.24.1 - 2021-02-24 = * CHANGE - WC Products - Small automations * CHANGE - FORMULAS - Add more dynamic placeholders * CHANGE - CORE - Add more advanced options * FIX - CORE - Compatibility issue with WP Frontend Admin * FIX - ACF - Improve the saving of map columns = V 2.24.0 - 2021-02-10 = * NEW - CORE - Add spanish translations for latinamerica * CHANGE - IMPORT - General Improvements * CHANGE - WC Products - Allow to import line breaks in custom attribute values * CHANGE - CORE - Add more advanced options * CHANGE - WC Products - Small automations * CHANGE - CORE - Small automations * FIX - CORE - Add compatibility with WPSolr Pro * FIX - ACF - Improve the saving * FIX - CORE - Small bug fixes * FIX - WC Products - Small fixes = V 2.23.0 - 2020-12-19 = * NEW - CORE - Improve the advanced settings * NEW - COLUMNS MANAGER - General Improvements * NEW - FORMULAS - Add more options * CHANGE - CORE - Terms search should mention the slug * CHANGE - ACF - Add support for more fields * CHANGE - CORE - Remove links from usage widget * CHANGE - WC Coupons - Prevent WC settings issue * CHANGE - WC Products - Improve support for vendors * CHANGE - CORE - Improve saving * CHANGE - WC Products - Improve variations handling * FIX - WC Products - improve support for variable subscriptions * FIX - WC Products - Variation images are not saved correctly * FIX - CORE - Small fixes * FIX - WC Products - Prevent bulk edit errors = V 2.22.0 - 2020-11-21 = * NEW - FORMULAS - Improve handling of some columns * CHANGE - IMPORT - Improve column mapping * CHANGE - CORE - Add more text to the status bar * CHANGES - WC Products - Improve the importing of images * CHANGES - CORE - Improve handling of non-utf-8 characters * CHANGE - FORMULAS - Improve the engine * CHANGE - CUSTOM COLUMNS - Improve the formatting * CHANGE - CORE - Improve handling of images * CHANGE - CORE - Simplify license activation * CHANGE - WPML - Improve language switching * CHANGE - WC Products - Improve the usability * FIX - CORE - Some columns are readonly by mistake * FIX - CORE - Compatibility with WP Offload Media * FIX - CORE - Edge cases with taxonomy terms * FIX - WC Products - Error while saving download files * FIX - CORE - Compatibility with WP Smart Import = V 2.21.3 - 2020-10-22 = * CHANGE - IMPORT - Improve column mapping * CHANGE - CORE - Add more text to the status bar * CHANGES - WC Products - Improve the importing of images * CHANGES - CORE - Improve handling of non-utf-8 characters * CHANGE - FORMULAS - Improve the engine * FIX - CORE - Some columns are readonly by mistake = V 2.21.2 - 2020-10-11 = * CHANGE - CORE - Add support for strange url images * CHANGE - IMPORT - Improve the mapping = V 2.21.1 - 2020-10-07 = * Updated to CORE v2.21.1 = V 2.21.0 - 2020-10-07 = * NEW - IMPORT - Generate log * CHANGE - WC Products - Add support for custom types * CHANGE - ACF - Improve compatibility * CHANGE - COLUMNS MANAGER - Improve formatting options * CHANGE - WC Products - Add columns * CHANGE - FORMULAS - Improve dates handling * CHANGE - EXPORT - Improve the handling of images * CHANGE - CORE - Improve handling of extensions * CHANGE - Export - Improve column selection * CHANGE - CORE - Add more columns * CHANGE - CORE - Don't use wpautop when saving content * CHANGE - IMPORT - Improve the handling of images * CHANGE - CORE - Allow to view column keys * FIX - CORE - Improve performance on some cells * FIX - Import - Sometimes some columns are not mapped correctly = V 2.20.3 - 2020-09-08 = * CHANGE - IMPORT - Make more data formatting checks * CHANGE - CORE - Improve the saving process * CHANGE - CORE - Improve support for some devices * CHANGE - CUSTOM COLUMNS - Improve the handling of weird fields * CHANGE - WC Products - Improve the handling of linked products * CHANGE - WC Products - Improve bulk edit of some columns * CHANGE - FORMULAS - Small improvements * CHANGE - CORE - Add support for modern jQuery * CHANGE - CORE - Productivity improvements for some contextual menu actions * CHANGE - WC Products - Small improvements for some columns * CHANGE - IMPORT - Improve productivity * CHANGE - CORE - Improve performance * FIX - COLUMNS MANAGER - It deletes columns by mistake sometimes * FIX - WC Products - Sometimes the formula doesn't edit all the selected products * FIX - WC Products - Sometimes it changes unnecessary fields * FIX - CORE - Sometimes sheets are not generated * FIX - CORE - Add support for rare wp media settings * FIX - CORE - Sometimes the media library modal doesn't let you select multiple images * FIX - CORE - Some cells are saving with wrong encoding * FIX - WC Products - Compatibility error with WC Bookings * FIX - SEARCH - Post status search doesn't work sometimes = V 2.20.2 - 2020-07-22 = * FIX - CORE - Save popup gets stuck when the changes are saved in < 350ms * FIX - YOAST - Some columns are not saving correctly * FIX - FORMULAS - The replace type doesn't work sometimes * FIX - CORE - Sometimes columns dont appear in secondary dropdowns but they appear as visible columns * FIX - CORE - Sometimes images aren't found in the media library when using URLs * FIX - WC Products - Timezone issue when saving sale dates. = V 2.20.1 - 2020-06-26 = * CHANGE - WC Products - Improve the handling of prices when creating variations * CHANGE - ACF - Improve support * CHANGED - COLUMNS VISIBILITY - Improve the removal process * CHANGE - WC Products - Import - Improve the process * CHANGE - EXPORT - Improve the handling of ghost columns * CHANGE - CORE - Improve performance when loading +800,000 cells at once * CHANGE - FORMULAS - Improve the builder for taxonomy terms * CHANGE - CORE - Improve the handling of advanced settings * CHANGE - WC Products - Improve the bulk edit of some fields * CHANGE - WC Coupons - Improve the search * CHANGE - ACF - Improve the handling of some fields * CHANGE - CORE - Add shortcuts to menu * CHANGE - CORE - Improve the handling of new fields * FIX - WC Products - Sometimes the variation attributes aren't copied correctly * FIX - CORE - Export doesn't complete when the current user is not administrator * FIX - FORMULAS - The encoding was wrong sometimes making the replace not match * FIX - ADVANCED FILTERS - Search data columns by empty value returns wrong results * FIX - CORE - Avoided memory leaks * FIX - FORMULAS - Bad value on checkbox * FIX - FORMULAS - Sometimes the edit is not applied to the full list * FIX - WPML - Sometimes changes aren't synced * FIX - WC Products - Sometimes columns can't be enabled = V 2.20.0 - 2020-05-20 = * NEW - CORE - Improve the handling of external images * NEW - FORMULAS - Improved the types of edit * NEW - FILTERS - Improve the search * Products el enlace de metabox variaciones que use id para búsqueda en lugar de title * in the autocomplete dialog for tags, when we use keyboard arrows to move down the list of matching tags, there is no visual indication of which menu item is selected. This means we can't use keyboard navigation to select items – the arrow keys do work, it's just we can't see what is selected. I'm sure a simple CSS tweak would fix this. If/when you release an update to fix this, please let me know at [email protected] * CHANGE - CORE - Improve the freezing of columns * CHANGE - CORE - Improve the productivity while sorting columns * CHANGE - WC Coupons - Remove duplicate columns * CHANGE - WC Products - Improve performance of the default attributes column * CHANGE - FORMULAS - Improve productivity for executing some edits * CHANGE - COLUMNS MANAGER - Improve the toolbar item * CHANGE - EXPORT - Improve the toolbar item * FIX - WC Products - Sometimes the post type and parent columns aren't saved * FIX - WC Products - Import - new images are not saved when using the option "skip broken images" * FIX - WC Products - Error when copying more than 100 variations * FIX - FORMULAS - Sometimes columns can't be copied * FIX - COLUMNS MANAGER - If we specify column formatting manually, don't overwrite it during automatic detection * FIX - CORE - Sometimes deleted columns also deleted similar columns by mistake * FIX - CORE - Sometimes the save popup gets stuck * FIX - WC Products - When converting a product into variation, the attributes are not migrated sometimes = V 2.19.0 - 2020-04-20 = * NEW - COLUMNS MANAGER - Improve the handling of columns between users * NEW - WC Products - Improve the handling of custom attributes * CHANGE - Small tweak to the display of advanced settings toolbar * CHANGE - WC Products - Keyword search by sku should allow partial matches * CHANGE - CORE - Prevent data errors during imports * CHANGE - WC Products - Import - Prevent attribute data errors * CHANGE - CORE - Prevent memory issues * CHANGE - UNIVERSAL SHEET - IMPORT - Remove the wp fields that can't be used for searching * CHANGE - FORMULAS - Make the "duplicates" option more flexible * CHANGE - WC Products - Create variations - Improve the context menu performance * CHANGE - IMPORT - Prevent column name errors * CHANGE - CORE - Prevent confusion when the loading of rows is disabled * CHANGE - WC Products - Prevent errors when using tools with missing data * CHANGE - COLUMNS MANAGER - Improve the productivity when managing columns * CHANGE - CORE - Optimized performance when we have thousands of columns * CHANGE - WC COUPONS - Facilitate the selection of coupon prefix while duplicating * CHANGE - WC Products - Improve the selection of products for creating variations * CHANGE - CORE - Facilitate the removal of many columns * CHANGE - WC COUPONS - Don't duplicate some fields * CHANGE - IMPORT - Prevent unnecessary stops * CHANGE - WC COUPONS - Make the edition of product restrictions more flexible * CHANGE - WC Coupons - Improve the display of usage limit columns * FIX - WC Products - The attributes column appear as text column * FIX - EXPORT - Fatal error when using the "decode quotes" option * FIX - Ajax Loops - Avoid sending too many fields in a request * FIX - WC Products - The "display variations" switch doesn't work sometimes * FIX - FORMULAS - Fatal error when applying bulk edit on an infinitely serialized column * FIX - CORE - Advanced settings modal doesn't save some options * FIX - CORE - The pagination options don't appear when we are in the middle of the spreadsheet and we reach the bottom * FIX - CORE - Bulk Edit - Empty checkboxes are ignored * FIX - CORE - Search - Empty checkboxes are ignored * FIX - CORE - TinyMCE popup sometimes skips rows when using the navigation * FIX - WC Products - Sometimes the bulk edit of "product attributes" settings fails * FIX - COLUMNS MANAGER - Sometimes some columns don't appear in the list * FIX - COLUMNS MANAGER - Sometimes text cell have date formatting * FIX - CORE - Non-hierarchical taxonomy terms should not have hierarchy * FIX - CORE -Parent name is wrongly encoded sometimes * FIX - WC Products - WPML - Sometimes variations are created and they're invisible * FIX - CUSTOM COLUMNS - Prevent data compatibility errors * FIX - WC Products - Searching by variation attributes is not working * FIX - CORE - Sometimes columns can't be enabled * FIX - WC Coupons - Expiration date wasn't saved sometimes * FIX - WC Products - Sometimes some columns are saved but new values don't appear in the frontend * FIX - CORE - Sometimes the columns manager can't save changes = V 2.18.1 - 2020-03-17 = * CHANGE - Small tweak to the display of advanced settings toolbar * CHANGE - WC Products - Keyword search by sku should allow partial matches = V 2.18.0 - 2020-03-16 = * NEW - CORE - Integrate with Elementor * NEW - ADVANCED FILTERS - Allow OR operators * NEW - FILTERS - Allow to save searches * NEW - COLUMNS - Improve the columns formatting * NEW - COLUMNS VISIBILITY - Allow to save groups * NEW - CORE - Improve the pagination * NEW - Add support for wpml * CHANGE - COLUMNS LOCATOR - Include field key in the search * CHANGE - ACF - Improve the support for repeater fields * CHANGE - ACF - Improve the detection of field group location parameters * CHANGE - ACF - Allow to rename fields * CHANGE - CORE - Improve the handling of full screen mode * CHANGE - CORE - Don't delete the manually created columns when the plugin is uninstalled * CHANGE - CORE - Improve the saving UI * CHANGE - WC Products - Improve the experience for editing downloadable files * CHANGE - FILTERS - Taxonomies field: If there are too many product attributes, don't show all the names * CHANGE - CORE - Improve the support for columns with autocomplete type in the search and bulk edit tools * CHANGE - WC Products - Improve the support for creating large numbers of variations * CHANGE - EXPORT - Improve the support for MS Excel * CHANGE - CORE - Allow to search by ID in all the dropdowns * CHANGE - COLUMNS - Improve the automatic format detection * CHANGE - CORE - Improve the advanced settings interface * CHANGE - WC Products - Notify when rare SKU errors happen * FIX - CUSTOM COLUMNS - Edit meta key - don't send ajax call unnecessarily * FIX - CORE - When we open the tinymce editor and the cell has a value with line breaks, the visual editor removes the line breaks * FIX - Posts table - The quick access button is duplicated when using multiple wpse plugins * FIX - EXPORT - The download URL breaks when the site uses https for backend and http for frontend * FIX - IMPORT - Columns with numbers in the names are not mapped automatically * FIX - COLUMNS VISIBILITY - Improve the deactivation of columns to avoid edge cases where some columns were not deactivated * FIX - WC Products - Improve the bulk edit support of the "variations enabled" column * FIX - Columns created manually sometimes don't appear * FIX - WC Products - Improve the process of copying variations * FIX - FILTERS - Column locator doesn't work sometimes. * FIX - ACF - The code for the dates columns interferes with date columns not coming from ACF * FIX - ADVANCED FILTERS - Sometimes the searches with empty values don't work = V 2.17.0 - 2020-02-19 = * NEW - FORMULAS - Allow to apply same bulk edit to multiple fields at once * NEW - FORMULAS - Allow to select individual rows with a checkbox and apply the bulk edit to those rows * NEW - CORE - Add support for custom post statuses * NEW - WC Products - Free - Allow to edit variation rows * NEW - GIVEWP - Added spreadsheet for editing/viewing donations * CHANGE - WC Coupons - FILTERS - When using the expiration date field, show a calendar to select dates easily without having to worry about the format * CHANGE - WC Coupons - Allow to save "allow products" as IDs separated by commas * CHANGE - WC Coupons - Allow to save "excluded products" as IDs separated by commas * CHANGE - WC Coupons - FORMULAS - When using the expiration date field, show a calendar to select dates easily without having to worry about the format * CHANGE - CORE - Allow to disable the cell comments * CHANGE - CORE - Allow to save taxonomy columns using a term slug * CHANGE - CORE - Load author cells with ajax * CHANGE - CORE - Reduce the memory usage when loading the spreadsheet page by reducing all the unnecessary output * CHANGE - FORMULAS - Show one text progress instead of one per batch to avoid crashing the browser when executing bulk edits with thousands of batches * CHANGE - UNIVERSAL SHEET - Export - Prevent errors if they are using a high batch size * CHANGE - UNIVERSAL SHEET - Export - Allow to control the export speed in the advanced settings * CHANGE - WC Products - Lock the price columns for parent product rows to prevent confusion because the prices are stored in the variations * CHANGE - CORE - Add cell comment to hierarchical taxonomy columns to indicate the format for child categories * CHANGE - CORE - When we save images on any field while editing a post type, automatically attach the image to the post if the image is unattached * CHANGE - FORMULAS - Don't show the tip about increasing speed if the bulk edit is applied on one batch * CHANGE - CORE - Allow to save a file name in the image columns and automatically save the first image from the media library matching the name * CHANGE - CORE - External button cells - Don't show a button when the value is empty * CHANGE - CORE - FREE - Allow to edit custom post types with limited fields * CHANGE - CORE - FREE - Remove formulas teaser from the toolbar and just link to it from the paragraph teaser * CHANGE - CORE - FREE - Disable the post types teaser from the toolbar because the post types can be edited in the free version now * CHANGE - CORE - FREE - Add a global teaser as paragraph in the header to better indicate the limitations and what's premium * CHANGE - YOAST FREE - Add a welcome page * CHANGE - CORE - Sort the list of spreadsheets in the form to display the available first, free extension second, and paid extensions finally * FIX - WC Products - When we edit global attributes in separate columns, it removes the attribute position * FIX - CUSTOM POST TYPES - Some post types added by other plugins appear locked * FIX - CORE - When changing the post type of a post, from page to another, clear the page template meta key to prevent the "invalid page template" error thrown by wp core * FIX - WC Products - Import - The auto mapping of csv columns is mapping only the first 9 download files and the rest are not being imported * FIX - WC Products - Import - The auto mapping of csv columns is mapping only the first 9 attributes and the rest are not being imported * FIX - CORE - When using multiple free plugins, sometimes the upgrade links get mixed up and one plugin shows the upgrade url of the other causing incorrect purchases * FIX - FILTERS - The "clear all filters" option removes the display variations filter, but the button in the toolbar appears as activated * FIX - FILTERS - When we make a search with an advanced filter, remove the filter, and make a search using the same input field, it doesn't apply the new search * FIX - POSTS TEMPLATES - When we duplicate a serialized field, it is saved as a literal string incorrectly * FIX - WC Products - Sometimes the "search on variations" filter wasn't added or removed when it should * FIX - FILTERS - When we unchecked a checkbox and submit the form, it didn't remove the filter * FIX - ACF - Repeater fields are saved correctly but the values are ignored by ACF = V 2.16.0 - 2020-01-13 = * NEW - CORE - Add option to "settings" menu to reset all settings * NEW - FORMULAS - Add variable $current_value_capitalize_each_word$ and option "Capitalize each word" to the "type of edit" list * NEW - FORMULAS - Added variable tags: $uuid$, $uniqid$, $current_value_lowercase$ * NEW - FILTERS - Add "Remove all" option to remove all active filters * NEW - UNIVERSAL SHEET - EXPORT - Allow to save the export with a name and show as dropdown in the toolbar to execute with one click in the future * NEW - CUSTOM COLUMNS - Add context menu option to rename meta key of meta columns * NEW - CUSTOM COLUMNS - Add option to delete custom field from database (full field, including key and values) * NEW - CORE - Allow to delete rows using the context menu and delete the selected items * NEW - CORE - Add option to scan DB to the settings dropdown to make it easier to find * CHANGE - WC Products - When we convert a product into a variation and the product has a status not supported by variations, automatically change it to "enabled variation" * CHANGE - CORE - Indicate in import modal that changes are saved directly * CHANGE - SEARCH - When we click to open the search tool and there are modified cells, notify that they should save first * CHANGE - FORMULAS - Modify the progress text to indicate that the numbers reflect updates per batch * CHANGE - CORE - Allow to select in the advanced settings which fields use the new serialization handler * CHANGE - WC Products - Added support for Subscription products * CHANGE - CORE - Performance optimizations: The "post parent" column should not load all the titles, it should be a dropdown with ajax search * CHANGE - CORE - Performance optimizations: Limit the usage of meta keys to 2500 columns, no one needs to search/edit more than 2500 keys and sites with +10000 meta keys are super slow * CHANGE - ADVANCED SEARCH - Performance optimizations: Limit the meta keys to 1000 options in the search dropdowns. * CHANGE - WC Products - Performance optimizations: Limit the variation meta keys to 1000 columns * CHANGE - CORE - Performance optimizations: When we rescan DB to find new columns, only scan once per page load * CHANGE - CORE - Return the full SQL query as meta data of the ajax call when loading rows to help during tech support/debugging, do this only for administrator * CHANGE - WC Products - Allow to load variation rows for products with a custom product type (i.e. registration products) * CHANGE - FREE YOAST - Display a wp-admin notice indicating why it was deactivated automatically when using a premium plugin * CHANGE - UNIVERSAL SHEET - IMPORT - Don't let the user continue in step 3 if they selected a column that is not being imported * CHANGE - FORMULAS - MATH - Automatically round number to the 2 nearest decimals * FIX - FORMULAS - When the post has orphan meta, the success message might say it updated more posts than the total causing confusion ("559 of 559 items have been processed. 606 items have been updated") * FIX - CORE - The post modified date is not being saved when edited in the cells * FIX - WC Products - Free version - When we edit prices, sometimes it doesn't show it on the frontend * FIX - WC Products - Free version - Sync price, sku, and stock changes with the lookup table introduced with WC +3.6 * FIX - ADVANCED FILTERS - The "exclude keyword" option is not returning the correct posts * FIX - WC Products - When searching by "search on variations" and leaving all the other fields empty, it doesn't return results * FIX - WC Products - Import - Some fields appear duplicated in the dropdown for mapping the columns so they are imported through Sheet Editor CORE instead of using the WooCommerce API causing duplicate sku issues * FIX - CORE - When we freeze a column, it freezes the wrong column * FIX - WC Coupons - Compatibility issue with the "Ordered Variable Product Report" plugin * FIX - CORE - Sometimes cells are misaligned = V 2.15.4 - 2019-11-24 = * FIX - WC Products - If variations of the same product have the same menu order, it only saves one of them * FIX - CORE - When using a free plugin and a premium plugin, don't initialize unsupported modules when using the free spreadsheet to prevent major issues * FIX - CORE - the gutenberg editor can't be opened when a post title contains double quotes = V 2.15.3 - 2019-11-18 = * CHANGE - CORE - blacklist columns with keys containing -wpfoof- * CHANGE - ACF - Register text columns from the ACF module instead of relying on the "custom columns" module * CHANGE - CORE - When changing the settings to load > 300 rows per page, show a notification indicating that it may overload the server * CHANGE - CORE - Prevent errors due to high number of rows per page - If the user defines rows per page >= 100 and it fails, automatically reset to 10 and retry * CHANGE - CORE - Add advanced option to delete attached images when we delete a post * CHANGE - IMPORT - identify when a file is uploaded for import if we're unable to detect the csv separator and show the solution to the user * CHANGE - CORE - When saving an external image into the media library, save the external URL and reuse the local image on future saves/imports to avoid duplicating the images on every import * CHANGE - CUSTOM COLUMNS - Add support for serialized fields with unlimited levels deep * CHANGE - CORE - Make the Columns Manager wider to have space for columns with long names * CHANGE - CORE - Columns manager - When hovering over the name of disabled columns, it doesn't show the name of the column * CHANGE - CORE - COLUMNS MANAGER - Don't show columns that can't be disabled * CHANGE - WC Products - When a variable product is imported, automatically select a default attribute if the default is missing otherwise WC won't create the variations * CHANGE - CORE - Updated styles of the toolbar * CHANGE - CORE - Fix the 2 toolbars during scroll, not just the main toolbar * CHANGE - CORE - Increased columns limit from 310 to 410 to prevent good columns from not showing up * CHANGE - CORE - COLUMNS VISIBILITY - When we rescan, automatically increase the limit, so they can rescan until the missing column shows up * CHANGE - CORE - Blacklist columns that contain a word with +26 characters because they usually are system/private columns that shouldn't be seen nor edited * CHANGE - WC Products > ADVANCED FILTERS - Allow to search by variation and use advanced filters by taxonomy applied to parent products * CHANGE - CORE - Indicate how to increase number of rows per page in the footer of the sheet * CHANGE - CORE - Highlight row that we're editing * FIX - CUSTOM POST TYPES - It doesn't register, save, or delete new post types * FIX - WC Products - Disable post actions when copying/creating variations to prevent conflicts with divi-bodycommerce plugin * FIX - ACF - When we edit fields, save the private _xx meta data with the ACF key required by ACF * FIX - ACF - Checkbox columns aren't saving correctly * FIX - COLUMNS VISIBILITY - When we blacklist a column, it keeps showing on the deactivated list * FIX - WC Products - Create variations from combination of attributes - Increase limit from 50 to 200 * FIX - WC Products - php warning when calculating inventory stats when hosts disable the ORDER BY from sql queries * FIX - WC Coupons - The "used by" column shows one user only * FIX - CORE - Sometimes the fixed header jumps/shakes during scroll * FIX - CORE - COLUMNS VISIBILITY - when we scroll to the right, the notification saying "column missing?" is not showing up * FIX - WC Products - When saving variations, sometimes there are validations errors and they're not shown to the user * FIX - WC Products - Sometimes variation images are not saving and causing it to not save other variation data * FIX - WC Products - Search > Advanced filters - When searching on variations by attribute it returned zero results * FIX - UNIVERSAL SHEET - Sometimes the export file has duplicate rows * FIX - CORE - When many posts have exact same date, sometimes the database returns duplicate posts during pagination because they are sorted by date * FIX - CORE - When saving taxonomy terms that contain + and there is a term with same name except +, the term with + is saved without + * FIX - WC Products - "Edit Attributes" column - sometimes it doesn't save new custom attributes * FIX - CORE - When we show 2 consecutive notifications of different type (success and info), they appear one on top of another * FIX - WC Products - Export - The "attribute : is taxonomy" column shows the "attribute : visible" value by mistake, which breaks the attribute import = V 2.15.1.2 - 2019-10-18 = * CHANGE - CORE - Allow to define default settings for product attributes (is visible, used for variations) * CHANGE - CORE - View Post column should use the real link for published posts * CHANGE - CORE - Automatic column detection should take the columns limit into consideration (i.e. to avoid scanning thousands of fields if only 100 are allowed) * CHANGE - WC Products - IMPORT - Allow to skip broken images and don't stop the import * FIX - CORE - Factory - On rare occasions, the taxonomies sheet shows columns as a post type * FIX - CORE - Factory - Some columns were missing because the sheet initialized twice * FIX - FORMULAS - Allow to replace empty value with empty value * FIX - WC PRODUCTS - Clear the cache when the column _thumbnail_id is edited * FIX - FORMULAS - it doesn't work when editing image cells * FIX - WC Products - Downloadable files - When editing as plain text in the cell, it saves the files with the wrong format * FIX - UNIVERSAL SHEET - IMPORT - JS error when a column name contains only numbers = V 2.15.0 - 2019-10-01 = * NEW - FORMULAS - Add placeholder: $random_date$ * NEW - WC Products - copy variations - Add option to copy individual variations * NEW - WC Products - Allow editing the "download files" column as plain text * NEW - WC Products - Allow copy pasting the "download files" column * NEW - ACF - Add support for "file" fields * NEW - POSTS TEMPLATES - Add "duplicate" option to the context menu to quickly duplicate rows * NEW - CORE - Add contextual option to auto resize columns based on the content * NEW - WC Products > Bulk Edit - Allow to activate/deactivate "is visible" for product attributes on all products at once * NEW - WC Products > Bulk Edit - Allow to activate/deactivate "is variation" for product attributes on all products at once * NEW - CORE - Added spanish translations * NEW - WC Products - Add contextual menu to create variations for selected row, which opens the create variations modal and auto selects the product * NEW - WC Products - Add contextual menu to copy variations from the selected row, which opens themodal and auto selects the product * NEW - ACF - Add support for gallery field * NEW - FILTERS - Add option to locate column * NEW - CORE - Add contextual option: realign cells * NEW - UNIVERSAL SHEET - IMPORT - Add advanced setting to skip the first N rows, so we can start imports from where we left off * NEW - WC Products - Add "All" option to the dropdown global attributes columns, which automatically selects all the options in the dropdown while saving * NEW - WC Products - Allow to edit the parent product of variations * NEW - WC Products - Add the "product_variation" option to the post types column to convert any product into a variation * CHANGE - CSV Import - Optimize the reading of CSV files to use less memory and read huge files * CHANGE - CUSTOM COLUMNS - Allow spaces and () in the automatic column names * CHANGE - WC Products - Free - Enable columns: 'view_post', 'open_wp_editor', 'post_status', 'post_modified', 'post_date', '_length', '_height', '_width', '_weight', * CHANGE - CORE - When saving images from external URLs, limit the download time to 4 seconds to prevent timeouts when external servers are too slow, throttle, or block our requests * CHANGE - FORMULAS - Don't reduce the calls after every batch, do the same number of batches as initial defined because sometimes it only processed half the rows * CHANGE - WC Products - Indicate why some cells are locked (i.e. columns for variations only or parent products only) * CHANGE - CORE - Add links to tutorials/faqs in all the popups and pages * CHANGE - UNIVERSAL SHEET - IMPORT - STEP 3 - Indicate that fields used for updating existing items must be imported in step 2 * CHANGE - UNIVERSAL SHEET - Upload csv - Detect when the file was uploaded successfully but it wasn't read, and show a notification saying that it wasn't read due to an encoding issue and ask them to verify that * CHANGE - UNIVERSAL SHEET - When import fails, indicate possible solutions * CHANGE - UNIVERSAL SHEET - IMPORT - When there is a data error and the import stops, indicate that the import was stopped and they need to correct the error and import again * CHANGE - FORMULAS - Allow multi-line values in the bulk edits (set value, replace, etc.) * CHANGE - CORE - Revert styles change of locked cells to experiment performance with/without the change * Poner textos en español en el readme.txt de todos los plugins con frases comunes de búsqueda * CHANGE - CORE - Free - make the pro columns more subtle, highlight the cell value * CHANGE - CORE - Show "menu order" column for all post types because some post types use it for unorthodox purposes * CHANGE - SPREADSHEET SETUP - Don't allow to save new custom post types when the custom post types module is not available * CHANGE - CORE - Added internal cache of conversion from friendly terms to IDs to speed up imports and savings * CHANGE - CORE - Added internal cache of conversion from file URLs to file IDs to speed up imports and savings * CHANGE - UNIVERSAL SHEET - Delete old csvs when the sheet loads because the cron job doesn't run on rare server setups * CHANGE - WC Products - When we add attributes and at least one is "allow for variations", automatically set the product as variable * CHANGE - POSTS TEMPLATE - when duplicating posts, don't copy the post date, so the new posts have new dates * CHANGE. UNIVERSAL SHEET. deactivate the rest api by default and add option to settings page to activate manually and add wp filter to activate programmatically * CHANGE - UNIVERSAL SHEET - IMPORT - Add advanced option to auto retry failed batches * CHANGE - UNIVERSAL SHEET - EXPORT - Add indications at the end of the process to answer questions like download didn't start, where to find the file, when are the files deleted. * CHANGE - UNIVERSAL SHEET - EXPORT - Optimize the download of large files to use less memory and start faster * FIX - CORE - Allow saving images with spaces in the URL on the gallery columns * FIX - CORE - Allow saving images from the /wp-content/uploads directory * FIX - FILTERS - Keyword search should search on post title, content, and excerpt * FIX - CORE - When importing terms with hierarchy, don't html encode the hierarchy symbol * FIX - CORE - Media columns - don't attempt to show preview of files that aren't images * FIX - CUSTOM COLUMNS - Post types list doesn't show sheets created with the Factory class * FIX - WC Products > variations - When the "variation enabled" checkbox goes from unchecked to checked, it's not saved * FIX - COLUMNS VISIBILITY - The list of disabled columns didn't show the current name of the columns, it showed the name the columns had when they were deactivated the first time * FIX - CORE - Image cells - Allow to save images containing portuguese characters like "ção" * FIX - WC Products - issue during cache clean up after saving when using WC copy variations - When saving meta data in the copied variations, unserialize to prevent double serialization from WP * FIX - WC Products - Export - Some columns were excluded from the export, when it was a custom field used by variations * FIX - WC Products - EXPORT - Some column headers when exporting attributes are missing because the first line of the file is not read properly * FIX - CORE - SERIALIZED FIELDS - When the field contains a single level and subfields have integers as keys, it only shows the value of the first subfield in the cells and the other subfields appear empty * FIX - WC Products - The internal caches of WC aren't cleared after saving, causing changes not to appear when sites use aggressive cache like wp.com * FIX - WC Products - when we edit global attributes in their own columns and change product type from simple to variable at the same time, automatically set the attribute as "used in variation" * FIX - WC Products > create variations > create for every combination of attributes - PHP warning * FIX - WC Products - When we delete a product completely, we remove the parent row but we should remove the child variation rows as well * FIX - CORE - VIEW column has wrong link when viewing custom post types as draft * FIX - GiveWP - It crashes the site if GiveWP is not installed * FIX. CORE. delete all traces of the plugin on uninstall = V 2.14.0 - 2019-09-06 = NEW - ACF - Add support for gallery field NEW - CORE - Add contextual option: realign cells to fix rare scenarios when cell borders don't match NEW - FILTERS - Add option to locate column to save time when searching for a column in the sheet. NEW - UNIVERSAL SHEET - IMPORT - Add advanced setting to skip the first N rows, so we can start imports from where we left off NEW - WC Products - Add "All" option to the dropdown of global attributes columns, which automatically selects all the options in the dropdown while saving NEW - WC Products - Add contextual menu to copy variations from the selected row, which opens the modal and auto-selects the product NEW - WC Products - Add contextual menu to create variations for the selected row, which opens the create variations modal and auto-selects the product NEW - WC Products - Add the "product_variation" option to the post types column to convert any product into a variation NEW - WC Products - Allow to edit the parent product of variations CHANGE - CORE - Added internal cache of conversion from file URLs to file IDs to speed up imports and savings CHANGE - CORE - Added internal cache of conversion from friendly terms to IDs to speed up imports and savings CHANGE - CORE - Free - make the pro columns more subtle, highlight the cell value CHANGE - CORE - Show "menu order" column for all post types because some post types use it for unorthodox purposes CHANGE - CSV Import - Optimize the reading of CSV files to use less memory and read huge files faster CHANGE - POSTS TEMPLATE - when duplicating posts, don't copy the post date, so the new posts have new dates CHANGE - SPREADSHEET SETUP - Don't allow to save new custom post types when the custom post types module is not available CHANGE - UNIVERSAL SHEET - Delete old csvs when the sheet loads because the cron job doesn't run on rare server setups CHANGE - UNIVERSAL SHEET - EXPORT - Add indications at the end of the process to answer questions like download didn't start, where to find the file, when are the files deleted. CHANGE - UNIVERSAL SHEET - EXPORT - Optimize the download of large files to use less memory and start faster CHANGE - UNIVERSAL SHEET - IMPORT - Add an advanced option to auto-retry failed batches CHANGE - WC Products - Free - Enable columns: 'view_post', 'open_wp_editor', 'post_status', 'post_modified', 'post_date', '_length', '_height', '_width', '_weight', CHANGE - WC Products - When we add attributes and at least one is "allow for variations", automatically set the product as variable CHANGE. UNIVERSAL SHEET. deactivate the rest api by default and add option to settings page to activate manually to avoid compatibility issues with other REST API configurations or external apps. FIX - CORE - SERIALIZED FIELDS - When the field contains a single level and subfields have integers as keys, it only shows the value of the first subfield in the cells and the other subfields appear empty FIX - CORE - VIEW column has the wrong link when viewing custom post types as a draft FIX - FORMULAS - When deleting thousands of rows completely, it only deletes half FIX - WC Products - EXPORT - Some column headers when exporting attributes are missing because the first line of the file is not read properly FIX - WC Products - Export - Some columns were excluded from the export when it was a custom field used by variations FIX - WC Products - Import - Remove the & symbol from the SKU before saving. WC returns a duplicate SKU error when it's not duplicate. FIX - WC Products - The internal caches of WC aren't cleared after saving, causing changes not to appear when sites use aggressive cache like wp.com FIX - WC Products - When we delete a product completely, we remove the parent row but we should remove the child variation rows as well FIX - WC Products - when we edit global attributes in their own columns and change product type from simple to variable at the same time, automatically set the attribute as "used in variation" FIX - WC Products > copy variations - When saving meta data in the copied variations, unserialize to prevent double serialization from WP FIX - WC Products > create variations > create for every combination of attributes - PHP warning FIX. CORE. delete all traces of the plugin on uninstall = 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 " 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 = V 2.11.3 - 2019-05-28 = FIX - FORMULAS - In numeric fields > set value - allow to use decimal numbers FIX - YOAST - It's filtering the meta columns and returning a blank value when it's not the primary category field = V 2.11.2 - 2019-05-27 = NEW - CORE - Added "wp editor" column that opens the default wp post editor NEW - CORE - Added quick access buttons above the posts lists NEW - CORE - Added support for the "disable gutenberg" plugin NEW - CORE - After a successful saving or bulk edit, ask users to leave a review on wp.org NEW - CORE - INTERNAL - Added option "rest api only" to make the plugin completely invisible and remove all the plugin pages, so we can use the rest api only CHANGE - YOAST - Enabled the "canonical URL" column CHANGE - YOAST - Enabled the "FB desc" column CHANGE - YOAST - Enabled the "FB image" column CHANGE - YOAST - Enabled the "FB title" column CHANGE - YOAST - Enabled the "TW desc" column CHANGE - YOAST - Enabled the "TW image" column CHANGE - YOAST - Enabled the "TW title" column CHANGE - ADVANCED FILTERS - Added css classes to every element to allow to hide specific elements easily CHANGE - COLUMNS VISIBILITY - Don't allow to remove or disable columns if the spreadsheet has unsaved changes CHANGE - COLUMNS VISIBILITY - Remove message saying "Note: When you hide columns we will remove those columns from the spreadsheet" CHANGE - COLUMNS VISIBILITY - When we hide column using context menu, check if it has unsaved changes and show message saying it's not possible until they save changes CHANGE - CORE - Add more information to the "help" modal in the sheet page CHANGE - CORE - Add option to cancel the process when loading rows (If the search query is too slow, the screen locks up, allow to cancel to try with another search query) CHANGE - CORE - Allow to disable the serialized fields module programmatically CHANGE - CORE - Allow to load the heartbeat api on the spreadsheet page to notify the users when the auth session expires CHANGE - CORE - Don't execute the wp filter in the gutenberg active check to avoid breaking other themes/plugins using the hook that require other wp functions that don't exist in that context CHANGE - CORE - Products teaser - Indicate that variable products aren't supported in the "load rows" notification CHANGE - CORE - quick setup - the post types list should link to the right product instead of sending everybody to the post types plugin CHANGE - CORE - When we open the main menu and one sheet is already setup, open the spreadsheet page directly instead of sending every time to spreadsheet setup CHANGE - FILTERS - Save the previous session filters only if rows were found and loaded, load the sheet on future sessions without any filters if rows weren't found CHANGE - FORMULA - When executing a formula. If it's the slug column and clear value, use slow execution automatically CHANGE - FORMULAS - Indicate how to change the saving speed in the same way as the "save" popup CHANGE - FORMULAS - Remove the "formulas" and "formulas builder" references in the UI because now it's called "bulk edit" CHANGE - GLOBAL - Add utm tags to the "Author URI" URL in the main php files CHANGE - GLOBAL - Include the posts-templates module in the events plugin (premium) CHANGE - GLOBAL - Include the posts-templates module in the post types plugin (premium) CHANGE - GLOBAL - Include the yoast module in all the premium plugins CHANGE - GLOBAL - show the "My license" item in the toolbar only for admin users CHANGE - PRODUCTS - When we change a variation post type to "product", copy the relevant information from the parent product to the new product CHANGE - UNIVERSAL SHEET - CSV IMPORT - Allow multi-line values in cells CHANGE - UNIVERSAL SHEET - IMPORT - Improve the progress message to indicate the count of updates and creations, instead of indicating the counts from the last batch CHANGE - UNIVERSAL SHEET - REST API - sheet settings - return the export and import columns to make it easier to use CHANGE - WC Products - Allow to copy paste the "default attributes" cells and save as plain text CHANGE - WC Products - Formulas - Allow to remove duplicates based on sku CHANGE - WC PRODUCTS - IMPORT - Now we can identify existing products by SKU or title only CHANGE - WOOCOMMERCE - Allow to filter the export columns list CHANGE - YOAST - Show the "primary taxonomy" column as terms dropdown instead of term id FIX - CORE - Gutenberg - When we're adding a link to the text and we make a search, the search results list disappears before we can make a selection for the link FIX - CORE - PHP warning is shown when we save empty taxonomy terms FIX - CORE - When we reached the columns limit, it didn't allow us to update existing columns FIX - FORMULAS - When we delete rows, the pagination breaks because the page number and rows count changes on every iteration FIX - GLOBAL - When the columns limit is reached, don't exclude columns that have allow_to_hide = false FIX - SPREADSHEET SETUP - We can't delete custom post types created in this page FIX - UNIVERSAL SHEET - Export - it exports all columns, regardless of the selected columns - when column visibility settings are empty FIX - UNIVERSAL SHEET - EXPORT - When we pause an export, the resume button doesn't appear FIX - UNIVERSAL SHEET - EXPORT - When we pause an ongoing export and start it again, the action buttons are hidden by mistake FIX - UNIVERSAL SHEET - IMPORT - Don't create placeholder products unnecessarily FIX - UNIVERSAL SHEET - IMPORT - Improve the auto mapping of columns, remove trailing spaces FIX - UNIVERSAL SHEET - IMPORT - Sometimes products with the same name were updated when we needed to create new products FIX - UNIVERSAL SHEET - IMPORT - The total rows in the progress message are wrong because they consider rows with multi-line values as multiple rows FIX - UNIVERSAL SHEET - REST API - PHP warning shows when we check if the rewrite rules are set up FIX - UNIVERSAL SHEET - When we import some csvs, some characters appear as ? FIX - WC Products - Error when saving default attributes if the global attribute used a custom slug, not generated from the sanitized title FIX - WC Products - Import - When the WC API returns an error, show it to the user instead of failing silently FIX - WC Products - REST API - make it work with the special columns from WC Core = V 2.11.1 - 2019-04-23 = NEW - CORE - Add "Order" (menu_order) column to post types that support page-attributes CHANGE - COLUMNS VISIBILITY - Improve design of the "A column is missing?" section in "spreadsheet setup" page FIX - CORE - When we rescan the columns, we're not clearing the meta keys cache, so the advanced filters don't show the latest columns FIX - CORE - Always allow the registration of the ID column, regardless of the columns limit, to prevent errors during saving FIX - CORE - When we save hierarchical taxonomies, the IDs of the existing terms were saved as new instead of assigning the existing ones FIX - WC Products - Copy variations - When we copy variations and the previous variations of the target products were removed, remove the rows from the sheet afterward FIX - UNIVERSAL SHEET - EXPORT - The 2nd page and up have column values in a different order = V 2.11.0 - 2019-04-17 = NEW - UNIVERSAL SHEET - Added option to export data to a CSV file NEW - UNIVERSAL SHEET - Added option to import CSV files with advanced column mapping and import settings NEW - UNIVERSAL SHEET - Allow to export individual columns using the contextual menu (right click on the sheet column) NEW - ADVANCED FILTERS - Allow searching by post data fields (id, title, content, date, etc.) using any operator, including finding empty values NEW - ADVANCED FILTERS - Allow searching by taxonomy fields using any operator, including finding empty values NEW - ADVANCED FILTERS - Allow to search posts using a list of URLs NEW - ADVANCED FILTERS - Allow to search rows by range of IDs NEW - CORE - Add option to change the max columns limit NEW - CORE - Add option to delete posts completely NEW - CORE - Add option to disable the serialized columns support to improve performance on some cases NEW - CORE - Add option to not load rows automatically NEW - CORE - Add option to open columns visibility tool using the sheet's context menu NEW - CORE - Added full screen mode NEW - CORE - Advanced settings - Added option to disable the use of wpautop NEW - CORE - Allow to bulk edit post type NEW - CORE - Allow to lock columns using the context menu NEW - CORE - taxonomy terms cells - Allow to save hierarchical values using the parent > child syntax NEW - CORE - When we scroll to the right and the sheet ends, automatically show a message indicating how to add any missing columns (only premium) NEW - FILTERS - Allow to search by status=trash NEW - FILTERS - Apply the filters from previous session when we open the sheet NEW - WC Products - Added compatibility with WooCommerce 3.6 NEW - WC Products - Copy variations - Add option to exclude the variation image during the copy (advanced settings) NEW - WC Products - Copy variations - Include in the copy the custom fields added by other plugins NEW - WC Products - FORMULAS - Allow to clear all default attributes at once NEW - WC Products - FORMULAS - Allow to clear all download files at once NEW - WC Products - FORMULAS - Allow to clear all product attributes at once NEW - WC Products - Variation - Allow to edit the status column in the cells to move individual variations to trash CHANGE - COLUMNS VISIBILITY - Add "arrow" buttons to deactivate/active columns CHANGE - COLUMNS VISIBILITY - Allow to remove columns only if they are disabled CHANGE - COLUMNS VISIBILITY - Don't show option to "hide columns" on the context menu if the column is not allowed to be hidden (i.e. ID) to prevent issues CHANGE - COLUMNS VISIBILITY - Improve the UI so the user knows why columns are missing and how to add new columns CHANGE - CORE - Added more capability checks CHANGE - CORE - Allow to edit the post modified date column CHANGE - CORE - Image cells - append new images instead of replacing the existing images when the cell accepts multiple images CHANGE - CORE - increase columns limit to 310 because the 250 limit was reached too easily CHANGE - CORE - Move "My license" button from the logo section to the secondary toolbar CHANGE - CORE - Post terms prefetch cache - Use the cache only for non-hierarchical taxonomies to support the use of the parent > child syntax for hierarchical terms CHANGE - CORE - Replace "Posts not found" with a clearer message when the search criteria doesn't return posts CHANGE - CORE - Save tool. Deactivate button if there's nothing to save to avoid unnecessary clicks CHANGE - CORE - Save tool. Show the "changes aren't reversible" warning one time only and start saving automatically in the next time CHANGE - FILTERS - Add "Active filters" to the filter buttons above the sheet clarify that the rows are filtered CHANGE - FILTERS - Move the "date range" search field into the "advanced filters" section to simplify the form CHANGE - FORMULAS - Add option to select if we want to edit all items, so we don't have to use the search popup if unnecessary CHANGE - FORMULAS - Allow to execute bulk edits without leaving the spreadsheet page CHANGE - FORMULAS - Allow to select values from a dropdown or checkbox when editing a dropdown or checkbox column, instead of having to figure out and type the value manually CHANGE - FORMULAS - Improved error messages so the user knows why the bulk edit failed CHANGE - FORMULAS - Remove sanitization on replace formulas if the user has the unfiltered_html capability CHANGE - FORMULAS - Show alert "When you execute this you will leave the page..." only when we have unsaved changes CHANGE - POSTS TEMPLATES - Add JS validation to the form to avoid unnecessary submissions CHANGE - WC Products - Allow to edit the status column on variations to delete individual variations (move to trash) CHANGE - WC Products - Display variations - Don't show the "we need to reload" alert if we don't have unsaved changes CHANGE- CORE - taxonomy terms cells - Display hierarchical terms using the parent > child syntax FIX - COLUMNS VISIBILITY - Columns with long titles appeared in 2 lines breaking the text alignment. FIX - CORE - Checkboxes with numeric values always appeared unchecked in the cells FIX - CORE - If the saving fails due to a server error, show the close button on the popup so we can save again FIX - CORE - iframes were removed from the post content on save FIX - CORE - SERIALIZED FIELDS - When we save one field, clear the provider cache, otherwise it only saves one subfield change per post FIX - CORE - The first ajax call to load rows was executed twice by mistake FIX - FILTERS - When we display the active filter buttons, strip html from the displayed value and limit to 20 characters FIX - FORMULAS - Deactivate column placeholders when executing a regex replace to avoid conflicts with the $xx$ syntax FIX - FORMULAS - REPLACE - regex is not parsed properly for regex replacements FIX - UNIVERSAL SHEET - CSV column ID is not auto mapped to the ID field FIX - UNIVERSAL SHEET - Import - Auto map attribute name and download columns when importing the export file or sample file FIX - UNIVERSAL SHEET - Import - When we import the sample CSV, it creates blank products FIX - WC Products - "visibility" column appears duplicated on old stores FIX - WC Products - Copy variations - the variation description is not included FIX - WC Products - Search by variation - it didn't work when PHP runs on a 32bit architecture FIX - WC Products - The "variation enabled" column is locked on variation rows when it shouldn't FIX - WC Products - The variation rows have empty titles FIX - WC Products - When we display variations, the pagination skips some products because it considers the variation rows as product rows = V 2.10.0 - 2019-03-01 = NEW - FORMULAS - Add option to delete posts containing duplicate values (it works on wp core fields only). NEW - CORE - Add admin-notice tip to the wp-admin>users.php page, similar to the coupons notice CHANGE - CORE - Serialized fields - Added object cache to improve performance during reading context CHANGE - CORE - Limit columns quantity to 250 to avoid performance problems when posts have too many fields CHANGE - Updated to freemius v2.2.4 FIX - FORMULAS - Sometimes the columns visibility doesn't have a list of unfiltered columns causing an "invalid column" error when executing formulas, added a fallback to prevent it FIX - COLUMNS VISIBILITY - Spreadsheet setup - when clicked "auto detect new columns" it shows json FIX - WC Products - Force WC to generate variation titles with all attributes, even when having a lot of attributes FIX - WC Products - FORMULAS - The options search doesn't find visibility terms = V 2.9.3 - 2019-02-14 = FIX - CORE - If frontend plugin is active, the "wp sheet editor" admin menu is not registered FIX - CORE - When allowing initialization on frontend, the core functionality never initializes because it uses a wp-admin only action. = V 2.9.2 - 2019-02-13 = FIX - WC Products - When we create variations, the parent product and variations don't appear on the sheet automatically FIX - WC Products - When we reload one variable product to display along its variations, the parent product disappears from the sheet FIX - WC Products - Variations - The attribute columns appear empty caused by the disabling of the post meta cache FIX - WC Products - When we create variations for the first time and save, it doesn't save the prices FIX - WC Products - When we create new variations, the "content" and "gallery" columns on the parent become locked FIX - WC Products - Variations images aren't saving FIX - CORE - Revert the disabling of the post meta cache when loading rows because it causes issues with blank columns and post saving. = V 2.9.1 - 2019-02-09 = CHANGE - WC Products - Remove "total sales" column from the blacklist, allow to view as readonly on the spreadsheet CHANGE - WC Products - Remove "review count" column from the blacklist, allow to view as readonly on the spreadsheet CHANGE - WC Products - Remove "average review" column from the blacklist, allow to view as readonly on the spreadsheet FIX - WC Products - The sale and regular price columns were blacklisted by mistake FIX - FORMULAS - WC Products - the sql formulas broke the serialized array on download files = V 2.9.0 - 2019-02-06 = NEW - CORE - Add option to change term separator character for taxonomy cells NEW - POST TEMPLATES - Added "duplicate" tool to spreadsheet NEW - CORE - allow to hide columns using the contextual menu NEW - ADVANCED FILTERS - Allow to search by list of IDs NEW - ACF - Added support for the Maps field and generate GPS coordinates from the address automatically NEW - SEARCH - WC PRODUCTS - Add option to search on variations NEW - FORMULAS - Add edit type "Clear value" NEW - CORE - Allow to copy paste image cells NEW - CORE - Allow to edit image cells as plain text NEW - CORE - Allow to enter external urls in image cells NEW - CORE - Allow to copy paste content cells NEW - CORE - Allow to edit content cells as plain text and using the tinymce at the same time CHANGE - FILTERS - Contains keyword - Search using the main sql query instead of a separate query to improve performance CHANGE - FILTERS - Not contains keyword - Search using the main sql query instead of a separate query to improve performance CHANGE - FILTERS - Don't show the authors filter if the post type doesn't support authors CHANGE - WC PRODUCTS - Show attributes in the variation title to help identify variations CHANGE - CORE - tinymce popup - make it bigger by default (now it's too small) CHANGE - CORE - When we create new rows, load all the new rows. Now it loads only the first 10 CHANGE - ADVANCED FILTERS - When selecting a checkbox/select , show the real checkbox/dropdown instead of plain input so they can select the value (Now they don't know what value to use) CHANGE - ADVANCED FILTERS - Show individual filters in the current filters area instead of a global "advanced filters" item CHANGE - FILTERS - When we remove a filter from the "current filters" section, clear the field on the search form as well CHANGE - CORE - Usage stats widget - Tweak css to use less spaceAll plugin names must use "wp sheet editor - " as prefix , specially secondary plugins, so users can identify them quickly CHANGE - CORE - COLUMNS API - Added options when register columns, so we can define read/save callbacks, helpful for registering columns for unrecognized data sources CHANGE - CORE - move visual composer buttons from the content column to a separate column CHANGE - CORE - Rewrite the gutenberg cell to have feature parity with the tinymce cell, so you can edit as plain text, copy paste, and update with formulas CHANGE - CORE - when we copy locked cells, exclude the html lock icon from the copy, copy the real value CHANGE - CORE - Image cells - Indicate if value is empty CHANGE - CORE - Image cells - show excerpt of the value CHANGE - CORE - Move locked cells rendering logic to the JS to improve performance and refactor PHP code. CHANGE - CORE - Allow to edit tinymce cells without internet connection and save all the changes later CHANGE - CORE - COLUMNS - Improved API to simplify the programmatic removal and update of column settings CHANGE - WC Products - Optimize performance of inventory stats calculation. Reduced from ~1.2secs to 0.2secs CHANGE - CORE - Disable term meta cache update when retrieving terms to improve performance. CHANGE - CORE - Added internal data store to database providers to cache all db queries and reuse objects CHANGE - CORE - Added prefetch logic to fetch all information from the database at once to improve performance. Reduced load time for 1000 rows at once, from 49secs to 7secs CHANGE - COLUMNS VISIBILITY - Added option to refresh columns list and detect new fields. CHANGE - CORE - Cache columns list for 30 minutes on small sites, 7 days for big sites, to avoid scanning all database fields on every spreadsheet load. This reduced 1.2secs load time when loading 1000 rows at once CHANGE - CORE - Load taxonomy terms for cells using ajax. This reduced load time by up to 1 second on big sites CHANGE - CORE - Now you can enable the post-slug column live on the spreadsheet, no need to visit the settings page and reload spreadsheet CHANGE - CORE - TinyMCE popup - now the save button closes the popup automatically CHANGE - CORE - Removed help button from the quick setup > 2nd step > top because no one used it in 2 months CHANGE - CORE - usage stats widget - if the current user is not administrator, show the "open spreadsheet" and "help" links only FIX - WC Products - We can't copy variations if the original variation has fields that inherit value from the parent product, and those fields are missing from the target product FIX - CORE - Gutenberg - media gallery and tinymce inline editors were hidden by mistake FIX - COLUMNS VISIBILITY - "Delete" button sends to blank page on spreadsheet setup page FIX - FORMULAS - Execute on variations doesn't find variations to update, wrong query FIX - WC Products - Sometimes product features don't load because WC loaded too late on rare multisite installs FIX - ADVANCED FILTERS - When we remove one advanced filter and submit form, the filter is not removed from the rows request FIX - CORE - Make it work on php < 5.6 FIX - CORE - When we activate the premium plugin (CORE or WC Products) deactivate the free inventory spreadsheet because it's included in the premium plugin FIX - FORMULAS - WC Products - The "short description" column has wrong name in the dropdown, it shows as "excerpt" FIX - FORMULAS - WC Products - The "enable reviews" column has wrong name in the dropdown, it shows as "comments" FIX - WC Products - short description is locked by mistake - it should be editable with tinymce renderer FIX - WC - We can't copy variations if the original variation has fields that inherit value from the parent product, and those fields are missing from the target product = V 2.8.2 - 2019-01-21 = INTERNAL - CORE - Added profiling API to faciliate performance testing. CHANGE - CORE - Optimize rows loading. Reduce load time for 100 rows from 27 to 7 seconds FIX - CUSTOM COLUMNS - Form in settings page is not saving (nonce validation is failing) FIX - CORE - Error 500 on rare occassions when /wp-admin/includes/post.php is loaded by wp or other plugins FIX - CORE - Disable links on post content when editing with Gutenberg to avoid navigating away by mistake = V 2.8.1 - 2019-01-18 = FIX - FORMULAS - It's not executing, validation always fails = V 2.8.0 - 2019-01-16 = NEW - CORE - Added support for Gutenberg. Use Gutenberg right on the spreadsheet. NEW - CUSTOM COLUMNS - Added automatic support for serialized columns (Experimental feature). NEW - CUSTOM COLUMNS - Detect custom fields with boolean values and show them as checkboxes on the sheet (Experimental feature). NEW - FILTERS - Allow to search by multiple keywords at once. NEW - WC Products - Allow to copy variations from one product into all products from the current search. NEW - Sheet setup - Add private URL parameter to delete all post types added through the setup page. NEW - Search - USERS - allow to search by users with/without WooCommerce orders NEW - USERS - Allow to delete individual rows CHANGE - CORE - extensions list - CSS tweak. CHANGE - CORE - remove icons from secondary toolbar to simplify it. CHANGE - FACTORY API - Allow to define columns as callable to generate during runtime. CHANGE - CORE - When we edit images/files on the "file upload" column, auto select the existing file on the media gallery CHANGE - CORE - Use get_userdata when generating post_author cell value to improve performance. CHANGE - USERS - Remove private fields from sheet CHANGE - WC Products - When we edit downloadable files in the cell/formula, set downloadable=true automatically because WC doesn't save the files when products aren't downloadable forcing the user to set it manually and set files again. CHANGE - CORE - Improved the ability to copy paste large amounts of data from Google Sheets and Excel. CHANGE - CORE - Improved the usability on mobile devices/touch screens. CHANGE - FORMULAS - Add message indicating that missing columns can be enabled. FIX - CORE - when we edit post slugs, wp doesn't redirect the old slug to the new one FIX - CUSTOM COLUMNS - Don't register columns with empty key, rare error caused by corrupted mysql data. FIX - CORE - If the current user is not allowed to edit posts from a post type, don't register a blank sheet for the post type. FIX - WC Products - Formulas - The "downloadable files" column doesn't appear in the list. FIX - WC Products - the taxonomy columns weren't registered on the sheet automatically (category, tags, and attributes missing). FIX - WC Products - When editing a price, it didn't sync with the private _price field making it not show on the frontend. FIX - FORMULAS - When searching using advanced filters, it updates all posts ignoring the search parameters. FIX - FORMULAS - When executing with the slow method, the progress text shows the wrong number of posts updated per batch. FIX - CORE - CUSTOM COLUMNS teaser shows oembed columns crashing the browser with hundreds of columns on rare occasions, which should be excluded. FIX - FORMULAS - The pagination is not working, it's always updating the first page repeatedly. FIX - FORMULAS - The "execute on variations" parameter is not working. FIX - ACF - Checkbox columns don't save the values on the right order. FIX - CORE - Added more than 200 bug fixes and performance improvements to the spreadsheet. FIX - FORMULAS - Pagination used wrong total rows, making it not execute on the last page = V 2.7.0 - 2018-12-20 = NEW - ACF - Added support for checkbox fields NEW - FORMULAS - Added support for serialized fields registered programmatically through the Serialized Fields API NEW - CORE - Updated Serialized Fields API to support fields on user profiles (users extension) NEW - CORE - Added spreadsheet factory API to create independent sheets easier NEW - Created "easy digital downloads" spreadsheet. CHANGE - CORE - tinymce - post_content - indicate that it doesn't work with gutenberg blocks and it works only with classic text CHANGE - FORMULAS - Added hook 'vg_sheet_editor/save_rows/before_saving_cell' to standarize the saving filtering CHANGE - Improved the columns api FIX - CORE - When we prepare the "reading" value of a taxonomy cell, if the post has a term ID assigned with corrupt/missing values it causes error 500 FIX - COLUMNS VISIBILITY - When they're displayed on the quick setup, they have display: none and the page looks blank FIX - ACF - Fields added on metaboxes containing multiple location conditions aren't showing on the sheet FIX - CORE - CSS tweak FIX - CORE - products teaser show when the products sheet is active FIX - CORE - Rare mysql bug that sometimes returns repeated rows in next paginated requests. Added JS filter to not add repeated rows as workaround FIX - WC Products - The featured column is not saving FIX - WC Products - The product_visiblity column wasn't saving using the WC 3.5 db arquitecture FIX - FORMULAS - js error caused by EDD's admin-scripts.js FIX - WC Products - When adding prices to a variation, the add-to-cart button still shows "Read more" instead of "Select options" = V 2.6.0 - 2018-12-07 = NEW - EVENTS - Released events, venues, and organizers spreadsheet. NEW - FORMULAS - Added $random_letters$ placeholder. Useful for generating coupon codes, passwords, etc. NEW - ACF - Added support for relationship fields. NEW - CORE - API. Added new cell type: metabox, which allows to show metaboxes in the spreadsheet for compatibility with complex UIs/data types. NEW - FORMULAS - Allow to exclude posts by keyword. NEW - ADVANCED FILTERS - Add "post parent" filter. NEW - FORMULAS - integrate search tool into the formulas builder to simplify the formulas form and allow advanced post selection. NEW - CORE - COLUMNS VISIBILITY - Add option to remove/restore columns completely for unused fields. NEW - CORE - Add option to settings page to allow to enable/disable object cache invalidation when saving posts. NEW - CORE - Added options to context menu on the sheet to freeze/unfreeze columns. NEW - CORE - Added options to context menu on the sheet: copy, cut, paste. CHANGE - FORMULAS - Make the search and replace fields as textarea to allow to replace entire paragraphs. CHANGE - COLUMNS VISIBILITY - When we create/detect new fields after columns were sorted/enabled/disabled, show the new columns as default instead of hiding them. CHANGE - COLUMNS VISIBILITY - Don't show columns in the settings that don't allow to be sorted/hidden. CHANGE - CORE - hide all wp notices in sheet page to make it cleaner. CHANGE - CORE - tinymce - post content - indicate that it's possible to edit as plain text and link to settings. CHANGE - CORE - sheet - move all settings related tools to a dropdown under settings - to simplify the toolbar. CHANGE - POSTS TEMPLATES - Now templates must be posts with "private" status, to improve settings page performance on sites with thousands of posts. FIX - ADVANCED FILTERS - When we search it adds a empty meta filter and causes "no results found". FIX - CORE - Allow to load assets on any page related to sheet editor and stop checking if post types are valid. FIX - FILTERS - Allow to submit by pressing enter. FIX - CORE - Some forms in popups didn't submit. FIX - COLUMNS VISIBILITY - Save settings in independent field, redux was resetting the columns. FIX - COLUMNS VISIBILITY - When we open the list, it shows the enabled columns in the wrong order. FIX - ACF - true/false fields show "bad value" when we uncheck them. FIX - CORE - Don't show the excerpt cell as html, show it as plain text. FIX - WOOCOMMERCE - Variations attribute columns appear empty and values are not saved. FIX - WC - Add support for Cross-sell and up-sell fields (save product ids separated by commas). FIX - CORE - can't copy more than 1000 rows at once. FIX - GLOBAL - php warnings. FIX - CORE - when we activated all sheet plugins at once, sometimes the same sheet appeared duplicated on the wp-admin menu. = V 2.5.2 - 2018-11-04 = NEW - CORE - PREMIUM - Added support for Advanced Custom Fields +v5.0.0 NEW - CORE - Added activity log to improve the user experience locally. NEW - FORMULAS - REPLACE - Allow regular expressions CHANGE - FORMULAS - Simplified popup, removed all unnecessary text and elements. CHANGE - CORE - Replace TGM library with direct link to wp plugin search. CHANGE - FORMULAS - Added option to use the slower, safer execution method CHANGE - CORE - Refactoring made to the bootstrap api to allow extensions to control the spreadsheet initialization CHANGE - CORE - Add message to indicate that tinymce editor can be resized. CHANGE - CORE - PREMIUM - Add option to disable extension offerings. CHANGE - FILTERS - Separate "locate cell" and "search" tools to avoid confussions. FIX - WC - FORMULAS - When using other columns in a math formula as placeholders, it generates wrong result FIX - ADVANCED SEARCH - When value is empty (we are searching for posts that have an empty field), include the NOT EXIST operator in the query because it doesn´t find all products FIX - ADVANCED SEARCH - when we make a search by keyword, it doesn´t find results because there is an advanced filter empty FIX - CUSTOM COLUMNS - Don't show private columns from WP CORE, ACF, and WC FIX - CORE - The post type teaser in the quick setup's first step doesn't show all post types FIX - CORE - Advanced filters teaser - fields were misaligned and didn't show FIX - CORE - WC Teaser - All columns were locked, enabled the free columns. FIX - CORE - Freemius optin - Can´t skip optin page FIX - CORE - Upgrade buttons on formulas and custom post type teasers didn't work. FIX - CUSTOM COLUMNS - In the users spreadsheet it doesn´t register custom fields columns automatically FIX - WC - Edit attributes - When saving multiple terms in global attributes, it saves them as single term. FIX - FORMULAS - When a product doesn´t have a meta_key in the database, the SQL execution doesn´t update the product FIX - WC - When a product was updated on the spreadsheet, the sale price date range was changed to a wrong timestamp FIX - WC - When a sale price date is updated, the price and dates weren´t syncing properly FIX - CORE - When opening tinymce editor in popup , the media gallery opens underneath the editor FIX - CORE - Quick setup - delete post type doesn't work FIX - CORE - Post type setup - If we send an existing post type, don't save it, just enable the existing post type. FIX - CORE - Image cell - Show the large preview at the left side if the column is at the right side. FIX - CORE - View Post - When we edit the post url in the sheet, the view post cell shows a broken link = V 2.5.1 - 08/12/2018 = CHANGE - CORE - Added custom fields column teasers for the users spreadsheet. CHANGE - CORE - Added custom fields search teasers. FIX - CORE - JS error caused by the plugin: "woocommerce product slider" FIX - CORE - User provider - We can´t create a lot of users at once because sometimes the temporary username is repeated and wp doesn´t create all the users. FIX - POSTS TEMPLATES - When we install another extension first, then CORE, the posts templates welcome page shouldn´t be displayed, it interrupts the extension setup flow. = V 2.5.0 - 07/22/2018 = NEW - CORE - Now Featured image cell shows image previews with zoom. NEW - FILTERS - Added "locate cell" tool, which finds and highlights cells in the spreadsheet. FIX - CORE - The wp core editor stopped working when you tried to open a custom post type not allowed by wp sheet editor. FIX - ADVANCED FILTERS - meta field dropdown is not showing all fields. FIX - Advanced Filters - meta filters are not working, they return empty search results. = V 2.4.0 - 07/17/2018 = NEW - FORMULAS - "Replace" allows empty search field to update empty fields only. NEW - CUSTOM COLUMNS - Detect custom fields automatically and display the columns. NEW - CORE - Added API for serialized fields columns. CHANGE - CORE - Quick setup - Make it easier to skip the second step (modules selection). CHANGE - CORE - Quick setup - Add "need help?" buttons in the entire process to reduce friction. CHANGE - FORMULAS - Allow to save post status by key or friendly name. CHANGE - FORMULAS - Dont allow to save invalid post statuses. CHANGE - CORE - When people try to open the settings page and reduxframework is missing show a message asking them to install it. CHANGE - CORE - Compress secondary toolbar to reduce clutter. CHANGE - CORE - FREE - Add custom columns teaser. CHANGE - FORMULAS - Removed the "automatic execution" UI. It confused users. CHANGE - Add help messages in custom columns page, formulas popup, and quick setup flow. FIX - CORE - Show as simple text is not working. FIX - CORE - Fix some license activating issues (updated freemius sdk). = V 2.3.1 - 06/11/2018 = CHANGE - Revert "fix - Columns visibility - when opening the products spreadsheet for the first time, the core columns are hidden" made in previous update to investigate the issue further. FIX - CORE - When you enable post types in the quick-setup page, the last step doesn´t show a button to start editing the new post types. = V 2.3.0 - 06/03/2018 = NEW - Formulas - Allow to execute on posts matching a keyword in the title. NEW - Formulas - Allow to execute formulas automatically after creating a post. NEW - Formulas - Allow to save formulas for ongoing execution. FIX - Formulas - When replacing in a downloadable file, it saves the wrong name FIX - Columns visibility - when opening the products spreadsheet for the first time, the core columns are hidden. CHANGE - CORE - Updated Freemius SDK. = V 2.2.0 - 05/30/2018 = NEW - CORE - Allow to disable cells lazy loading in order to use the browser search tool. NEW - CORE - Allow to offset the rows to skip a number of posts. NEW - WOOCOMMERCE - Allow to update downloadable files with formulas. NEW - CORE - add column with button linking to post URL. FIX - WOOCOMMERCE - When copying variations from one product to another the global attributes are saved as custom. FIX - WOOCOMMERCE - When copying variations from one product to another it saves wrong variation image. FIX - WOOCOMMERCE - Improved performance for inventory calculations. FIX - CORE - Improved performance for sites with thousands of users. CHANGE - CORE - Disable heartbeat api in the spreadsheet page to improve performance. = V 2.1.0 - 05/01/2018 = NEW - POST TEMPLATES - Released free extension for duplicating posts in the spreadsheet. NEW - COLUMNS VISIBILITY - This premium feature is now free. You can hide and sort columns in the spreadsheet. NEW - AUTO FILL CELLS - This premium feature is now free. You can autofill cells by dragging down a cell like you do in excel. NEW - WOOCOMMERCE - Now we calculate the total inventory units and total inventory price of all the products in the spreadsheet and display it in the status bar NEW - WOOCOMMERCE - Added new columns to the free version of the plugin: SKU, Width, Length, Height, Weight, Manage stock, Stock status, and stock quantity. CHANGE - CORE - Improved usability. We updated some texts to make it clear what features are free and what features are premium CHANGE - CORE - the quick setup flow was redesigned to make the setup easier to understand. CHANGE - CORE - Improved translations. Now we include a .pot file. FIX - CORE - Added compatibility with "ultimate fields" plugin. = V 2.0.0 - 04/01/2018 = NEW - WooCommerce - Allow to clone variations from one product to other products NEW - WooCommerce - Create variation - Allow to create variations for multiple products at once. NEW - WooCommerce - allow to copy downloadable files from other product in popup NEW - CORE (free) - Add "search" tool. Search by keyword, author, and post status. NEW - COLUMNS RESIZING - Allow to resize columns and save for next sessions. NEW - FORMULAS - Allow to execute formula only on WooCommerce variations. NEW - FILTERS - Added bar showing active filters with options to remove individual filters. NEW - FILTERS - Added advanced meta filters with operators like =, !=, <, >, LIKE, etc. NEW - CORE - Added status bar showing number of posts loaded in spreadsheet and total posts available according to the filters. NEW - CORE - Added settings page button in the toolbar for quick access. NEW - CUSTOM COLUMNS - Added settings page button in the toolbar for quick access. NEW - FORMULAS - Added option for executing custom formula on any field type. NEW - PRO - Added set up wizard for post types that allows you to set up a post type and custom columns quickly. NEW - FORMULAS - Added direct SQL execution for simple formulas allowing to update thousands of posts in just a few seconds. Huge speed improvement. NEW - CORE - Updated welcome page to showcase extensions. NEW - PRO - Added option to create new spreadsheets for new post types. NEW - USERS - Released users extension for editing WordPress users profiles in spreadsheet. NEW - UNIVERSAL SHEET - Released extension for exporting posts to Google Sheets, Excel, or any spreadsheet program, and Importing back to WordPress. CHANGE - CORE - Updated texts for improved usability. CHANGE - CORE - Removed extensions teasers and replaced with a simple text message. CHANGE - CORE - If the spreadsheet wasn´t modified, don´t show the "please save your changes" notification when the page is closed. FIX - CORE - When closing file uploads or tinymce popups, the screen doesn´t return to the original position. FIX - CORE - Sometimes options page doesn´t load. FIX - CORE - Schedule posts are not showing on spreadsheet. FIX - WooCommerce - Variation titles appear empty. FIX - FORMULAS - Sometimes it doesn´t update the last posts. FIX - FORMULAS - Sometimes when searching post terms while preparing formula, it doesn´t find any. FIX - FILTERS - When using the same filter multiple times with different values it starts returning wrong posts. FIX - FILTERS - When making a lot of searches, the total posts count changes and the infinite scroll stops working. FIX - CUSTOM POST TYPES - It doesn´t allow post types created after the settings page is registered, ignoring post types added by "types" plugin. FIX - FORMULAS - It doesn´t accept decimal numbers. FIX - CORE - it doesn´t allow to create new WooCommerce products. FIX - CUSTOM COLUMNS - It doesn´t allow to remove the first column. FIX - WooCommerce - When editing attributes it marks "visible" and "is taxonomy" as true ignoring the set value. FIX - FORMULAS - it doesn´t allow to replace something with nothing (remove a value). FIX - FORMULAS - File columns dont save files when using url with query strings FIX - WooCommerce - download files popup doesn´t show previously edited values FIX - CORE - spreadsheet becomes too slow when loading thousands of rows. FIX - COLUMNS VISIBILITY - Drag and drop is not working on popup FIX - FORMULAS - Wrong formula generated for "decrease by %" option. = V 1.4.7 - 05/16/2017 = FIX: CORE - Allow users with "edit_posts" capability to use the editor. FIX: FORMULAS - JS error while executing formulas. FIX: CORE - It doesn´t save the post date on post with "draft" status. = V 1.4.6 - 05/03/2017 = FIX: CORE - sometimes it doesn´t save custom fields properly. FIX: CORE - file / image field - when selecting a new file save automatically otherwise the preview wont work. = V 1.4.5 - 05/03/2017 = FIX: CORE - Teasers dont check if the freemius premium plugin is active. = V 1.4.4 - 05/01/2017 = FIX: CORE - tinymce popup - links editor appeared underneath the modal. FIX: CORE - TGM - It uses wrong method causing a php error. FIX: WC - create posts - It creates products when we request to create other post types. Other small fixes and changes. = V 1.4.3 - 04/27/2017 = NEW: CORE - Integrated Freemius SDK. = V 1.4.2 - 04/21/2017 = FIX: CORE - When saving for a second time, it doesn´t recognize the last changes. FIX: CORE - tinymce - when editing links, the link editor is displayed below the modal. FIX: WC - variations titles appear empty some times. FIX: CORE - It keeps loading forever when creating new posts. FIX: WC - download_limit and download_expiry show -1 as value when it should be empty. FIX: Filters - Searching returns zero results. Other minor changes. = V 1.4.1 - 04/13/2017 = FIX: CUSTOM COLUMNS - JS Error when viewing pages that are not the editor. CHANGE: CORE - Now you can enable the editor on private post types (for advanced users). NEW: WOOCOMMERCE - Added "type" column to edit product type. CHANGE: CUSTOM COLUMNS - Now the "key" field autocompletes with the list of existing keys. = V 1.4.0 - 04/10/2017 = NEW: WooCommerce - Added "Edit Attributes" column for editing/creating custom and global attributes. NEW: WooCommerce - Added support for "variable" products and all their fields. NEW: WooCommerce - Added support for "downloadable" products and all their fields. NEW: WooCommerce - Added "Default Attributes" column for variable products. NEW: WooCommerce - Added "shipping_class" column. NEW: Formulas - Allow wildcards in REPLACE formula. NEW: Formulas - You can search and replace, or save images using URLs. NEW: Formulas - Added formulas builder to create formulas easily. NEW: Columns visibility - Added option to sort and hide columns live in the spreadsheet. NEW: CORE - Now you can upload images and files using URLs. CHANGE: WooCommerce - Rewritten attributes saving / displaying logic. CHANGE: CORE - After saving changes, the modified cells are no longer considered as modified. CHANGE: CORE - Dashboard widget - Added button to open the spreadsheet editor. CHANGE: CORE - Dashboard widget - Moved to the top of the page. CHANGE: CORE - Converted all cells for "yes | no" values to checkboxes to make it easier to edit. CHANGE: CORE - Allow to edit WooCommerce products in the free version, but with limited columns and product types. CHANGE: CORE - Done a performance audit in the spreadsheet and improved performance by 300%in some cases. Now you can open hundreds of posts in the spreadsheet. CHANGE: CORE - Done a performance audit in the saving process and improved performance by 200%in some cases. Now the saving is faster. CHANGE: WooCommerce - Added compatibility with PHP 5.2. CHANGE: CORE - Updated some texts and adding some upgrade invitations. FIX: CORE - When closing a popup it moves the scroll to the top and left, loosing the position. FIX: CORE - Checkbox cells displayed a "bad-value" message when the cells were empty. FIX: CORE - The saving log displays the last messages at the bottom making them not visible. FIX: Formulas - After executing a formula successfully it shows a message saying the process didn´t complete. FIX: Formulas - The updates log displays the last messages at the bottom making them not visible. FIX: PRO - When enabling the premium plugin it shows an error if the free plugin is active. FIX: CORE - QUICK USAGE - TGM - If another theme or plugin uses the library, the button in the page breaks. Other minor changes. = V 1.3.1 - 12/24/2016 = NEW: Options page - Added option to allow the edition of the post slugs column. It´s off by default for security reasons. NEW: Formulas - Added placeholders to use other columns values in formulas. FIX: Columns visibility - Fixed some PHP warnings. CHANGE: Options page - If reduxframework is not active, don´t display links to the options page to prevent confusions. CHANGE: Options page - If reduxframework is not active, save default settings during installation to allow the use of the plugin without reduxframework. FIX: Custom columns - Default data source is empty, so some columns are not connecting to the database. FIX: YOAST SEO - The score column is being registered even if YOAST SEO is not active or the column was disabled. FIX: Save changes - When loading more posts in the spreadsheet, it considers the last posts as "modified" and saves them with no need. FIX: Custom columns - new columns don´t allow to be hidden or renamed in options page, due to a wrong default setting. FIX: Custom columns - new columns are marked as "hidden" in the options page by default. FIX: Formulas > replace - If the search or replace text contains quotes, it breaks. FIX: Formulas > replace - It doesn´t save changes to the "content" column, sometimes it leaves the field blank losing existing content. FIX: Formulas > replace - If replacing $current_value and current_value is empty, the post is skipped. FIX: Options page - It doesn´t load the options page in some cases when reduxframework is loaded internally by other plugins. FIX: Quick usage screen - After saving settings it generates a redirection loop. FIX: Global - Sometimes the options dropdowns won´t open due to css conflicts with other plugins or theme. = V 1.3.0 - 12/05/2016 = NEW: CORE - Added option to fix the first column, so it´s always visible while scrolling to the right. NEW: Filters - Added option to search/filter by keyword in post title or post content. NEW: WooCommerce - Added columns: "allow backorders", "is featured", "manage stock", "stock quantity". NEW: Columns visibility - Now you can sort the columns on the settings page per post type. FIX: Custom columns - Some JS files were loading globally in wp-admin causing issues. = V 1.2.1 - 11/30/2016 = FIX: CORE - When saving email-optin notice it doesn´t save a flag to not display it again. FIX: CORE - Quick setup screen - when redux-framework is already active, TGM throws a warning. = V 1.2.0 - 11/28/2016 = NEW: Added "what´s new" page after plugin updates to show the new features to the users. NEW: Added "custom columns" module that allows to add custom fields to the spreadsheet editor. CHANGE: Added logo to the dashboard widget. CHANGE: SECURITY improvements = V 1.1.0 - 11/23/2016 = NEW: Added multisite compatibility, one license per network. FIX: License verification - Removed PHP error on old versions of PHP. NEW: Added Advanced Custom Fields integration. Edit basic ACF fields in the spreadsheet. FIX: WooCommerce Products Spreadsheet - JS conflict caused by WC JS files. NEW: Added Visual Composer integration. Use Visual Composer backend and live editor while using the spreadsheet editor. CHANGE: Dependencies - Don´t ask to install required plugins if the plugins already loaded from a theme. CHANGE: Quick usage screen - Added "Settings" button. FIX: Spreadsheet - Cells with very long values make the rows too tall. Now the text is truncated aesthetically but saved in full. CHANGE: Spreadsheet - If there are no posts to display, don´t display empty rows. CHANGE: Added "PRO Theme - Professional WP Admin Dashboard Theme" compatibility. CHANGE: Tweaked the CSS to prevent conflicts with other plugins. = V 1.0.1 11/08/2016 = FIX: when saving posts in the spreadsheet, the post ID is wrong. FIX: when saving posts, the modal on the front-end doesn´t show the right number of posts to be saved. FIX: when editing a "single image upload" cell, we get a JS error. = V 1.0.0 - 11/08/2016 = - Initial release.