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.

Hi, 

 

I’m fairly new to all this. I’m a record store owner. Used ECWID for about 12 months now, love it. Heard about Zapier not long after and started using it to help streamline the shipping of my items (in an indirect way) but it still saves me 3-4 hours a week. So I could see the value in it and am now a paying Zapier user for some months now. 

I have decided to change from MYOB accounting to Xero, this is in part to the Zapier integration, but there are several other reasons, basically I outgrew it.

So being new to Xero and a relative novice in Zapier I sat down to integrate Ecwid to Xero. It connected fine, the integration worked. Kinda!

So in my example there were 2 items ordered. One item $40 and a 2nd item $42 and the customer selected Express Post which as it weighs over 500g is $16. Total $98

The line items for the products worked fine, but “Shipping” line hasn’t come through. So the invoice has come through at $82, not $98. I’ve tried a few things with some fairly weird results. But I just can’t see how to add the shipping to invoice? I can see the details are there in the Data Fields, but I must be missing something.

As an aside, though not as important, is it possible to bring the customer’s address details across to the invoice? even just in the notes? I like to use it as a cross reference.

 

Cheers

Shane

Hi @Prehistoric Sounds 

Can you share a screenshot showing your Zapier action setup page? Try to show as much fields as possible and how did you add the data in the fields.

Hi,

Here are the nuts and bolts of the line items. The Shipping Data (ie Method, Price) is in the fields available from ECWID, but not sure where to put it?

 

Been thinking about itthough, do I make a 2 part Zap? Add the shipping in the 2nd part where the line items are?

 

@Prehistoric Sounds

So, in Xero, you need to send the total price altogether, there’s no field for adding shipping rate.

What you are missing at this point is in the Unit Price field you need to have the subtotal price (Price+Shipping) from Ecwid. Look for the value that contains subtotal / total price / price + shipping from Ecwid and add the value to the Unit Price field in Xero.

​​​@Prehistoric Sounds - I suggest using a Formatter step here, particularly the Line itemizer transform to append the Shipping details to the rest of the line item data that Ecwid provides Xero. This should result in an additional line item in the Xero invoice for Shipping. Here’s a detailed help guide that has more information: https://zapier.com/help/doc/how-use-line-items-formatterv2#add-shipping-information-to-your-invoice-using-the-line-itemizer-utility

I hope that helps and let me know if you have further questions!

Thanks @Paolo that looks like it has worked. Really appreciate it.

Actually @Paolo , a few days after using it, there has been a problem, If the client buys one item, no problem, however, if the customer buys multiple items, it fails.

In my example, a customer ordered 5 products.

The error message is 

Required field "Quantity" (line_quantity) is missing. Required field "Quantity" (line_quantity) is missing. Required field "Quantity" (line_quantity) is missing. Required field "Quantity" (line_quantity) is missing.

When I had a look it had divided the freight by the amount of items which was 5, it was trying to say there were 5 freights, but it said 1,NULL, NULL, NULL, NULL.

 

Any ideas?

Shane

 

 

 

Terms & Conditions