Mass Action - Order tax value

  • Posts: 8
  • Thank you received: 0
1 year 2 weeks ago #273537

-- HikaShop version -- : 3.1.1
-- Joomla version -- : 3.7.3
-- Browser(s) name and version -- : Chrome 59.0.3071.115

I am trying to get Mass Actions to do a report that includes the total tax charged on each order. I have all of rhe other parameters that I need:
Order created
Order full price
Order number
order payment price
order shipping price
order status
address company
address country
address state

I can't find anything that will give me order tax value

Please help. Thanks

Last Edit: 1 year 2 weeks ago by gjftoronto.

Please Log in or Create an account to join the conversation.

  • Posts: 62779
  • Thank you received: 9005
  • MODERATOR
1 year 1 week ago #273538

Hi,

The total of the tax is not stored. It's calculated dynamically when the order/invoice is displayed by summing together the product taxes, the shipping taxes, the payment taxes, the discount taxes, etc. So you won't find it in the export.
The closer is the order_tax_info column which contains the details of the taxes of the order, but it's in a json format and not made to be easily readable by a human.

Please Log in or Create an account to join the conversation.

Time to create page: 0.085 seconds
Powered by Kunena Forum