Export Shipping & Order Information

Got it figured out.
To eliminate the timestamp from exported orders.
Replaced this:
$str_export .= $FIELDSEPARATOR . $FIELDSTART . $order_details->fields['date_purchased'] . $FIELDEND;
With this.
$str_export .= $FIELDSEPARATOR . $FIELDSTART . zen_date_short($order_details->fields['date_purchased']) . $FIELDEND;

On the date display I had to move the date_purchased from the end of the query to the appropriate position in this code as I am not displaying all the fields.

$query = "SELECT o.orders_id, customers_email_address, delivery_name, delivery_company, delivery_street_address, delivery_suburb, delivery_city, delivery_postcode, delivery_state, delivery_country, date_purchased, shipping_method, customers_telephone, order_total
FROM ". TABLE_ORDERS ." o
WHERE downloaded_ship='no'
ORDER BY orders_id ASC";

Trying to export customer info to Excel: name, mailing address in full.

Tried to download a plugin, it`s not working.

Anyone?

Quote:

---

Originally Posted by lolo1

Trying to export customer info to Excel: name, mailing address in full.

Tried to download a plugin, it`s not working.

Anyone?

---

What plugin?

Quote:

---

Originally Posted by lolo1

Trying to export customer info to Excel: name, mailing address in full.

Tried to download a plugin, it`s not working.

Anyone?

---

What plugin?
How/where is it failing?

ZC 1.51 with several plugins and modified core files.

I have duplicate products names (items) but some are in a hidden category prefaced with a "H" for a special customer.
When I export orders I would like to parse the product names and strip the "H" from the front of certain items.
But not all of them.
EXAMPLE:

H10001 after export 10001
H10002 after export H10002
H10003 after export 10003
H10004 after export H10004
etc.

I've already made some mods to sort on product names in shipping_export.php but I could use some help on this one.

Thanks

Quote:

---

Originally Posted by lhungil

The Export Shipping & Orders Information module is not compatible with Zen Cart 1.5.3+. If one wishes to use this module in newer versions of Zen Cart, the module will need to be updated.


NOTE 1: In particular, this module uses direct "mysql_*" functions (mixed with $db method calls). Best practice is for Zen Cart plugins (modules) to only use $db methods for accessing the database. This provides better long term compatibility with Zen Cart (and future versions).

NOTE 2: Zen Cart 1.5.3+ no longer uses "mysql_*" functions (these functions were removed from upstream versions of PHP). Instead Zen Cart now uses the newer "mysqli_*" functions. This means modules using "mysql_*" functions and relying on Zen Cart to open a MySQL connection for the "mysql_*" functions (instead of only using $db) will fail in Zen Cart 1.5.3+.

---

Is there anyone out there who's prepared to upgrade this mod? My PHP skills are not adequate...

The "orders export" plugin might provide similar functionality? Though not updated as a plugin for 1.5.4, the support thread has an updated RC that has been working for me in 1.5.3 for a year & 1.5.4 since early July.

Quote:

---

Originally Posted by schoolboy

Is there anyone out there who's prepared to upgrade this mod? My PHP skills are not adequate...

---

I was the original author of the module. I can look at updating it to work with newer versions. Let me see what it would take to do that here.

Quote:

---

Originally Posted by econcepts

I was the original author of the module. I can look at updating it to work with newer versions. Let me see what it would take to do that here.

---

Please do! My monthly sales analysis is a nightmare without it!

So, uhm... I'm not sure if I'm missing something obvious here, but it took me 5 minutes to upgrade it and have it working with 1.5.4...

I'll submit it to the plugins in a few minutes since everything seems to be working fine on my test install. In the meantime, for those who can't wait for it to be approved, here's a direct link to the file on my server:
click here