9 replies to this topic

[theherbman]

Hi all.
Is it possible to find out which customers have requested updates/notifications of products?

Regards Mel

[FIMBLE]

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

Edited by FIMBLE, 14 March 2010, 09:54.

[theherbman]

FIMBLE, on 14 March 2010, 09:52, said:

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

[theherbman]

theherbman, on 14 March 2010, 10:17, said:

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

[multimixer]

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?

[theherbman]

multimixer, on 14 March 2010, 11:20, said:

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

[multimixer]

Fine, I understand the situation, but technically, what type of solution do you need? Do you want a list or what?

[theherbman]

multimixer, on 14 March 2010, 17:21, said:

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

[multimixer]

theherbman, on 14 March 2010, 17:42, said:

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

Edited by multimixer, 14 March 2010, 18:21.

[theherbman]

O.K.
I would like to have is the customer id on the customer info page that you find in admin.

Regards Mel