Results 1 to 4 of 4
  1. #1
    Join Date
    Jun 2006
    Posts
    2
    Plugin Contributions
    0

    Default Report needed: List of customers who have purchased specific product

    Greetings folks:

    Newbie here, but one who has her store customized quite well and up and running. I've searched and searched for this, but not finding quite the answer I need.

    My store doesn't sell product - it sells advance tickets to events. I need to be able to generate a simple report that lists the customer names of all the people who have purchase a specific event ticket. This is for the registration folks at the event, who will tick off the name of the purchaser.

    I installed Sales report and that didn't quite do it. Then I took a look at SuperOrders and can't tell if it will or not, yet don't wish to install if it doesn't.

    Does anyone know of an easy way to do this that I'm missing? Or, if this has been covered in a previous thread and I'm just asking incorrectly, please be kind enough to send me in the right direction.

    Youre help is greatly appreciated!
    revmags

  2. #2
    Join Date
    Feb 2005
    Posts
    13
    Plugin Contributions
    0

    Default Re: Report needed: List of customers who have purchased specific product

    I needed the same function and the only way I was able to get what I needed is through the database using a function in Excel.

    I downloaded both the orders and customers tables in CSV for Excel format. WITH headers.

    Opened them in Excel and sorted the orders by product (products_name).

    Then I selected the order numbers for the specific product (orders_id) and copied them and pasted them into a new sheet in that workbook.

    Then, I entered the information I wanted in the top line of the new sheet (customers_name, customers_street, etc.) and ran a vlookup function in Excel. It looks up the information you want for each order number you pasted.

    It is a huge pain in the ######## and I had to do it quarterly since I sell subscriptions to a quarterly magazine.

    IF the databases would be able to combine products_id and customer_name it would be SO much easier, but there is no table that includes both values that I can find. I even tried doing a custom query but that didn't work either.

  3. #3
    Join Date
    Jul 2004
    Posts
    44
    Plugin Contributions
    0

    Default Re: Report needed: List of customers who have purchased specific product

    I've just solved it quickly:

    Your server must have a tool installed called phpMyadmin, you can enter from the control panel of your hosting company.

    You must enter the database associated with your zen cart store, click on the "SQL" button and type the following:

    ---------------

    SELECT *
    FROM `zen_orders_products`
    WHERE `products_name` LIKE 'Exact Product Name'
    LIMIT 0 , 30

    ----------------

    IMPORTANT: Replace "Exact Product Name" with the exact product name you have on your store, then Click OK.

    The second column in the results are the order ID, you can easily track those orders by hand in the panel.

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

    Default Re: Report needed: List of customers who have purchased specific product

    Thanks for that query -- simplified things a LOT -- so with this and an order ID / customer name query I should be able to merge the info to get my report... I will try that!

 

 

Similar Threads

  1. v139h Email to customers who have ordered a specific item?
    By thehomeopath in forum General Questions
    Replies: 0
    Last Post: 11 Sep 2012, 03:24 PM
  2. Coupon for customers who previously purchased a specific item
    By CKlemow in forum Discounts/Coupons, Gift Certificates, Newsletters, Ads
    Replies: 4
    Last Post: 29 Jun 2010, 08:32 AM
  3. Disable Specific Product from Customers who bought/selected also purchased...
    By dharma in forum Templates, Stylesheets, Page Layout
    Replies: 7
    Last Post: 25 Dec 2009, 07:18 PM
  4. Replies: 1
    Last Post: 3 Dec 2009, 10:21 PM
  5. emailing customers who have purchased..??? is it possible??
    By kitcorsa in forum General Questions
    Replies: 6
    Last Post: 29 Jul 2009, 02:29 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