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.

I'm trying to add a Zap so whenever I make a sale in Shopify it generates an invoice in Wave. I am having a problem when the Zap has to look up items to match them up between Shopify and Wave. Perhaps because I am choosing the wrong field for Product ID in the custom value drop down? The error message I'm getting is:

Got 500 calling POST https://api.waveapps.com/businesses/96a65730-f6c5-4443-9f13-b7c02cfb9cf6/invoices/, expected 2xx.

Any ideas what to do?

Thanks


Hi @springforthfarmnc

Can you show us how you have the Wave step setup?


Screen Shot 2.jpgThis is the area where I am having trouble. If I don't put in a custom value under Item Product, then it doesn't work properly. (It just lists the selected product for all lines on the invoice.)


For the "Custom Value for Item ID" I am not sure what to put. No matter what I put there, I have gotten the same error message.


Screen Shot 1.jpgHere is a picture of the error message. The highlighted number is the numerical ID imported from Shopify. In Wave, the numerical ID for the same product is an 8 digit number beginning with 4.


Hey @springforthfarmnc! In order for this to work, your Zap is going to need to be able to compare product IDs and know which Wave ID to choose when a specific Shopify ID comes across from your Trigger. There are 2 options we can recommend here:

  1. If you don't have a lot of products, you can insert a Formatter step between your existing steps and use the "Lookup Table" utility. Entering the Shopify Product ID as the key(s) and the associated Wave Product IDs as the values should do the trick. More info on that here: https://zapier.com/help/create/format/create-lookup-tables-in-zaps
  2. If you have a rather long product list, instead of using the Formatter, you might record those IDs in a Google Sheet and do a lookup from that sheet as a middle step instead using a "Find Row" Search Action.

In either scenario, you would want to use the output of the step you choose to move forward with in the "Item Product" field of your Wave "Create Invoice" action step. That should get you to the desired outcome you're after here.


@jesse thank you. That completely answered my question.

Why is a Google sheet better than a lookup table for lots of products?

Next step, try to figure out how to export product IDs from Shopify and Wave...


@springforthfarmnc sure thing and happy to clarify! Google Sheets makes it easier to paste in/edit items in bulk. With Formatter's Lookup Table, you need to enter each key/value pair one by one. Best of luck grabbing those Product IDs! Usually this can be done with an API call but that's likely a bit technical in approach. You best bet might be to ask the Shopify and Wave teams about the best way to retrieve this information.


Terms & Conditions