About Zapier Community
New to our Community? Get to know more about our space and how to make the most of your time here.

Code of Conduct Community FAQ's Zapier Common Questions What to Expect

Get Started With Zapier
New to Zapier? We have got you covered with our Zapier 101 Resources.

Zapier Essentials

Get Support
Have a question? Let's get you an answer!

How Do I...? Troubleshooting Code & Webhooks Developer Zone

Other Help Resources
Wait, there's more! Check out these Community sourced spaces for additional resources.

Zapier Help Center Hire an Expert

Zapier Reading
All of our best learning resources can be found here.

Featured Articles Show & Tell AI Hub Zapier Tools Hub

Learning Groups
Excited to meet other builders? Check out our interest areas full of doers, dreamers, and in-betweeners.

User Groups

Other Learning Resources
Some of our favorite additional ways to upskill your Zapier knowledge.

Zapier Learn Zapier Blog Zapier Webinars

Product Updates
Check out what is new and upcoming with Zapier with our regular product updates.

Product Updates

Early Access Program
Want to join Early Access? Learn more here.

  • Home
  • Get Help
  • How Do I
  • How to automatically select existing products when creating new orders in Shopify?
Best answer

How to automatically select existing products when creating new orders in Shopify?

  • 12 January 2022
  • 7 replies
  • 261 views
C
Userlevel 1
Badge

I am trying to upload unique SKU’s from a google sheet into Shopify. These SKU’s already preexist in Shopify store a product. I am able to bring the products individually (line items) into Shopify, however, they are coming in as a “new” product and not coming into Shopify as a pre-existing product with same product name/title which is already in Shopify 

  1. I am using Utility function to convert “Text To Line-Item”
  2. And then taking output from Utility app into Shopify webstore 

 

 

This is the output in Shopify web store. It is coming as a “new” Product instead of linking to an already preexisting product with the below product name/title 

 

 

icon

Best answer by Troy Tessalone 13 January 2022, 17:11

View original
This post has been closed for comments. Please create a new post if you need help or have a question about this topic.

7 replies

Troy Tessalone
Userlevel 7
Badge +14

Hi @charlesriver 

Please post screenshots with how your Zap steps are configured with the variables mapped between Zap steps, thanks.

⚡ Troy Tessalone - AutomationAce.com | Premier Certified Zapier Expert | #1 Zapier Community Contributor
C
Userlevel 1
Badge

@Troy Tessalone here you go. let me know if any more information is needed. Thanks 

Step1:

 

 

Step 2:

 

Step 3:

 

 

Step 4:

 

 

Troy Tessalone
Userlevel 7
Badge +14

@charlesriver 

You may need to use the internal Shopify Product IDs for this field.

You can check by looking at the values in the dropdown when the mapped variable is removed.

Take note of the internal Product IDs (smaller gray font under each friendly name).

The Shopify action may create new Products if an existing Shopify Product ID is not found, which would explain the behavior you are experiencing.

 

⚡ Troy Tessalone - AutomationAce.com | Premier Certified Zapier Expert | #1 Zapier Community Contributor
C
Userlevel 1
Badge

@Troy Tessalone I just tried that and still outputting similar issue

 

In order to find the “Product ID”, I added a “Find Product Using Title” feature in Zapier and then used the output from there under Create Order. See the screenshots below

 

I did that just with one SKU (before doing the loop) and faced a similar issue. See screenshot below

 

"Finding the Product In Shopify"

image.png

 

 

 

Found the Product ID for the above description

 

image.png

 

 

 

In Create Order, I added the Product Id under line item and the Title I found by "Find Product" under Product Title 

 

image.png

 

 

 

Shopify Output - Still did not find the SKU that already exist in Shopify 

 

 

image.png

C
Userlevel 1
Badge

 

@Troy Tessalone 

An Update

 

I was able to figure out and get correct id published in Shopify as needed. Thanks for your input on that. To follow up on the above, I can only find one product ID at a time through “Find Product by Title in Shopify”.

I was thinking using “Create Loop From Text” feature so the process run multiple times depending on the unique SKU, but I am not able to figure out how do I use the output from “Create Loop From Text” into “Find Product Title in Shopify”. See example below

  1. Set it up for 2 unique item in the below screen shot

 

 

  1. The feature output two unique SKU as required
  1. Now trying to map the above results in the Find Product feature and little lost here. These are the options I get when I try to map it but not sure which one to use. 
Troy Tessalone
Userlevel 7
Badge +14

Hi @charlesriver 

Working with line items can get tricky with the logic involved.

 

You may want to explore using Storage by Zapier or Digest by Zapier to aggregate and retrieve the data.

Storage: https://zapier.com/apps/storage/integrations

Digest: https://zapier.com/apps/digest/help

 

You can have a Looping app run, then only continue after the last iteration as per...

How do I stop a loop from running in subsequent action steps?

All actions after the looping step will run for each iteration of the loop. If you don’t want an action step to loop:

  • After the last step you want to loop, add a filter step.
  • Set the filter to only continue if the value loop_iteration_is_last matches the (Boolean) Is True condition.

The filter will run in every loop but will only pass in the last loop. Any actions step after the filter will run once in the last loop and use only 1 task.

Note

If you want an action step to only run once, add it before the looping step, if possible. This will use less tasks and the filter step won’t be needed.

⚡ Troy Tessalone - AutomationAce.com | Premier Certified Zapier Expert | #1 Zapier Community Contributor
C
Userlevel 1
Badge

Thank you!

Terms & Conditions