Page 1 of 1
check customers wishlist
Posted: Mon Sep 19, 2011 9:33 am
by AliceH
I hope I am not posting something that has already been answered, I have searched and can't find it. Is there a way to see if customers are using the wishlist? I can't see it in admin anywhere.
Alice.
Re: check customers wishlist
Posted: Thu Sep 22, 2011 2:51 pm
by AliceH
Any ideas?
Re: check customers wishlist
Posted: Thu Nov 10, 2011 8:12 am
by rwalker
I too am searching! I will continue looking.
Re: check customers wishlist
Posted: Thu Nov 24, 2011 1:43 pm
by AliceH
It would be nice to be able to check what people are adding to the wishlist, there must be a way. Anybody know how?
Re: check customers wishlist
Posted: Thu Nov 24, 2011 4:06 pm
by speedy
The ONLY way, so far, is going to
Code: Select all
phpmyadmin>database>your-database-name->wishlist>browse
There you will see some lists. You can see their user id and product id that they have in their wishlist. SWEET!!!!!!!!!!!
Re: check customers wishlist
Posted: Thu Nov 24, 2011 4:32 pm
by AliceH
Thank you.
Re: check customers wishlist
Posted: Mon Nov 28, 2011 3:01 pm
by AliceH
I can't find wishlist in the db.
Re: check customers wishlist
Posted: Mon Nov 28, 2011 6:57 pm
by wolfsteritory
go in admin panel -> sales-> customers-> & then login !
easy as chicken pie !
)))
Re: check customers wishlist
Posted: Tue Nov 29, 2011 9:04 am
by AliceH
Thank you that works. It would take me a whilt to go throught them though because I have 1900 customers. but it does work.
Re: check customers wishlist
Posted: Tue Nov 14, 2017 9:44 am
by nicolasconnault
I know this is 6 years later, but in case someone is also looking for a way to see an overview of customers' wishlist, you can run this query in the Database and it will show a tally of the last 90 days' worth of customer wishlists, ordered by most to least wanted products:
Code: Select all
select `oc_product`.`model` AS `model`,count(`oc_customer_wishlist`.`product_id`) AS `total` from `oc_customer_wishlist` join `oc_product` where ((`oc_product`.`product_id` = `oc_customer_wishlist`.`product_id`) and (`oc_customer_wishlist`.`date_added` between (curdate() - interval 90 day) and now())) group by `oc_customer_wishlist`.`product_id` order by `total` desc
Just be mindful that this assumes you haven't changed the database table prefix from its default value of 'oc_'.
Re: check customers wishlist
Posted: Tue Nov 14, 2017 11:36 pm
by Johnathan
If you're not handy with database queries, the easiest way is to just log in as the customer to the front-end. You can then inspect their saved cart and wishlist items.