Skip to main content
Best answer

How to create Shopify orders with multiple products from Google Sheets?

  • December 30, 2024
  • 7 replies
  • 34 views

Forum|alt.badge.img
  • Beginner
  • 3 replies

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

Best answer by YoniBest answer by Yoni

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?

View original
Did this topic help you find an answer to your question?
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
Forum|alt.badge.img+14
  • Zapier Expert
  • 30887 replies
  • December 31, 2024

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:

 


Forum|alt.badge.img+4

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,


Forum|alt.badge.img
  • Author
  • Beginner
  • 3 replies
  • January 2, 2025
Troy Tessalone wrote:

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:

https://community.zapier.com/show-tell-5/how-to-handle-arrays-with-line-items-in-zaps-31190

 

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


Forum|alt.badge.img
  • Author
  • Beginner
  • 3 replies
  • Answer
  • January 2, 2025

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?


Troy Tessalone
Forum|alt.badge.img+14

@Yoni 

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


Forum|alt.badge.img
  • Author
  • Beginner
  • 3 replies
  • January 2, 2025

@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


SamB
Community Manager
Forum|alt.badge.img+11
  • Community Manager
  • 7414 replies
  • January 6, 2025

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!