If you are looking for a way of listing all orders in Greenbarnweb/Kryptonic’s ClickCartPro software that is exempt from European/UK VAT, then you may find the following SQL query useful:
SELECT `id` , `dateday` , `datemonth` , `dateyear` , `ordertotal`, `eutaxrefundtotal` , `country` FROM `gbu0_orders` WHERE STATUS = 'C' AND (eutaxrefundtotal >0) ORDER BY dateyear DESC , datemonth DESC
Be First to Comment