Results 1 to 4 of 4
  1. #1
    Join Date
    Dec 2006
    Posts
    7
    Plugin Contributions
    0

    help question Export orders to spreadsheet

    How do i export my orders into a excel spreadsheet?

    all the order programs put each order on a new page . i just need to print outa long list of what ppl ordered and where they live so my delivery gu can run aaround and send em.

    any ideas?

    Thank you to anyone who can help

    --
    Ronald Cummings-John

  2. #2
    Join Date
    Mar 2006
    Location
    Australia
    Posts
    289
    Plugin Contributions
    3

    Default Re: Export orders to spreadsheet

    Hi there
    Sounds to me like it would be easiest if you use phpmyadmin and run a sql query and then export it as a csv or spreadsheet file and open it with your spreadsheet program.

  3. #3
    Join Date
    Mar 2006
    Location
    Australia
    Posts
    289
    Plugin Contributions
    3

    Default Re: Export orders to spreadsheet

    sorry. might need to be a bit more specific. Run this SQL statements (adjust dates to suit yourself):
    select zen_orders_total.orders_id, zen_orders_total.text
    from zen_orders_total, zen_orders
    where zen_orders.orders_id = zen_orders_total.orders_id and zen_orders_total.class = 'ot_total' and zen_orders.date_purchased >= '2006-08-14' and zen_orders.date_purchased <= '2006-08-20'

  4. #4
    Join Date
    Dec 2006
    Posts
    7
    Plugin Contributions
    0

    Default Re: Export orders to spreadsheet

    thank you for your help

 

 

Similar Threads

  1. v139h with Orders Exporter can I export only recent orders?
    By kbrown in forum All Other Contributions/Addons
    Replies: 3
    Last Post: 29 Sep 2012, 02:39 PM
  2. Export orders to Spreadsheet / Excel to email to suppliers
    By apemusic in forum Managing Customers and Orders
    Replies: 222
    Last Post: 31 Aug 2012, 05:22 PM
  3. spreadsheet import export populate product category
    By Factorycycle in forum All Other Contributions/Addons
    Replies: 4
    Last Post: 18 Jun 2011, 08:04 AM
  4. Exporting orders to a spreadsheet
    By pace in forum General Questions
    Replies: 4
    Last Post: 15 Jul 2010, 03:49 PM
  5. export sales data to spreadsheet?
    By tjthecat3 in forum General Questions
    Replies: 1
    Last Post: 5 Apr 2007, 03:40 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