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.
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:
Just be mindful that this assumes you haven't changed the database table prefix from its default value of 'oc_'.
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
Who is online
Users browsing this forum: No registered users and 43 guests