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.

Best answer

Duplicating Shopify Orders to Infusionsoft

A
  • Anonymous

Hi,

I’ve been trying to set up a Zap to copy any orders made in Shopify to Infusionsoft for record keeping, essentially the same as the related post “Duplicating Shopify Orders to Infusionsoft”.

It looks like they solved their problem in setting this up but unfortunately the solution was not included in any of the replies.

The key issue I am having at the moment is in the ‘Products’ field in the Zap for Infusionsoft. I am currently setting it to pull in ‘1. Line Items Name:’ from Shopify.

When I test the Zap using the sample order pulled from my Shopify it returns the following error:

I’ve seen conflicting information around the place when I’ve tried to find an answer for this regarding line items, some of them have said that it is possible to pull line items from Shopify into Infusionsoft using Zapier, and others that it is not.

Any help or solutions would be much appreciated.

Best answer by Wemakefuture

Will and Able wrote:

Hi @AndrewJDavison_Luhhu 

Unfortunately not. The products in Shopify come through as line items, and unfortunately the Infusionsoft plugin in Zapier does not currently support line items. As such we have not been able to resolve this issue, and have instead taken the approach of simply recording what products have been purchased by a customer across their lifetime using tags since we cannot get the orders themselves to appear in Infusionsoft.

@Will and Able 

 

You can although go with python to create a string from the int or other way around. This should solve the issue above. In addition you can split line items and with the new loop coming up you can iterate these, otherwise go with gsheet in between.

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.

6 replies

Davidh88
Forum|alt.badge.img+2
  • Davidh88Zapier Expert
  • Zapier Expert
  • 58 replies
  • July 31, 2020

Hi @Will and Able I don’t have a Shopify account so I can’t test but I have collected line item data from Shopify for a client.  I recall in the new order zap there is an option to select line items.

The image above isn’t using the Shopify zap.  What are you using?

 

David

A
  • Anonymous
  • 0 replies
  • August 2, 2020

Hi David,

The first part of the Zap is ‘New Paid Order in Shopify’, I’ve also tried ‘New Order (Any Status) in Shopify’, both have line item support but return the same error.

The information appears to pull in from Shopify fine, however, it is the translation into Infusionsoft using the Create Order in Infusionsoft segment that is the issue.

In the Customize Order section, I have tried all the different line item values pulled from Shopify i.e. “1. Line Items Name: ecoToilet Clean...” in the ‘Product’ line.

 

Upon selecting ‘Continue’ to the ‘Send Data’ section it appears to pull through the different line items, but testing then results in the error shown.

 

On this Zapier blog post it lists Infusionsoft as supporting line items so not sure where to go from here.

https://zapier.com/blog/formatter-line-item-automation/

 

Any help much appreciated.

Davidh88
Forum|alt.badge.img+2
  • Davidh88Zapier Expert
  • Zapier Expert
  • 58 replies
  • August 3, 2020

@Will and Able That error is basically saying that the value you are mapping is not an integer (number).

Like I say, I can’t test so I am guessing a little!

Does Shopify have an SKU number that gets read in?  If so can you make the SKU number in Shopify the same as the SKU number in Infusionsoft?  (NB. Infusionsoft has a field in the product that you can put in any number you wish).

So I steps to you are effectively placing an order in Infusionsoft for the SKU that you pulled from Shopify.  It will also map quality.

I hope that gives you another direction to try.

David

 

 

AndrewJDavison_Luhhu
Forum|alt.badge.img+10

@Will and Able 

Just checking in… were you able to get this solved?

We're Zapier Certified Experts - we help businesses do cool stuff with automation | www.luhhu.com
A
  • Anonymous
  • 0 replies
  • October 7, 2020

Hi @AndrewJDavison_Luhhu 

Unfortunately not. The products in Shopify come through as line items, and unfortunately the Infusionsoft plugin in Zapier does not currently support line items. As such we have not been able to resolve this issue, and have instead taken the approach of simply recording what products have been purchased by a customer across their lifetime using tags since we cannot get the orders themselves to appear in Infusionsoft.

Wemakefuture
Forum|alt.badge.img+8
  • WemakefutureZapier Expert
  • Zapier Expert
  • 166 replies
  • Answer
  • October 7, 2020
Will and Able wrote:

Hi @AndrewJDavison_Luhhu 

Unfortunately not. The products in Shopify come through as line items, and unfortunately the Infusionsoft plugin in Zapier does not currently support line items. As such we have not been able to resolve this issue, and have instead taken the approach of simply recording what products have been purchased by a customer across their lifetime using tags since we cannot get the orders themselves to appear in Infusionsoft.

@Will and Able 

 

You can although go with python to create a string from the int or other way around. This should solve the issue above. In addition you can split line items and with the new loop coming up you can iterate these, otherwise go with gsheet in between.

https://www.wemakefuture.com/
Terms & Conditions