I want to have custom report which will show Product view count and total quantity ordered and ratio of these two in a report.
Please give me some idea how I can create this report in admin.
asked Jan 5, 2016 at 11:37
Add a comment
|
1 Answer
You probably can start from the table report_viewed_product_aggregated_daily and join it with the sales_bestsellers_aggregated_daily. Both contain product_id and names.
I can also take care about products with zero views/purchases, probably as a separate section.
-
Thanks, Also can you please guide me towards any good tutorial for creating new custom reports. Jan 6, 2016 at 4:06
-
You can just create a new extension with a menu item and grid, see stackoverflow.com/questions/12704729/… for example– AmastyJan 6, 2016 at 9:48