Woocommerce tax_rate_id mapping to bookkeeping app

[GuillaumeGroen]

Your Workflow URL

https://connect.pabbly.com/v2/app/workflow/share/CkIDMQVSVDcCSAFrD2oMKwwYBQFQCVQ2AxoDEQEOXCRXGQN4URAAag9DVz0CTQNiVx5VP1UKDWkOGlVRB1FTIFxSCRsAA1MpVRhSKQxdCDsKVAMrBWQ#

Consent to Access & Modify

I authorize Pabbly Support to log in to my account and make changes to the specified workflow for troubleshooting.

Hi,

I have a WooCommerce shop and use Moneybird for bookkeeping. I use multiple steps to create a Moneybird invoice by mapping and transforming order fields. The invoice creation stops because I need to map the WooCommerce `tax_rate_id` to the Moneybird `tax_rate_id`.

How do I handle international VAT rates? And how do I map the `tax_rate` received by the WooCommerce connector to the Moneybird connector for use on the Moneybird invoice?

I can make a JSON GET request to the API gateway, but I still need to map those values to the WooCommerce values.

How do I do that?

If you make changes please tell me what you changed.

 

[ArshilAhmad]

Hi @GuillaumeGroen,

The workflow you have shared contains neither WooCommerce nor Moneybird steps. Could you please make a short screen recording explaining your use case and the issue you are encountering?

Thanks & Regards,
Arshil Ahmad
Customer Support Associate
Pabbly.com
Rate your support

 

[GuillaumeGroen]

Hi, Sorry, It should be this one. https://connect.pabbly.com/v2/app/w...KUGoMGAsPAFYHdFFIUW1UV1YsVhtTKAJXCDtbBVN7A2I#

 

[Preeti Paryani]

Hi @GuillaumeGroen,

To map the WooCommerce tax_rate_id with the Moneybird tax_rate_id, you can use the Lookup Table by Pabbly action before the Create Invoice (Moneybird) step.

Here’s how you can set it up:

1. Add a Lookup Table by Pabbly action before the Moneybird – Create Invoice action.
2. Set the Lookup Key as the tax_rate_id coming from WooCommerce.
3. In the Lookup Table configuration (click the + icon to add entries):
   • Add the WooCommerce tax_rate_id as the Key
   • Add the corresponding Moneybird tax_rate_id as the Value

You can find the Moneybird tax_rate_id in the Moneybird action. Turn Map ON for the Tax Rate field to see the available tax IDs and use the appropriate one for each tax percentage.

Whenever a specific tax_rate_id comes from WooCommerce, the corresponding Moneybird tax_rate_id will be returned by the Lookup Table action. You can then map this returned value into the Create Invoice action in Moneybird.

Please try this approach and let us know if you face any issues.

Video reference:

 

[GuillaumeGroen]

Hi, thank you. But can I map the values?
I added the WooCommerce rate_id as a lookup key. And via a Moneybird custom API request, I request the BWT (VAT) classes. I can add them manually, but then I get a failed response. When I map them, I get a failed response aswell. What am I doing wrong? I followed the video guidance.

I added the lookup table in the workflow.

 

[Preeti Paryani]

Hi @GuillaumeGroen,

The issue occurs because the WooCommerce tax_rate_id values are coming as comma-separated values, while the Lookup Table can process only one value at a time, which is why the lookup is failing.

To automate this, you would need to:

1. Convert the comma-separated tax_rate_id values into an array (using a Text Formatter).
2. Process them using a Loop/Iterator so each tax ID is checked individually in the Lookup Table.
3. Collect the corresponding Moneybird tax_rate_id values and use them later in the Moneybird action.

Please note that this approach will make the workflow more complex and may require restructuring some steps. If your tax rates are fixed, a simpler option would be to manually maintain the tax ID mappings in Moneybird.

Let us know which approach you would prefer, and we will guide you accordingly.