In this page, you can see the changelog for the CORE modules included in all our spreadsheets.
If you want to see the changelog for our spreadsheet packages, check these links:
- Users extension changelog
- WooCommerce Customers Spreadsheet changelog
- WooCommerce Products changelog
- WooCommerce Coupons changelog
- Events changelog
- Frontend Sheets for Apps changelog
- Easy Digital Downloads Spreadsheet changelog
- Taxonomy Terms Spreadsheet Changelog
------ V 2.11.2 - 2019-05-pending ------ 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 - WooCommerce Coupons - Released coupons 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: Spreadsheet - Display file upload columns only if the wp user has permissions to upload files. CHANGE: SECURITY: Spreadsheet - Display only the posts that the wp user is allowed to view and edit. CHANGE: SECURITY: Spreadsheet - If the wp user is not allowed to publish or delete posts, we don´t show the option while editing posts. ------ 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.