Every 6 months or so, I find myself having to start from scratch on building a Shopify lookup in an Iman job. For example, you might need to pull current qty on hand from Shopify inventory so you can use it for some conditional logic in the job. Writing a Shopify lookup that works is tedious, but FAR easier, if you have the steps. Here's an overview - but see the attached pdf file for screenshots and more details - including useful links and formula examples.

1. Go to the Shopify Dev website where it shows examples of Shopify queries for Orders, inventory, item variants, etc. and find a query that is similar to the information you are looking for.
2. Login to Shopify using the same Shopify login where your Shopify private app is setup - the one that Iman uses to connect to Shopify.
   1. Open a new browser screen and build a json query for the data you are looking for. Make sure you include admin/api in the query so that you are pulling the data the same way that Iman would pull it.
   2. Once you have successfully gotten your query to work in the browser - copy the query into notepad - so you can use it to build your lookup formula.
3. In the iman job - build a lookup formula - hardcoding the values for each section of the lookup - rather than pulling in values from other Iman fields are formulas.
   1. Verify that your lookup pulls the data you wanted.
   2. Once the hardcoded version of the formula works at pulling a single correct piece of data, you can then update it to dynamically use Shopify fields or Iman formulas to pull the information that pertains to each specific record in your job.