Results 1 to 4 of 4
  1. #1
    Join Date
    Apr 2013
    Location
    Los Angeles, CA
    Posts
    2
    Plugin Contributions
    0

    help question Excel Export of Customer Contact Details and Customer Order History?

    Im a newbie, so please forgive me if this already exists, but having searched through the forums for a few hours I was not able to find a reference to this requirement.
    I want to be able to download and export to Excel a set of data that is a join between the customer contact details and each customer's product order history. Iow, I want to produce a spreadsheet that has customer name followed by address, email, phone number, and then for that customer his/her product order/purchase history, product name/ID, product category, volume ordered/purchased, product order date, certain custom defined product fields.
    I would like to filter the download by customer name e.g. customer name =a* or customer name >=a* and <= lzzz*, as well as by order date. e.g all orders between 01012013 and 04012013

    Any advice or assistance will be greatly appreciated
    Zen Cart ver 1.2.5
    DB Patch Level 1.2.5
    MySQL 5.5.11
    PHP ver 5.2.17

  2. #2
    Join Date
    Mar 2013
    Posts
    95
    Plugin Contributions
    0

    Default Re: Excel Export of Customer Contact Details and Customer Order History?


  3. #3
    Join Date
    Nov 2007
    Location
    Sunny Coast, Australia
    Posts
    3,379
    Plugin Contributions
    9

    Default Re: Excel Export of Customer Contact Details and Customer Order History?

    Quote Originally Posted by denniszc View Post
    Doubtful this will work - the poster is running an outdated v.1.2.5

  4. #4
    Join Date
    Apr 2013
    Location
    Los Angeles, CA
    Posts
    2
    Plugin Contributions
    0

    Default Re: Excel Export of Customer Contact Details and Customer Order History?

    Thank you for the responses. I will be back once i've looked into the suggested plugin. Thank yu

 

 

Similar Threads

  1. v1.2.x Exporting All Customer and Order Details
    By mahanteshpa in forum Managing Customers and Orders
    Replies: 3
    Last Post: 12 May 2015, 02:52 AM
  2. Export Customer Details
    By Nick1973 in forum General Questions
    Replies: 4
    Last Post: 11 Dec 2010, 09:52 PM
  3. My Order History and Order History Details - how do I get order comments in both?
    By trisha1581 in forum Templates, Stylesheets, Page Layout
    Replies: 0
    Last Post: 29 Nov 2007, 06:37 PM
  4. Contact Form with customer's details
    By helpdbay in forum Managing Customers and Orders
    Replies: 1
    Last Post: 9 Aug 2006, 06:28 PM

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