Mapping Shopify total tax per lines in NetSuite

Integration Apps
,
1

Can anyone share ideas on how I can sum the the tax_lines array per line_items so that I can get the total tax per line on custom column in NetSuite?

2

Hi Jon,

This should be pretty straight forward. Try this:

The image shows a table with highlighted text fields labeled "line_items[*].tax_total" and "Items: eTail Order Line Tax." (Captioned by AI)
The image shows a table with highlighted text fields labeled "line_items[*].tax_total" and "Items: eTail Order Line Tax." (Captioned by AI)948×128 5.31 KB

3

Hi Cory,

Thank you for the quick response.

I've already tried this but unfortunately, the line_items[*].tax_total does not return any value from Shopify.

All the best!

4

Hi Jon,

There must be something different with the data coming out of Shopify then. I reviewed 2 other Shopify - NetSuite integrations and they both have the line level tax being populated with that mapping. Maybe that helps point you in the right direction.