Skip to main content

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

Learning Resources
All of our best learning resources can be found here.

Featured Articles Show & Tell Zapier's products AI Hub Zapier Tools Hub

Share your knowledge
Give back to the Community by sharing your automation wins and helping to answer questions.

Share your success See unanswered questions 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.

I am trying to import orders from Google Sheets to Shopify
I have one line per order. Each order can have multiple products
I have columns with comma separated values for Product IDs, titles, quantity and price:


Step 2:
Formatter using line itemizer:
 

 

 

My products are simple products, no variations.

In the Create Order in shopify, I have the following setup:
 

 

 

When I test, the order is created, however as you can see, the products are simply added as custom products and not linked to the product in my shopify store
 



 

 

How can I fix this??

​​​​​​​Thanks

Hi ​@Yoni 

Make sure you are using the correct Shopify Product IDs.

 

A different approach would be to use this Formatter action: Formatter > Utilities > Text to Line Items

Do that for each of the 4 columns from GSheets.

 

Help link for using line items in Zaps:

 

Hi ​@Yoni 👋

Welcome to the Zapier Community! 

The screenshots you shared are super helpful. I believe that what’s causing the order to not have your existing products linked to it is that the Product field is meant to be used only when selecting a variant. This is mentioned in the field’s help text:

e9264f1491d5adf0bb4ff7a0a1bd5473.png
(view larger)

I’d recommend creating variants for these products and see if selecting them gets the results you need. If you keep the title and price filled out, they’ll override the variants:

247ea0e9fd1e0685f510df4947c93be0.png
(view larger)

Let us know if this gets you pointed in the right direction!

Thanks,

Hi ​@Yoni 

Make sure you are using the correct Shopify Product IDs.

 

A different approach would be to use this Formatter action: Formatter > Utilities > Text to Line Items

Do that for each of the 4 columns from GSheets.

 

Help link for using line items in Zaps:

 

I felt that this would only cost me extra ZAPs
The outcome seems to be the same…

I am getting a proper list of each value.

I am looking into Daniela’s suggestion

So, I got it to work 
 

What I did:
Left Product empty

I then submitted the following data from my formatter:

Variant I entered the fake Variant that I created for each one (I called them Pack) and entered a value of 1

Quantity 

Price

But I still don’t understand, why I need to create a “fake” Variant
My products don’t have/need variants, so why can’t I add a regular product to an order through Zapier
(I was able to create an order through the shopify dashboard without a problem)
Is this a bug or is there logic that I don’t understand?

​@Yoni 

NOTE: Formatter steps count as 0 Tasks in Zap Runs.

​@Troy Tessalone 
OK, but what I used, essentially does the 4 steps all in one.

But thanks for the info on the fact that it charges 0 tasks

Hi ​@Yoni,

Thanks so much for sharing those details on how you solved it—it’s much appreciated! 🤗

But I still don’t understand, why I need to create a “fake” Variant
My products don’t have/need variants, so why can’t I add a regular product to an order through Zapier
(I was able to create an order through the shopify dashboard without a problem)
Is this a bug or is there logic that I don’t understand?

In Shopify every product will have always have a product variant by default. If no variations are added at the time a product is created, the product will have one variant automatically added with a title of "Default Title" but it looks like this is automatically hidden in the Shopify UI. Check out this related thread on the Shopify Community for details: https://community.shopify.com/c/shopify-design/should-every-product-have-a-default-variant-in-2023/m-p/1940114

Hope that helps. If you have any further questions or if there's anything else we can help with do let us know!

Terms & Conditions