Shopify: Check if a product variant is present in Shopify by lookup sku
Hi,
We manage our product catalog in Salesforce and need to sync the catalog with Shopify.
Salesforce is the master.
Suppose I have a product with 2 size variants such that two size variants exist in Salesforce but only one of them exists in Shopify.
The two size variants have the same “handle” in Shopify, but they have different SKUs.
We currently do not have the information of the Shopify variant IDs in Salesforce, but the sku’s are in Salesforce. i.e. we would like to use the product skis as the key for creation and update of products.
How can I do a search in Shopify to check whether a particular product variant sku is present?
Best Answer
A
Amanda Wong
said
about 7 years ago
Would 'product variants' in Salesforce trigger the recipe individually i.e. one salesforce variant to sync per job?
While the Shopify Search Product action allows you to search at the product level, you can access the Product Variant data from the search output. You can use a repeat action to loop through the "Products" list data pill from the search output and use another repeat action to loop through the "Variants" list data pill from the first repeat (foreach) action step output. This will allow you to access the SKU data for each of the product variants.
Next, you can set up an IF condition to determine if the Salesforce trigger SKU contains each of the Shopify product variant SKU. If a match is found, update the Shopify product variant. Otherwise, create a Shopify product variant.
The resulting recipe flow would look something like this:
Step 2 loops through all search results from step 1.
Step 3 loops through all product variants found associated with products in step 1.
Steps 4 to 7 are nested under Step 3. This means the steps will be executed for each product variant associated with product.
Answer
Amanda Wong
said
about 7 years ago
Would 'product variants' in Salesforce trigger the recipe individually i.e. one salesforce variant to sync per job?
While the Shopify Search Product action allows you to search at the product level, you can access the Product Variant data from the search output. You can use a repeat action to loop through the "Products" list data pill from the search output and use another repeat action to loop through the "Variants" list data pill from the first repeat (foreach) action step output. This will allow you to access the SKU data for each of the product variants.
Next, you can set up an IF condition to determine if the Salesforce trigger SKU contains each of the Shopify product variant SKU. If a match is found, update the Shopify product variant. Otherwise, create a Shopify product variant.
Saul Macht
Shopify: Check if a product variant is present in Shopify by lookup sku
Hi,
We manage our product catalog in Salesforce and need to sync the catalog with Shopify.
Salesforce is the master.
Suppose I have a product with 2 size variants such that two size variants exist in Salesforce but only one of them exists in Shopify.
The two size variants have the same “handle” in Shopify, but they have different SKUs.
We currently do not have the information of the Shopify variant IDs in Salesforce, but the sku’s are in Salesforce. i.e. we would like to use the product skis as the key for creation and update of products.
How can I do a search in Shopify to check whether a particular product variant sku is present?
Would 'product variants' in Salesforce trigger the recipe individually i.e. one salesforce variant to sync per job?
While the Shopify Search Product action allows you to search at the product level, you can access the Product Variant data from the search output. You can use a repeat action to loop through the "Products" list data pill from the search output and use another repeat action to loop through the "Variants" list data pill from the first repeat (foreach) action step output. This will allow you to access the SKU data for each of the product variants.
Next, you can set up an IF condition to determine if the Salesforce trigger SKU contains each of the Shopify product variant SKU. If a match is found, update the Shopify product variant. Otherwise, create a Shopify product variant.
Note: Repeat actions are necessary when you want to process more than one record. More info on Repeat Actions here: http://docs.workato.com/recipes/steps.html#repeat-step
The resulting recipe flow would look something like this:
Step 2 loops through all search results from step 1.
Step 3 loops through all product variants found associated with products in step 1.
Steps 4 to 7 are nested under Step 3. This means the steps will be executed for each product variant associated with product.
Amanda Wong
Would 'product variants' in Salesforce trigger the recipe individually i.e. one salesforce variant to sync per job?
While the Shopify Search Product action allows you to search at the product level, you can access the Product Variant data from the search output. You can use a repeat action to loop through the "Products" list data pill from the search output and use another repeat action to loop through the "Variants" list data pill from the first repeat (foreach) action step output. This will allow you to access the SKU data for each of the product variants.
Next, you can set up an IF condition to determine if the Salesforce trigger SKU contains each of the Shopify product variant SKU. If a match is found, update the Shopify product variant. Otherwise, create a Shopify product variant.
Note: Repeat actions are necessary when you want to process more than one record. More info on Repeat Actions here: http://docs.workato.com/recipes/steps.html#repeat-step
The resulting recipe flow would look something like this:
Step 2 loops through all search results from step 1.
Step 3 loops through all product variants found associated with products in step 1.
Steps 4 to 7 are nested under Step 3. This means the steps will be executed for each product variant associated with product.