[Skip to main content](#vessel-content) # Number of sold products in a certain period ## - **[Remko](/forum/user/7328-remko "View Remko's Profile")** - [![Remko's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar7328.jpg)](/forum/user/7328-remko "View Remko's Profile") Topic Author - [ Offline](/forum/user/7328-remko) - Like HikaShop very much Less More - Posts: 46 - Thank you received: 0 - - - - [](http://www.edsmusic.nl/) - 12 years 10 months ago [\#137456](#137456) by [Remko](/forum/user/7328-remko "View Remko's Profile") *[Number of sold products in a certain period](/forum/36-reports-statistics/864503-number-of-sold-products-in-a-certain-period#137456 "Hi, Is it possible to make a report of the number of sold products in a certain period within certain catagories. i.e. When I have the catagories DVD, CD and BLUE RAY, I like to see how many CD's I've sold per month, per week or per year. (only the shipped and confirmed orders). I'm also loooking for an easy option to create a list of all the sold products in a certain period. (Which titles of DVD's did I sell in March). -- HikaShop version -- :2.2.3 Business -- Joomla version -- : 2.5.17 -- PHP version -- : 5.2.x")* was created by *[Remko](/forum/user/7328-remko "View Remko's Profile")* Hi, Is it possible to make a report of the number of sold products in a certain period within certain catagories. i.e. When I have the catagories DVD, CD and BLUE RAY, I like to see how many CD's I've sold per month, per week or per year. (only the shipped and confirmed orders). I'm also loooking for an easy option to create a list of all the sold products in a certain period. (Which titles of DVD's did I sell in March). -- HikaShop version -- :2.2.3 Business -- Joomla version -- : 2.5.17 -- PHP version -- : 5.2.x Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM2LXJlcG9ydHMtc3RhdGlzdGljcy84NjQ1MDMtbnVtYmVyLW9mLXNvbGQtcHJvZHVjdHMtaW4tYS1jZXJ0YWluLXBlcmlvZD90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[nicolas](/forum/user/63-nicolas "View nicolas's Profile")** - [![nicolas's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar63.png?1793428657)](/forum/user/63-nicolas "View nicolas's Profile") - [ Offline](/forum/user/63-nicolas) Less More - Posts: 86555 - Thank you received: 14304 - - 12 years 10 months ago [\#137508](#137508) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Number of sold products in a certain period](/forum/36-reports-statistics/864503-number-of-sold-products-in-a-certain-period#137508 "Hi, Is it possible to make a report of the number of sold products in a certain period within certain catagories. i.e. When I have the catagories DVD, CD and BLUE RAY, I like to see how many CD's I've sold per month, per week or per year. (only the shipped and confirmed orders). I'm also loooking for an easy option to create a list of all the sold products in a certain period. (Which titles of DVD's did I sell in March). -- HikaShop version -- :2.2.3 Business -- Joomla version -- : 2.5.17 -- PHP version -- : 5.2.x")* Hi, Yes. All that is possible by creating reports for your categories via the menu Orders->Reports: [ www.hikashop.com/support/documentation/1...hop-report-form.html](http://www.hikashop.com/support/documentation/133-hikashop-report-form.html) You can restrict your reports per category and group the sales per period on your graphics, but you can also display a comparison listing of the products. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM2LXJlcG9ydHMtc3RhdGlzdGljcy84NjQ1MDMtbnVtYmVyLW9mLXNvbGQtcHJvZHVjdHMtaW4tYS1jZXJ0YWluLXBlcmlvZD90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[Remko](/forum/user/7328-remko "View Remko's Profile")** - [![Remko's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar7328.jpg)](/forum/user/7328-remko "View Remko's Profile") Topic Author - [ Offline](/forum/user/7328-remko) - Like HikaShop very much Less More - Posts: 46 - Thank you received: 0 - - - - [](http://www.edsmusic.nl/) - 12 years 9 months ago [\#141471](#141471) by [Remko](/forum/user/7328-remko "View Remko's Profile") Replied by *[Remko](/forum/user/7328-remko "View Remko's Profile")* on topic *[Number of sold products in a certain period](/forum/36-reports-statistics/864503-number-of-sold-products-in-a-certain-period#141471 "Hi, Is it possible to make a report of the number of sold products in a certain period within certain catagories. i.e. When I have the catagories DVD, CD and BLUE RAY, I like to see how many CD's I've sold per month, per week or per year. (only the shipped and confirmed orders). I'm also loooking for an easy option to create a list of all the sold products in a certain period. (Which titles of DVD's did I sell in March). -- HikaShop version -- :2.2.3 Business -- Joomla version -- : 2.5.17 -- PHP version -- : 5.2.x")* Hi Nicolas, Thanks for your help. I had succes with displaying the amount of orders in a certain period, but I don't know how to create a list of all the sold products in a certain period. In my shop, I sell music and I like to create a list of all the sold titles per month or per year. How can I do that without restrictions of the number of items? Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM2LXJlcG9ydHMtc3RhdGlzdGljcy84NjQ1MDMtbnVtYmVyLW9mLXNvbGQtcHJvZHVjdHMtaW4tYS1jZXJ0YWluLXBlcmlvZD90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[Eliot](/forum/user/1824-eliot "View Eliot's Profile")** - [![Eliot's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar1824.png)](/forum/user/1824-eliot "View Eliot's Profile") - [ Offline](/forum/user/1824-eliot) Less More - Posts: 2334 - Thank you received: 403 - - 12 years 9 months ago [\#141542](#141542) by [Eliot](/forum/user/1824-eliot "View Eliot's Profile") Replied by *[Eliot](/forum/user/1824-eliot "View Eliot's Profile")* on topic *[Number of sold products in a certain period](/forum/36-reports-statistics/864503-number-of-sold-products-in-a-certain-period#141542 "Hi, Is it possible to make a report of the number of sold products in a certain period within certain catagories. i.e. When I have the catagories DVD, CD and BLUE RAY, I like to see how many CD's I've sold per month, per week or per year. (only the shipped and confirmed orders). I'm also loooking for an easy option to create a list of all the sold products in a certain period. (Which titles of DVD's did I sell in March). -- HikaShop version -- :2.2.3 Business -- Joomla version -- : 2.5.17 -- PHP version -- : 5.2.x")* Hi there, You can create a listing which shows the most sold product. To do so, create a report with the diplay type listing, on the period you want. Then, select the type "product" and choose "sales" for display informations. Take a look at the screenshot to make sure you got it correctly! #### Attachment not found However, this will show the top sold product according to the money they generate. It's not based on the number of product sold. Is that what you would like? Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM2LXJlcG9ydHMtc3RhdGlzdGljcy84NjQ1MDMtbnVtYmVyLW9mLXNvbGQtcHJvZHVjdHMtaW4tYS1jZXJ0YWluLXBlcmlvZD90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[Remko](/forum/user/7328-remko "View Remko's Profile")** - [![Remko's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar7328.jpg)](/forum/user/7328-remko "View Remko's Profile") Topic Author - [ Offline](/forum/user/7328-remko) - Like HikaShop very much Less More - Posts: 46 - Thank you received: 0 - - - - [](http://www.edsmusic.nl/) - 12 years 9 months ago [\#141603](#141603) by [Remko](/forum/user/7328-remko "View Remko's Profile") Replied by *[Remko](/forum/user/7328-remko "View Remko's Profile")* on topic *[Number of sold products in a certain period](/forum/36-reports-statistics/864503-number-of-sold-products-in-a-certain-period#141603 "Hi, Is it possible to make a report of the number of sold products in a certain period within certain catagories. i.e. When I have the catagories DVD, CD and BLUE RAY, I like to see how many CD's I've sold per month, per week or per year. (only the shipped and confirmed orders). I'm also loooking for an easy option to create a list of all the sold products in a certain period. (Which titles of DVD's did I sell in March). -- HikaShop version -- :2.2.3 Business -- Joomla version -- : 2.5.17 -- PHP version -- : 5.2.x")* Hi Eliot, It is just a little bit of what I like. This list is limited to 50 products, but I like to have a compete list with number of times that the products have been sold. In my case (selling music) I need a list to tell the copyright organisation which titles I've sold. But in other situations a similar list can be useful. A report function would be nice, but an export function (to csv or xls) will be nice as well. As long as I can create a list of the sold products in a year or a month or another defined period. Hope it is possible or that this function will be added in a future update. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM2LXJlcG9ydHMtc3RhdGlzdGljcy84NjQ1MDMtbnVtYmVyLW9mLXNvbGQtcHJvZHVjdHMtaW4tYS1jZXJ0YWluLXBlcmlvZD90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[Eliot](/forum/user/1824-eliot "View Eliot's Profile")** - [![Eliot's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar1824.png)](/forum/user/1824-eliot "View Eliot's Profile") - [ Offline](/forum/user/1824-eliot) Less More - Posts: 2334 - Thank you received: 403 - - 12 years 9 months ago [\#141645](#141645) by [Eliot](/forum/user/1824-eliot "View Eliot's Profile") Replied by *[Eliot](/forum/user/1824-eliot "View Eliot's Profile")* on topic *[Number of sold products in a certain period](/forum/36-reports-statistics/864503-number-of-sold-products-in-a-certain-period#141645 "Hi, Is it possible to make a report of the number of sold products in a certain period within certain catagories. i.e. When I have the catagories DVD, CD and BLUE RAY, I like to see how many CD's I've sold per month, per week or per year. (only the shipped and confirmed orders). I'm also loooking for an easy option to create a list of all the sold products in a certain period. (Which titles of DVD's did I sell in March). -- HikaShop version -- :2.2.3 Business -- Joomla version -- : 2.5.17 -- PHP version -- : 5.2.x")* Hi Remko, Actually I just realized that if you select "Orders" instead of "Sales" it will give you the number of item sold. So it should display waht you're looking for! Also, you can change the "limit" field to display more items. About the csv export, well, it's already available! Just look at the top of the page and you'll see the export button. The following user(s) said Thank You: [Remko](/forum/user/7328-remko "View Remko's Profile") Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM2LXJlcG9ydHMtc3RhdGlzdGljcy84NjQ1MDMtbnVtYmVyLW9mLXNvbGQtcHJvZHVjdHMtaW4tYS1jZXJ0YWluLXBlcmlvZD90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[Remko](/forum/user/7328-remko "View Remko's Profile")** - [![Remko's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar7328.jpg)](/forum/user/7328-remko "View Remko's Profile") Topic Author - [ Offline](/forum/user/7328-remko) - Like HikaShop very much Less More - Posts: 46 - Thank you received: 0 - - - - [](http://www.edsmusic.nl/) - 12 years 9 months ago [\#141667](#141667) by [Remko](/forum/user/7328-remko "View Remko's Profile") Replied by *[Remko](/forum/user/7328-remko "View Remko's Profile")* on topic *[Number of sold products in a certain period](/forum/36-reports-statistics/864503-number-of-sold-products-in-a-certain-period#141667 "Hi, Is it possible to make a report of the number of sold products in a certain period within certain catagories. i.e. When I have the catagories DVD, CD and BLUE RAY, I like to see how many CD's I've sold per month, per week or per year. (only the shipped and confirmed orders). I'm also loooking for an easy option to create a list of all the sold products in a certain period. (Which titles of DVD's did I sell in March). -- HikaShop version -- :2.2.3 Business -- Joomla version -- : 2.5.17 -- PHP version -- : 5.2.x")* YES, YES and another YES! :woohoo: On the screen the list is limited to a maximum of 50, that was one of reasons that it was not exactly what I was looking for. The Export function did not work last week, but now it does (I don't know why). But now the export function works and I see that that list is not limited, I'm very happy! ![:cheer:](/media/kunena/emoticons/2.png ":cheer:") :woohoo: The suggestion to change Sales to Orders was also a great suggestion! Thank you very much for you help!!!! :woohoo: Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM2LXJlcG9ydHMtc3RhdGlzdGljcy84NjQ1MDMtbnVtYmVyLW9mLXNvbGQtcHJvZHVjdHMtaW4tYS1jZXJ0YWluLXBlcmlvZD90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[Remko](/forum/user/7328-remko "View Remko's Profile")** - [![Remko's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar7328.jpg)](/forum/user/7328-remko "View Remko's Profile") Topic Author - [ Offline](/forum/user/7328-remko) - Like HikaShop very much Less More - Posts: 46 - Thank you received: 0 - - - - [](http://www.edsmusic.nl/) - 12 years 9 months ago [\#141675](#141675) by [Remko](/forum/user/7328-remko "View Remko's Profile") Replied by *[Remko](/forum/user/7328-remko "View Remko's Profile")* on topic *[Number of sold products in a certain period](/forum/36-reports-statistics/864503-number-of-sold-products-in-a-certain-period#141675 "Hi, Is it possible to make a report of the number of sold products in a certain period within certain catagories. i.e. When I have the catagories DVD, CD and BLUE RAY, I like to see how many CD's I've sold per month, per week or per year. (only the shipped and confirmed orders). I'm also loooking for an easy option to create a list of all the sold products in a certain period. (Which titles of DVD's did I sell in March). -- HikaShop version -- :2.2.3 Business -- Joomla version -- : 2.5.17 -- PHP version -- : 5.2.x")* One little thing... ![:unsure:](/media/kunena/emoticons/18.png ":unsure:") When I choose to display (or export) the orders of **last year**, everything seems to be okay, but when I choose to display **this year** (just a month in this case at this moment), the list is too long. I think that not this year is displayed, but from one year ago until now. I solved this by choosing the date from 2014-01-01 00:00 to 2014-12-31 23:59. Maybe this can be improved (or the translation to Dutch is not right)... Have a nice day! With kind regards, Remko Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM2LXJlcG9ydHMtc3RhdGlzdGljcy84NjQ1MDMtbnVtYmVyLW9mLXNvbGQtcHJvZHVjdHMtaW4tYS1jZXJ0YWluLXBlcmlvZD90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[Eliot](/forum/user/1824-eliot "View Eliot's Profile")** - [![Eliot's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar1824.png)](/forum/user/1824-eliot "View Eliot's Profile") - [ Offline](/forum/user/1824-eliot) Less More - Posts: 2334 - Thank you received: 403 - - 12 years 9 months ago [\#141823](#141823) by [Eliot](/forum/user/1824-eliot "View Eliot's Profile") Replied by *[Eliot](/forum/user/1824-eliot "View Eliot's Profile")* on topic *[Number of sold products in a certain period](/forum/36-reports-statistics/864503-number-of-sold-products-in-a-certain-period#141823 "Hi, Is it possible to make a report of the number of sold products in a certain period within certain catagories. i.e. When I have the catagories DVD, CD and BLUE RAY, I like to see how many CD's I've sold per month, per week or per year. (only the shipped and confirmed orders). I'm also loooking for an easy option to create a list of all the sold products in a certain period. (Which titles of DVD's did I sell in March). -- HikaShop version -- :2.2.3 Business -- Joomla version -- : 2.5.17 -- PHP version -- : 5.2.x")* I'm glad you appreciate the solution ![:D](/media/kunena/emoticons/1.png ":D") About the "this year" thing, it actually display the last 365 days. You're not the first complaining about that so I am going to add a real "this year" option in the dropdown and rename this one to "last 365 days". It will be included in the next release. The following user(s) said Thank You: [Remko](/forum/user/7328-remko "View Remko's Profile") Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM2LXJlcG9ydHMtc3RhdGlzdGljcy84NjQ1MDMtbnVtYmVyLW9mLXNvbGQtcHJvZHVjdHMtaW4tYS1jZXJ0YWluLXBlcmlvZD90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[Eliot](/forum/user/1824-eliot "View Eliot's Profile")** - [![Eliot's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar1824.png)](/forum/user/1824-eliot "View Eliot's Profile") - [ Offline](/forum/user/1824-eliot) Less More - Posts: 2334 - Thank you received: 403 - - 12 years 9 months ago [\#141861](#141861) by [Eliot](/forum/user/1824-eliot "View Eliot's Profile") Replied by *[Eliot](/forum/user/1824-eliot "View Eliot's Profile")* on topic *[Number of sold products in a certain period](/forum/36-reports-statistics/864503-number-of-sold-products-in-a-certain-period#141861 "Hi, Is it possible to make a report of the number of sold products in a certain period within certain catagories. i.e. When I have the catagories DVD, CD and BLUE RAY, I like to see how many CD's I've sold per month, per week or per year. (only the shipped and confirmed orders). I'm also loooking for an easy option to create a list of all the sold products in a certain period. (Which titles of DVD's did I sell in March). -- HikaShop version -- :2.2.3 Business -- Joomla version -- : 2.5.17 -- PHP version -- : 5.2.x")* I just did the modification, if you don't want to wait for the release (which should be next week) I can give you the code (2 files have to be edited). The following user(s) said Thank You: [Remko](/forum/user/7328-remko "View Remko's Profile") Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM2LXJlcG9ydHMtc3RhdGlzdGljcy84NjQ1MDMtbnVtYmVyLW9mLXNvbGQtcHJvZHVjdHMtaW4tYS1jZXJ0YWluLXBlcmlvZD90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[Remko](/forum/user/7328-remko "View Remko's Profile")** - [![Remko's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar7328.jpg)](/forum/user/7328-remko "View Remko's Profile") Topic Author - [ Offline](/forum/user/7328-remko) - Like HikaShop very much Less More - Posts: 46 - Thank you received: 0 - - - - [](http://www.edsmusic.nl/) - 12 years 9 months ago [\#141892](#141892) by [Remko](/forum/user/7328-remko "View Remko's Profile") Replied by *[Remko](/forum/user/7328-remko "View Remko's Profile")* on topic *[Number of sold products in a certain period](/forum/36-reports-statistics/864503-number-of-sold-products-in-a-certain-period#141892 "Hi, Is it possible to make a report of the number of sold products in a certain period within certain catagories. i.e. When I have the catagories DVD, CD and BLUE RAY, I like to see how many CD's I've sold per month, per week or per year. (only the shipped and confirmed orders). I'm also loooking for an easy option to create a list of all the sold products in a certain period. (Which titles of DVD's did I sell in March). -- HikaShop version -- :2.2.3 Business -- Joomla version -- : 2.5.17 -- PHP version -- : 5.2.x")* Great! I can wait for the next update. No problem. The most important is that I can create a list. I'm very happy with your care for your customers. Thanks again! Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM2LXJlcG9ydHMtc3RhdGlzdGljcy84NjQ1MDMtbnVtYmVyLW9mLXNvbGQtcHJvZHVjdHMtaW4tYS1jZXJ0YWluLXBlcmlvZD90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. Board Categories HikaShop Install & Update Product & Category Display Content Creation Sales and Orders Orders management Reports & Statistics Customers Checkout Payment Methods Shipping Methods Import & Export (CSV, XLS…) Specific Features Affilation Taxes Wishlist Vote Carousel & Slider Mass Actions Filters & Search Discount & Coupon Feature Request Integrations Showcase General Talk about HikaShop Development HikaShop 3.0 Beta Translation Commercial Jobs HikaShop Components HikaMarket Market: Feature requests Market: How to? Market: Bug Report HikaSerial General talk about HikaSerial Serial: Bug Report Serial: How to? Support en Français de HikaSerial (French Support) HikaSubscription HikaAuction Auction: Feature requests Auction: How to? Auction: Bug report Hikashop around the world Support en Français (French Support) Russian FAQ. Курс выживания с Hikashop. Частые вопросы и о Расширения Hikashop Наши сайты на Hikashop 日本語版サポート(Japanese Support) Thai German Archives Bug Report How to? [](/forum/topics/feed/mode-topics?format=feed&type=rss) Time to create page: 0.072 seconds [Powered by](/forum/credits) [Kunena Forum](https://www.kunena.org)