[Skip to main content](#vessel-content) # Number of Product Orders not showing correctly ## - **[NewAgeWarrior](/forum/user/31640-newagewarrior "View NewAgeWarrior's Profile")** - [![NewAgeWarrior's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/31640-newagewarrior "View NewAgeWarrior's Profile") Topic Author - [ Offline](/forum/user/31640-newagewarrior) Less More- Posts: 6 - Thank you received: 0 - - 12 years 6 months ago - 12 years 6 months ago [\#151103](#151103) by [NewAgeWarrior](/forum/user/31640-newagewarrior "View NewAgeWarrior's Profile") *[Number of Product Orders not showing correctly](/forum/36-reports-statistics/867239-number-of-product-orders-not-showing-correctly#151103 "-- HikaShop version -- : 2.3.0 -- Joomla version -- : 3.2.3 -- Browser(s) name and version -- : Chrome Version 33.0.1750.154 m Hello, I have a sales report on my site which should show the quantity sold of a product in a period of time. The problem is the report is not showing the exact quantity of a product sold but only how often it is included in an order. Like this: Client 1 orders 2 pieces of product X Client 2 orders 1 piece of product X The quantity sold of product X is 3 an it was order 2 times. The sales report now should show that the exact quantity sold in this month is 3 right? But instead it shows that the quantity sold is 2 because it was ordered 2 times. It displays the times the product were orderd not the qunatity that were orderd. But i need the exact amount of products sold not the amount of times someone has orderd it.. Greetings NewAge")* was created by *[NewAgeWarrior](/forum/user/31640-newagewarrior "View NewAgeWarrior's Profile")* -- HikaShop version -- : 2.3.0 -- Joomla version -- : 3.2.3 -- Browser(s) name and version -- : Chrome Version 33.0.1750.154 m Hello, I have a sales report on my site which should show the quantity sold of a product in a period of time. The problem is the report is not showing the exact quantity of a product sold but only how often it is included in an order. Like this: Client 1 orders 2 pieces of product X Client 2 orders 1 piece of product X The quantity sold of product X is 3 an it was order 2 times. The sales report now should show that the exact quantity sold in this month is 3 right? But instead it shows that the quantity sold is 2 because it was ordered 2 times. It displays the times the product were orderd not the qunatity that were orderd. But i need the exact amount of products sold not the amount of times someone has orderd it.. Greetings NewAge Last edit: 12 years 6 months ago by [NewAgeWarrior](/forum/user/31640-newagewarrior "View NewAgeWarrior's Profile"). Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM2LXJlcG9ydHMtc3RhdGlzdGljcy84NjcyMzktbnVtYmVyLW9mLXByb2R1Y3Qtb3JkZXJzLW5vdC1zaG93aW5nLWNvcnJlY3RseT90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[Mohamed Thelji](/forum/user/6861-mohamed-thelji "View Mohamed Thelji's Profile")** - [![Mohamed Thelji's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar6861.png)](/forum/user/6861-mohamed-thelji "View Mohamed Thelji's Profile") - [ Offline](/forum/user/6861-mohamed-thelji) Less More- Posts: 12953 - Thank you received: 1778 - - - 12 years 6 months ago [\#151158](#151158) by [Mohamed Thelji](/forum/user/6861-mohamed-thelji "View Mohamed Thelji's Profile") Replied by *[Mohamed Thelji](/forum/user/6861-mohamed-thelji "View Mohamed Thelji's Profile")* on topic *[Number of Product Orders not showing correctly](/forum/36-reports-statistics/867239-number-of-product-orders-not-showing-correctly#151158 "-- HikaShop version -- : 2.3.0 -- Joomla version -- : 3.2.3 -- Browser(s) name and version -- : Chrome Version 33.0.1750.154 m Hello, I have a sales report on my site which should show the quantity sold of a product in a period of time. The problem is the report is not showing the exact quantity of a product sold but only how often it is included in an order. Like this: Client 1 orders 2 pieces of product X Client 2 orders 1 piece of product X The quantity sold of product X is 3 an it was order 2 times. The sales report now should show that the exact quantity sold in this month is 3 right? But instead it shows that the quantity sold is 2 because it was ordered 2 times. It displays the times the product were orderd not the qunatity that were orderd. But i need the exact amount of products sold not the amount of times someone has orderd it.. Greetings NewAge")* Hello, Can you show me how did you configured your report through some screenshots ? Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM2LXJlcG9ydHMtc3RhdGlzdGljcy84NjcyMzktbnVtYmVyLW9mLXByb2R1Y3Qtb3JkZXJzLW5vdC1zaG93aW5nLWNvcnJlY3RseT90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[NewAgeWarrior](/forum/user/31640-newagewarrior "View NewAgeWarrior's Profile")** - [![NewAgeWarrior's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/31640-newagewarrior "View NewAgeWarrior's Profile") Topic Author - [ Offline](/forum/user/31640-newagewarrior) Less More- Posts: 6 - Thank you received: 0 - - 12 years 6 months ago - 12 years 6 months ago [\#151574](#151574) by [NewAgeWarrior](/forum/user/31640-newagewarrior "View NewAgeWarrior's Profile") Replied by *[NewAgeWarrior](/forum/user/31640-newagewarrior "View NewAgeWarrior's Profile")* on topic *[Number of Product Orders not showing correctly](/forum/36-reports-statistics/867239-number-of-product-orders-not-showing-correctly#151574 "-- HikaShop version -- : 2.3.0 -- Joomla version -- : 3.2.3 -- Browser(s) name and version -- : Chrome Version 33.0.1750.154 m Hello, I have a sales report on my site which should show the quantity sold of a product in a period of time. The problem is the report is not showing the exact quantity of a product sold but only how often it is included in an order. Like this: Client 1 orders 2 pieces of product X Client 2 orders 1 piece of product X The quantity sold of product X is 3 an it was order 2 times. The sales report now should show that the exact quantity sold in this month is 3 right? But instead it shows that the quantity sold is 2 because it was ordered 2 times. It displays the times the product were orderd not the qunatity that were orderd. But i need the exact amount of products sold not the amount of times someone has orderd it.. Greetings NewAge")* Hi, i can try. But it will be difficult because i have it all in german. What i have is a report as a table like this: [ ![250](http://www.lanconnectionhh.de/downloads/report1.PNG) ](http://www.lanconnectionhh.de/downloads/report1.PNG "250") You see that for example the first line shows that the product is ordered 6 times. That is the amount of users who have ordered it. In fact two of them have ordered two pieces of it so it should be 8 and not 6. Know what i mean? The configuration is complicated as i said, but i try with these screens: [ ![250](http://www.lanconnectionhh.de/downloads/report2.PNG) ](http://www.lanconnectionhh.de/downloads/report2.PNG "250") [ ![250](http://www.lanconnectionhh.de/downloads/report3.PNG) ](http://www.lanconnectionhh.de/downloads/report3.PNG "250") They show the configuration of one of the products in the report. the general report is set to a table form. The products are set to "this month" as timescale and "orders" as value. I hope it will clear up what i mean. Anyway thanks for the help ![:-)](/media/kunena/emoticons/9.png ":-)"). Greetings NewAge Last edit: 12 years 6 months ago by [NewAgeWarrior](/forum/user/31640-newagewarrior "View NewAgeWarrior's Profile"). Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM2LXJlcG9ydHMtc3RhdGlzdGljcy84NjcyMzktbnVtYmVyLW9mLXByb2R1Y3Qtb3JkZXJzLW5vdC1zaG93aW5nLWNvcnJlY3RseT90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[JohnA](/forum/user/32238-johna "View JohnA's Profile")** - [![JohnA's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/32238-johna "View JohnA's Profile") - [ Offline](/forum/user/32238-johna) Less More- Posts: 2 - Thank you received: 0 - - 12 years 6 months ago [\#152562](#152562) by [JohnA](/forum/user/32238-johna "View JohnA's Profile") Replied by *[JohnA](/forum/user/32238-johna "View JohnA's Profile")* on topic *[Number of Product Orders not showing correctly](/forum/36-reports-statistics/867239-number-of-product-orders-not-showing-correctly#152562 "-- HikaShop version -- : 2.3.0 -- Joomla version -- : 3.2.3 -- Browser(s) name and version -- : Chrome Version 33.0.1750.154 m Hello, I have a sales report on my site which should show the quantity sold of a product in a period of time. The problem is the report is not showing the exact quantity of a product sold but only how often it is included in an order. Like this: Client 1 orders 2 pieces of product X Client 2 orders 1 piece of product X The quantity sold of product X is 3 an it was order 2 times. The sales report now should show that the exact quantity sold in this month is 3 right? But instead it shows that the quantity sold is 2 because it was ordered 2 times. It displays the times the product were orderd not the qunatity that were orderd. But i need the exact amount of products sold not the amount of times someone has orderd it.. Greetings NewAge")* The problem seems to be with the Table Display option. If I select Column for the Display option, the result shows the quantity of products sold in each time interval (though not in total). If I select Listing for the Display option, the result shows the quantity of products sold and the total sales value. If I select Table for the Display option, the result shows the number of orders. (Some orders are for five or more of the same product). Screenshots for these reports are attached. They all cover the same period and were constructed as far as possible in the same way. The heading "Orders" causes some confusion. "Products ordered" or "Products sold" might be better. John - [ ![h5510338.png](/forum/attachment/16761) ](/forum/attachment/16761 "h5510338.png") [ ](/forum/attachment/16761?download=1 "h5510338.png") - [ ![h3dfd808.png](/forum/attachment/16762) ](/forum/attachment/16762 "h3dfd808.png") [ ](/forum/attachment/16762?download=1 "h3dfd808.png") - [ ![h028dc7f.png](/forum/attachment/16763) ](/forum/attachment/16763 "h028dc7f.png") [ ](/forum/attachment/16763?download=1 "h028dc7f.png") Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM2LXJlcG9ydHMtc3RhdGlzdGljcy84NjcyMzktbnVtYmVyLW9mLXByb2R1Y3Qtb3JkZXJzLW5vdC1zaG93aW5nLWNvcnJlY3RseT90bXBsPW1hcmtkb3du) 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)](/forum/user/63-nicolas "View nicolas's Profile") - [ Away](/forum/user/63-nicolas) Less More- Posts: 86279 - Thank you received: 14262 - - 12 years 6 months ago [\#152754](#152754) 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 Product Orders not showing correctly](/forum/36-reports-statistics/867239-number-of-product-orders-not-showing-correctly#152754 "-- HikaShop version -- : 2.3.0 -- Joomla version -- : 3.2.3 -- Browser(s) name and version -- : Chrome Version 33.0.1750.154 m Hello, I have a sales report on my site which should show the quantity sold of a product in a period of time. The problem is the report is not showing the exact quantity of a product sold but only how often it is included in an order. Like this: Client 1 orders 2 pieces of product X Client 2 orders 1 piece of product X The quantity sold of product X is 3 an it was order 2 times. The sales report now should show that the exact quantity sold in this month is 3 right? But instead it shows that the quantity sold is 2 because it was ordered 2 times. It displays the times the product were orderd not the qunatity that were orderd. But i need the exact amount of products sold not the amount of times someone has orderd it.. Greetings NewAge")* Hi, I checked more in depth the issue (not easy with German text in the screenshots) and it appears that you selected "orders" in the "type" option of your table entry instead of selecting "sales" (the second one). Because of that it indeed display the number of orders with that product instead of displaying the total of the products bought. I think I found a solution. Replace the code: Code: $select.='COUNT(DISTINCT(a.order_id)) as Total, a.order_currency_id'; with: Code: if(isset($widget->widget_params->filters['prod.product_id'])){ $select .='SUM(prod.order_product_quantity) AS Total, a.order_currency_id'; }else{ $select.='COUNT(DISTINCT(a.order_id)) as Total, a.order_currency_id'; } in the file administrator/components/com_hikashop/classes/widget.php and that should work like you expect it to. The following user(s) said Thank You: [JohnA](/forum/user/32238-johna "View JohnA's Profile") Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM2LXJlcG9ydHMtc3RhdGlzdGljcy84NjcyMzktbnVtYmVyLW9mLXByb2R1Y3Qtb3JkZXJzLW5vdC1zaG93aW5nLWNvcnJlY3RseT90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[JohnA](/forum/user/32238-johna "View JohnA's Profile")** - [![JohnA's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/32238-johna "View JohnA's Profile") - [ Offline](/forum/user/32238-johna) Less More- Posts: 2 - Thank you received: 0 - - 12 years 6 months ago [\#153049](#153049) by [JohnA](/forum/user/32238-johna "View JohnA's Profile") Replied by *[JohnA](/forum/user/32238-johna "View JohnA's Profile")* on topic *[Number of Product Orders not showing correctly](/forum/36-reports-statistics/867239-number-of-product-orders-not-showing-correctly#153049 "-- HikaShop version -- : 2.3.0 -- Joomla version -- : 3.2.3 -- Browser(s) name and version -- : Chrome Version 33.0.1750.154 m Hello, I have a sales report on my site which should show the quantity sold of a product in a period of time. The problem is the report is not showing the exact quantity of a product sold but only how often it is included in an order. Like this: Client 1 orders 2 pieces of product X Client 2 orders 1 piece of product X The quantity sold of product X is 3 an it was order 2 times. The sales report now should show that the exact quantity sold in this month is 3 right? But instead it shows that the quantity sold is 2 because it was ordered 2 times. It displays the times the product were orderd not the qunatity that were orderd. But i need the exact amount of products sold not the amount of times someone has orderd it.. Greetings NewAge")* Hi Nicolas, That fixed it thank you! Kind regards, John Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM2LXJlcG9ydHMtc3RhdGlzdGljcy84NjcyMzktbnVtYmVyLW9mLXByb2R1Y3Qtb3JkZXJzLW5vdC1zaG93aW5nLWNvcnJlY3RseT90bXBsPW1hcmtkb3du) 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.355 seconds [Powered by](/forum/credits) [Kunena Forum](https://www.kunena.org) [](#top)