Zen Cart Logo
Forums / Managing Customers and Orders / Export Customer Orders

Export Customer Orders

Locked

Views: 2,457

Results 1 to 2 of 2
This thread is locked. New replies are disabled.
27 Dec 2006, 10:59 PM
#1
mary_fran avatar

mary_fran

New Zenner

Join Date:
Apr 2006
Posts:
4
Plugin Contributions:
0

Export Customer Orders

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

28 Dec 2006, 9:38 PM
#2
wolfsz avatar

wolfsz

Zen Follower

Join Date:
Mar 2006
Location:
Australia
Posts:
286
Plugin Contributions:
3

Re: Export Customer Orders

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'