- When you purchased the plugin, you received an email with the download link and license key
- If you were using the free version of the plugin before, you need to uninstall the free version now
- Now go to your WordPress site (wp-admin) and open the plugins > add new page, and click on Upload
- Upload the premium zip
- You will see a screen asking for a license, enter your license key
- 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
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 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 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”.
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.
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).