Page 20 of 23 FirstFirst ... 101819202122 ... LastLast
Results 191 to 200 of 223
  1. #191
    Join Date
    Dec 2005
    Posts
    1,509
    Plugin Contributions
    6

    Default Re: Export orders Version 1.3.0 Released.

    Ok, here is the direct link to the page you can download this new 1.3.0 version from if you don't want to wait for it to be activated in the Zen Cart downloads section (it has been submitted ... just waiting for the Zen Cart team to activate it.)

    http://www.zencartoptimization.com/downloads/

    Here are the changes and updates you'll find in the 1.3.0 version:


    1) Added ability to have the exported file either downloaded to your computer or automatically sent to a desired email address. This is nice for automating the sending of orders to suppliers for fulfillment (as in the case of those using zen cart to drop ship).

    2) Added ability to automatically update the order status after a successful export. Status can be updated to what ever you choose (from dropdown).

    3) Added ability to include header row or leave it out of your exported file.

    4) Added the ability to export different file types. (CSV / TXT)

    5) Bugfix: REMOVED the option to export manufacturing data as it was causing problems. (This will be added in the next release after worked on a bit.)

    6) Bugfix: Corrected issues with Company Name not showing up in export.

    7) Bugfix: Corrected issue with some people getting a header row but no orders exported.

    8) Moved product details field data to the end of the export again. After recent additions to new fields the product details were showing up in the middle of the exported file and this could throw off columns if exporting 1 order per line on mixed orders with attributes and without.
    Last edited by econcepts; 14 May 2010 at 05:14 PM. Reason: added bold text for ease of reading
    Eric
    20 Ways to Increase Sales Using Zen Cart
    Zen Cart contribs: Simple Google Analytics, Export Shipping Information

  2. #192
    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 riolas View Post
    I would like to export:

    products

    total sale price

    delivery method

    name/company address


    into .doc file. Is this possible?
    A number of things are needed for this to happen. Got your private message and am responding to that to figure out what might be able to be done (and present options available to you that you might want to consider which are already built into native zen cart.)
    Eric
    20 Ways to Increase Sales Using Zen Cart
    Zen Cart contribs: Simple Google Analytics, Export Shipping Information

  3. #193
    Join Date
    Oct 2009
    Posts
    66
    Plugin Contributions
    0

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

    Great. Let me know as soon as you can.

  4. #194
    Join Date
    Mar 2007
    Location
    Pepperell, Massachusetts
    Posts
    232
    Plugin Contributions
    1

    Default Re: Export orders Version 1.3.0 Released.

    Quote Originally Posted by econcepts View Post
    Here are the changes and updates you'll find in the 1.3.0 version:



    7) Bugfix: Corrected issue with some people getting a header row but no orders exported.
    I installed 1.3.0 into my 1.3.8a store-- I've become one of those people with no exports! I tried all sorts of combinations, everything I could think of. I cannot get it to export anything, I am rolling back once again to 1.2.2 !

  5. #195
    Join Date
    Mar 2007
    Location
    Pepperell, Massachusetts
    Posts
    232
    Plugin Contributions
    1

    Default Re: Export orders Version 1.3.0 Released.

    Quote Originally Posted by dhcernese View Post
    I installed 1.3.0 into my 1.3.8a store-- I've become one of those people with no exports! I tried all sorts of combinations, everything I could think of. I cannot get it to export anything, I am rolling back once again to 1.2.2 !
    ...it does successfully set all the orders downloaded_ship = "yes"

  6. #196
    Join Date
    Mar 2007
    Location
    Pepperell, Massachusetts
    Posts
    232
    Plugin Contributions
    1

    Default Re: Export orders Version 1.3.0 Released.

    Quote Originally Posted by dhcernese View Post
    ...it does successfully set all the orders downloaded_ship = "yes"
    I'm reading the code and I can't see how it could ever work!

    Specifically, it no longer echos $str_export inside the loop. It only writes a single record to either to be emailed or the download.

    So I change it to clear the $str_export before the loop and inside the loop begin $str_export construction with .=

    Now it outputs orders (but only in 1 order per row mode)

    You got same major bugs dude, maybe you uploaded the wrong version??
    Last edited by dhcernese; 22 May 2010 at 01:44 AM.

  7. #197
    Join Date
    Mar 2007
    Location
    Pepperell, Massachusetts
    Posts
    232
    Plugin Contributions
    1

    Default Re: Export orders Version 1.3.0 Released.

    Quote Originally Posted by dhcernese View Post
    I'm reading the code and I can't see how it could ever work!

    Specifically, it no longer echos $str_export inside the loop. It only writes a single record to either to be emailed or the download.

    So I change it to clear the $str_export before the loop and inside the loop begin $str_export construction with .=

    Now it outputs orders (but only in 1 order per row mode)

    You got same major bugs dude, maybe you uploaded the wrong version??
    I debugged a little further, I need 1 order per product-- if I try that it outputs every order 240 times!
    Last edited by dhcernese; 22 May 2010 at 01:56 AM.

  8. #198
    Join Date
    Mar 2007
    Location
    Pepperell, Massachusetts
    Posts
    232
    Plugin Contributions
    1

    Default Re: Export orders Version 1.3.0 Released.

    Quote Originally Posted by dhcernese View Post
    I debugged a little further, I need 1 order per product-- if I try that it outputs every order 240 times!
    I forgot to mention: in order to get this to work at all for my order, I had to rename the ACCOUNT_STATE variable (and just to be safe, I commented out the devliery_country stuff).. ..that indicates to me that your ACCOUNT_STATE code is not going to work for me.

  9. #199
    Join Date
    Mar 2007
    Location
    Pepperell, Massachusetts
    Posts
    232
    Plugin Contributions
    1

    Default Re: Export orders Version 1.3.0 Released.

    Quote Originally Posted by dhcernese View Post
    I forgot to mention: in order to get this to work at all for my order, I had to rename the ACCOUNT_STATE variable (and just to be safe, I commented out the devliery_country stuff).. ..that indicates to me that your ACCOUNT_STATE code is not going to work for me.
    I commented out all the country code stuff and now even 1 product per row works (and no multiplier by 240, which might have something to do with the number of countries?).

  10. #200
    Join Date
    Mar 2007
    Location
    Pepperell, Massachusetts
    Posts
    232
    Plugin Contributions
    1

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

    fyi -- the last history comment can have newlines in it and the attributes can have ^M^J in them, neither are cleaned.

 

 
Page 20 of 23 FirstFirst ... 101819202122 ... 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