Page 21 of 23 FirstFirst ... 111920212223 LastLast
Results 201 to 210 of 223
  1. #201
    Join Date
    Mar 2007
    Location
    Pepperell, Massachusetts
    Posts
    232
    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
    232
    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
    232
    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
    232
    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
    232
    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,509
    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
    495
    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
    495
    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
    495
    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 Users and Orders to Excel?
    By Crazy88 in forum Managing Customers and Orders
    Replies: 5
    Last Post: 20 Nov 2012, 08:24 AM
  2. Excel Spreadsheet
    By shutupplease in forum Setting Up Categories, Products, Attributes
    Replies: 1
    Last Post: 2 Jul 2009, 09:44 PM
  3. export orders to excel
    By pgu64 in forum Managing Customers and Orders
    Replies: 8
    Last Post: 5 Oct 2008, 02:15 PM
  4. Export orders to spreadsheet
    By thezbian in forum Managing Customers and Orders
    Replies: 3
    Last Post: 31 Dec 2006, 12:07 PM
  5. 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
  •  
disjunctive-egg
Zen-Cart, Internet Selling Services, Klamath Falls, OR