Bulk Edit Posts and Products in Spreadsheet

Beskrivelse

A Spreadsheet created specially for WordPress. Edit posts in bulk using Spreadsheet.

It works with Gutenberg (new editor) and the Classic Editor

You can edit the post content using the Gutenberg editor right on the spreadsheet.
It also works with the Classic Editor.

Awesome things that you can do with WP Sheet Editor

  • View all your posts, pages, and woocommerce products in a spreadsheet
  • Edit posts in Spreadsheet (all core fields)
  • Edit pages in Spreadsheet (all core fields)
  • Create a lot of posts / products at once
  • Copy information between posts
  • Edit WooCommerce Products (Free version limited to title, status, regular price, sale price).
  • And more…

WP Sheet Editor is perfect for you if…

  • You are tired of opening several pages to edit your posts
  • You are tired of wasting time waiting for each post editor to load and save

Features

  • Spreadsheet where you can edit all the information of your posts, pages, and woocommerce products including post title, post content, post status, post excerpt, featured image, publish date, comment status, page parent, post categories, and post tags.
  • You can navigate in the spreadsheet with your keyboard
  • You can order the spreadsheet by any column.
  • You can edit hundreds of posts without reloading the page
  • It works on shared hosting (you can adjust the server consumption on the options page)
  • Developers can add custom columns to the spreadsheet using actions and filters.
  • WPBakery Page Builder integration. Open the live or backend editor right on the spreadsheet.

Premium features

WooCommerce Spreadsheet:

Edit woocommerce products using the spreadsheet.
It works well with Variable Products, Attributes, Downloadable Products, and Variations.

Buy WooCommerce Spreadsheet Plugin
Money back guarantee. We´ll give you a refund if the plugin doesn´t work.

Edit all product fields, including:

  • sale price
  • regular price
  • gallery
  • short description
  • stock status
  • stock quantity
  • featured image
  • visibility
  • is virtual
  • is downloadable
  • attributes
  • categories
  • tags
  • sale price dates
  • purchase notes
  • enable reviews
  • Shipping class
  • Custom fields
  • And more.

Buy WooCommerce Spreadsheet Plugin
Money back guarantee. We´ll give you a refund if the plugin doesn´t work.

Replace formula:

Apply changes to ALL YOUR POSTS AT ONCE with just a few clicks.

You can do a lot of things, like:

  • Replace words or phrases
  • Add a message at the end/beginning of your posts
  • Change posts status
  • Add a message above or below all the images.
  • Add shortcodes at the beginning or ending of all the posts in a specific category
  • Change all references to old prices in your posts
  • Change all links in your posts
  • Mark all products in a specific category as «out of stock»
  • Add a category to ALL THE POSTS in a specific category
  • Change post status from draft to publish, or any other
  • Set the same featured image in ALL the posts in specific category.
  • Replace an existing value with the current date
  • Etc.

Buy Premium Version

Math formula:

For example:

  • Increase / decrease products prices by a 10%
  • Increase / decrease your products stock in a specific product category

Advanced Custom Fields integration

Edit your metaboxes in the spreadsheet.

Add custom columns to the spreadsheet and edit other plugin´s fields.

Buy Premium Version

Copy information between posts in bulk

Do you need to set the same categories to 20 posts? Instead of adding every category manually, just drag one cell and paste it into the 20 cells below. Yes, it´s that easy.

You can copy titles, excerpts, post dates, categories, tags, etc.

You can enable / disable columns on the spreadsheet.

You can rename columns on the spreadsheet

Edit custom post types

You can enable the spreadsheet on ANY custom post type.

For example, you can edit the descriptions or captions of your images (media attachments) to improve your SEO.

If you theme added a «Portfolio» post type, you can edit the items too.

Buy Premium Version

Spanish / Español

Este plugin te permite editar entradas, artículo, y páginas usando una hoja de cálculo dentro de WP admin.
Tú puedes ver todos los posts y páginas en la hoja de cálculo y rápidamente editar los campos de WordPress.

La versión gratuita te permite:
– Ver todos los artículos, entradas, o páginas en la hoja de cálculo
– Crear y editar artículos, entradas, o páginas rápidamente
– Puedes buscar artículos por palabra clave, fecha, o autor
– Puedes copiar información de un artículo a otro
– Funciona con el nuevo editor de WordPress (Gutenberg)
– Puedes editar estos campos: título del post, contenido, estado, fragmento, imágen destacada, fecha de publicación, habilitar comentarios, página padre, categorías, y etiquetas.
– Editar precios de productos rápidamente usando la hoja de cálculo

La versión de pago te permite:
– Editar todos los tipos de posts: posts, páginas, productos de WooCommerce, eventos, portafolios, etc.
– Exportar e importar posts, páginas, productos para editar en excel o Google Sheets
– Editar todos los campos, el editor mostrará todos los campos del tipo de post. Ej. si son productos = todos los precios, inventario, galerías, etc.
– Hacer búsquedas avanzadas por cualquier combinación de campos (ej. buscar por precio, organizadores, información seo, etc.)
– Editar miles de artículos a la vez en un segundo (ej. eliminar cientos de artículos, reemplazar textos, establecer precios en lotes, actualizar fotos, etc.)

Descarga versión de pago
Garantía de devolución de dinero si no te funciona el plugin.

Skjermskudd

  • spreadsheet editor
  • settings page

Installasjon

Automatic installation

Automatic installation is the easiest option as WordPress handles the file transfers itself and you don’t need to leave your web browser. To do an automatic install log in to your WordPress dashboard, navigate to the Plugins menu and click Add New.

In the search field type WP Sheet Editor and click Search Plugins. Once you’ve found our plugin you can install it by simply clicking “Install Now”.

Manual installation

The manual installation method involves downloading our plugin and uploading it to your webserver via your favourite FTP application. The WordPress codex contains instructions on how to do this here.

FAQ

What kind of posts can I edit using the spreadsheet?

Only posts, pages, and woocommerce products with the free plugin.

WooCommerce Products include LIMITED support, you can edit only simple products and you can edit prices only.

The premium plugin allows you to edit ANY custom post types, including WooCommerce products with all their fields.

What post information can I edit using the spreadsheet?

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

Can I edit WooCommerce products using the spreadsheet?

The free plugin includes limited support for WooCommerce Products, you can edit only simple products and you can edit prices only.

You need the premium version for editing all types of WooCommerce products and all product fields. Read more about the extension.

Can I edit easy digital downloads products using the spreadsheet?

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

Can I edit custom post types using the spreadsheet?

The free plugin only allows to edit posts and pages.

But we have the premium version that allows you to edit any custom post type, for example, media attachments, posts , pages , courses , jobs , projects , or any other post type added by other plugins.

Read more about the extension.

Can I run formulas on the spreadsheet?

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

Can I hide the spreadsheet columns that I dont need?

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

Can I rename the spreadsheet columns?

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

Can I add custom columns to the spreadsheet?

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

Can I use this plugin on cheap / shared servers?

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

Vurderinger

25. november, 2019
This plugin is a really very useful tool, and I'm very happy to have it. And the customer service is AMAZING! I had a real problem, and Jose was able to fix it in minutes! All the while being polite, professional, and keeping me informed about what he was doing. I have gotten a bit too used to crappy Customer Service - Jose showed me how it should be done right! alphamare.ca
5. november, 2019
Saves us a ton of time on the occasional bulk update project! Their support is instant, as well, when using the chat support. Greatly appreciate it!
29. september, 2019
Plugin was the only one I've found that could do what I needed to do with bulk migration of a site from another platform to WordPress. Plus, had a minor issue with my particular search query needs, and the developer worked with me to get it hot-fixed inside an hour on a Saturday night. THAT'S customer service. HIGHLY recommend.
17. september, 2019
Wow this plugin has saved me so so much time. You will not regret getting the full version to automate your import processes. I've used it for Easy Digital Downloads imports, bulk media imports (using download links from S3 even!), and bulk user imports. They all work seamlessly well. Jose is absolutely wonderful. I needed this plugin to do things very specific for my project and he was able to go above and beyond to help me fulfill those needs. Definitely 100% recommend this plugin. If you need to import data to WordPress, this is the plugin to go to.
5. september, 2019
Great support! Fast response! Great plugin. I'm just getting to learn how to use it, but I have hundreds of products to manage, so this is going to be a huge timesaver!
Les alle 48 vurderinger

Bidragsytere og utviklere

“Bulk Edit Posts and Products in Spreadsheet” er programvare med åpen kildekode. Følgende personer har bidratt til denne utvidelsen.

Bidragsytere

Endringslogg

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.4 – 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 +

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.4 – 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 < 3.6
  • FIX – FORMULAS – The text encoding was changing making some text (I.e. some quotes) not match during replacements
  • FIX – WC Products – When editing variation, don’t change the order of 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 – FORMULAS – When deleting thousands of rows completely, it only deletes half
  • FIX – WC Products > 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

Updated to CORE v2.14.0.1
* 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 &quot can’t be read
  • FIX – WC Products – Export – The columns coming from the WC CORE api are duplicated starting from batch 2
  • FIX – WC Products – Import – Optimize the auto mapping of columns to avoid using too much memory when we have too many columns
  • FIX – WC Products – Import – Sometimes we end up with ghost products created by WC Core, auto delete them
  • FIX – WC Products – Import – The «Import as meta» option in the columns mapping wasn’t working

See full changelog.