View Single Post
  #4  
Old April 8th, 2013, 01:29 PM
Eric's Avatar
Eric Eric is offline
Datafeedr Team
 
Join Date: Feb 2008
Posts: 16,902
Default

Hi,

All of that information is stored in your database. Every link to a merchant's website is tracked.

Currently that information isn't exposed in your backend section but if you have access to phpMyAdmin you can run the following query (this assumes your WordPress $table_prefix is set to 'wp_').

Code:
SELECT 
	p.id AS ID, 
	p.name AS Name,
	p.site_link AS Link,
	stats.views AS Views, 
	stats.clicks AS Clicks 
FROM 
	wp_dfr_shop_products AS p, 
	wp_dfr_xhits AS stats
WHERE p.id = stats.id
ORDER BY stats.clicks DESC
That will give you a list of products ordered by number of clicks descending.

Eric