In this guide, we’ll explain the advanced settings of the WP Sheet Editor – Google Sheets Sync helper plugin.
To open the advanced settings, go to Settings > Advanced Settings > Automations on any of the WP Sheet Editor spreadsheets.
- Imports: How many rows to process per batch: If you leave this field empty, we’ll use the values defined in the “speed and performance” tab. Use this option if you want to have different settings for the automation/background jobs vs. the manual operations performed in the spreadsheet interface.
- Exports: How many rows to process per batch: Same as the previous field.
- Bulk edits: How many rows to process per batch: Same as the previous field.
- Save cells: How many rows to process per batch: Same as the previous field.
- Enable the debugging mode for the log: By default, we create a log file containing information in a friendly format, so anyone can read it. If you activate this option, we’ll add more information that can be used by developers or by the WP Sheet Editor support team to troubleshoot issues.
- Google Sheets: How often (in minutes) should we retry real-time exports when connection to Google Sheets is not available: By default, when the wpsheeteditor.com API or the Google API is not available for any export/real-time sync, we retry every 720 minutes (12 hours).
- Google Sheets: How often (in minutes) should we retry an import when we’re unable to retrieve the Google Sheets data: By default, when the wpsheeteditor.com API or Google API is not available for a scheduled import, we retry every 360 minutes (6 hours). You can change that value here.
- Google Sheets: Should we not delete rows from your Google Sheet when the items are deleted on WordPress: By default, when you configure a real-time Export to a Google Sheet, any change you make on WordPress will be reflected in your Google Sheet, including any edits and deletes. But you can activate this option if you only want to add/update to Google Sheets and never delete rows from Google Sheets, so your Google Sheet Works as some sort of backup.
- Google Sheets: Should we import all the rows from Google Sheets always: By default, when you configure an ongoing import from Google Sheets, we import all the rows from Google Sheets the first time, but the next imports will only include the modified rows from Google Sheets, which provides multiple benefits: the imports will finish much faster, and you will use fewer server resources on your WordPress site. But you can enable this option if you want to process all the rows always, maybe because you’re going to add duplicate rows in Google Sheets and you don’t want them to be excluded or maybe because the content might have changed in WordPress after the first import and you want to reimport all the rows from Google Sheets every time.
- Google Sheets: How long should we wait between bulk sync batches: By default, when you’re using real-time exports, and you make a bulk edit on WordPress, we trigger a sync for 200 items every 45 seconds. You can enter the number of seconds here, for example, enter 120 to wait 2 minutes between every batch. This has zero effect for individual edits, it’s only for bulk syncs.
- Google Sheets: How long should we wait when we make a request to the wpsheeteditor.com or Google Sheet API: By default, we have a timeout of 60 seconds. You can increase it if you want to wait longer before we mark the process as failed.
- How often should we update the log in the scheduled jobs table: If you leave this field empty, we’ll update the log every 30 seconds. Add the number of seconds you want us to update the log. A lower number means that the log will be refreshed very often and it will use more server resources.
- Security: Allow any IP to make requests to our API on this site’s behalf: By default, every time you connect a site to the WP Sheet Editor API, we generate an API key and restrict it to only accept communication between your server IP and our server, which provides high security because no one can make API requests impersonating your site. But you can activate this option to disable the server IP restrictions when your site uses load balancer/multiple servers and you’ll be making requests from different server IPs. Disabling this option is not recommended because it reduces the level of security, so use it only when it’s absolutely necessary.
- Google Sheets: how long should we wait before importing the changes into WordPress: By default, we’ll import the modified rows into WordPress 2 hours after your last edit in Google Sheets. This is to give you time to complete your changes, avoid importing incomplete data, use fewer Google API credits, and reduce server usage. A higher number means delayed imports but reduced server usage, a lower number means faster synchronization but higher server usage. You can select any of the following options:
- 15 minutes after my last edit in Google Sheets
- 30 minutes after my last edit in Google Sheets
- 1 hour after my last edit in Google Sheets
- 2 hours after my last edit in Google Sheets
- 3 hours after my last edit in Google Sheets
- 6 hours after my last edit in Google Sheets
- 12 hours after my last edit in Google Sheets
Once you have made any changes to the advanced settings, don’t forget to click on Save to apply the changes.