Hi,
am connecting Shopify with Quickbooks using Zapier.
Can anyone please let me know which values goes here : https://prnt.sc/rhqmzl
With the values on screenshot am getting this error : https://prnt.sc/rhqnwo
Thanks in advance!
Hi,
am connecting Shopify with Quickbooks using Zapier.
Can anyone please let me know which values goes here : https://prnt.sc/rhqmzl
With the values on screenshot am getting this error : https://prnt.sc/rhqnwo
Thanks in advance!
Hi
Thanks for reaching out to us! Sorry you’re running into an issue with the line items here.
I see that Support is currently working with you to solve this, but please let us know if you have any further questions! Happy to help!
Hi
Hi Barton,
Daniel here with Zapier support! Thanks for writing in; I'll be more than happy to help here.
I took a look and I can see that the error is coming from some data validation that Quickbooks is doing before trying to create the sales receipt.
The first field in the Line Items section is titled "Line Amount". This field is looking for the total amount of a particular line item. Additionally, this field must be equal to the "Line Item Quantity" value times the "Line Item Unit Price" value. It looks like the "Line Amount" field is currently mapped with the collective total of all line items, instead of the total value of each line item. Here's a screenshot to illustrate what I mean:
(view larger)
Could you please try checking to see if Shopify is able to send over the total value of each line item as part of the data that's received in the Trigger step? If not, we can manually create this value using another Formatter step.
I'm looking forward to hearing back from you and getting this Zap set up! I'll keep an eye out for your reply.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.