Orders Exporter Module

[RixStix]

No keepalive related issues since using DrByte's original version instead of the Numinix version.

I didn't see an option for enable/disable comments, so not sure about that being enabled or disabled.

I am seeing things that don't make sense because I had edited the installation of the 1.3.9 version so that only datafields that I needed were exported.

Those same datafields are in the RC you sent instead of everything. I am still looking for what is causing that. Could be the change in filenaming between the versions and an older file carrying over instead of being overwritten by the new. Latest inserts an underscore orders_export instead of ordersexport

That issue is also affecting exported file column labels.

One nagging issue is that once an export file is generated, it doesn't seem to change upon subsequent exports. ie: new order arrives a few minutes after generating an export file. Generate a new export file and there is no change. Since filenames do not change except hourly, even after waiting until the next hour rolls over, the file is the same. The only way I found to see the new data added is to use the Order ID range and include the latest order numbers.

[RixStix]

Just noticed today when we had a list of 3 dozen plus line items, that there appears to be a change in sorting of the output file product names/options which puts them in a very different order that listed on the printed invoice.

As mentioned earlier, once a file is generated for a day, none of the subsequent changes are included with the export file if regenerated with a different default timestamp.

This is definitely above my paygrade to troubleshoot but am willing to do whatever is needed to help.

[RixStix]

I had a DUH moment today. I didn't realize that I needed to edit the sort orders in the /admin/includes/language/english/orders_export.php file to align the proper datafields. I found the 'v_orders_comment' setting that you mentioned, changed to 0 and the duplicates disappeared.

Now to figure out how to prevent sorting so that the order attributes appear in the download file in the same order they appear on the printed invoice.

Looking good now. Knowing where and how to edit will make this very useful for almost anyone.

[gjh42]

I will make the editing instructions a bit more explicit in the readme, to help people understand how to customize their reports. The attributes are output in the same order that the SQL query retrieves them, which probably has nothing to do with the way they are sorted for display in product pages or official invoices. It may be possible to add to the query to sort by attribute sort order where relevant... not something I had planned on doing, but I will keep it in mind as a future enhancement.

[RixStix]

No problems. I thought that might be the case for sorting and must be a difference between the different ZC versions. There is no logic that I can see to the order.

Thank you for taking the time to make this valuable pluging compatable with the latest version and provide the options for easy customization.

[gjh42]

It just occurred to me that your issue with the output not changing even when the source changes within a day may be due to some kind of query caching. If the system thinks the SQL query has already been run and is still good, it may fetch a cached copy instead of searching again. There was a reset button at the bottom of the page from the earliest version of the mod, and it might be useful for flushing the cache and forcing a new search... don't know enough about it to be sure.

[gjh42]

I have the order comments output rebuilt and working correctly on my test site, and the readme brought fully up to date. I want to test it on my live site before submitting to Plugins just to make sure. There is one nagging item, which does not cause any problems I can see, but ought not to be happening. When selecting an export range, two odd elements are added to the URL in the address bar. They vary seemingly at random in the numbers, but always look like ...&x=23&y=9.
For example:

http://localhost/zc151/my_admin/orders_export.php?from_oid=1&to_oid=99&x=38&y=6

I don't know what in the form submission would insert that, and would like to eliminate it.

    <div class="oidSetting"> <!-- Order ID setting inputs -->
      <h2><?php echo ORDERSEXPORT_PAGE_HEADING_OID; ?></h2>
      <?php echo zen_draw_form('oid_range', FILENAME_ORDERSEXPORT, '', 'get');
      echo '<div class="oidInput">' . OEX_FROM_OID_PRE . zen_draw_input_field('from_oid', $limits['orders_id'][0], 'size="10"') . '</div>';
      echo '<div class="oidInput">' . OEX_TO_OID_PRE . zen_draw_input_field('to_oid', $limits['orders_id'][1], 'size="10"') . '</div>';
      echo '<div class="oidSubmit">' . zen_image_submit('button_save.gif', IMAGE_SAVE) . '</div>';//form submit
      echo '</form>';?>
    </div>