Page 1 of 2 12 LastLast
Results 1 to 10 of 223

Hybrid View

  1. #1
    Join Date
    May 2006
    Posts
    134
    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
    Location
    Arizona
    Posts
    27,761
    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

  3. #3
    Join Date
    Dec 2005
    Posts
    1,509
    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
    134
    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,509
    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
    Oct 2006
    Posts
    64
    Plugin Contributions
    0

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

    Does this Mod have the ability to select a date range of orders to export?

    Thanks

    JON

  9. #9
    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 wapnoj View Post
    Does this Mod have the ability to select a date range of orders to export?

    Thanks

    JON
    The current version 1.2.2 does not. The next release won't either, but 1.2.4 will (2 releases from now). Unless I can squeeze it into 1.2.3 here (to be released shortly).
    Eric
    20 Ways to Increase Sales Using Zen Cart
    Zen Cart contribs: Simple Google Analytics, Export Shipping Information

  10. #10
    Join Date
    Oct 2006
    Posts
    64
    Plugin Contributions
    0

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

    Is there a possibility to have the tax exported into a column. The tax is include into the total, but it woulb great for ivoice reasons to have the tax in a seperate column.

    Having the attributes in seperate colmns would be awesome too.


    Thanks

    JON

 

 
Page 1 of 2 12 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