[Skip to main content](#vessel-content) # Is it possible to show the sales per categories (from the last 30 days)? ## - **[Lumiga](/forum/user/31479-lumiga "View Lumiga's Profile")** - [![Lumiga's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar31479.png)](/forum/user/31479-lumiga "View Lumiga's Profile") Topic Author - [ Offline](/forum/user/31479-lumiga) Less More - Posts: 637 - Thank you received: 26 - - - 6 years 6 months ago [\#318337](#318337) by [Lumiga](/forum/user/31479-lumiga "View Lumiga's Profile") *[Is it possible to show the sales per categories (from the last 30 days)?](/forum/36-reports-statistics/899719-is-it-possible-to-show-the-sales-per-categories-from-the-last-30-days#318337 "-- HikaShop version -- : 4.3.0 Hi, Is it possible to show the sales per categories (for example from the last 30 days)? I have tried al lot also with clean installes from Joomla and Hikashop but most of the time I get errors when I trie to create reports. For example: - 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ' CONCAT('',c.category_name) as `type` FROM #__hikashop_order AS a LEFT JOIN m' at line 1 With this configuratrion: Or do I have to do that with Mass Actions? I also have used the standard report "Five best categories over the last two weeks" but this report give me no infomation. Hope you can help us. Kind regards, Lumiga")* was created by *[Lumiga](/forum/user/31479-lumiga "View Lumiga's Profile")* -- HikaShop version -- : 4.3.0 Hi, Is it possible to show the sales per categories (for example from the last 30 days)? I have tried al lot also with clean installes from Joomla and Hikashop but most of the time I get errors when I trie to create reports. For example: - 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ' CONCAT('',c.category_name) as `type` FROM #__hikashop_order AS a LEFT JOIN m' at line 1 With this configuratrion: [ ![screenshot-615.jpg](/forum/attachment/49234) ](/forum/attachment/49234 "...enshot-615.jpg") Or do I have to do that with Mass Actions? I also have used the standard report "Five best categories over the last two weeks" but this report give me no infomation. Hope you can help us. Kind regards, Lumiga --- Kind regards, Lumiga - [ ![screenshot-615.jpg](/forum/attachment/49234) ](/forum/attachment/49234 "...enshot-615.jpg") [ ](/forum/attachment/49234?download=1 "...enshot-615.jpg") Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM2LXJlcG9ydHMtc3RhdGlzdGljcy84OTk3MTktaXMtaXQtcG9zc2libGUtdG8tc2hvdy10aGUtc2FsZXMtcGVyLWNhdGVnb3JpZXMtZnJvbS10aGUtbGFzdC0zMC1kYXlzP3RtcGw9bWFya2Rvd24=) 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") - [ Away](/forum/user/63-nicolas) Less More - Posts: 86541 - Thank you received: 14304 - - 6 years 6 months ago [\#318346](#318346) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Is it possible to show the sales per categories (from the last 30 days)?](/forum/36-reports-statistics/899719-is-it-possible-to-show-the-sales-per-categories-from-the-last-30-days#318346 "-- HikaShop version -- : 4.3.0 Hi, Is it possible to show the sales per categories (for example from the last 30 days)? I have tried al lot also with clean installes from Joomla and Hikashop but most of the time I get errors when I trie to create reports. For example: - 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ' CONCAT('',c.category_name) as `type` FROM #__hikashop_order AS a LEFT JOIN m' at line 1 With this configuratrion: Or do I have to do that with Mass Actions? I also have used the standard report "Five best categories over the last two weeks" but this report give me no infomation. Hope you can help us. Kind regards, Lumiga")* Hi, You want to do that with a report. You'll need to select the type "category". And the display type "listing". Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM2LXJlcG9ydHMtc3RhdGlzdGljcy84OTk3MTktaXMtaXQtcG9zc2libGUtdG8tc2hvdy10aGUtc2FsZXMtcGVyLWNhdGVnb3JpZXMtZnJvbS10aGUtbGFzdC0zMC1kYXlzP3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[Lumiga](/forum/user/31479-lumiga "View Lumiga's Profile")** - [![Lumiga's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar31479.png)](/forum/user/31479-lumiga "View Lumiga's Profile") Topic Author - [ Offline](/forum/user/31479-lumiga) Less More - Posts: 637 - Thank you received: 26 - - - 6 years 6 months ago [\#318396](#318396) by [Lumiga](/forum/user/31479-lumiga "View Lumiga's Profile") Replied by *[Lumiga](/forum/user/31479-lumiga "View Lumiga's Profile")* on topic *[Is it possible to show the sales per categories (from the last 30 days)?](/forum/36-reports-statistics/899719-is-it-possible-to-show-the-sales-per-categories-from-the-last-30-days#318396 "-- HikaShop version -- : 4.3.0 Hi, Is it possible to show the sales per categories (for example from the last 30 days)? I have tried al lot also with clean installes from Joomla and Hikashop but most of the time I get errors when I trie to create reports. For example: - 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ' CONCAT('',c.category_name) as `type` FROM #__hikashop_order AS a LEFT JOIN m' at line 1 With this configuratrion: Or do I have to do that with Mass Actions? I also have used the standard report "Five best categories over the last two weeks" but this report give me no infomation. Hope you can help us. Kind regards, Lumiga")* Yes we did that, but then I think the results are not correct! Because all the categories together are more then 3 times the turnover from the last 30 days from the whole shop. How can you explain that? [ ![screenshot-617.jpg](/forum/attachment/49243) ](/forum/attachment/49243 "...enshot-617.jpg") --- Kind regards, Lumiga - [ ![screenshot-617.jpg](/forum/attachment/49243) ](/forum/attachment/49243 "...enshot-617.jpg") [ ](/forum/attachment/49243?download=1 "...enshot-617.jpg") Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM2LXJlcG9ydHMtc3RhdGlzdGljcy84OTk3MTktaXMtaXQtcG9zc2libGUtdG8tc2hvdy10aGUtc2FsZXMtcGVyLWNhdGVnb3JpZXMtZnJvbS10aGUtbGFzdC0zMC1kYXlzP3RtcGw9bWFya2Rvd24=) 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") - [ Away](/forum/user/63-nicolas) Less More - Posts: 86541 - Thank you received: 14304 - - 6 years 6 months ago [\#318397](#318397) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Is it possible to show the sales per categories (from the last 30 days)?](/forum/36-reports-statistics/899719-is-it-possible-to-show-the-sales-per-categories-from-the-last-30-days#318397 "-- HikaShop version -- : 4.3.0 Hi, Is it possible to show the sales per categories (for example from the last 30 days)? I have tried al lot also with clean installes from Joomla and Hikashop but most of the time I get errors when I trie to create reports. For example: - 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ' CONCAT('',c.category_name) as `type` FROM #__hikashop_order AS a LEFT JOIN m' at line 1 With this configuratrion: Or do I have to do that with Mass Actions? I also have used the standard report "Five best categories over the last two weeks" but this report give me no infomation. Hope you can help us. Kind regards, Lumiga")* Hi, If you have products in several categories, then they'll be counted for each category's total amount. So it's normal that if you sum the total amount of all the categories you get a bigger number than your turnover. Note also that if you modified older orders recently, their modified date will be updated and thus they will appear there even if they were paid before. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM2LXJlcG9ydHMtc3RhdGlzdGljcy84OTk3MTktaXMtaXQtcG9zc2libGUtdG8tc2hvdy10aGUtc2FsZXMtcGVyLWNhdGVnb3JpZXMtZnJvbS10aGUtbGFzdC0zMC1kYXlzP3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[Lumiga](/forum/user/31479-lumiga "View Lumiga's Profile")** - [![Lumiga's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar31479.png)](/forum/user/31479-lumiga "View Lumiga's Profile") Topic Author - [ Offline](/forum/user/31479-lumiga) Less More - Posts: 637 - Thank you received: 26 - - - 6 years 6 months ago - 6 years 6 months ago [\#318456](#318456) by [Lumiga](/forum/user/31479-lumiga "View Lumiga's Profile") Replied by *[Lumiga](/forum/user/31479-lumiga "View Lumiga's Profile")* on topic *[Is it possible to show the sales per categories (from the last 30 days)?](/forum/36-reports-statistics/899719-is-it-possible-to-show-the-sales-per-categories-from-the-last-30-days#318456 "-- HikaShop version -- : 4.3.0 Hi, Is it possible to show the sales per categories (for example from the last 30 days)? I have tried al lot also with clean installes from Joomla and Hikashop but most of the time I get errors when I trie to create reports. For example: - 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ' CONCAT('',c.category_name) as `type` FROM #__hikashop_order AS a LEFT JOIN m' at line 1 With this configuratrion: Or do I have to do that with Mass Actions? I also have used the standard report "Five best categories over the last two weeks" but this report give me no infomation. Hope you can help us. Kind regards, Lumiga")* Oké good point to use "create" as Date Type but then we see almost no difference. But I stil don't know what the rapport does and how I have to read the Report? Because all the product that where sold have only ONE categorie. selected. See screenshots. [ ![screenshot-619.jpg](/forum/attachment/49252) ](/forum/attachment/49252 "...enshot-619.jpg") I did a test with orders from the last 2 days, and there was one order with € 53,95 With € 32,50 from categorie Chalk Paint and € 21,45 from the categorie brushes. Why does the report give € 107,90 from the categorie brushes and € 53,95 ChalkPaint? It looks like two or more categories for one product is not the issue. . [ ![screenshot-621.jpg](/forum/attachment/49254) ](/forum/attachment/49254 "...enshot-621.jpg") [ ![screenshot-620.jpg](/forum/attachment/49253) ](/forum/attachment/49253 "...enshot-620.jpg") --- Kind regards, Lumiga - [ ![screenshot-619.jpg](/forum/attachment/49252) ](/forum/attachment/49252 "...enshot-619.jpg") [ ](/forum/attachment/49252?download=1 "...enshot-619.jpg") - [ ![screenshot-620.jpg](/forum/attachment/49253) ](/forum/attachment/49253 "...enshot-620.jpg") [ ](/forum/attachment/49253?download=1 "...enshot-620.jpg") - [ ![screenshot-621.jpg](/forum/attachment/49254) ](/forum/attachment/49254 "...enshot-621.jpg") [ ](/forum/attachment/49254?download=1 "...enshot-621.jpg") Last edit: 6 years 6 months ago by [Lumiga](/forum/user/31479-lumiga "View Lumiga's Profile"). Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM2LXJlcG9ydHMtc3RhdGlzdGljcy84OTk3MTktaXMtaXQtcG9zc2libGUtdG8tc2hvdy10aGUtc2FsZXMtcGVyLWNhdGVnb3JpZXMtZnJvbS10aGUtbGFzdC0zMC1kYXlzP3RtcGw9bWFya2Rvd24=) 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") - [ Away](/forum/user/63-nicolas) Less More - Posts: 86541 - Thank you received: 14304 - - 6 years 6 months ago [\#318468](#318468) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Is it possible to show the sales per categories (from the last 30 days)?](/forum/36-reports-statistics/899719-is-it-possible-to-show-the-sales-per-categories-from-the-last-30-days#318468 "-- HikaShop version -- : 4.3.0 Hi, Is it possible to show the sales per categories (for example from the last 30 days)? I have tried al lot also with clean installes from Joomla and Hikashop but most of the time I get errors when I trie to create reports. For example: - 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ' CONCAT('',c.category_name) as `type` FROM #__hikashop_order AS a LEFT JOIN m' at line 1 With this configuratrion: Or do I have to do that with Mass Actions? I also have used the standard report "Five best categories over the last two weeks" but this report give me no infomation. Hope you can help us. Kind regards, Lumiga")* Hi, I'm not sure then. I would need to check the situation directly on the website backend to better understand what's going on. Could you provide such access ? Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM2LXJlcG9ydHMtc3RhdGlzdGljcy84OTk3MTktaXMtaXQtcG9zc2libGUtdG8tc2hvdy10aGUtc2FsZXMtcGVyLWNhdGVnb3JpZXMtZnJvbS10aGUtbGFzdC0zMC1kYXlzP3RtcGw9bWFya2Rvd24=) 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") - [ Away](/forum/user/63-nicolas) Less More - Posts: 86541 - Thank you received: 14304 - - 6 years 5 months ago [\#320089](#320089) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Is it possible to show the sales per categories (from the last 30 days)?](/forum/36-reports-statistics/899719-is-it-possible-to-show-the-sales-per-categories-from-the-last-30-days#320089 "-- HikaShop version -- : 4.3.0 Hi, Is it possible to show the sales per categories (for example from the last 30 days)? I have tried al lot also with clean installes from Joomla and Hikashop but most of the time I get errors when I trie to create reports. For example: - 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ' CONCAT('',c.category_name) as `type` FROM #__hikashop_order AS a LEFT JOIN m' at line 1 With this configuratrion: Or do I have to do that with Mass Actions? I also have used the standard report "Five best categories over the last two weeks" but this report give me no infomation. Hope you can help us. Kind regards, Lumiga")* Hi, Thanks for the access. I checked the situation but I'll have to do some debugging to be able to go down to the bottom of the problem. Could you also provide a FTP access so that I can do that ? Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM2LXJlcG9ydHMtc3RhdGlzdGljcy84OTk3MTktaXMtaXQtcG9zc2libGUtdG8tc2hvdy10aGUtc2FsZXMtcGVyLWNhdGVnb3JpZXMtZnJvbS10aGUtbGFzdC0zMC1kYXlzP3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[Lumiga](/forum/user/31479-lumiga "View Lumiga's Profile")** - [![Lumiga's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar31479.png)](/forum/user/31479-lumiga "View Lumiga's Profile") Topic Author - [ Offline](/forum/user/31479-lumiga) Less More - Posts: 637 - Thank you received: 26 - - - 6 years 5 months ago - 6 years 5 months ago [\#320500](#320500) by [Lumiga](/forum/user/31479-lumiga "View Lumiga's Profile") Replied by *[Lumiga](/forum/user/31479-lumiga "View Lumiga's Profile")* on topic *[Is it possible to show the sales per categories (from the last 30 days)?](/forum/36-reports-statistics/899719-is-it-possible-to-show-the-sales-per-categories-from-the-last-30-days#320500 "-- HikaShop version -- : 4.3.0 Hi, Is it possible to show the sales per categories (for example from the last 30 days)? I have tried al lot also with clean installes from Joomla and Hikashop but most of the time I get errors when I trie to create reports. For example: - 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ' CONCAT('',c.category_name) as `type` FROM #__hikashop_order AS a LEFT JOIN m' at line 1 With this configuratrion: Or do I have to do that with Mass Actions? I also have used the standard report "Five best categories over the last two weeks" but this report give me no infomation. Hope you can help us. Kind regards, Lumiga")* Hi Nicolas, Sorry for my late reply, but I don't get e-mails from the ticketsystem (also not in the spam box). So sometime I have to check the issues by my selfs. But I have send you the FTP access. UPDATE: You can login, access is tested and working now! Kind regards, Lumiga --- Kind regards, Lumiga Last edit: 6 years 5 months ago by [Lumiga](/forum/user/31479-lumiga "View Lumiga's Profile"). Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM2LXJlcG9ydHMtc3RhdGlzdGljcy84OTk3MTktaXMtaXQtcG9zc2libGUtdG8tc2hvdy10aGUtc2FsZXMtcGVyLWNhdGVnb3JpZXMtZnJvbS10aGUtbGFzdC0zMC1kYXlzP3RtcGw9bWFya2Rvd24=) 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.165 seconds [Powered by](/forum/credits) [Kunena Forum](https://www.kunena.org)