Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Finding all customers that purchased a specific product


cgutzmer

Recommended Posts

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

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

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

  • 11 months later...

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...