For assistance, see Orders Exporter Module in the Zen Cart support forum.
If you find this mod useful and want to support its development, a Paypal donation ($5.00 suggested) to simonokewode@hotmail.com will be greatly appreciated.
For assistance with installation or customization, you may contact me, or go to PRO-Webs' store.
Orders Exporter allows you to download orders from your Zen Cart to a flexible tab delimited text file, which can be edited (printed, saved) in MS Excel, OpenOffice and other applications for bookkeeping and such.
Download Orders - tab-delimited .txt file
New files included:
FIRST MAKE A FULL BACKUP OF YOUR WEBSITE'S FILES AND DATABASE!
Check your Zen Cart version (click "Version" in your admin page header). This version of Orders Exporter is only operable on v1.5.0 or newer.
For v1.3.9(anything), use v1.6 of this mod. If you have v1.3.8a or older, you need to upgrade for security before adding any enhancements.
After unzipping the files on your computer, follow the folder tree to /your_admin/. Rename the /your_admin/ folder to your secret admin folder name.
After making any necessary file edits, ftp the /renamed_admin/ and /oexport/ folders to the root of your store on the server. The files will automatically be placed in the correct locations.
The /oexport/ folder is where exported files will be saved on your server if you select that option. You will then need to download them by FTP if you want to look at them on your computer.
If upgrading from an earlier version of this mod, note that many filenames have changed, or the files are very different from the originals. Delete all files belonging to the previous version of Orders Exporter before installing the new version.
You will find your new exporter page in your administration interface under the Tools menu called "Orders Export".
** You will need to refresh your admin interface to load the new menu item.
You can select a date range in days before the current day, by entering numbers in the labeled fields and clicking the "save" button. The default is set to 365 days; you can alter this by changing the defines in the language file.
Alternatively, you can select a date range by calendar dates, or set these dates in the define; or you can set or define a range of order ids to export.
Only one of these settings can be active at a time. If you leave one end of a range blank, it will default to the earliest/latest possible.
You can then select the type of report you want and the method ("download" to display directly on your computer, or "save" to save a file on the website server).
You can change many default settings and create some new types of exports by editing /your_admin/includes/languages/english/orders_export.php in a text editor.
You can specify custom "order status" names, exported filename structure or other text.
You can choose which fields to export and what order they will display in, and what their headings will be in the output.
The file has comments describing many of the options.
You will probably want to make some of the changes which are available, as most stores will not need all of the possible fields.
Usage note for OpenOffice (this can presumably be done in Excel as well):
To display the full text of long attribute values and comments in a reasonable width, select the column, then Format > Cells and choose Text Alignment - Horizontal > Left/Center/Justified (as desired) and Properties > Wrap text automatically.
Set the column width by selecting the column, then Format > Column > Width > enter the desired width.
URL note:
The &x=##&y=## that appears in the page URL after selecting an export range are artifacts of the form click and cn be ignored.
To uninstall, delete the files listed in the package from your server. No original files need to be modified.
Then copy the code below and paste it into your admin > Tools > Install SQL Patches page and click "submit".
DELETE FROM admin_pages WHERE page_key = 'orders_export';
This file is part of Orders Exporter.
Orders Exporter is free software: you can redistribute it and/or modify it under the terms of the GNU General Public License as published by the Free Software Foundation, version 2 of the License.
Orders Exporter is distributed in the hope that it will be useful, but WITHOUT ANY WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU General Public License for more details.
You should have received a copy of the GNU General Public License along with Orders Exporter. If not, see http://www.gnu.org/licenses/.