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?
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:
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:
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?
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!
