How do I deduct taxes from Shopify product prices before applying the tax line rate in Zapier for Axonaut invoices?

Hi @Justtttt1 

The 2 variables used in the Formula are structured as arrays, which is why the error is the happening.

You may have to use a Code step to iterate thru each array index and perform the math operation.

Try asking ChatGPT for help with the code.

@Justtttt1 

For example, the screenshots shows 2 items in each array separated by commas.

e.g. You are trying to subtract 0-0, then 169.99-8.86, and so on for each pair.

The array index is the position of the item in the array, starting at 0 for the first array item.

@Justtttt1

 

For example, the screenshots shows 2 items in each array separated by commas.

e.g. You are trying to subtract 0-0, then 169.99-8.86, and so on for each pair.

The array index is the position of the item in the array, starting at 0 for the first array item.

 

Hi,

Made some progress here, but still not there yet (new problem!) : 

Made a javascript code that seems to work :

// Extracting the prices with taxes from the input data const pricesWithTaxes = inputData[ "This is my products prices with taxes" ].split(","); // Extracting the taxes from the input data const taxes = inputData["This is the taxes of the prices "].split(","); // Initializing an array to store the calculated prices without taxes let pricesWithoutTaxes = []; // Looping through the prices with taxes and taxes arrays for (let i = 0; i < pricesWithTaxes.length; i++) { // Converting the prices with taxes and taxes to numbers const priceWithTax = Number(pricesWithTaxes[i]); const tax = Number(taxes[i]); // Subtracting the tax from the price with tax to get the price without tax const priceWithoutTax = priceWithTax - tax; // Adding the calculated price without tax to the pricesWithoutTaxes array pricesWithoutTaxes.push(priceWithoutTax.toFixed(2)); } // Creating an output object with the prices without taxes output = { "Prices without taxes": pricesWithoutTaxes };

It generate my price without taxes super well : 

Setup like this in the next step :

But when setting up the creation of the invoice in the next step, it add up a weird total tax amount on each product :

That is showing like this on my invoice :

So that amount is showing at the product price place, but my VAT amount/invoice amount is right ! :

Any ideas ? I’m thinking maybe the format of the javascript results used in the next step is not right ?

Thanks a lot!