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.
Alice.
I too am searching! I will continue looking.
Discount Golf Clubs and Golf Equipment - Powered by Opencart
It would be nice to be able to check what people are adding to the wishlist, there must be a way. Anybody know how?
The ONLY way, so far, is going to There you will see some lists. You can see their user id and product id that they have in their wishlist. SWEET!!!!!!!!!!!
Code: Select all
phpmyadmin>database>your-database-name->wishlist>browse
go in admin panel -> sales-> customers-> & then login !
easy as chicken pie ! )))
easy as chicken pie ! )))
Here Are Your Options :
1st Option: Web3DesignStudio
More Options ? - What More Do You Need ? !
Thank you that works. It would take me a whilt to go throught them though because I have 1900 customers. but it does work.
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 206 guests