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.

To copy values between columns, you have two options:

1. Do it on the spreadsheet: Simply select the content from column 1 and then paste it on column 2 using CTRL + V. Finally, click on Save to update the column content.

2. Do it with the Bulk Edit tool: If, for example, you want to add your product titles to the URL Slug, you just need to open the Bulk Edit tool and select these values:

  • What field do you want to edit: URL Slug
  • Select type of edit: Copy from other columns
  • Copy from this column: $post_title$ (Title)
  • Click on Execute now

Of course, this is an example, you decide from which columns and to which columns you’ll copy the content.

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.

5- Disable the post actions while saving

WP triggers the save_post hook everytime a post is updated in any context. Sometimes other plugins make mistakes and execute their metabox saving logic outside the post editor.

Their mistake may break our saving because we don’t pass their security checks as we’re not in the normal editor.

You can deactivate the “disable post actions while saving” option in the settings page (wp-admin > wp sheet editor > settings > advanced).

Close Menu