[Skip to main content](#vessel-content) # Report sold items gives wrong number ## - **[gasoline](/forum/user/6454-gasoline "View gasoline's Profile")** - [![gasoline's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar6454.jpg)](/forum/user/6454-gasoline "View gasoline's Profile") Topic Author - [ Offline](/forum/user/6454-gasoline) - Still searching ... Less More - Posts: 247 - Thank you received: 9 - - - - [](https://gasoline.nl) - 8 years 2 months ago [\#297531](#297531) by [gasoline](/forum/user/6454-gasoline "View gasoline's Profile") *[Report sold items gives wrong number](/forum/36-reports-statistics/895649-report-sold-items-gives-wrong-number#297531 "-- HikaShop version -- : 3.5.1 -- Joomla version -- : 3.8.12 -- PHP version -- : 7.1.21 Some products are displayed in 2 categories. When client makes a report he gets a wrong number. The wright number should be Any idea what is going wrong here? Shows 3 products sold = correct Shows 6 orders, while there are only 3 orders. So also Total sales is double")* was created by *[gasoline](/forum/user/6454-gasoline "View gasoline's Profile")* -- HikaShop version -- : 3.5.1 -- Joomla version -- : 3.8.12 -- PHP version -- : 7.1.21 Some products are displayed in 2 categories. When client makes a report he gets a wrong number. The wright number should be **3** Any idea what is going wrong here? Shows 3 products sold = correct [ ![1-orders.jpg](/forum/attachment/44762) ](/forum/attachment/44762 "1-orders.jpg") Shows 6 orders, while there are only 3 orders. So also Total sales is double [ ![2-products.jpg](/forum/attachment/44763) ](/forum/attachment/44763 "2-products.jpg") --- I'll keep on trying! - [ ![1-orders.jpg](/forum/attachment/44762) ](/forum/attachment/44762 "1-orders.jpg") [ ](/forum/attachment/44762?download=1 "1-orders.jpg") - [ ![2-products.jpg](/forum/attachment/44763) ](/forum/attachment/44763 "2-products.jpg") [ ](/forum/attachment/44763?download=1 "2-products.jpg") Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM2LXJlcG9ydHMtc3RhdGlzdGljcy84OTU2NDktcmVwb3J0LXNvbGQtaXRlbXMtZ2l2ZXMtd3JvbmctbnVtYmVyP3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[Philip](/forum/user/34318-philip "View Philip's Profile")** - [![Philip's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/34318-philip "View Philip's Profile") - [ Offline](/forum/user/34318-philip) Less More - Posts: 4820 - Thank you received: 652 - - 8 years 2 months ago - 8 years 2 months ago [\#297551](#297551) by [Philip](/forum/user/34318-philip "View Philip's Profile") Replied by *[Philip](/forum/user/34318-philip "View Philip's Profile")* on topic *[Report sold items gives wrong number](/forum/36-reports-statistics/895649-report-sold-items-gives-wrong-number#297551 "-- HikaShop version -- : 3.5.1 -- Joomla version -- : 3.8.12 -- PHP version -- : 7.1.21 Some products are displayed in 2 categories. When client makes a report he gets a wrong number. The wright number should be Any idea what is going wrong here? Shows 3 products sold = correct Shows 6 orders, while there are only 3 orders. So also Total sales is double")* Hello, From your settings screenshot something **but can't be sure** I guess that means that you have **3 orders confirrmed** (paid) with this product and **6** order from **all** order status **created** (not paid) or even **cancelled** **plus** your **3** order **confirmed** (paid). Can you check that I'm right because **without seeing your order listening** I'm just able to make a guess. Regards Last edit: 8 years 2 months ago by [Philip](/forum/user/34318-philip "View Philip's Profile"). Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM2LXJlcG9ydHMtc3RhdGlzdGljcy84OTU2NDktcmVwb3J0LXNvbGQtaXRlbXMtZ2l2ZXMtd3JvbmctbnVtYmVyP3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[gasoline](/forum/user/6454-gasoline "View gasoline's Profile")** - [![gasoline's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar6454.jpg)](/forum/user/6454-gasoline "View gasoline's Profile") Topic Author - [ Offline](/forum/user/6454-gasoline) - Still searching ... Less More - Posts: 247 - Thank you received: 9 - - - - [](https://gasoline.nl) - 8 years 2 months ago [\#297566](#297566) by [gasoline](/forum/user/6454-gasoline "View gasoline's Profile") Replied by *[gasoline](/forum/user/6454-gasoline "View gasoline's Profile")* on topic *[Report sold items gives wrong number](/forum/36-reports-statistics/895649-report-sold-items-gives-wrong-number#297566 "-- HikaShop version -- : 3.5.1 -- Joomla version -- : 3.8.12 -- PHP version -- : 7.1.21 Some products are displayed in 2 categories. When client makes a report he gets a wrong number. The wright number should be Any idea what is going wrong here? Shows 3 products sold = correct Shows 6 orders, while there are only 3 orders. So also Total sales is double")* > Philip wrote: Hello, > > From your settings screenshot something **but can't be sure** I guess that means that you have **3 orders confirrmed** (paid) with this product and **6** order from **all** order status **created** (not paid) or even **cancelled** **plus** your **3** order **confirmed** (paid). > > Can you check that I'm right because **without seeing your order listening** I'm just able to make a guess. > > Regards Hi Philip, Thanks, that could be maybe possible. I can't see more orders (cancelled/refund, etc). But client made 'mistake' few weeks ago and DELETED orders. So they are NOT in system anymore to be visible. But maybe somewhere in the database these orders are still counted? I already told them never do that again and just use Hikashop for handling refunds, cancellations etc. I'll keep an eye on it and will check in the near future with new orders if I can see what will happen. --- I'll keep on trying! Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM2LXJlcG9ydHMtc3RhdGlzdGljcy84OTU2NDktcmVwb3J0LXNvbGQtaXRlbXMtZ2l2ZXMtd3JvbmctbnVtYmVyP3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[Philip](/forum/user/34318-philip "View Philip's Profile")** - [![Philip's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/34318-philip "View Philip's Profile") - [ Offline](/forum/user/34318-philip) Less More - Posts: 4820 - Thank you received: 652 - - 8 years 2 months ago - 8 years 2 months ago [\#297567](#297567) by [Philip](/forum/user/34318-philip "View Philip's Profile") Replied by *[Philip](/forum/user/34318-philip "View Philip's Profile")* on topic *[Report sold items gives wrong number](/forum/36-reports-statistics/895649-report-sold-items-gives-wrong-number#297567 "-- HikaShop version -- : 3.5.1 -- Joomla version -- : 3.8.12 -- PHP version -- : 7.1.21 Some products are displayed in 2 categories. When client makes a report he gets a wrong number. The wright number should be Any idea what is going wrong here? Shows 3 products sold = correct Shows 6 orders, while there are only 3 orders. So also Total sales is double")* Hello, For your last point the most important point is for us to know **how your customer delete these orders** because if it's directly in the database that may break **database bridge** and allow this kind of non consistent results. On the other hand, delete orders from the HikaShop backend will leads **to delete them as well on the database**. Hope this will help you to progress on your subject. Regards Last edit: 8 years 2 months ago by [Philip](/forum/user/34318-philip "View Philip's Profile"). Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM2LXJlcG9ydHMtc3RhdGlzdGljcy84OTU2NDktcmVwb3J0LXNvbGQtaXRlbXMtZ2l2ZXMtd3JvbmctbnVtYmVyP3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[gasoline](/forum/user/6454-gasoline "View gasoline's Profile")** - [![gasoline's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar6454.jpg)](/forum/user/6454-gasoline "View gasoline's Profile") Topic Author - [ Offline](/forum/user/6454-gasoline) - Still searching ... Less More - Posts: 247 - Thank you received: 9 - - - - [](https://gasoline.nl) - 8 years 2 months ago [\#297598](#297598) by [gasoline](/forum/user/6454-gasoline "View gasoline's Profile") Replied by *[gasoline](/forum/user/6454-gasoline "View gasoline's Profile")* on topic *[Report sold items gives wrong number](/forum/36-reports-statistics/895649-report-sold-items-gives-wrong-number#297598 "-- HikaShop version -- : 3.5.1 -- Joomla version -- : 3.8.12 -- PHP version -- : 7.1.21 Some products are displayed in 2 categories. When client makes a report he gets a wrong number. The wright number should be Any idea what is going wrong here? Shows 3 products sold = correct Shows 6 orders, while there are only 3 orders. So also Total sales is double")* He has deleted them with Hikashop. So there should be no conflicting reports? [ ![deleting-orders.jpg](/forum/attachment/44784) ](/forum/attachment/44784 "...ing-orders.jpg") --- I'll keep on trying! - [ ![deleting-orders.jpg](/forum/attachment/44784) ](/forum/attachment/44784 "...ing-orders.jpg") [ ](/forum/attachment/44784?download=1 "...ing-orders.jpg") Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM2LXJlcG9ydHMtc3RhdGlzdGljcy84OTU2NDktcmVwb3J0LXNvbGQtaXRlbXMtZ2l2ZXMtd3JvbmctbnVtYmVyP3RtcGw9bWFya2Rvd24=) 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 - - - 8 years 2 months ago [\#297612](#297612) 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 *[Report sold items gives wrong number](/forum/36-reports-statistics/895649-report-sold-items-gives-wrong-number#297612 "-- HikaShop version -- : 3.5.1 -- Joomla version -- : 3.8.12 -- PHP version -- : 7.1.21 Some products are displayed in 2 categories. When client makes a report he gets a wrong number. The wright number should be Any idea what is going wrong here? Shows 3 products sold = correct Shows 6 orders, while there are only 3 orders. So also Total sales is double")* Hello, > He has deleted them with Hikashop. So there should be no conflicting reports? If you delete orders via "Hikashop->Orders", it will delete datas of your order through your database and you won't have any trace of that order. If you want to display product from "confirmed" / "paid" orders, you'll just have to set the "Order status" option of your report to "confirmed". Kind regards, Mohamed Thelji. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM2LXJlcG9ydHMtc3RhdGlzdGljcy84OTU2NDktcmVwb3J0LXNvbGQtaXRlbXMtZ2l2ZXMtd3JvbmctbnVtYmVyP3RtcGw9bWFya2Rvd24=) 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.102 seconds [Powered by](/forum/credits) [Kunena Forum](https://www.kunena.org)