Post by AliceH » Mon Sep 19, 2011 9:33 am

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.

http://www.embroideryallsorts.com.au


User avatar
Active Member

Posts

Joined
Sun Jan 09, 2011 11:00 am
Location - Australia

Post by AliceH » Thu Sep 22, 2011 2:51 pm

Any ideas?

http://www.embroideryallsorts.com.au


User avatar
Active Member

Posts

Joined
Sun Jan 09, 2011 11:00 am
Location - Australia

Post by rwalker » Thu Nov 10, 2011 8:12 am

I too am searching! I will continue looking.

Discount Golf Clubs and Golf Equipment - Powered by Opencart


New member

Posts

Joined
Fri Jul 01, 2011 8:14 am

Post by AliceH » Thu Nov 24, 2011 1:43 pm

It would be nice to be able to check what people are adding to the wishlist, there must be a way. Anybody know how?

http://www.embroideryallsorts.com.au


User avatar
Active Member

Posts

Joined
Sun Jan 09, 2011 11:00 am
Location - Australia

Post by speedy » Thu Nov 24, 2011 4:06 pm

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!!!!!!!!!!!

New member

Posts

Joined
Thu Jul 28, 2011 1:23 am

Post by AliceH » Thu Nov 24, 2011 4:32 pm

Thank you.

http://www.embroideryallsorts.com.au


User avatar
Active Member

Posts

Joined
Sun Jan 09, 2011 11:00 am
Location - Australia

Post by AliceH » Mon Nov 28, 2011 3:01 pm

I can't find wishlist in the db.

http://www.embroideryallsorts.com.au


User avatar
Active Member

Posts

Joined
Sun Jan 09, 2011 11:00 am
Location - Australia

Post by wolfsteritory » Mon Nov 28, 2011 6:57 pm

go in admin panel -> sales-> customers-> & then login !

easy as chicken pie ! :))))

Here Are Your Options :
1st Option: Web3DesignStudio
More Options ? - What More Do You Need ? !


User avatar
New member

Posts

Joined
Sun Feb 01, 2009 2:08 am

Post by AliceH » Tue Nov 29, 2011 9:04 am

Thank you that works. It would take me a whilt to go throught them though because I have 1900 customers. but it does work.

http://www.embroideryallsorts.com.au


User avatar
Active Member

Posts

Joined
Sun Jan 09, 2011 11:00 am
Location - Australia

Post by nicolasconnault » Tue Nov 14, 2017 9:44 am

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_'.


Posts

Joined
Thu Sep 06, 2012 4:33 pm

Post by Johnathan » Tue Nov 14, 2017 11:36 pm

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.

Image
Image Image Image Image Image Image


User avatar
Global Moderator

Posts

Joined
Fri Dec 18, 2009 3:08 am

Who is online

Users browsing this forum: No registered users and 51 guests