Hey there @Accademia Pedagogia Viva !
The main issue you will run into with a Zap like this is that the “Find” action will only ever find a single record. It will not find all new records that are marked as Pending. In Zapier, Find/Search steps only ever return a single item unless the description of the app explicitly says it will return more than one, and this is why you see 10 in WC but Zapier has only touched 3.
Looking at the WooCommerce app we offer, I am afraid we do not have a search step which will do what you wish here.
What if you were to use a workflow like this instead?:
- WooCommerce New Order trigger
- Filter by Zapier action (Only continue if status = Pending)
- Delay by Zapier action (delay until midnight)
- WooCommerce Update Order action
Since the search will not do what you wish, the main workaround I could imagine is catching all New Orders as they arrive and then delaying them until midnight. Let me know if you had other considerations in your workflow that you omitted or any question you may have, but this might work for you =)