Invalid Reference in a Filter

:bullseye: What is your goal?

When we receive inventory on items that have been out of stock, we want to automatically send an email to customers who have been waiting. We have a Google Sheet with their email and item SKU.

:thinking: What is the problem & what have you tried?

We start with a Search Rows module with Google Sheets that looks at each item then we have a Search Products module with SHopify to look up those items based on the item SKU. Then I have a filter to only get products that have an inventory quantity greater than 0. That is the filter that is giving me issues. It says that the Inventory Quantity reference is invalid. I have deleted and redone both the filter and the Shopify module. It is still giving me this same error.

:clipboard: Error messages or input/output bundles

"Invalid reference in filter ‘0-0’ on link before module ‘4’: Variable ‘17.inventoryQuantity’ references not existing module ‘17’.

:link: Create public scenario page

:camera_with_flash: Screenshots (scenario flow, module settings, errors)

Hey there,

this issue happens when you delete a module with a filter before it without deleting the filter.

Filter 1-2 for example means the filter is between modules 1 and 2. 0-0 means that the modules were deleted but not the filter it self.

try reverting to an older scenario version where the filter still exists so you can delete it and recreate the rest of the scenario.

OK that worked but then I kept getting more issues so I reconfigured the whole thing.

But I am getting an error in the Gmail module:

  • Missing value of required parameter ‘to’.

But I have the customer email slotted from the Google Sheets module

I am unsure why it is giving me this error.

Here is the link to the public scenario:

Check what the sheets modulemis giving as output. Cause the error means there is no email address.

Let’s continue the discussion in your new thread: "Missing Value of Required Parameter"