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.

Troy Tessalone wrote:

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.

Hey,

Thanks for the answer, and do you know approximately how I should ask that ? I’m quite lost on “iterate thru each array index”. Thanks!

@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.

Troy Tessalone wrote:

@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.

 

Thanks for the answer, the AI doesn’t seem to understand what i want.. !

thanks!

Troy Tessalone wrote:

@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!

Hi @Justtttt1,

I took a look at your concern and it looks like you may have resolved this issue according to one of your tickets with our Support Team.

If you’re still having issues with this I’d recommend continuing the conversation with our Support Team via email.

Thanks!