Re: Export orders to Spreadsheet / Excel to email to suppliers
Quote:
Originally Posted by
dhcernese
fyi -- the last history comment can have newlines in it and the attributes can have ^M^J in them, neither are cleaned.
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]
Re: Export orders to Spreadsheet / Excel to email to suppliers
Quote:
Originally Posted by
dhcernese
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]
Also, you can't use "nl2br()" later for cleaning product attribute values.. ..it does not remove newlines unlike the function name implies.
Re: Export orders to Spreadsheet / Excel to email to suppliers
Another bug: your code marks all orders downloaded even if they were not included in the date range and not downloaded. :(
1 Attachment(s)
Re: Export orders to Spreadsheet / Excel to email to suppliers
For your reference, see my copy with all my edits (except for fixing the fact that it sets all orders downloaded).
Re: Export orders to Spreadsheet / Excel to email to suppliers
Hi,
Just a question, this shipping export zip file contain only one PHP file. Should we install before the shipping export module first ?
Pascal.
Re: Export orders to Spreadsheet / Excel to email to suppliers
Quote:
Originally Posted by
fe1lho
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.
Re: Export orders to Spreadsheet / Excel to email to suppliers
Quote:
Originally Posted by
dhcernese
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.
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!
Re: Export orders to Spreadsheet / Excel to email to suppliers
sorry to dig up the past, just downloaded and order exporter from downloads section, i thought this would include price paid for the items???
Re: Export orders to Spreadsheet / Excel to email to suppliers
Quote:
Originally Posted by
spid3r1987
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???
Re: Export orders to Spreadsheet / Excel to email to suppliers
Quote:
Originally Posted by
spid3r1987
what code would i need to add to "admin>ordersExport.php" for this to show the EXC tax price???
ignore comment above, found the table and what info i need to put in :D
brings up the info i need now :D