Batch Size & Sheet Position
Control how many rows BuddyActivity processes per sync and understand how it tracks progress through your sheet.
Batch Size
Batch size determines the maximum number of rows BuddyActivity will process in a single sync run. If your sheet has 50 pending rows and your batch size is 20, BuddyActivity will process the first 20 on the first sync, the next 20 on the second, and so on.
To configure batch size:
- Go to BuddyActivity → Settings.
- Find the Batch Size field.
- Enter a number between 1 and 100.
- Click Save Settings.
Tip: A batch size of 10–20 is recommended for most sites. Larger batches process more rows per run but increase the time each sync takes, which can cause issues on shared hosting with strict PHP execution time limits.
Choosing the Right Batch Size
- Shared hosting — Use 5–10. These environments often have 30-second PHP execution limits.
- VPS / managed WordPress hosting — Use 20–50. More resources available per request.
- Dedicated server — Up to 100. Rarely needs to be this high.
Sheet Position
BuddyActivity tracks which row in your sheet it last read using an internal sheet position pointer. On each sync, it resumes from where it left off rather than re-reading the entire sheet from the top.
This means:
- Already-processed rows are not re-checked on every sync, which keeps syncs fast on large sheets.
- New rows must be added below the last processed row, not inserted in the middle.
- The sheet position resets if you change the active sheet or tab name in settings.
Warning: Do not insert new rows above or between already-processed rows. New activities should always be appended to the bottom of the sheet. Inserting rows mid-sheet can cause the position pointer to misalign and process wrong rows.
Resetting the Sheet Position
If you need to reset the position pointer (for example, after restructuring your sheet):
- Go to BuddyActivity → Settings.
- Find the Reset Sheet Position option.
- Click Reset to set the pointer back to row 2 (first data row after the header).
Danger: Resetting sheet position will cause BuddyActivity to re-read the sheet from the beginning on the next sync. Rows already marked as
done will be skipped, but any unprocessed rows that were previously bypassed will run again.