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?

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?

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

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.

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.

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

The update has been approved and can be downloaded from the Plugins section. I'm removing it from my server so please use the official download section.

Excellent. Thanks. I'll take a look here. I have a version that a few have used (even more automated than the one on the site I believe) which has some nice features in it. I'll compare that with the 'newest' version here and merge any updates so users get those updates as well. Will compare the two soon.

Hi guys.

Loving the module... just a small question that has not been answered, CRON JOB. I know it is possible but i do not know how.I am using cron job for other modules and that works

I am using zen-cart 1.5.4 and i modified the php file so that some boxes are ticked/checked by default.

Any help would be very appreciated.

Greetings Kevin

Hi Kevin,

I've setup the CRON version of this for a number of stores. I have a totally separate file I wrote for that (as the current file has to many areas where it requires being run from the 'admin panel' directly.)

Have you made any updates to the current version you are using?

I can adjust this file and send it your way based on any adjustments you might have made or need.

Send me a private message and we can exchange details on how to get that file adjusted and sent your way.

Eric

Hi

Will this addon work with 1.5.5b and PHP7?

Thanks

Dene

econcepts:

Hi Kevin,

I've setup the CRON version of this for a number of stores. I have a totally separate file I wrote for that (as the current file has to many areas where it requires being run from the 'admin panel' directly.)

Have you made any updates to the current version you are using?

I can adjust this file and send it your way based on any adjustments you might have made or need.

Send me a private message and we can exchange details on how to get that file adjusted and sent your way.

Eric

Thank you Eric.

I have send you an PM...

Greetings

Kevin

Kevin,

Just replied to your email. Gave you the email to send your file to.

Thanks

Deno:

Hi

Will this addon work with 1.5.5b and PHP7?

Thanks

Dene

Hi Dene,

It should work (but may need a little modification.)

Are you looking for the CRON version or the native admin version?

Hello there,
Following on from Kevin, I am interested to learn about the cron edition of this module please.

Regards,
James

James, I'm working on a customized copy of the CRON edition for Kevin. What version are you using currently of the software?

Eric