Page 4 of 23 FirstFirst ... 2345614 ... LastLast
Results 31 to 40 of 223
  1. #31
    Join Date
    Dec 2005
    Posts
    1,509
    Plugin Contributions
    6

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

    Yeah, I'm just about there. Hoping to have it in the next few days at the latest.

    This one is far better than the first. Since each user has different requirements, but all need the shipping address, etc.., I made it possible in this new version for you to actually select which "additional fields" you want included in the export file.

    I also included a few other "bonus features" as well.

    I have it running successfully on my test system. A screenshot of the newest version (to be released soon) is attached for reference.

    Consider it a "sneak peak".
    Attached Images Attached Images  
    Eric
    20 Ways to Increase Sales Using Zen Cart
    Zen Cart contribs: Simple Google Analytics, Export Shipping Information

  2. #32
    Join Date
    May 2007
    Posts
    47
    Plugin Contributions
    0

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

    ...sweet...
    Zack Coffman
    Producer/Director of Choppertown and Brittown

  3. #33
    Join Date
    Oct 2006
    Posts
    109
    Plugin Contributions
    0

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

    This looks wonderful. Thank you much!

  4. #34
    Join Date
    Jun 2007
    Posts
    27
    Plugin Contributions
    0

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

    This is just what I need, can I test the beta release please?

  5. #35
    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 andes View Post
    This is just what I need, can I test the beta release please?
    Everybody is going to get to "test it" in the next day or so. I have one bug that just arose and am working that out. After that is out of the way, I think it's good to go.

    I'll post here when it is ready, and upload to the Contributions section (updating the previous version 1.0.0 I initially released).
    Eric
    20 Ways to Increase Sales Using Zen Cart
    Zen Cart contribs: Simple Google Analytics, Export Shipping Information

  6. #36
    Join Date
    Dec 2005
    Posts
    1,509
    Plugin Contributions
    6

    Default Export Orders to Excel - New Version 1.2.0 Ready!

    OK Everyone.

    The new version of the Export shipping module is ready to go.

    I uploaded to the contributions section here at Zen tonight (as an update to the previous version). I anticipate that being available and active within the next few days (sometimes they are faster with approving mods).

    For those of you that want it now and can't wait, here is the link to a little more information on it:
    http://www.zencartoptimization.com/2...-contribution/

    And here is the link to my downloads page where you can get it (version 1.2.0) before it hits the "Zen Contributions" section.

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

    This new version covers a lot of what users were asking for. There may be more to come in future releases. I think we're pretty close now though to the requested "wish list" you all provided.
    Eric
    20 Ways to Increase Sales Using Zen Cart
    Zen Cart contribs: Simple Google Analytics, Export Shipping Information

  7. #37
    Join Date
    May 2007
    Posts
    47
    Plugin Contributions
    0

    Default Re: Export Orders to Excel - New Version 1.2.0 Ready!

    great contribution! just a couple of things, wondered how easy or difficult to fix:

    1. when a customer has purchased multiple products, every product appears on that line and then that line is repeated; is it possible to repeat the lines, but have each product appear in a single "product ordered" column? this would make it much easier to create tables and organize the data by type of item ordered etc.

    2. is it possible to automatically have the field names included at the top of the spreadsheet? (in case it needs to be imported into a shipping program, it helps to have the headings).

    3. foreign orders are causing the columns to go out of alignment (could be a setting in my excel? or maybe a blank space needs to be inserted in the u.s. orders to make it line up right?)

    great work!
    Zack Coffman
    Producer/Director of Choppertown and Brittown

  8. #38
    Join Date
    May 2007
    Posts
    47
    Plugin Contributions
    0

    Default Re: Export Orders to Excel - New Version 1.2.0 Ready!

    sorry...had some clearer ideas...but my editing time passed...

    here's a better idea of what i meant...


    1. it seems that orders are getting repeated; not sure why, it doesn't happen to every order...but most of them.

    2. when a customer has purchased multiple products, currently every product appears on that line. is it possible to repeat the lines and have each product appear in a single "product ordered" column? (bonus: include each item's price as well for a quick daily revenue count)... this would make it much easier to create tables and organize the data by type of item ordered etc. and be easier to pick and pack.

    3. is it possible to automatically have the field names included at the top of the spreadsheet? (in case it needs to be imported into a shipping program, it helps to have the headings).

    4. foreign orders are causing the columns to go out of alignment due to address line 1, 2, 3. is it possible to fix the address section to include all the possible address fields? (this would align everything)
    Zack Coffman
    Producer/Director of Choppertown and Brittown

  9. #39
    Join Date
    Dec 2005
    Posts
    1,509
    Plugin Contributions
    6

    Default Re: Export Orders to Excel - New Version 1.2.0 Ready!

    Quote Originally Posted by OneWorldStudios View Post
    sorry...had some clearer ideas...but my editing time passed...

    here's a better idea of what i meant...


    1. it seems that orders are getting repeated; not sure why, it doesn't happen to every order...but most of them.

    2. when a customer has purchased multiple products, currently every product appears on that line. is it possible to repeat the lines and have each product appear in a single "product ordered" column? (bonus: include each item's price as well for a quick daily revenue count)... this would make it much easier to create tables and organize the data by type of item ordered etc. and be easier to pick and pack.

    3. is it possible to automatically have the field names included at the top of the spreadsheet? (in case it needs to be imported into a shipping program, it helps to have the headings).

    4. foreign orders are causing the columns to go out of alignment due to address line 1, 2, 3. is it possible to fix the address section to include all the possible address fields? (this would align everything)
    See if I can cover some things here for you.

    1) I know why this "could" happen (it happened during testing once and I thought is was corrected). To diagnose, can you spot a "pattern" of when it happens? (Like when 3 products are added, like when there are multiple attributes, etc...)

    2) Actually, my personal preference is to include EACH order per LINE instead of "each order per column" as it is now. However, so many people asked for it the way it is now, I figured that was the "safest bet". I'll work on another version here in the coming weeks once I get some more feedback. In that version I will attempt to give you the option of printing out "1 product per row" or "multiple products per row (as it is now).

    As for the product pricing, that is not a problem to add. Pretty easy there.


    3) Yes, and no. I had the headers in the original version, but due to the way people wanted the export to happen (different length records), it was hard to create a "standard header row". My plan was in the next version to figure out a way around that and provide header info as well.


    4) Can you send me an example of an address (foreign) and using FAKE info (but in the same format as it comes across to you) so I can look at that.

    Thanks!
    Eric
    20 Ways to Increase Sales Using Zen Cart
    Zen Cart contribs: Simple Google Analytics, Export Shipping Information

  10. #40
    Join Date
    Oct 2006
    Posts
    109
    Plugin Contributions
    0

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

    I'm so excited - thank you so much for this add!!

    Question - I did my first export and I selected to open the file instead of save it. It said the file could not be read, and the file size is 0.
    This could very well be because I selected Open and not Save - I've encountered that problem before - so it may not even have anything to do with your module.

    However, I can't try again with the Save option to see if I can export successfully because it thinks I've already exported everything, so there are no records to export.

    Is there a workaround for this -- to re-export items that it thinks I've already exported?

    Thanks!

 

 
Page 4 of 23 FirstFirst ... 2345614 ... 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