Report of top selling products by characteristic

  • Posts: 158
  • Thank you received: 4
  • Hikamarket Multivendor Hikashop Business
4 years 5 months ago #229716

-- HikaShop version -- : 2.6.1
-- Joomla version -- : 3.4.8

We are looking to create a report that indicates the top selling products in 2015 organized by the color/size options (which we have entered in as characteristics). In short, we want to know which colors and sizes are the most popular. I am unable to figure out a way of doing this with the Reporting or Mass Action capabilities built into HikaShop. How would be go about accomplishing this? Thank you.

Please Log in or Create an account to join the conversation.

  • Posts: 70149
  • Thank you received: 10504
  • MODERATOR
4 years 5 months ago #229776

Hi,

As far as I can see, neither the mass actions nor the reports will allow you to output such statistics.
The solution I can see is to do a normal export of your products as a CSV, open it in Excel, and with some excel magic, use the product_sales column and the characteristic columns of the CSV in order to generate the report you need.

Please Log in or Create an account to join the conversation.

  • Posts: 158
  • Thank you received: 4
  • Hikamarket Multivendor Hikashop Business
4 years 5 months ago #229868

Thought that might be the case. Thank you for confirming. Time to pull out some mad spreadsheet skills! Hopefully, some time in the future, there will be an ability built in to sort/export by characteristic... ;-)

Please Log in or Create an account to join the conversation.

Time to create page: 0.056 seconds
Powered by Kunena Forum