During testing I found a better way to do this.
Instead of writing to a second trigger table and using a second Automation (and a 3rd, 4th, & 5th), the last step if there’s more records to process is to delete the original trigger record and then re-add it, which will trigger the Automation again as many times as needed to finish all the records.
So it basically flows like this:
This also gets around the issue of what if the next order has 600 records? Or 700? The above method of cascading 100 at a time only works if you have enough Automations and trigger tables to handle all the records in advance.
I’d be happy to share more details if anyone else has this same use case - comment below or send me a message!