Page 21 of 23 FirstFirst ... 111920212223 LastLast
Results 201 to 210 of 223
  1. #201
    Join Date
    Mar 2007
    Location
    Pepperell, Massachusetts
    Posts
    233
    Plugin Contributions
    1

    Default Re: Export orders to Spreadsheet / Excel to email to suppliers

    Quote Originally Posted by dhcernese View Post
    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]

  2. #202
    Join Date
    Mar 2007
    Location
    Pepperell, Massachusetts
    Posts
    233
    Plugin Contributions
    1

    Default Re: Export orders to Spreadsheet / Excel to email to suppliers

    Quote Originally Posted by dhcernese View Post
    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.

  3. #203
    Join Date
    Mar 2007
    Location
    Pepperell, Massachusetts
    Posts
    233
    Plugin Contributions
    1

    Default 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.

  4. #204
    Join Date
    Mar 2007
    Location
    Pepperell, Massachusetts
    Posts
    233
    Plugin Contributions
    1

    Default 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).
    Attached Files Attached Files

  5. #205
    Join Date
    Apr 2010
    Posts
    74
    Plugin Contributions
    0

    help question 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.

  6. #206
    Join Date
    Mar 2007
    Location
    Pepperell, Massachusetts
    Posts
    233
    Plugin Contributions
    1

    Default Re: Export orders to Spreadsheet / Excel to email to suppliers

    Quote Originally Posted by fe1lho View Post
    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.

  7. #207
    Join Date
    Dec 2005
    Posts
    1,440
    Plugin Contributions
    6

    Default Re: Export orders to Spreadsheet / Excel to email to suppliers

    Quote Originally Posted by dhcernese View Post
    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!
    Eric
    20 Ways to Increase Sales Using Zen Cart
    Zen Cart contribs: Simple Google Analytics, Export Shipping Information

  8. #208
    Join Date
    Jul 2009
    Posts
    468
    Plugin Contributions
    0

    Default 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???
    i may not know how yet, but i soon will....i hope :)

  9. #209
    Join Date
    Jul 2009
    Posts
    468
    Plugin Contributions
    0

    Default Re: Export orders to Spreadsheet / Excel to email to suppliers

    Quote Originally Posted by spid3r1987 View Post
    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???
    i may not know how yet, but i soon will....i hope :)

  10. #210
    Join Date
    Jul 2009
    Posts
    468
    Plugin Contributions
    0

    Default Re: Export orders to Spreadsheet / Excel to email to suppliers

    Quote Originally Posted by spid3r1987 View Post
    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
    brings up the info i need now
    i may not know how yet, but i soon will....i hope :)

 

 
Page 21 of 23 FirstFirst ... 111920212223 LastLast

Similar Threads

  1. export sales data to spreadsheet?
    By tjthecat3 in forum General Questions
    Replies: 1
    Last Post: 5 Apr 2007, 03:40 AM
  2. missing email addr. in confirm acct. creation
    By Sunabac in forum General Questions
    Replies: 0
    Last Post: 6 Feb 2007, 03:47 AM
  3. Export orders
    By fparadise in forum Managing Customers and Orders
    Replies: 2
    Last Post: 1 Feb 2007, 12:37 AM
  4. Is it possible to download customer list to excel spreadsheet?
    By bcbailey in forum Managing Customers and Orders
    Replies: 1
    Last Post: 11 Jun 2006, 10:03 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •