Page 11 of 23 FirstFirst ... 91011121321 ... LastLast
Results 101 to 110 of 223
  1. #101
    Join Date
    Dec 2005
    Posts
    1,509
    Plugin Contributions
    6

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

    Right now the product ID is not exported. Only the model etc.. I'll included that option within the next release which I am actively working on now. There have been enough requests for additional items that I moved the development of that release forward here.

    I hope to have it complete in the near future.

    I'll post to this board when ready.
    Eric
    20 Ways to Increase Sales Using Zen Cart
    Zen Cart contribs: Simple Google Analytics, Export Shipping Information

  2. #102
    Join Date
    May 2006
    Posts
    134
    Plugin Contributions
    0

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

    Thanks Eric,

    Appreciate your help :)

    Except I went in Admin to Tools > Install SQL Patches, I cut and paste this in the box:

    UPDATE orders SET downloaded_ship="no" WHERE downloaded_ship="yes"

    and clicked "SEND" and it comes back with FAILED

    Sorry but I don't know PHP or SQL so no clue what I would type for AND [add your other criteria here such as dates between etc...]. I tried a few thinngs but still "failed"
    I just need July 2006 - June 2007, but if I can just reset all orders to NO and export them all again that is more than fine!! I can then sort in excel

    Anyone know how I can correct that SQL statement above so it works and keep moving??

    Basically for those who didn't see my last post I want to export all my past orders again, this time with the full details, but since I have exported them before they don't appear ... pls help :)


    Quote Originally Posted by econcepts View Post
    The only way right now is to go into the ORDERS database and set the "downloaded_ship" field in each record you want to re-export to "no".

    This will make them show once again when you visit the "export shipping" page in your admin.

    To speed up this process, you could write an SQL script that looks something like this and run it form within your admin.

    UPDATE orders SET downloaded_ship="no" WHERE downloaded_ship="yes" AND [add your other criteria here such as dates between etc...]


    Hope that helps. :)

    Now, would you get some sleep already!
    ApeShop.com - Mobile Cell Phones, Digital Cameras, Camcorders, Lenses, iPods, PSPs, Watches & more!
    http://www.apeshop.com/

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

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

    Instead of that SQL, try this one. The quotes needed to be reworked.

    UPDATE orders SET downloaded_ship='no' WHERE downloaded_ship='yes';

    If you want to export just the orders between July 2006 and June 2007 then try something like the following:

    UPDATE orders SET downloaded_ship='no' WHERE date_purchased >= '2006-07-01 00:00:00' AND date_purchased <= '2007-07-01 00:00:00' AND downloaded_ship='yes';
    Eric
    20 Ways to Increase Sales Using Zen Cart
    Zen Cart contribs: Simple Google Analytics, Export Shipping Information

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

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

    any update on a new release? specifically quoting bug fixes and the ability to clear the exported flag?

  5. #105
    Join Date
    Sep 2006
    Posts
    122
    Plugin Contributions
    0

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

    Hi,

    A+ contrib. Thank you very much!

    Any chance you can add a option to download payment type chosen aswell? :)

    Thanks again
    Gavin
    Hi,

    Yes that is correct. Basically I download paypal csv accounts aswell.

    I need to know which payments are with paypal so that dont re-enter the same info twice when combining the two together.

    The reason I need the paypal sheet aswell is because I make sales on eBay aswell.

    So if I can see what payment type they are I can delete those ones that are paid by paypal without having to compare with paypal one by one.

    A HUGE time saver :)

    This later release coming anytime soon?

    Best wishes,
    Gavin
    Hi,

    Just wanted to remind you to include the above in the new relese if possible. Really would appreciate it. Thanks alot, is it coming out any time soon
    This is my Signature: w00t

  6. #106
    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
    any update on a new release? specifically quoting bug fixes and the ability to clear the exported flag?
    Getting real close I'm hoping within the next 2 weeks to have it ready for release.
    Eric
    20 Ways to Increase Sales Using Zen Cart
    Zen Cart contribs: Simple Google Analytics, Export Shipping Information

  7. #107
    Join Date
    Nov 2007
    Posts
    7
    Plugin Contributions
    0

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

    Eric,

    Thanks for this contribution! I am new to Zen Cart and I like all of the help these forums offer.

    I am setting up a new cart for event registrations. Because the product is virtual there is no shipping address needed. Is there any easy way to copy the customer information to the shipping fields so it will download? Would it just be easier to modify the shipping_export file to pull from other fields in the database?

  8. #108
    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 econcepts View Post
    Getting real close I'm hoping within the next 2 weeks to have it ready for release.
    Thanks, I appreicate it!

  9. #109
    Join Date
    May 2006
    Posts
    134
    Plugin Contributions
    0

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

    Thanks Eric you're a champ! This worked like a charm and is very handy when sometimes I export orders without all the fields I need and then need to reset them to export again

    Just hanging out eagerly for the next release of Export Orders, atm cutting and pasting company name so just if that field is fixed will be a lifesaver

    cheers,
    Dave

    Quote Originally Posted by econcepts View Post
    Instead of that SQL, try this one. The quotes needed to be reworked.

    UPDATE orders SET downloaded_ship='no' WHERE downloaded_ship='yes';

    If you want to export just the orders between July 2006 and June 2007 then try something like the following:

    UPDATE orders SET downloaded_ship='no' WHERE date_purchased >= '2006-07-01 00:00:00' AND date_purchased <= '2007-07-01 00:00:00' AND downloaded_ship='yes';
    ApeShop.com - Mobile Cell Phones, Digital Cameras, Camcorders, Lenses, iPods, PSPs, Watches & more!
    http://www.apeshop.com/

  10. #110
    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 econcepts View Post
    UPDATE orders SET downloaded_ship='no' WHERE downloaded_ship='yes';
    Curious, why the "WHERE" clause? Can I leave it out?

 

 
Page 11 of 23 FirstFirst ... 91011121321 ... 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