Update Inventory using Google Sheets

[zest83]

IS there any video, wherein, multiple items go out of stock in one day, and we can take the workflow ahead from here
Detecting one such item is easy, using GET ROWS but what about multiple items going out of stock on the same day

How will it work?

 

[Arshita]

Hey @zest83

While we may not have a specific video for multiple items going out of stock in one day, I can guide you on how to handle this scenario within Pabbly Connect.

When using the GET ROWS action to detect items going out of stock, you can create a conditional workflow to handle multiple items. You can use the "Filter" in your action step which will tell you about the multiple items out of stock in a day.

 

[zest83]

So when GET ROWS is capturing data
It will send All data one at a time right?

so as soon as any criteria meets the filter... Suppose the 1st row itself meets the filter requirement
will the automation stop right here
Or will it also check the second matching filter
and then the third matching filter?

Will it go on a loop or work on a continuous feed basis the First "GET ROWS" action, which has captured the data all at once and sending it downward into the workflow.

Individual Inventory update will work perfect.
But will Multiple Inventory Update work .. is my question

 

[Arshita]

It will send All data one at a time right?

Yes, GET ROWS will send all data one at a time.

so as soon as any criteria meets the filter... Suppose the 1st row itself meets the filter requirement

In such a scenario, you should add an iterator action step in your workflow.

When the iterator initiates, the filter step will execute, and it won't cease even if the first filter step satisfies the condition. Subsequently, the second filter step will run, followed by the third filter step, and so forth.

Will it go on a loop or work on a continuous feed basis the First "GET ROWS" action, which has captured the data all at once and sending it downward into the workflow.

Yes, it will operate continuously without forming a loop.

 

[zest83]

thank you for your help