cgutzmer Posted January 27, 2009 Share Posted January 27, 2009 Hello all! I have been searching for a while (granted I am not very good at searching) for a way to find all customers that purchased a specific item. It seems like it shouldnt be too hard to do but I cant for the life of me figure it out! I know I can do the product notification (which I did) but it only went to 5 of the 9 people that purchased the product. Its important to notify the others because without this update their product wont work as intended! Let me know if I am missing the obvious :) Thanks! Chris Chris Gutzmer Link to comment Share on other sites More sharing options...
satish Posted January 27, 2009 Share Posted January 27, 2009 A proper sql query will do. Satish Ask/Skype for Free osCommerce value addon/SEO suggestion tips for your site. Check My About US For who am I and what My company does. Link to comment Share on other sites More sharing options...
cgutzmer Posted January 27, 2009 Author Share Posted January 27, 2009 except I have no experience with that and would prefer to not mess around with the databases.... ;) Chris Gutzmer Link to comment Share on other sites More sharing options...
NodsDorf Posted January 27, 2009 Share Posted January 27, 2009 Hello all!I have been searching for a while (granted I am not very good at searching) for a way to find all customers that purchased a specific item. It seems like it shouldnt be too hard to do but I cant for the life of me figure it out! I know I can do the product notification (which I did) but it only went to 5 of the 9 people that purchased the product. Its important to notify the others because without this update their product wont work as intended! Let me know if I am missing the obvious :) Thanks! Chris I would think that something would be available for this. Depending on the size of your orders pages I know you could go back through your orders and try to find them that way. But if the item sold for lets say $39.99 and you have like kathousand other products that sold for that, it would be painstaking. You could run an sql query in your database that searches your orders table for products named XXX then returns the order id which is also your order number on the website. Then go to the website search each order number and issue a email from there. Since you only have 9 people shouldn't be to bad. I just ran this query on my database it worked fine: SELECT orders_id, products_model, products_name From orders_products Where products_model = 'YGO_P15' Order by orders_id Just change your products_model to whatever you're searching for and make sure its inbetween the ' ' If you don't use product model numbers then you could use the products_name to get the info. Where products_name ="Dancing with the Devils DVD' or whatever. Link to comment Share on other sites More sharing options...
♥geoffreywalton Posted January 27, 2009 Share Posted January 27, 2009 You could also look in the contributions under reports. There are reports of who bought what etc. Need help installing add ons/contributions, cleaning a hacked site or a bespoke development, check my profile Virus Threat Scanner My Contributions Basic install answers. Click here for Contributions / Add Ons. UK your site. Site Move. Basic design info. For links mentioned in old answers that are no longer here follow this link Useful Threads. If this post was useful, click the Like This button over there ======>>>>>. Link to comment Share on other sites More sharing options...
cgutzmer Posted January 30, 2009 Author Share Posted January 30, 2009 Thanks! I will give that sql a try - looks pretty straight forward :) Chris Gutzmer Link to comment Share on other sites More sharing options...
bhbilbao Posted January 18, 2010 Share Posted January 18, 2010 Im using this contribution. Find Customers by Product http://addons.oscommerce.com/info/6902 It gets an error on client_search.php Error! Unable to determine the page link! Function used: tep_href_link('', 'selected_box=newsdesk', 'NONSSL') help. Link to comment Share on other sites More sharing options...
bhbilbao Posted January 18, 2010 Share Posted January 18, 2010 Removing left_column works fine. <!-- left_navigation //--> <!-- left_navigation_eof //--> ¿? Link to comment Share on other sites More sharing options...
New 
Recommended Posts
Archived
This topic is now archived and is closed to further replies.