Export Customer Orders

[Mary Fran]

Hi,

I am running version 1.3.0 and would like to export all customer orders to my hard drive to use for tax purposes. Could someone please let me know what file I need to export, that will provide the detail of each order, in a text readable format to retain for income tax reporting. I see there is the QBI but I am only looking for the detailed order info.

Thanks in advance,

Mary

[wolfsz]

Hi there
using phpmyadmin or a similar tool run this SQL query (replace dates with the date range you require):
select zen_orders_total.orders_id, zen_orders_total.text
from zen_orders_total, zen_orders
where zen_orders.orders_id = zen_orders_total.orders_id and zen_orders_total.class = 'ot_total' and zen_orders.date_purchased >= '2006-08-14' and zen_orders.date_purchased <= '2006-08-20'