Finding Shopify Product ID with Shopify SKU

[Ben_Jones]

• I would like to update my Shopify inventory
• The inventory file comes from an FTP file and contains the SKU (col 1 in the CSV parse) of the Shopify product.
• I need to use the SKU to find the product ID, but I am getting stuck. Can anyone help please?

Integration FTP, CSV, Shopify.blueprint.json (22.5 KB)

[Stoyan_Vatov]

Hey Ben,

switch to advanced query mode and search by SKU directly. Syntax should be something like this:

{ productVariants(query: "sku:EXAMPLESKU", first: 10) { edges{ node{ id title product { id title } } } } }

[Stoyan_Vatov]

Oh sorry, I forgot that for the search module Make handles the syntax, so it should be something like:

query=sku:SKU_GOES_HERE

[Ben_Jones]

Thanks, that worked perfectly