Back on 16-Nov-2007 I posted the fix for the comment field: replace [FONT=Courier New]"\r\n" with [/FONT][FONT=Courier New]array("\r\n","\r","\n")[/FONT]Quote:
Originally Posted by dhcernese
Printable View
Back on 16-Nov-2007 I posted the fix for the comment field: replace [FONT=Courier New]"\r\n" with [/FONT][FONT=Courier New]array("\r\n","\r","\n")[/FONT]Quote:
Originally Posted by dhcernese
Also, you can't use "nl2br()" later for cleaning product attribute values.. ..it does not remove newlines unlike the function name implies.Quote:
Originally Posted by dhcernese
Another bug: your code marks all orders downloaded even if they were not included in the date range and not downloaded. :(
For your reference, see my copy with all my edits (except for fixing the fact that it sets all orders downloaded).
Hi,
Just a question, this shipping export zip file contain only one PHP file. Should we install before the shipping export module first ?
Pascal.
My changes were meant for the author primarily-- however you are free to use them, after installing the base module, just replace the one file.Quote:
Originally Posted by fe1lho
Been out of the office here and just getting back in. Wow. Thanks for spear heading this. I'm reading through your previous posts here and going to dload your file. Will add credit in the readme etc... for you!Quote:
Originally Posted by dhcernese
sorry to dig up the past, just downloaded and order exporter from downloads section, i thought this would include price paid for the items???
what code would i need to add to "admin>ordersExport.php" for this to show the EXC tax price???Quote:
Originally Posted by spid3r1987
ignore comment above, found the table and what info i need to put in :DQuote:
Originally Posted by spid3r1987
brings up the info i need now :D
Thanks for keeping this up-to-date. I'm looking forward to messing with it.Quote:
Originally Posted by econcepts
Naive question: is this essentially a much more robust version of Orders Exporter?
THANKS AGAIN!
There is actually a 1.3.1 version now out (at the same link posted previously) which addresses a few bugs the 1.3.0 version had. Will post that officially to the Zen Downloads section after I see how it fairs with those using it.Quote:
Originally Posted by IdeaShop
I don't know how the Orders Exporter works to be honest (never used it) so I don't know if it is a more robust version. I saw that the orders exporter is based off of Easy Populate so that may be a little different (mine was basically written years ago from scratch for the most part.)
Once this mod is up and running, could the csv file be automatically generated using a cron job?
Thanks!
what are the chances there is an update for the 1.3.9h version??? I could really use a mod like this.
Thanks
With a number of adjustments (and a new file ready for cron) yes. I have built this custom type of job for a number of users. If interested, send me a private message and we can go over details etc...Quote:
Originally Posted by Danielle
I've customized it for number of people where it not only runs the cron job, but emails (or even FTP's) the completed file to the supplier for fulfillment.
This should work on all version of Zen cart just fine. I'm running it on a few 1.3.9h installs with no issues.Quote:
Originally Posted by evaudio
How hard would it be to split my attributes into separate columns? I am using flexible attributes and I am running up to 13 attributes for some products.
This looks like a great tool and I will use it to import to my sage peachtree accounting package.
I have installed it and did my 1st 'test mode' export and had the check box for ISO Country Code (2 Character) checked and received this error.
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 (zen_orders o LEFT JOIN zen_orders_products op ON o.orders_id = op.orders_id), zen_orders_total ot, zen_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.
Unchecking the ISO Country Code (2 Character) option
runs fine.
BowEquipped.com
ver 1.3.9.f
Any ideas what i did wrong?
Quote:
Originally Posted by econcepts
Is there a way to export the State names in Abbreviations instead of the full name?
Just installed the latest version in 1.5 store but I get nothing in my tools menu. Tried in different browsers too. I do have the "orders export" add-on installed, could that mess things up? All files uploaded and confirmed and ran the sql with no problem, any ideas?
Hi,
Is it possible to have this work with Amazon Fulfillment? I'm looking to have a mod where you select check boxes or something like that and click export and it exports orders in a format that can be uploaded to Amazon (without needing any extra tweaking) as they will be fulfilling my orders.
Basically download and upload to amazon exactly in the format that Amazon will accept.
Thanks in advance!
Hello econcepts.
How can I get this mod you have developed? I have a client that needs this exact functionality!
Thanks!
can the exported file be imported into sage, I have tried the mod sage line integration but does not work, does anyone know if this can be done with this mod.
cheers