Hi, 

I am trying to set up a Shopify and Xero zapier integration for whenever an order is paid it creates a Sales Invoice in Xero. My current issue is related to the Account Code aspect of the Xero zap. If I have multiple products in an order, they have different Account Codes such as ‘Merchandise’ or ‘Mixed Packs’. However, in the Account Code section, I can only select one option. 

I have tried to use the Formatter zap before the Xero zap to create a lookup table based on the products purchased and then use that field in the Account Code section, so that it would print both Account Codes depending on the product. However, it says the following: 

A validation exception occurred, Account code 'MERCHANDISE' is not a valid code for this document., Account code 'SALES - MIXED PACKS' is not a valid code for this document.

I have triple checked that these codes are written exactly as they are in Xero. 

Does anyone have any tips on if this method can work or if there is a better method to integrate Shopify orders into Xero? 

Thank you in advance - hugely appreciated!