Sales and Use

Through much wailing and gnashing of teeth, I'm not a mysql expert as the code below will confirm...
Anyway, I have a client that needs a monthly 'sales and use' report. She created an example excel worksheet with the fields she wanted. Here's what I came up with:

SELECT zen_orders.customers_name, zen_orders.date_purchased, zen_orders_total.text AS subtotal, shipping_source.text AS shipping, shipping_source.title AS shipping_method,zen_orders.order_tax, zen_orders.order_total
FROM zen_orders, zen_orders_total
LEFT JOIN zen_orders_total AS shipping_source ON zen_orders_total.orders_id = shipping_source.orders_id
WHERE zen_orders_total.title LIKE 'Sub%'
AND shipping_source.title LIKE 'Unit%'
AND zen_orders.orders_id = zen_orders_total.orders_id

I am rather convinced there is a more elegant solution. I'm also hoping to put this in a shell script that will put a date range in and have cron run it once a month to produce an .xls. I used phpmyadmin to execute and export the file. It works for me. Let me know what you think!

http://www.zen-cart.com/index.php?main_page=product_contrib_info&products_id=83
Sales Report mod from downloads section BUT if your
method works then stick with it..thanks for posting/sharing
your solution anyway
:clap:

Thanks for the kind words. I'm a former ballet dancer, I teach now. Any time I can prove that I can do more than count to eight, I'm happy.
I'll check out the mod.