Hi all. I have a question about structuring scenarios. I’ve included below a screenshot of what I’m trying to achieve.
We’re monitoring a Google sheet that holds inventory numbers.
There are 17 products in the sheet.
If the inventory figure changes, the updated figure should be sent to the relevant Shopify product.
Within the Google sheet inventory figures are stored in cells, e.g.:
Product #1 (cell G1)
Product #2 (cell G2)
Product #3 (cell G3)
Product #4 (cell G4)
After the router, we have filters set up on every path. E.g.,
if the cell range is equal to G2 then allow data to pass to Shopify product #2.
if the cell range is equal to G3 then allow data to pass to Shopify product #3.
This works, but only for updating inventory against 1 Shopify product. Essentially, data is only flowing to the first path it matches in the filter and then Make is completing the scenario.
If inventory figures change for all 17 products in the Google sheet, Make is seeing the changes but completing the scenario via the first filter match only. So only 1 out of 17 products update.
I understand the logic behind why it’s doing this, but I’m unsure what the best solution is.
I can create 17 separate scenarios but this seems excessive — or is this the best way?
Is there a way that this can be handled within 1 scenario?
I could schedule the scenario to run every 15 minutes, but assuming 17 products need updating, that’s going to take 17*15 = 255 minutes or 4-5 hours to complete the updates!
Hopefully this makes sense. I’d appreciate any input here as I’m a bit of Make newbie.