Orders Exporter Module

I seem to be having brain fart. I have uploaded the files to my uniquely named admin folder. I am not able to see the "Orders Export" option in my Tools dropdown. And I am out of ideas...can someone give me a hint? (P.S. I am a superuser; the only admin for this shopping cart)

juniper:

I seem to be having brain fart. I have uploaded the files to my uniquely named admin folder. I am not able to see the "Orders Export" option in my Tools dropdown. And I am out of ideas...can someone give me a hint? (P.S. I am a superuser; the only admin for this shopping cart)

Clear your browser cache =)

mprough:

Clear your browser cache =)

Thanks. I tried that and in several browsers. I am wondering is there anywhere in the Admin CP that I need to re-direct to my uniquely named admin folder? (It seems to know this anyway since the site is working). Perhaps tied to the webhost going down last night; will see what tomorrow brings.

FlyingChangeWebs:

I need this same feature. Is there a way to ADD the quantity into the full report? That's a pretty important piece to be missing.

I need this as well. Without Quantity, the export file is pretty useless. Is there any way to add this?

If you go into the ordersExport.php file in the admin directory you will see the code below
you can apparently add or delete the database fields to you want displayed in the exported files
and specify the order. You need to replicate it for each form type and you need to add the data field call to each section (line 54):

//all columns:

'v_date_purchased' => $iii++,
'v_orders_status_name' => $iii++,
'v_orders_id' => $iii++,
'v_customers_id' => $iii++,
'v_customers_name' => $iii++,
'v_customers_company' => $iii++,
'v_customers_street_address' => $iii++,
//'v_customers_suburb' => $iii++,
//'v_customers_city' => $iii++,
//'v_customers_postcode' => $iii++,
//'v_customers_state' => $iii++,
'v_customers_country' => $iii++,
'v_customers_telephone' => $iii++,
'v_customers_email_address' => $iii++,
'v_products_model' => $iii++,
'v_products_quantity' => $iii++,
'v_products_name' => $iii++,
//'v_products_options' => $iii++,
//'v_products_options_values' => $iii++,
);

$filelayout_sql = "SELECT 

zo.orders_id as v_orders_id,
customers_id as v_customers_id,
customers_name as v_customers_name,
customers_company as v_customers_company,
customers_street_address as v_customers_street_address,
customers_suburb as v_customers_suburb,
customers_city as v_customers_city,
customers_postcode as v_customers_postcode,
customers_country as v_customers_country,
customers_telephone as v_customers_telephone,
customers_email_address as v_customers_email_address,
date_purchased as v_date_purchased,
orders_status_name as v_orders_status_name,
products_model as v_products_model,
products_name as v_products_name,
products_quantity as v_products_quantity,
products_options as v_products_options,
products_options_values as v_products_options_values
FROM ".TABLE_ORDERS_PRODUCTS." zop LEFT JOIN ".TABLE_ORDERS_PRODUCTS_ATTRIBUTES." opa
ON(zop.orders_products_id = opa.orders_products_id), ".TABLE_ORDERS." zo, ".TABLE_ORDERS_STATUS." zos
WHERE zo.orders_id = zop.orders_id
AND zo.orders_status = zos.orders_status_id

hope that helps..
Dont forget to backup your work

I suspect if someone was decent at PHP coding (Which I am not) they could add a piece of code to this that would allow presorting of the data or specific data exported.
i.e all the orders on/or after a certain date.. or a certain product name..

I am working on a comprehensive overhaul of this mod, including adding the ability to specify a date range (in days before present), and output all orders of a given status. I will look into the price total aspect as it has been requested repeatedly. I am only planning on supporting v1.5.x in this.

The "noAttribs" option already includes a line for order total cost, so it will probably be easy to add that to the rest of the options. Anyone who is careful and observant should be able to fix this for themselves.

There are some useful code snippets in this old thread which are still relevant:
http://www.zen-cart.com/showthread.php?81146-orders-Exporter-0-1

add a piece of code to this that would allow presorting of the data or specific data exported. I have long-range plans for a total rewrite of the mod that will allow choosing the elements to be output and their order, as well as more ways to limit output by specific criteria. For now, I will give it the date range, order status and a few more fields.

I am having difficulty understanding the installation instructions. I am 1.3.9, so I have located the proper orders_Exporter folder to upload, but it doesn't make since to upload into my admin folder. Is that what I am supposed to do? The "orders_Exporter" folder is supposed to go exactly as is in my admin folder? Also, my admin folder was renamed years ago, so I don't understand why the instructions are asking me to rename it. Very confusing the way it is written, even a tech at bluehost could not understand the instructions. Thank you for your help.

There are two levels of /orders_Export/ folders under the /orders_exporter_installation_for_zen_cart_1.3.X/ folder (I don't know why), and then the /admin/ and /oexport/ folders. Rename the mod /admin/ folder to match your renamed admin, then upload the admin and oexport folders to the root of your site.

The /oexport/ folder is just a place for downloaded files to be saved to by the export page.

Do you have a timetable for the revamped mod? The current one and a similar one (Export Shipping Information) do some good things, but not everything I need and the date function would make this one perfect.

Thanks for all your contributions!

I got the changes partly functional, but time ran out for me on the urgent application, and I have been busy with other things since June. When I get time to concentrate, I do want to finish debugging and making the modest upgrade work, and make it available. Getting that base functional should make it easier to do the major overhaul.

My big obstacle with dates, oddly enough, has been making the "between" function of MySQL operate. The manual indicates that it should work exactly as I used it, but it gives no output. If I knew SQL debugging tools I might be able to figure out what it doesn't like. Alternately I could use a more verbose but maybe more reliable ">" and "<" set of filters.

Wish I could help. The other mod, Export Shipping Information, does date ranges.

Update: I have completed the major rewrite of this mod and have it functioning perfectly in my local test site. I next need to transfer it to my live site and ensure that it works there, do some more overhaul of the readme, and then it will be ready for release. I can package it soon for anyone who would like to test it and give feedback before official release. It works on v1.5.0 and v1.5.1, and I know of no reason it should not work on v1.5.3 (I will test this before release).

The new version has all new code except for the actual download/save functionality, and allows you to select a range of days ago, from/to dates, or from/to order ids, and then the original choice of download styles, plus the ability to download all of any one order status within the specified range. You can set in the defines the fields to export and their order in the file. The tab-delimited file will have customizable field titles, and basic info like customer name, date, etc. only appears once for orders with multiple products or attributes. Total cost and order comments can be included in the output, and other fields can be added by following the format of existing ones.

TNX Glenn,

I am testing v1.5.3 in my sandbox and am expecting to go live early next week. We use orders exporter on a daily basis, so I have the time to give it a workout in v1.53.

153bugs(at)chainweavers.com if you need an email address

Here is a zip of RC1 for testing. Please let me know of any issues, and what environments you have tested on.
I still need to figure out an uninstall SQL for this; the file included is a stub from another mod. Any examples for uninstalling from the Tools menu would be appreciated.

This shows the options on the admin page:

My schedule for tonight was just redirected to a different priority, so I'll look more tomorrwo.

First run. Minor issue, browser title
[Attachment no longer available]

First couple of reports run included the contents of the "Keep alive session" file above the expected data.

Below that keep-alive code was the expected data for orders in the processing status.

You certainly have expanded the options.

zen v1.5.3 installed one folder inside server root.

<!-- BOF: Keepalive for Session --> |

|
|
|
|
|
|
|

<!-- timeout warning alert --> |

|
|
|
|
|
|
|
|

<div id="keepalivetimer" title="Your session is about to expire!" style="display: none"> | | |

<p class="ui-state-error-text"> | 

|
|
|
|
|
|
|

    <span class="ui-icon ui-icon-alert" style="float:left; margin:0 7px 50px 0;"></span> | 

|
|

    You will be logged off in  <span id="keepalivetimer-countdown" style="font-weight:bold"></span> minutes. | 

</p> | 

|
|
|
|
|
|
|
|
|
|

|
|
|
|
|
|
|
|
|
|
|

<p>Do you want to continue your session?</p> | 

|
|
|
|
|
|

</div> | | | | | | | | | | |

<link href="//ajax.googleapis.com/ajax/libs/jqueryui/1.10.1/themes/base/jquery-ui.css" type="text/css" rel="stylesheet" /> |

<script type="text/javascript"> | | | | | | | |

if (typeof jQuery == "undefined") {//no jquery yet |
|
|
|
|
|
|

document.write('<scr'+'ipt type="text/javascript" src="//ajax.googleapis.com/ajax/libs/jquery/1/jquery.min.js">'); | 

document.write('</scr' + 'ipt>'); | 

|
|
|
|
|
|
|

} |
|
|
|
|
|
|
|
|
|
|

</script> |
|
|
|
|
|
|
|
|
|
|

<script type="text/javascript"> | | | | | | | |

if (!jQuery.ui) { |
|
|
|
|
|
|
|
|
|

document.write('<scr'+'ipt type="text/javascript" src="//ajax.googleapis.com/ajax/libs/jqueryui/1/jquery-ui.min.js">'); | 

document.write('</scr' + 'ipt>'); | 

|
|
|
|
|
|
|

} |
|
|
|
|
|
|
|
|
|
|

</script> |
|
|
|
|
|
|
|
|
|
|

<script src="includes/javascript/jquery.idletimer.js?t=1405472253" type="text/javascript"></script> |

|

<script src="includes/javascript/jquery.idletimeout.js?t=1405472253" type="text/javascript"></script> |

|

<style type="text/css"> | | | | | | | | |

a.ui-dialog-titlebar-close {display:none;} |
|
|
|
|
|
|

.ui-widget-overlay { background: green; opacity: .40;filter:Alpha(Opacity=40); } |
|
|
|

</style> |
|
|
|
|
|
|
|
|
|
|

<script type="text/javascript"> | | | | | | | |

//setup the dialog |
|
|
|
|
|
|
|
|
|

$("#keepalivetimer").dialog({ |
|
|
|
|
|
|
|
|

autoOpen: false, |
|
|
|
|
|
|
|
|
|

modal: true, |
|
|
|
|
|
|
|
|
|

width: 430, |
|
|
|
|
|
|
|
|
|

height: 250, |
|
|
|
|
|
|
|
|
|

closeOnEscape: false, |
|
|
|
|
|
|
|
|

draggable: false, |
|
|
|
|
|
|
|
|
|

resizable: false, |
|
|
|
|
|
|
|
|
|

position: "top", |
|
|
|
|
|
|
|
|
|

buttons: { |
|
|
|
|
|
|
|
|
|

'Yes, Keep Working': function(){ | 

|
|
|
|
|
|
|

  $(this).dialog('close'); | 

|
|
|
|
|
|
|
|

}, | 

|
|
|
|
|
|
|
|
|
|

'No, Logoff': function(){ | 

|
|
|
|
|
|
|
|

  $.idleTimeout.options.onLogoffClick.call(this); | 

|
|
|
|
|
|

} | 

|
|
|
|
|
|
|
|
|
|

} |
|
|
|
|
|
|
|
|
|
|

}); |
|
|
|
|
|
|
|
|
|
|

|
|
|
|
|
|
|
|
|
|
|

// start the idle timer monitor |
|
|
|
|
|
|
|
|

var $countdown = $("#keepalivetimer-countdown"); |
|
|
|
|
|

$.idleTimeout('#keepalivetimer', 'div.ui-dialog-buttonpane button:first', { |
|
|
|

idleAfter: 600, // 600 user is considered idle after 10 minutes of no movement in this browser window/tab |

warningLength: 250, // 250 countdown timer starts at this many seconds (250sec=4:50min) |
|
|

pollingInterval: 60, //60 check for server connection every minute; if it fails or user is logged out, keepalive scripts will abort |

keepAliveURL: 'keepalive.php', serverResponseEquals: 'OK', |
|
|
|
|
|

titleMessage: 'Warning: %s seconds until log out | ', |
|
|
|
|
|

onTimeout: function(){ |
|
|
|
|
|
|
|
|

document.title = '!!Expired Session'; | 

|
|
|
|
|
|
|

$(this).html('<p class="ui-state-error-text"><span class="ui-icon ui-icon-alert" style="float:left; margin:0 7px 50px 0;"></span>Sorry, you have been logged out due to inactivity.</p><p>Any unsaved work was lost. If you were composing content which you wish to save, click Close and copy that content to your clipboard. Then refresh the page to login again.</p><p>To continue, please login again.</p>'); | 

$(this).dialog("option", "title", 'Your session has expired'); | 

|
|
|
|
|

$(this).dialog("option", "minWidth", "450"); | 

|
|
|
|
|
|

$(this).dialog("option", "buttons", {'Close': function(){$(this).dialog('close');},'Login': function(){window.location.reload();}}); | 

//$(this).dialog("option", "buttons", {'Login': function(){window.location.reload();}    }); | 

|
|

}, |
|
|
|
|
|
|
|
|
|
|

onAbort: function(){ |
|
|
|
|
|
|
|
|

// TODO: another modal dialog would be more friendly | 

|
|
|
|
|

alert('We are unable to connect to the server. Your work may be lost. Please review your work and perhaps copy information to your clipboard if you had any work in progress which you do not wish to lose.'); | 

}, |
|
|
|
|
|
|
|
|
|
|

onIdle: function(){ |
|
|
|
|
|
|
|
|
|

$(this).dialog("open"); | 

|
|
|
|
|
|
|
|

}, |
|
|
|
|
|
|
|
|
|
|

onLogoffClick: function(){ |
|
|
|
|
|
|
|
|

window.location = "logoff.php"; | 

|
|
|
|
|
|
|

}, |
|
|
|
|
|
|
|
|
|
|

onCountdown: function(counter){ |
|
|
|
|
|
|
|

var sec = counter % 60; | 

|
|
|
|
|
|
|
|

var min = Math.floor(counter/60); | 

|
|
|
|
|
|
|

if (sec < 0) { | 

|
|
|
|
|
|
|
|
|

  sec = 59; | 

|
|
|
|
|
|
|
|
|

  min = min - 1; | 

|
|
|
|
|
|
|
|
|

} | 

|
|
|
|
|
|
|
|
|
|

if (sec<=9) { sec = "0" + sec; } | 

|
|
|
|
|
|
|
|

var time = (min<=9 ? "0" + min : min) + ":" + sec; | 

|
|
|
|
|
|

$countdown.html(time); | 

|
|
|
|
|
|
|
|

} |
|
|
|
|
|
|
|
|
|
|

}); |
|
|
|
|
|
|
|
|
|
|

</script> |
|
|
|
|
|
|
|
|
|
|

<!-- EOF: Keepalive for Session --> |

|
|
|
|
|
|
|

Status |
OID |
Date purchased |
Name |
E-mail |
Product name |
Qty |
Options |
Values |
Comments |
ENDOFROW |

Processing |
EDITED |
######## |
EDITED |
Bronze |
0.5 |
Wire |
Square |
|
ENDOFROW |

|
|
|
|
|
0.5 |
Mandrel |
3.50 |
|
ENDOFROW |

|
|
|
|
|