Page 1 of 23 12311 ... LastLast
Results 1 to 10 of 223
  1. #1
    Join Date
    May 2006
    Posts
    136
    Plugin Contributions
    0

    help question Export orders to Spreadsheet / Excel to email to suppliers

    Hi Zenners,

    Every time a customer places an order I have to fill out an order form in Excel and email it to my suppliers, the order form has fields like this below.

    Surely it is possible for Zen-Cart to export certain orders into Excel? At the moment for every single order every day I am cutting and pasting into each field, there has to be a better way to export into Excel with these fields:

    Name:
    Company:
    Address 1 :
    Address 2 :
    City :
    State :
    Zip Code :
    Country :
    Telephone:

    Product Ordered:
    Qty:

    I need to do this every day so ideally I could just put a checkbox next to several orders and have those exported?

    cheers,
    Dave

    P.S. I see this thread: http://www.zen-cart.com/forum/showthread.php?t=54399
    However how do you run an SQL query like that? Does that mean I have to login to my GoDaddy MySQL admin every day to do this? Still not sure how to run those SQL statements.

    A button within Zen-Cart I could check and export would be great? Even better if I can tick and select certain orders only??

  2. #2
    Join Date
    Aug 2005
    Posts
    26,425
    Plugin Contributions
    9

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

    I would venture to guess that very few shop owners need or require orders to be in excel format...
    So you are probably on your own obtaining this function and making it available in the admin

    This could be a form of the order notification mail...but you need this in excel so a mysql export of the relavent order tables would be in order as a csv that you can then open in excel. Once you get this worked out you could then cron this to happen at some time each day...

    Too bad you are with GoDaddy!!!
    Zen-Venom Get Bitten
    Get Your Business Found

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

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

    Surely it is possible for Zen-Cart to export certain orders into Excel? At the moment for every single order every day I am cutting and pasting into each field, there has to be a better way to export into Excel with these fields:

    Name:
    Company:
    Address 1 :
    Address 2 :
    City :
    State :
    Zip Code :
    Country :
    Telephone:

    Product Ordered:
    Qty:

    I need to do this every day so ideally I could just put a checkbox next to several orders and have those exported?
    I've got a mod I created to export ORDERS directly into Excel format (with the info you need here and more) that I used to integrate with UPS automatic shipping, scale (weight) and label printing for bulk orders.

    Let me dig that out here and I'll send it over to you to download. It was accessible from the Tools Menu under the Admin.

    Hang on a day or so. I'll get the files needed for it together.

    It should do exactly what you want -- or need very little modification to get it to only include the fields you need. In mine, I had to include weight of the order etc.. as well as the shipping location.
    Last edited by econcepts; 14 May 2007 at 04:08 AM. Reason: Additional info added
    Eric
    20 Ways to Increase Sales Using Zen Cart
    Zen Cart contribs: Simple Google Analytics, Export Shipping Information

  4. #4
    Join Date
    May 2006
    Posts
    136
    Plugin Contributions
    0

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

    Thanks econcepts! That module you are talking about sounds awesome I can't wait to check it out ...

    Thanks Kobra as well, Godaddy seems fine though? Just now sure how exactly you export things and cron job though

  5. #5
    Join Date
    Nov 2005
    Posts
    9
    Plugin Contributions
    0

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

    hey econcepts

    sounds like you have just what i need to link with our shipping people, would it be ok if you could let me have the export module you have

    thanks buddy :)

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

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

    Quote Originally Posted by studmuffin View Post
    hey econcepts

    sounds like you have just what i need to link with our shipping people, would it be ok if you could let me have the export module you have

    thanks buddy :)
    I sent it over in a PM to you a few days ago. Check your Private Message box. It should be there.
    Eric
    20 Ways to Increase Sales Using Zen Cart
    Zen Cart contribs: Simple Google Analytics, Export Shipping Information

  7. #7
    Join Date
    May 2007
    Posts
    1
    Plugin Contributions
    0

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

    Hi econcepts.

    I was just finding that kind of mod you made.

    Can I use your mod too?

  8. #8
    Join Date
    Dec 2005
    Posts
    1,474
    Plugin Contributions
    6

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

    Quote Originally Posted by noa View Post
    Hi econcepts.

    I was just finding that kind of mod you made.

    Can I use your mod too?
    Not a problem. I didn't realize that so many users were looking for it. Let me put together an "official" contribution and I'll upload to the Zen site as well as send you a copy.

    If you are versed in PHP, I could send you my altered file and you could mess with it to get it to do what you need. Just let me know.
    Eric
    20 Ways to Increase Sales Using Zen Cart
    Zen Cart contribs: Simple Google Analytics, Export Shipping Information

  9. #9
    Join Date
    May 2007
    Location
    Tulsa, OK
    Posts
    15
    Plugin Contributions
    0

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

    I also need a mod like this ... I need to export order information in csv for my stamps.com program ... can I have the mod too? please?
    -Much Love, Jessica :)
    -My Blog - MYSPACE - jesstankersley######################
    -Make a small loan, Make a big difference - Kiva.org

  10. #10
    Join Date
    Dec 2005
    Posts
    1,474
    Plugin Contributions
    6

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

    Quote Originally Posted by jessiebags View Post
    I also need a mod like this ... I need to export order information in csv for my stamps.com program ... can I have the mod too? please?
    Yes, I am finishing up a full package to upload to the forums here. I didn't realize there was such a demand. It should be available in the coming days.
    Eric
    20 Ways to Increase Sales Using Zen Cart
    Zen Cart contribs: Simple Google Analytics, Export Shipping Information

 

 
Page 1 of 23 12311 ... 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
  •