theherbman Posted March 14, 2010 Share Posted March 14, 2010 Hi all. Is it possible to find out which customers have requested updates/notifications of products? Regards Mel Link to comment Share on other sites More sharing options...
FIMBLE Posted March 14, 2010 Share Posted March 14, 2010 You can search through your database Mel, or alter a customer export to csv add on to get this info i did it a while babck for someone who wanted similar but with the newsletter i think its the TABLE_CUSTOMERS_INFO you want to search and TABLE_PRODUCT_NOTIFCATIONS Nic Sometimes you're the dog and sometimes the lamp post [/url] My Contributions Link to comment Share on other sites More sharing options...
theherbman Posted March 14, 2010 Author Share Posted March 14, 2010 You can search through your database Mel, or alter a customer export to csv add on to get this info i did it a while babck for someone who wanted similar but with the newsletter i think its the TABLE_CUSTOMERS_INFO you want to search and TABLE_PRODUCT_NOTIFCATIONS Nic You are talking MySQL daterbases. Those I know nothing about that at all. I will have a look to see what I can find. Like everything its easy when you know how but I'm leaning. Regards Mel Link to comment Share on other sites More sharing options...
theherbman Posted March 14, 2010 Author Share Posted March 14, 2010 You are talking MySQL daterbases. Those I know nothing about that at all. I will have a look to see what I can find. Like everything its easy when you know how but I'm leaning. Regards Mel I know this is really off subject..... I did find all the info but the table notifications only show customers id and you have to look at another table to find who the id relates to. The same goes for product thats only id as well. Is there any way in there to marry the two up ie. product name and customer name. As you know the product notification has to be done by hand and it would be so much easier to have a list. But of course I might have missed something. Regards Mel Link to comment Share on other sites More sharing options...
multimixer Posted March 14, 2010 Share Posted March 14, 2010 Using those id's (for customer and product) you can search the tables customers, products or products_descriptions to find any data that is stored there. What exactly is your purpose? My community profile | Template system for osCommerce - New: Responsive | Feedback channel Link to comment Share on other sites More sharing options...
theherbman Posted March 14, 2010 Author Share Posted March 14, 2010 Using those id's (for customer and product) you can search the tables customers, products or products_descriptions to find any data that is stored there. What exactly is your purpose? I have a lot of customers who ask for updates of plants at this time of the year as its nearly spring. I sent out updates to everyone 2 days one of my local customers daughters phoned me today very upset because her mother had died last week and said I should have known because I was at the funeral. O.K. I might or mightnot have noticed if her name was there but its not certain. This is one instance where paperwork is better......maybe. I was just hoping I would not have to copy all the ID's. I have all the product ID in admin on quick edit but the customers Id I cannot find in admim? Regards Mel Link to comment Share on other sites More sharing options...
multimixer Posted March 14, 2010 Share Posted March 14, 2010 Fine, I understand the situation, but technically, what type of solution do you need? Do you want a list or what? My community profile | Template system for osCommerce - New: Responsive | Feedback channel Link to comment Share on other sites More sharing options...
theherbman Posted March 14, 2010 Author Share Posted March 14, 2010 Fine, I understand the situation, but technically, what type of solution do you need? Do you want a list or what? It would me nice to have the info available in the osc admin, without having to go to my mySQL and printing off the 2 tables. Regards Mel Link to comment Share on other sites More sharing options...
multimixer Posted March 14, 2010 Share Posted March 14, 2010 It would me nice to have the info available in the osc admin, without having to go to my mySQL and printing off the 2 tables. Regards Mel Mel, what info do you mean, what exactly you want to have? :) Lets say "I want a list that show ???" or "on the customer info page in admin I want to show ???" something like this Of course you should not go to print out any database tables, this "printing" of the info you need can be done via php, but it need to be absolutely clear what exactly you want My community profile | Template system for osCommerce - New: Responsive | Feedback channel Link to comment Share on other sites More sharing options...
theherbman Posted March 14, 2010 Author Share Posted March 14, 2010 O.K. I would like to have is the customer id on the customer info page that you find in admin. Regards Mel 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.