Export Shipping & Order Information

Quote:

---

Originally Posted by 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:

Quote:

---

<?php echo zen_draw_checkbox_field('shipmethod', '1', $shipping_method_checked=true);?>&nbsp;<?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):

Quote:

---

<?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:

Quote:

---

<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:

Quote:

---

// 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:

Quote:

---

Originally Posted by 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.

Quote:

---

Originally Posted by 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.

Quote:

---

Originally Posted by 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?