If you’re using any of the WP Sheet Editor spreadsheets, this post is for you. We’ll show you how to optimize the spreadsheet speed. We know that sometimes your experience with the spreadsheet may not be so fast.
Important: It’s not necessarily slow; in fact, our spreadsheet processes things in seconds most of the time.
The problem is not the spreadsheet, but the conditions under which some users manage their data. For example, if you have +10,000 rows in the spreadsheet (posts/products/downloads/etc.), it’s possible that the load will take longer than if you had just 1,000 or 500 rows.
Therefore, here you have some things you can do to optimize it.
WP Sheet Editor allows you to load only the columns you want to see/edit. For this, you need to go to Settings > Hide/Display/Sort columns.
Once there, you need to select the columns you’ll hide and drag them to the right side.
That change will apply only for this session, but you have the option to Save these settings for future sessions. Just tick the checkbox if you want.
Finally, click on Apply settings.
When you open the spreadsheet, all your rows will be loaded. However, you can use the Search tool to search for the rows you want to see/edit. That way, you won’t be dealing with all your content, but only with the specific contend you need at that moment.
Once you open the Search tool, you can search for your rows by keyword, status, category, attribute, tag, etc.
Important: This is for WooCommerce. Of course, the search parameters will vary from spreadsheet to spreadsheet. If you’re using the Users spreadsheet, then you’ll be able to search rows by role, and so on.
This is something that allows you save time and process changes on hundreds of products in seconds. You can use the Bulk Edit tool to apply changes to hundreds of rows instead editing them one by one.
Here’s an example. These values should be used to decrease the sale prices of hundreds of products by 20%:
- Select the rows that you want to update: I want to search rows to update.
- What field do you want to edit: Sale Price
- Sale type of edit: Decrease by percentage
- Decrease by: 20
- Click on Execute now.
Imagine you want to copy 5,000 rows with all your WC products or your WP users’ info. It will be difficult to select those 5,000 rows in order to copy them.
Instead, you can use the Export tool, located on the top toolbar.
Once you open it, just select the columns that you want to export and click on Start export, which will generate a CSV file with all your data. Simple as that.
Sometimes, your server can give errors when trying to save thousands of changes. Therefore, we’ve designed the spreadsheets to give your server a 6-second break between batches.
However, if your server still needs some more time, you can increase the number of seconds it waits between batches. Just go to Settings > EDD sheet > How long do you want to wait between batches and enter the number of seconds you want your server to wait. Finally, click on Save changes.
If you’re using the WooCommerce products spreadsheet, the plugin automatically calculates your inventory stats every time you load your rows. However, it can be a process you don’t always need and you may want to disable it in order to release some CPU and server usage.
For this, go to Settings > EDD sheet > Disable product inventory stats and select the On option. Finally, click on Save changes.
When you open the spreadsheet, it loads all the rows automatically, but sometimes you may want it to load only the rows you want. Therefore, you can disable the automatic loading of roads by going to Settings > EDD sheet > Disable the automatic loading of rows and select the On option. Finally, click on Save changes.
Now, every time you open the spreadsheet, it won’t load any row, but you can use the Search tool to load the rows you want to see/edit.
These options will help you optimize your experience with the WP Sheet Editor spreadsheets.