The samples, like what my files show, is one cell with all the attributes:

Color: Black | Memory: 16 mb |

Did I miss something?

I use attributes for the registration of students under 18 (account creation/payment is for the parents) so would like to separate the attributes of Student First Name, Student Last Name, Age, etc. I played around with separators other than | and tried to open the file with different spreadsheet selections other than Comma, but to no avail.

While you're here...

2. To change the order of columns (ID, Name, etc.), is it enough to play with your file or is the mod connected to a core file? I tried moving around just two as a test and didn't even get that working...average/poor php skills here.

3. Is there a way to export just a certain product category? That would be amazing for the company I do this for, there are only a handful of categories, and we'd donate a few bucks for it.

I am currently using Orders Exporter but need the date range feature of this module.

BUT I only want to export these 4 columns of data in my csv file.
Deliver TO Company - Order ID - Product Name - Product Quantity
1:
Can I modify the code to do this?
2:
Would you point me to where in the code I do this?

AND I want to eliminate the RSS stuff.
1:
I'm thinking I just don't upload hose files?

Thanks,

By default, the module will export the shipping information as well (address etc...). The only way to remove that is to go into the code and comment out all of those sections (there will be a few based on the ability to export two ways (1. one order per row, and 2. one product per row.)

You would also need to remove the part of the header (column headings) that would print for those as well.

All other columns are controlled by check marking items in the admin of the module.

For the RSS Stuff you would need to remove those files and (1. remove the section of code that includes those in the admin panel .... 2. alter the panel template if desired to remove that now blank section.)

Let me know if that helps.

Thanks, Sounds like I'm on the right path.

excellent module - thank you

however we have spotted a weird thing and not sure how to come around it

when we do an export we only want to export orders that are "completed" - that works on the CSV however the non-completed orders are getting updated as "exported" in the database and therefore not appearing again?

Does that follow?

Using 1.3.9h

Everything else works as expected it just seems to toggle the database to "export" everything and ignoring the "completed" part for the "Order Status Export Options"
we select - Assigned Order Status (select below) and completed from drop down

I sit possible that it only updates the database with items that match the CSV file ?

Thank you
Sarah

The reason this is, is because the module looks for any order that has not been SHIPPED yet (all new orders) and exports those. Is one of your "order statuses" (in the admin) "completed"? If you want to only export orders that are "completed" (order status) then you would need to customize the current module to look for order status 'completed' (the id of what that is in your db).

econcepts:

The reason this is, is because the module looks for any order that has not been SHIPPED yet (all new orders) and exports those. Is one of your "order statuses" (in the admin) "completed"? If you want to only export orders that are "completed" (order status) then you would need to customize the current module to look for order status 'completed' (the id of what that is in your db).

Hi Eric

I am somewhat confused by your reply

Am I not right in that the CSV file download does NOT equal whats updated in the database table?

As the CSV correctly uses this setting in your module "Order Status Export Options" and yes one of our statuses is "Completed" - so it downloads the "completed" and "unshipped" orders

However regardless of us using this option or not the "non-completed" and "unshipped" statuses are still marked as "exported" - when actually the ones that are not "completed" should be carried over to the next time its run?

As I don't understand why the SQL isn't matching the options for the CSV download....

Or is that not what this module does and everytime its run marks anything not exported as exported regardless of any options selected?

Thanks
Sarah

Sarah,

What version of the module are you using? It is possible that there is a bug in it preventing that from working correctly. Let me know and I'll have a look at it.

Eric

version 1.3.2
as using 139h on ZC too

and yes agree its odd too:)

thanks
Sarah

Sarah,

I took a look at that version and it appears that the update function only accounts for date range when selected and / or all or nothing (meaning update of all orders.)

If you send me the file that you are using (I sent you a PM for where to send it) then I'll make the update to it and send it back to you.

Thanks!

ZC 1.5.1. The easy stuff first:

What code in export_shipping_information_V1.3.2.1/"shipping_export.php" do I change to set the below as defaults?
(Obviously not the 10 things I tried :yuck:
1:
Product per row.
(Currently set to Order per row)
2:
Include Header Row In Export.
(Currently you have a check box)
3:
Full Product Details
(Currently you have a check box)

And the issue................
ZC 1.5.1 with plugins: When installed in the order listed below everyone plays nice. Note the order listed and that EP4 & ESI must be installed before FEC.

EasyPopulate-4.0-master [mc12345678 strain], export_shipping_information_V1.3.2.1, FEC, column_layout_grid_2_3_1, extra_field_on_customer_sign_up_2-0, Minimum Order, AND Mods to the layout template.

I installed ESI on my production build which already had the other mods installed and ESI exports the headers but NO product data and does NOT throw any errors.
I know this isn't much to go on but maybe some of you who are smarter that me (or at least know how ESI works) could tell me how this is possible.

Seems to me this is some sort of database ordering issue. I have compared the databases of the working vrs. non-working install and the only differences I could see was the order the plugins were install in.

NOTE:
A similar condition exists with EasyPopulate-4.0-master in that it has to be installed before FEC. Because I already have it installed on my production build it's not a problem for me in the short term but may be a problem later on.

Thanks,

It technically shouldn't matter what order any of those are installed in UNLESS, one of them has a "delete" type of command that in unknowingly removes some database field(s) from other modules (I've seen this before with a number of mods.)

To set defaults on the selection items you need to add another portion to the function for drawing either the radio fields, checkboxes etc...

Specifically you would need to add something that follows this pattern "$variablenamehere=true"

An example of how you would select by default the type of file layout would be

ORIGINAL LINE OF CODE:

<?php echo zen_draw_radio_field('filelayout', '2' );?> <?php echo TEXT_FILE_LAYOUT_PPR_FIELD; ?><br />

CHANGE TO:

<?php echo zen_draw_radio_field('filelayout', '2' , $filelayout=true);?> <?php echo TEXT_FILE_LAYOUT_PPR_FIELD; ?><br />

Notice the addition of the ", $filelayout=true" portion of code.

You would do the same for the checkboxes (adding the appropriate variable = to true for each that you wish to pre-select.

Example for checkbox would be:

ORIGINAL LINE:

<?php echo zen_draw_checkbox_field('product_details', '1');?> <?php echo TEXT_PRODUCT_DETAILS_FIELD; ?> <span style="color: #ff0000"><strong>*</strong></span><br />

CHANGE TO:

<?php echo zen_draw_checkbox_field('product_details', '1', $prod_details_checked=true);?> <?php echo TEXT_PRODUCT_DETAILS_FIELD; ?> <span style="color: #ff0000"><strong>*</strong></span><br />

Notice addition of the ", $prod_details_checked=true" portion.

Let me know if that helps.

Thanks for the default code. Nothing like what I was trying. :blush: I'll try yours later today.

The SOI Issue:
My Orders tables look identical as far as the same numbers of columns/fields except the order of them.
Obviously if you add OSI first it's extra column/field is before the columns/fields FEC adds and the opposite if you add FEC first.

Is it a different table causing the problem?
I reviewed the code in shipping_export.php but couldn't see where SOI pulls data from any other sql tables. Of course I'm not that good at PHP so I may have missed something.

The only other table I see affected is the "admin_pages but the same applies there, only the order is different.

Here's the two "orders" Tables
i.e.. See red stuff

FEC First
-- Table structure for table orders

CREATE TABLE IF NOT EXISTS orders (
orders_id int(11) NOT NULL AUTO_INCREMENT,
customers_id int(11) NOT NULL DEFAULT '0',
customers_name varchar(64) NOT NULL DEFAULT '',
customers_company varchar(64) DEFAULT NULL,
customers_street_address varchar(64) NOT NULL DEFAULT '',
customers_suburb varchar(32) DEFAULT NULL,
customers_city varchar(32) NOT NULL DEFAULT '',
customers_postcode varchar(10) NOT NULL DEFAULT '',
customers_state varchar(32) DEFAULT NULL,
customers_country varchar(32) NOT NULL DEFAULT '',
customers_telephone varchar(32) NOT NULL DEFAULT '',
customers_email_address varchar(96) NOT NULL DEFAULT '',
customers_address_format_id int(5) NOT NULL DEFAULT '0',
delivery_name varchar(64) NOT NULL DEFAULT '',
delivery_company varchar(64) DEFAULT NULL,
delivery_street_address varchar(64) NOT NULL DEFAULT '',
delivery_suburb varchar(32) DEFAULT NULL,
delivery_city varchar(32) NOT NULL DEFAULT '',
delivery_postcode varchar(10) NOT NULL DEFAULT '',
delivery_state varchar(32) DEFAULT NULL,
delivery_country varchar(32) NOT NULL DEFAULT '',
delivery_address_format_id int(5) NOT NULL DEFAULT '0',
billing_name varchar(64) NOT NULL DEFAULT '',
billing_company varchar(64) DEFAULT NULL,
billing_street_address varchar(64) NOT NULL DEFAULT '',
billing_suburb varchar(32) DEFAULT NULL,
billing_city varchar(32) NOT NULL DEFAULT '',
billing_postcode varchar(10) NOT NULL DEFAULT '',
billing_state varchar(32) DEFAULT NULL,
billing_country varchar(32) NOT NULL DEFAULT '',
billing_address_format_id int(5) NOT NULL DEFAULT '0',
payment_method varchar(128) NOT NULL DEFAULT '',
payment_module_code varchar(32) NOT NULL DEFAULT '',
shipping_method varchar(128) NOT NULL DEFAULT '',
shipping_module_code varchar(32) NOT NULL DEFAULT '',
coupon_code varchar(32) NOT NULL DEFAULT '',
cc_type varchar(20) DEFAULT NULL,
cc_owner varchar(64) DEFAULT NULL,
cc_number varchar(32) DEFAULT NULL,
cc_expires varchar(4) DEFAULT NULL,
cc_cvv blob,
last_modified datetime DEFAULT NULL,
date_purchased datetime DEFAULT NULL,
orders_status int(5) NOT NULL DEFAULT '0',
orders_date_finished datetime DEFAULT NULL,
currency char(3) DEFAULT NULL,
currency_value decimal(14,6) DEFAULT NULL,
order_total decimal(14,2) DEFAULT NULL,
order_tax decimal(14,2) DEFAULT NULL,
paypal_ipn_id int(11) NOT NULL DEFAULT '0',
ip_address varchar(96) NOT NULL DEFAULT '',
COWOA_order tinyint(1) NOT NULL DEFAULT '0',
downloaded_ship enum('yes','no') NOT NULL DEFAULT 'no',
PRIMARY KEY (orders_id),
KEY idx_status_orders_cust_zen (orders_status,orders_id,customers_id),
KEY idx_date_purchased_zen (date_purchased),
KEY idx_cust_id_orders_id_zen (customers_id,orders_id)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=145 ;

--
-- Dumping data for table orders

INSERT INTO orders (orders_id, customers_id, customers_name, customers_company, customers_street_address, customers_suburb, customers_city, customers_postcode, customers_state, customers_country, customers_telephone, customers_email_address, customers_address_format_id, delivery_name, delivery_company, delivery_street_address, delivery_suburb, delivery_city, delivery_postcode, delivery_state, delivery_country, delivery_address_format_id, billing_name, billing_company, billing_street_address, billing_suburb, billing_city, billing_postcode, billing_state, billing_country, billing_address_format_id, payment_method, payment_module_code, shipping_method, shipping_module_code, coupon_code, cc_type, cc_owner, cc_number, cc_expires, cc_cvv, last_modified, date_purchased, orders_status, orders_date_finished, currency, currency_value, order_total, order_tax, paypal_ipn_id, ip_address, COWOA_order, downloaded_ship) VALUES
(142, 62, 'rrrrrrrrrrrr rrrrrrrrrr', 'rrrrrrrrrr', 'rrrrrr', 'rrrrrrrrrrr', 'rrrrrrrrrr', 'rrrrrrrrrr', 'Rhode Island', 'United States', 'rrrrrrrrrrrr', '[email protected]', 2, 'rrrrrrrrrrrr rrrrrrrrrr', 'rrrrrrrrrr', 'rrrrrr', 'rrrrrrrrrrr', 'rrrrrrrrrr', 'rrrrrrrrrr', 'Rhode Island', 'United States', 2, 'rrrrrrrrrrrr rrrrrrrrrr', 'rrrrrrrrrr', 'rrrrrr', 'rrrrrrrrrrr', 'rrrrrrrrrr', 'rrrrrrrrrr', 'Rhode Island', 'United States', 2, '', 'moneyorder', 'Flat Rate (Best Way)', 'flat', '', '', '', '', '', NULL, NULL, '2014-02-17 12:44:14', 1, NULL, 'USD', '1.000000', '1282.05', '0.00', 0, '70.123.98.89 - 70.123.98.89', 0, 'no'),

SOI First
Table structure for table orders

CREATE TABLE IF NOT EXISTS orders (
orders_id int(11) NOT NULL AUTO_INCREMENT,
customers_id int(11) NOT NULL DEFAULT '0',
customers_name varchar(64) NOT NULL DEFAULT '',
customers_company varchar(64) DEFAULT NULL,
customers_street_address varchar(64) NOT NULL DEFAULT '',
customers_suburb varchar(32) DEFAULT NULL,
customers_city varchar(32) NOT NULL DEFAULT '',
customers_postcode varchar(10) NOT NULL DEFAULT '',
customers_state varchar(32) DEFAULT NULL,
customers_country varchar(32) NOT NULL DEFAULT '',
customers_telephone varchar(32) NOT NULL DEFAULT '',
customers_email_address varchar(96) NOT NULL DEFAULT '',
customers_address_format_id int(5) NOT NULL DEFAULT '0',
delivery_name varchar(64) NOT NULL DEFAULT '',
delivery_company varchar(64) DEFAULT NULL,
delivery_street_address varchar(64) NOT NULL DEFAULT '',
delivery_suburb varchar(32) DEFAULT NULL,
delivery_city varchar(32) NOT NULL DEFAULT '',
delivery_postcode varchar(10) NOT NULL DEFAULT '',
delivery_state varchar(32) DEFAULT NULL,
delivery_country varchar(32) NOT NULL DEFAULT '',
delivery_address_format_id int(5) NOT NULL DEFAULT '0',
billing_name varchar(64) NOT NULL DEFAULT '',
billing_company varchar(64) DEFAULT NULL,
billing_street_address varchar(64) NOT NULL DEFAULT '',
billing_suburb varchar(32) DEFAULT NULL,
billing_city varchar(32) NOT NULL DEFAULT '',
billing_postcode varchar(10) NOT NULL DEFAULT '',
billing_state varchar(32) DEFAULT NULL,
billing_country varchar(32) NOT NULL DEFAULT '',
billing_address_format_id int(5) NOT NULL DEFAULT '0',
payment_method varchar(128) NOT NULL DEFAULT '',
payment_module_code varchar(32) NOT NULL DEFAULT '',
shipping_method varchar(128) NOT NULL DEFAULT '',
shipping_module_code varchar(32) NOT NULL DEFAULT '',
coupon_code varchar(32) NOT NULL DEFAULT '',
cc_type varchar(20) DEFAULT NULL,
cc_owner varchar(64) DEFAULT NULL,
cc_number varchar(32) DEFAULT NULL,
cc_expires varchar(4) DEFAULT NULL,
cc_cvv blob,
last_modified datetime DEFAULT NULL,
date_purchased datetime DEFAULT NULL,
orders_status int(5) NOT NULL DEFAULT '0',
orders_date_finished datetime DEFAULT NULL,
currency char(3) DEFAULT NULL,
currency_value decimal(14,6) DEFAULT NULL,
order_total decimal(14,2) DEFAULT NULL,
order_tax decimal(14,2) DEFAULT NULL,
paypal_ipn_id int(11) NOT NULL DEFAULT '0',
ip_address varchar(96) NOT NULL DEFAULT '',
downloaded_ship enum('yes','no') NOT NULL DEFAULT 'no',
COWOA_order tinyint(1) NOT NULL DEFAULT '0',
PRIMARY KEY (orders_id),
KEY idx_status_orders_cust_zen (orders_status,orders_id,customers_id),
KEY idx_date_purchased_zen (date_purchased),
KEY idx_cust_id_orders_id_zen (customers_id,orders_id)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=4 ;

--
-- Dumping data for table orders

INSERT INTO orders (orders_id, customers_id, customers_name, customers_company, customers_street_address, customers_suburb, customers_city, customers_postcode, customers_state, customers_country, customers_telephone, customers_email_address, customers_address_format_id, delivery_name, delivery_company, delivery_street_address, delivery_suburb, delivery_city, delivery_postcode, delivery_state, delivery_country, delivery_address_format_id, billing_name, billing_company, billing_street_address, billing_suburb, billing_city, billing_postcode, billing_state, billing_country, billing_address_format_id, payment_method, payment_module_code, shipping_method, shipping_module_code, coupon_code, cc_type, cc_owner, cc_number, cc_expires, cc_cvv, last_modified, date_purchased, orders_status, orders_date_finished, currency, currency_value, order_total, order_tax, paypal_ipn_id, ip_address, downloaded_ship, COWOA_order) VALUES
(3, 1, 'FFFFFFF LLLLLLLL', 'FEC Co', '9876Huiuy', '', 'Jkkkk', '90909', 'Florida', 'United States', '9876545432', '[email protected]', 2, 'FFFFFFF LLLLLLLL', 'FEC Co', '9876Huiuy', '', 'Jkkkk', '90909', 'Florida', 'United States', 2, 'FFFFFFF LLLLLLLL', 'FEC Co', '9876Huiuy', '', 'Jkkkk', '90909', 'Florida', 'United States', 2, 'Check/Money Order', 'moneyorder', 'Flat Rate (Best Way)', 'flat', '', '', '', '', '', NULL, NULL, '2014-02-17 14:01:51', 1, NULL, 'USD', '1.000000', '47.00', '0.00', 0, '70.123.98.89 - 70.123.98.89', 'no', 0);

---

econcepts , That is purrrfect! THANKS!
You have just taught this man how to fish (for the little ones) :cool:

I've been reviewing the code & database regarding the below issue but no joy... I'm sure the problem is staring me in the face but I can't see it.

And the issue................
ZC 1.5.1 with plugins: When installed in the order listed below everyone plays nice. Note the order listed and that EP4 & ESI must be installed before FEC.

EasyPopulate-4.0-master [mc12345678 strain], export_shipping_information_V1.3.2.1, FEC, column_layout_grid_2_3_1, extra_field_on_customer_sign_up_2-0, Minimum Order, AND Mods to the layout template.

I installed ESI on my production build which already had the other mods installed and ESI exports the headers but NO product data and does NOT throw any errors.
I know this isn't much to go on but maybe some of you who are smarter that me (or at least know how ESI works) could tell me how this is possible.

Seems to me this is some sort of database ordering issue. I have compared the databases of the working vrs. non-working install and the only differences I could see was the order the plugins were install in. Can't determine where the DB Query is going off the rails.

After a couple of 4:00 AM sessions I found the smoking gun and a workaround for the issue I posted on Feb. 22, 2014 :clap: > ES+OI exports the headers but NO product data and does NOT throw any errors

If I reset the "starting order" number via the admin panel before importing new product with EP4, ES+OI then correctly exports ALL information. Obviously it has to be reset to a number above the highest existing order number.
You still have to adhere to the plugin installation order listed in my Feb. 22 post.

Is this an EP4 or an ES+OI problem?
I would sure like to know how/why this happens and IMHO an elegant fix is in order.

Found another nit. Leading zeros are stripped from (in my case product numbers) when data is exported as a CSV file.
This does not happen when exporting to a CSV file in EP4 so can that same code be applied to this plugin?

Other than those two issues I Love this Plugin.

This bit of information may save someone a LOT of time & hair pulling.
I found the rest of the smoking gun which was the real problem I had where just the header information would download.
IMHO I think this is a bug and should be fixed for those who do not want to/need to display certain shipping information.

If you do NOT have ot_shipping selected in the "Admin Panel > Modules > Shipping > ot_shipping" ES+OI will NOT download the order information.

My work around/solution was to comment out the code for "ot_shipping" in ADMIN > shipping_export.php
Around line 104:
$order_info = $order_info; // . "AND ot.class = 'ot_shipping'";

Around line 135:
$order_info = $order_info . " WHERE o.orders_id = ot.orders_id";
// AND ot.class = 'ot_shipping' ";

Around line 165:
WHERE o.orders_id = ot.orders_id";
//AND ot.class = 'ot_shipping'";

Thanks,

ZC Version 1.5.1

Hi,

I am using the Keep Alive Timer Pluggin. When exporting to csv or text I get the following code showing before the order info:

<!-- 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=1393853933" type="text/javascript"></script> <script src="includes/javascript/jquery.idletimeout.js?t=1393853933" 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 -->

I have included a snapshot of the settings.

Is there something that I can do to stop this from showing?

I would also like to alter the fields that are shown when I download the info. My suppliers dropship many items for me and do not need all of the info that is supplied by this pluggin. They have requested that I do not send all of the info that the Excel file contains. This means I have to manually alter the info that is shown and delete fields that are not required. How can I alter what is downloaded so that only the fields needed are shown in the CSV file?

I would need the following:

Order ID
Delivery Name
Company
Delivery Street
Delivery Suburb
Delivery City
Delivery State
Delivery Post Code
Delivery Country
Product Qty
Product Name
Product Model
Delivery Comments (This is a field that I am going to add to the checkout procedure as a one line separate field in the near future and will allow me to separate order comments from delivery comments).

Also, I would like to include a Suppliers field that I have placed in the product info page on the admin side. I would like to include this as a field so that I can separate orders for different suppliers. This I would probably have to do manually but it would help a lot and save a lot of time going through all of the orders and determining which order is for which supplier. If I can see which supplier is providing each product it would be a cut and paste into another Excel document.

I think that I have provided all of the info but if more is needed please ask and I will make sure that I make things a little clearer.

Thanks in advance for any help.

I modified in my code to achieve the results pictured. My MODIFIED shipping_export.php.zip is attached.

Attachment #13851

Sorry but I did not comment my changes. You'll have to compare this to the original shipping_export.php.

I would like to export my orders sorted by Order/product Name. Instead they are exported by Order/order entered in cart.
Any suggestions/code on how to do this?

Thanks,

Responding to one of your older posts. Glad you found it all and got it working. I have been in the process of updating all of my plugins as part of a suite of tools so at some point a new version here of this will be ready to go with some added features hopefully.