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
Snippet: ClickCartPro: Extracting VAT Exempt orders
February 21st, 2009 by Richy C. Leave a reply »Posted in Life: Work and Techy, Snippet
Tags: clickcartpro ecommerce greenbarnweb kryptonic sql vat
You can follow any responses to this entry through the RSS 2.0 Feed. Both comments and pings are currently closed.
Comments are closed.
