We are trying to automatically communicate Woocommerce and Copper via Zapier.
We have already set up some parameters, tags and custom fields as dropdown format in Copper that our zaps don't seem to convert properly.
We want to fill a dropdown currency parameter on Copper consisting of EUR, USD, GBP or AUD. Woo-commerce sends this information via the tag “Currency”, which is exactly EUR, USD, GBP, AUD. When we try to link the Copper parameter with the woocommerce export field, we get the 422 trouble error. This doesn’t happen if, instead of filling a dropdown parameter, we fill a plain text field. It is important for us to filter the currencies with a parameter, not a string.
Any suggestion? Many thanks!
Best answer by GetUWired
it looks like the dropdown has unique identifiers for each option. The pretty value is USD or EUR but the accepted dropdown value would be the grayed numbers below so USD = 1532459 and EUR=1532460. To map into this field dynamically, you should include a lookup table before this step to translate between the two values.. https://zapier.com/help/create/format/create-lookup-tables-in-zaps