Export Shipping & Order Information

I've seen this posted in one other place back in this thread, but not answer. Is there a way to set default settings so that I don't have to set them every time? My export settings are the same every time I run the export, so it would be nice to not have to set them each time.

split63:

Here are the timestamps for the last four of that day.
Aug 22, 2010 11:56:53 PM
Aug 22, 2010 11:58:28 PM
Aug 22, 2010 11:59:26 PM (failed to export)
Aug 22, 2010 11:59:44 PM (failed to export)

Great, thanks for providing these. I suspected they were "later in the day" numbers. I will make a few alterations in calculation of the date / time in the next version to see if this can be remedied. I appreciate the feedback!

stevelucky:

I've seen this posted in one other place back in this thread, but not answer. Is there a way to set default settings so that I don't have to set them every time? My export settings are the same every time I run the export, so it would be nice to not have to set them each time.

Currently the is no way to "save" your configuration (maybe an option I could consider for future versions) but you can preset options if you know php.

To do this you would need to open the file shipping_export.php found in the root of the admin folder. Then scroll to the bottom where the form is generated and add "selected" etc... to the items you want to have preselected. I've done this on a number of installs and it works well.

econcepts:

Currently the is no way to "save" your configuration (maybe an option I could consider for future versions) but you can preset options if you know php.

To do this you would need to open the file shipping_export.php found in the root of the admin folder. Then scroll to the bottom where the form is generated and add "selected" etc... to the items you want to have preselected. I've done this on a number of installs and it works well.

One quick fix that is not ideal, but better than nothing, would be to provide a separate include file that we could edit. In the file is each of those variables and a simple "0" or "1" next to each variable.
Users would then edit the file and set the values to one or zero. Then each time Export is used, these default values set the check boxes accordingly.
This would be much easier and safer than going in and editing each corresponding line in the php file. I had gone in an edited the php file, but when I upgraded to v1.3.2. those edits were lost. With the include file approach, new updates would not be a problem

Nice idea there. I'll look at incorporating that into the next release.

nice mod here. I just installed it and I'm getting a 1064 error (error in SQL syntax) when I attempt to export. Any idea what could be causing this. (my server is using PHP 5.2.9)

1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND cc.countries_name = o.delivery_country WHERE o.orders_id = ot.orders_id AND' at line 1
in:
[SELECT o.orders_id, customers_email_address, delivery_name, delivery_company, delivery_street_address, delivery_suburb, delivery_city, delivery_postcode, delivery_state, delivery_country, shipping_method, customers_telephone, order_total, op.products_model, products_name, op.products_price, final_price, op.products_quantity, date_purchased, ot.value, orders_products_id, order_tax, o.orders_status, o.payment_method, cc.countries_iso_code_2 FROM (3wuw_orders o LEFT JOIN 3wuw_orders_products op ON o.orders_id = op.orders_id), 3wuw_orders_total ot, 3wuw_countries cc AND cc.countries_name = o.delivery_country WHERE o.orders_id = ot.orders_id AND ot.class = 'ot_shipping' AND downloaded_ship='no' ORDER BY orders_id ASC]
If you were entering information, press the BACK button in your browser and re-check the information you had entered to be sure you left no blank fields.

magnusrf:

nice mod here. I just installed it and I'm getting a 1064 error (error in SQL syntax) when I attempt to export. Any idea what could be causing this. (my server is using PHP 5.2.9)

I had ISO Country Code checked, when I went back and unchecked it , it worked.

In the shipping_export.php file is looks like there are plans to enable exporting as an XML file?

This would be great since I have a 3rd Party Fulfillment warehouse that prefers an XML file when I send them my orders. Any idea if and when we could see this functionality?

magnusrf:

nice mod here. I just installed it and I'm getting a 1064 error (error in SQL syntax) when I attempt to export. Any idea what could be causing this. (my server is using PHP 5.2.9)

What version of the module are you using?

I'll have to look and see if anything else changed that would have added or dropped something when the ISO codes are used. Anyone else notice this problem on their system?

magnusrf:

In the shipping_export.php file is looks like there are plans to enable exporting as an XML file?

This would be great since I have a 3rd Party Fulfillment warehouse that prefers an XML file when I send them my orders. Any idea if and when we could see this functionality?

This is indeed on the drawing board to add. Just haven't got a hard date on it yet. I was working on correcting a number of issues that arose in previous releases to come back to a new "stable" version (which I think from current reports we have now with 1.3.2).

The issue with the XML file to a degree is that some fulfillment houses want the XML file in a certain format with records indicated in various forms. This XML file would be a standard type of export that they would have to map to for it to work (so we have a consistent basis for all users.)

econcepts:

Currently the is no way to "save" your configuration (maybe an option I could consider for future versions) but you can preset options if you know php.

To do this you would need to open the file shipping_export.php found in the root of the admin folder. Then scroll to the bottom where the form is generated and add "selected" etc... to the items you want to have preselected. I've done this on a number of installs and it works well.

Can you give me an idea of what that might look like? I'm looking at the file right now, but I'm not sure I can see where I would add "selected".

For fields that have checkmarks, you would alter to read as follows:

<?php echo zen_draw_checkbox_field('shipmethod', '1', $shipping_method_checked**=true**);?> <?php echo TEXT_SHIPPING_METHOD_FIELD; ?><br />

For fields that are drop downs you would need to do this (where the highlighted part references the actual 'value' for the drop down element you want to pre-select):

<?php echo zen_draw_pull_down_menu('order_status', $status_array**, $default='5'**, 'id="order_status"'); ?>

For any fields that are referenced through straight HTML you want to alter as follows:

<input type="radio" name="status_target" value="1">Any Order Status<br />

Is there a way to include the header row in the e-mailed version?

Did you check the box for exporting the header row? If so, let me know if it doesn't show in your file. I can take a look at adding that for the next version (I thought it added that to the file already though.)

Yes, I did check the box. I notice in the shipping_export.php file, it has this code about halfway through the file:

// saving to a file for email attachement, so write and ready else do regular output (prompt for download)
// Do not set headers becuase we are going to email the file to the supplier.
//open output file for writing
$f=fopen(DIR_FS_EMAIL_EXPORT.$file,'w+');
fwrite($f,$str_export);
//fwrite($f,$str_full_export);
fclose($f);
unset($f);

It looks like if the file is going to be saved on the server and e-mailed, the header row is not included, even if the box is checked. How would I change that?

Thanks!

Hi Eric,

It looks like this newest version has an addition field called Ship Destination Type.

Can this field be added to the Select Additional Fields section so I can exclude it? To have a new field just pop up like this throws my whole import off (I'm automatically importing it into Access).

Thanks, Susie

Two other things I noticed.

1. When I changed downloaded_ship to no, that record did not show up again on the screen (it had in the past). Did you change something to look at more than that field for new records?

2. These fields are now in a different place:
   product qty, product price, product name, product model, product attributes.

In the old version, these fields were between order date and order tax. In the new they come at the end after order status.

Any chance you could put these back to be in the same position they were before? Anyone who has the records automatically imported into something else will be messed up by this.

I'm using these settings:

Danielle:

Yes, I did check the box. I notice in the shipping_export.php file, it has this code about halfway through the file:

It looks like if the file is going to be saved on the server and e-mailed, the header row is not included, even if the box is checked. How would I change that?

Thanks!

Make sure you are working with the newest version. The newest version has that section altered to include the header row. 1.3.2 is what you want.

susb8383:

1. When I changed downloaded_ship to no, that record did not show up again on the screen (it had in the past). Did you change something to look at more than that field for new records?

No, nothing else is looked at. That is the only field.

susb8383:

2. These fields are now in a different place:
   product qty, product price, product name, product model, product attributes.

In the old version, these fields were between order date and order tax. In the new they come at the end after order status.

Any chance you could put these back to be in the same position they were before? Anyone who has the records automatically imported into something else will be messed up by this.

In one of the original (very early) versions the way it is now is the way it should have been. Somewhere along the line the details changed. To be more relevant for the majority of users the field locations were put back to their original areas.

Having said that, your import could likely be thrown off do the the addition of the new field Ship Dest Type. I have already marked this field as an optional field in the next release (1.3.3) so that has been completed now. Once I get a few other details in 1.3.3 I'll release it. If you want to send me a private message with your email I can email a copy of that to you (with the changes you need to the ship dest type field).

Oh...darn it lol, mine is quite heavily modified to include extra fields and remove other unnecessary fields. Can I just grab the header section from the 1.3.2 file and put it in my file, or are there other changes that would need to be made for that to work?