Can I edit other content types added by my theme?

Yes. You can edit any custom post type added by your theme or other plugins. For example, you can edit “portfolio items”, “Courses”, etc.

Does it work with WordPress Multisite?

Yes. You can install the plugin in a WordPress multisite installation. You can activate the plugin on individual sites or network wide. But you need one license for every site where the plugin is active.

Can I add more columns to the spreadsheet?

Yes. You can add any columns you want!

How can I install this plugin?

You can find a tutorial for this on our tutorials page .

Can I edit WooCommerce products using this plugin?

Yes , it works with woocommerce products.   You can edit ALL TYPES of products like simple, virtual, downloadable, variable, etc. and you can edit all the product fields:

  • :: Title
  • :: URL Slug
  • :: Content
  • :: Date
  • :: Modified Date
  • :: Short description
  • :: Status
  • :: Enable reviews
  • :: Featured Image
  • :: Product categories
  • :: Product tags
  • :: Edit attributes
  • :: Type
  • :: SKU
  • :: Regular Price
  • :: Sale Price
  • :: Weight
  • :: Width
  • :: Height
  • :: Length
  • :: Manage stock
  • :: Stock status
  • :: Stock
  • :: Visibility
  • :: Gallery
  • :: Downloadable
  • :: Virtual
  • :: Sales price date from
  • :: Sales price date to
  • :: Sold individually
  • :: is featured?
  • :: Allow backorders
  • :: Purchase note
  • :: Shipping class
  • :: Download limit
  • :: Download expiry
  • :: Download type
  • :: Download files
  • :: Variation description
  • :: Variation enabled?
  • :: Default attributes
  • And custom fields

Can I edit easy digital downloads products using this plugin?

Yes, it works with Easy Digital Downloads products. We have a special plugin for EDD products.

What post types can I edit using this plugin?

All the post types !.

I am a developer, can I extend the plugin to add new columns to the editor?

Yes , the plugin has an easy to use API that allows to add or remove columns to the spreadsheet . You can create extensions to make the spreadsheet show your plugin custom fields. Read more about the API here.

I purchased the plugin and I need help

I need a refund

We can give you a refund only under certain conditions:

  • You can´t use the plugin because it´s not compatible with your wordpress site
  • You found an issue in the plugin and you can´t wait while we fix it

You can request a refund here.

I found an issue on the plugin

If you found an issue please contact us , we will fix it as soon as possible..

Can I use the spreadsheet without internet connection?

If the website is hosted on a local server (a development site) , the spreadsheet will work offline. But if the website is hosted on the internet (remote server), the spreadsheet requires internet connection to be able to read/save changes.

Can I translate the plugin?

Yes. You can translate it using poedit or the loco translate WordPress plugin

How can I sort the spreadsheet by columns?

Yes. You can sort the spreadsheet by any column. First you need to load all the posts . You can do it manually by scrolling down (the spreadsheet loads more posts as you scroll down) or you can change the settings to load all the posts at once. After that , you can sort the spreadsheet by clicking on any column header.

How can I search in the Spreadsheet?

The spreadsheet has 2 tools: – Search – Locate cell. If you use the “search” button, you will see a popup where you can search by keyword, taxonomies (category, tag, attributes, etc.), and advanced filters (multiple columns at once). This will show only the matching posts only. If you use the locate cell, it just highlights the cells containing a text. This is helpful if you want to locate a cell quickly. For example, you were editing the post “cars” and later you want to locate it again.

Help. I´m getting error 500

1- Maybe you have too many product attributes. A customer had thousands of attributes and he got the same error, he fixed it by deleting some unused attributes.

2- Maybe you are loading too many posts per page? you can change this in the settings page

3- Maybe it´ s a code conflict with other plugin, you can enable the WP_DEBUG option to see if you get php errors or warnings

4- Try deactivating one plugin at a time until you find the bad plugin.

If you need more help you can contact us we´ ll be happy to help. Please include WP and FTP credentials so we can log in and fix the issue.

Getting started

  1. When you purchased the plugin, you received an email with the download link and license key
  2. If you were using the free version of the plugin before, you need to uninstall the free version now
  3. Now go to your WordPress site (wp-admin) and open the plugins > add new page, and click on Upload
  4. Upload the premium zip
  5. Activate
  6. You will see a screen asking for a license, enter your license key
  7. Done. Now you should see the welcome page where you can set up the plugin and start using it

IMPORTANT: We stopped selling on CodeCanyon in 2017. This information applies to old customers using licenses from CodeCanyon. Customers who purchased after 2017 need to ignore this.

1- If you dont know your license code, please follow these steps to find the license

2- If you see a message saying that “the license could not be activated”. It can be for 2 reasons:

a) The license is valid for one domain. So if you already used the license on one site, you need to deactivate it in the first site to use it in a second site.

b) Our license server is not available, please try again later.

Deactive license in all sites:

How to use the spreadsheet

To create new rows, write the number of rows you want to create and then hit the “Add new” button.

To open the “Search” tool, click “Search” on the toolbar.

It contains fields to look for products by keyword, status, category, attribute, tag, date, product variations, and filters to do advanced searches.

To open this tool, click “Bulk Edit” on the toolbar.

It contains fields for you to search for the products to edit. It also contains the fields you’ll edit and the type of edit you’ll apply.

To locate specific cells in the spreadsheet, just write the word of the cell you want to locate in the “Locate cell” field and hit enter.

If you want to load 500 rows at once in the spreadsheet, then you need to go to advanced settings, and then to advanced.

Write 500 in the “How many posts do you want to display on the spreadsheet?”

Sheet Editor saves products in batches, so if you want to increase the number of products to save in each batch go to advanced settings > advanced > How many posts do you want to save per batch?, and write the number of products to save in each batch.

To reduce the time the plugin waits between batches, set the number in the “How long do you want to wait between batches? (in seconds)” field.

To show date columns as simple texts, you need to go to settings > Show cells as simple text.

To hide columns from the spreadsheet, you need to right click on the column you want to hide and click “Hide column”.

To display hidden columns in the spreadsheet, go to settings > Hide / Display / Sort columns.

Drag the disabled columns to the enabled columns.

To delete a column permanently, go to settings > Hide / Display / Sort columns.

Once there, hit the “X” in the column you want to delete permanently.

If you delete a column by error, you can restore it by clicking “Restore deleted columns”.

To create a new column, go to advanced settings > add columns for custom fields.

Once there, you’ll have to specify the values for the new column: name, key, type.

To edit images as plain text/URLs, you need to go to the cell you want to edit and double click it; it converts into a plain text field when you double click on it.

Then just paste the image URL.

To copy/paste images from one cell to another, just copy from one cell and then paste into another cell using CTRL + V.

To copy from excel, go to the spreadsheet in Excell and copy what you need from a specific cell, row, column, and then go to Sheet Editor and paste the info you’ve copied using CTRL + V.

To edit a product/post URL, go to the “Slug” column, and hit “Enable”.

Then, paste the URL in the “Slug” cell.

To disable the loading of rows on scroll, go to settings > Load more rows on scroll and leave it unchecked.

I am text block. Click edit button to change this text. Lorem ipsum dolor sit amet, consectetur adipiscing elit. Ut elit tellus, luctus nec ullamcorper mattis, pulvinar dapibus leo.

To delete everything in one column, you have two options: manual and bulk.

Manually, select the column by clicking the above part of it and then hit “Delete” in your keyboard.

To delete a whole column content, open the “Bulk Edit” tool.

Select the column you’ll edit in the “Field you want to edit” field and select the type of edit you’ll apply: “Clear value”.

To replace words or phrases in an entire column, go to “Bulk Edit” on the toolbar.

Select the column you’ll edit in the “Field you want to edit” field.

Then, select “Replace” as the type of edit you’ll apply.

Finally, write the new value and hit the Run search button.

To set new values on columns, go to the “Bulk Edit” tool.

Select the column you’ll edit. Then, select “Set value” as the type of edit you’ll apply and write the new value.

To prepend or append something to columns or rows, open the “Bulk Edit” tool.

Select the fields you’ll edit and select the type of edit you’ll apply: prepend or append.

Finally, write the value you’ll add and hit “Run Search.”

To disable or enable the fixing of the first 2 columns at the left side of the spreadsheet, go to settings > advanced settings > advanced > Fix first 2 columns at the left side?

Once there, you decide whether to activate it or not by selecting On / Off.

When you have 1000 posts, you might want to open the spreadsheet and start editing from post 200.

For that, go to settings > advanced settings > advanced > Initial rows offset, and enter the number.

If you want to select a different taxonomy separator, go to settings > advanced settings > advanced > Separator for taxonomy terms cells, and enter the separator in the field.

To disable extension offerings, go to settings > advanced settings > advanced > Disable extension offerings?, and select On / Off.

To suspend object cache invalidation, go to settings > advanced settings > advanced > Suspend object cache invalidation?, and select On / Off.

To disable usage stats widget, go to settings > advanced settings > advanced > Disable usage stats widget?, and select On / Off.

To disable cells lazy loading, go to settings > advanced settings > advanced > Disable cells lazy loading?, and select On / Off.

To disable post actions while saving, go to settings > advanced settings > advanced > Disable post actions while saving?, and select On / Off.

To import or export something on the spreadsheet, go to settings > advanced settings > Import / Export.

Once there, select the import options: “Import from file” or “Import from URL”.

Or select the export options: “Copy Data”, “Download Data File” or “Copy Export URL”.

Once you’ve finished, hit “Save changes”.

The default way uses a faster execution method, but it might not work in all the cases.

In such cases, go to “Bulk Edit” and check the “Use slower execution method” before executing the changes.

To add extensions to the plugin, open the “Extensions” tool by clicking “Extensions” on the toolbar.

To change dates in the spreadsheet you need to locate in the “Date” column and change the date using the calendar popup in the cells.

Common errors

If you are getting network errors (messages like “server not available”) when you are saving changes or executing bulk edits, it means your server is overloaded.

Possible solutions:

1- You need to save less posts per batch and increase the time between batches.

The spreadsheet saves the posts in batches, for example, 4 posts every 8 seconds. But if you are using a cheap server, this can overload the server.

So you can reduce the number to 2 posts every 10 seconds. You need to adjust the number of posts per batch and the time until it works.

2- WordPress has a heartbeat API, which pings the server every few seconds to check log in status. This overloads the server.

For example, you open the spreadsheet editor and use it for one hour, heartbeat has made about 100 requests to the server in that hour so when you start saving the server is already busy.

You can disable the heartbeat in our advanced settings (in the spreadsheet page > settings (top toolbar) > advanced settings > advanced).

3- Maybe you were saving and logged out and logged in again in another tab. This would invalidate the security tokens and you won´t be able to continue saving. This rarely happens though.

4- Try to save smaller batches manually

For example, edit 5 posts and save, then edit other posts and save. Don’t wait until you make too many changes to save because it will take longer.

Close Menu