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?
Best answer by jesse
- 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
- 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.