[Skip to main content](#vessel-content)

#   Best selling products statistic does not work prop

##

- **[lacasetta](/forum/user/5505-lacasetta "View lacasetta's Profile")**
- [![lacasetta's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar5505.jpg)](/forum/user/5505-lacasetta "View lacasetta's Profile") Topic Author
- [ Offline](/forum/user/5505-lacasetta)

Less More

- Posts: 719
- Thank you received: 3
-
-
-
- [](http://www.lacasettabio.it)
-

12 years 1 month ago [\#173684](#173684) by [lacasetta](/forum/user/5505-lacasetta "View lacasetta's Profile")  *[Best selling products statistic does not work prop](/forum/36-reports-statistics/871974-best-selling-products-statistic-does-not-work-prop#173684 "-- HikaShop version -- : 2.3.3  Hi i noticed something wrong on the best selling products statistic. I have the total amount of some products too big. I have not sold all those products! Do you have notice of the same issue with other users? If not, could you explain better how does that type of statistic works? For example when the amount is update? If i try to make an order just for a test i don't see the amount update.")* was created by *[lacasetta](/forum/user/5505-lacasetta "View lacasetta's Profile")*

-- HikaShop version -- : 2.3.3

Hi i noticed something wrong on the best selling products statistic.
I have the total amount of some products too big. I have not sold all those products!
Do you have notice of the same issue with other users?
If not, could you explain better how does that type of statistic works?
For example when the amount is update?
If i try to make an order just for a test i don't see the amount update.

---

my site with Hikashop
[ www.lacasettabio.it](http://www.lacasettabio.it)

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM2LXJlcG9ydHMtc3RhdGlzdGljcy84NzE5NzQtYmVzdC1zZWxsaW5nLXByb2R1Y3RzLXN0YXRpc3RpYy1kb2VzLW5vdC13b3JrLXByb3A/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation.

- **[Xavier](/forum/user/4105-xavier "View Xavier's Profile")**
- [![Xavier's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar4105.png)](/forum/user/4105-xavier "View Xavier's Profile")
- [ Offline](/forum/user/4105-xavier)

Less More

- Posts: 13201
- Thank you received: 2322
-
-
-
- [](http://www.kidiweb.fr)
-

12 years 1 month ago [\#173701](#173701) by [Xavier](/forum/user/4105-xavier "View Xavier's Profile")  Replied by *[Xavier](/forum/user/4105-xavier "View Xavier's Profile")* on topic *[Best selling products statistic does not work prop](/forum/36-reports-statistics/871974-best-selling-products-statistic-does-not-work-prop#173701 "-- HikaShop version -- : 2.3.3  Hi i noticed something wrong on the best selling products statistic. I have the total amount of some products too big. I have not sold all those products! Do you have notice of the same issue with other users? If not, could you explain better how does that type of statistic works? For example when the amount is update? If i try to make an order just for a test i don't see the amount update.")*

Hi,

Thanks to give us a screenshot of you report configuration in order to try to reproduce the issue on our end.
The amount should be updated once the order has a confirmed status.

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM2LXJlcG9ydHMtc3RhdGlzdGljcy84NzE5NzQtYmVzdC1zZWxsaW5nLXByb2R1Y3RzLXN0YXRpc3RpYy1kb2VzLW5vdC13b3JrLXByb3A/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation.

- **[lacasetta](/forum/user/5505-lacasetta "View lacasetta's Profile")**
- [![lacasetta's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar5505.jpg)](/forum/user/5505-lacasetta "View lacasetta's Profile") Topic Author
- [ Offline](/forum/user/5505-lacasetta)

Less More

- Posts: 719
- Thank you received: 3
-
-
-
- [](http://www.lacasettabio.it)
-

12 years 1 month ago [\#173822](#173822) by [lacasetta](/forum/user/5505-lacasetta "View lacasetta's Profile")  Replied by *[lacasetta](/forum/user/5505-lacasetta "View lacasetta's Profile")* on topic *[Best selling products statistic does not work prop](/forum/36-reports-statistics/871974-best-selling-products-statistic-does-not-work-prop#173822 "-- HikaShop version -- : 2.3.3  Hi i noticed something wrong on the best selling products statistic. I have the total amount of some products too big. I have not sold all those products! Do you have notice of the same issue with other users? If not, could you explain better how does that type of statistic works? For example when the amount is update? If i try to make an order just for a test i don't see the amount update.")*

Hi,
here you are the screenshot.

---

my site with Hikashop
[ www.lacasettabio.it](http://www.lacasettabio.it)

- [ ![Senza-titolo-1&#95;2014-10-01.jpg](/forum/attachment/19888) ](/forum/attachment/19888 "...2014-10-01.jpg") [ ](/forum/attachment/19888?download=1 "...2014-10-01.jpg")

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM2LXJlcG9ydHMtc3RhdGlzdGljcy84NzE5NzQtYmVzdC1zZWxsaW5nLXByb2R1Y3RzLXN0YXRpc3RpYy1kb2VzLW5vdC13b3JrLXByb3A/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation.

- **[Xavier](/forum/user/4105-xavier "View Xavier's Profile")**
- [![Xavier's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar4105.png)](/forum/user/4105-xavier "View Xavier's Profile")
- [ Offline](/forum/user/4105-xavier)

Less More

- Posts: 13201
- Thank you received: 2322
-
-
-
- [](http://www.kidiweb.fr)
-

12 years 1 month ago [\#173934](#173934) by [Xavier](/forum/user/4105-xavier "View Xavier's Profile")  Replied by *[Xavier](/forum/user/4105-xavier "View Xavier's Profile")* on topic *[Best selling products statistic does not work prop](/forum/36-reports-statistics/871974-best-selling-products-statistic-does-not-work-prop#173934 "-- HikaShop version -- : 2.3.3  Hi i noticed something wrong on the best selling products statistic. I have the total amount of some products too big. I have not sold all those products! Do you have notice of the same issue with other users? If not, could you explain better how does that type of statistic works? For example when the amount is update? If i try to make an order just for a test i don't see the amount update.")*

Hi,

In the filter of this report you don't have selected an order status, so all the products of all the orders statuses are displayed.
Even products in cancelled, or created orders, so as you said it don't represent the sol products.

You just have to add more conditions in the filters.

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM2LXJlcG9ydHMtc3RhdGlzdGljcy84NzE5NzQtYmVzdC1zZWxsaW5nLXByb2R1Y3RzLXN0YXRpc3RpYy1kb2VzLW5vdC13b3JrLXByb3A/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation.

- **[lacasetta](/forum/user/5505-lacasetta "View lacasetta's Profile")**
- [![lacasetta's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar5505.jpg)](/forum/user/5505-lacasetta "View lacasetta's Profile") Topic Author
- [ Offline](/forum/user/5505-lacasetta)

Less More

- Posts: 719
- Thank you received: 3
-
-
-
- [](http://www.lacasettabio.it)
-

12 years 1 month ago [\#174014](#174014) by [lacasetta](/forum/user/5505-lacasetta "View lacasetta's Profile")  Replied by *[lacasetta](/forum/user/5505-lacasetta "View lacasetta's Profile")* on topic *[Best selling products statistic does not work prop](/forum/36-reports-statistics/871974-best-selling-products-statistic-does-not-work-prop#174014 "-- HikaShop version -- : 2.3.3  Hi i noticed something wrong on the best selling products statistic. I have the total amount of some products too big. I have not sold all those products! Do you have notice of the same issue with other users? If not, could you explain better how does that type of statistic works? For example when the amount is update? If i try to make an order just for a test i don't see the amount update.")*

Hi,
it was setted on shipped.
On the screenshot i did not scroll down the menù.

---

my site with Hikashop
[ www.lacasettabio.it](http://www.lacasettabio.it)

- [ ![Senza-titolo-1&#95;2014-10-02.jpg](/forum/attachment/19911) ](/forum/attachment/19911 "...2014-10-02.jpg") [ ](/forum/attachment/19911?download=1 "...2014-10-02.jpg")

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM2LXJlcG9ydHMtc3RhdGlzdGljcy84NzE5NzQtYmVzdC1zZWxsaW5nLXByb2R1Y3RzLXN0YXRpc3RpYy1kb2VzLW5vdC13b3JrLXByb3A/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation.

- **[lacasetta](/forum/user/5505-lacasetta "View lacasetta's Profile")**
- [![lacasetta's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar5505.jpg)](/forum/user/5505-lacasetta "View lacasetta's Profile") Topic Author
- [ Offline](/forum/user/5505-lacasetta)

Less More

- Posts: 719
- Thank you received: 3
-
-
-
- [](http://www.lacasettabio.it)
-

12 years 1 month ago -  12 years 1 month ago [\#174015](#174015) by [lacasetta](/forum/user/5505-lacasetta "View lacasetta's Profile")  Replied by *[lacasetta](/forum/user/5505-lacasetta "View lacasetta's Profile")* on topic *[Best selling products statistic does not work prop](/forum/36-reports-statistics/871974-best-selling-products-statistic-does-not-work-prop#174015 "-- HikaShop version -- : 2.3.3  Hi i noticed something wrong on the best selling products statistic. I have the total amount of some products too big. I have not sold all those products! Do you have notice of the same issue with other users? If not, could you explain better how does that type of statistic works? For example when the amount is update? If i try to make an order just for a test i don't see the amount update.")*

So,
now i tested better it.
I buy two pcs of a same product, the total amount is 26 Euro.
The total amount on the statistic, before the purchase is 490 Euro.
When i set the order on shipped the amount on the statistic is 672 Euro!!!!!
if i set the order on cancelled the statistic amount come back on 490 Euro.

So the system adds 182 Euro insted of 26 :ohmy:

---

my site with Hikashop
[ www.lacasettabio.it](http://www.lacasettabio.it)

Last edit: 12 years 1 month ago by [lacasetta](/forum/user/5505-lacasetta "View lacasetta's Profile").

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM2LXJlcG9ydHMtc3RhdGlzdGljcy84NzE5NzQtYmVzdC1zZWxsaW5nLXByb2R1Y3RzLXN0YXRpc3RpYy1kb2VzLW5vdC13b3JrLXByb3A/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation.

- **[Jerome](/forum/user/80-jerome "View Jerome's Profile")**
- [![Jerome's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar80.png)](/forum/user/80-jerome "View Jerome's Profile")
- [ Offline](/forum/user/80-jerome)
- HikaShop core developer

Less More

- Posts: 26400
- Thank you received: 4080
-
- [](http://obsi.dev)
-

12 years 1 month ago [\#174117](#174117) by [Jerome](/forum/user/80-jerome "View Jerome's Profile")  Replied by *[Jerome](/forum/user/80-jerome "View Jerome's Profile")* on topic *[Best selling products statistic does not work prop](/forum/36-reports-statistics/871974-best-selling-products-statistic-does-not-work-prop#174117 "-- HikaShop version -- : 2.3.3  Hi i noticed something wrong on the best selling products statistic. I have the total amount of some products too big. I have not sold all those products! Do you have notice of the same issue with other users? If not, could you explain better how does that type of statistic works? For example when the amount is update? If i try to make an order just for a test i don't see the amount update.")*

Hi,

Can you please edit the file "administrator/components/com_hikashop/helpers/widget.php" and replace Code:

$query='SELECT *, '.$dataType.' as Total, COUNT(a.order_id) AS quantity FROM '.hikashop_table('order_product').' AS prod LEFT JOIN '.hikashop_table('order').' AS a on a.order_id=prod.order_id ' .$leftjoin.' '.$filters.' GROUP BY prod.order_product_name ORDER BY Total '.$order.' '.$limit; $db-&gt;setQuery($query);

By Code:

$query='SELECT *, '.$dataType.' as Total, COUNT(a.order_id) AS quantity FROM '.hikashop_table('order_product').' AS prod LEFT JOIN '.hikashop_table('order').' AS a on a.order_id=prod.order_id ' .$leftjoin.' '.$filters.' GROUP BY prod.product_id ORDER BY Total '.$order.' '.$limit; $db-&gt;setQuery($query);

I'm trying to reproduce your problem, I guess that a there is a aggregation missing which made a multiplication of the quantity (by 7 in your case).

Regards,

---

Jerome - Obsidev.com
HikaMarket &amp; HikaSerial developer / HikaShop core dev team.

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM2LXJlcG9ydHMtc3RhdGlzdGljcy84NzE5NzQtYmVzdC1zZWxsaW5nLXByb2R1Y3RzLXN0YXRpc3RpYy1kb2VzLW5vdC13b3JrLXByb3A/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation.

- **[lacasetta](/forum/user/5505-lacasetta "View lacasetta's Profile")**
- [![lacasetta's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar5505.jpg)](/forum/user/5505-lacasetta "View lacasetta's Profile") Topic Author
- [ Offline](/forum/user/5505-lacasetta)

Less More

- Posts: 719
- Thank you received: 3
-
-
-
- [](http://www.lacasettabio.it)
-

12 years 1 month ago [\#174188](#174188) by [lacasetta](/forum/user/5505-lacasetta "View lacasetta's Profile")  Replied by *[lacasetta](/forum/user/5505-lacasetta "View lacasetta's Profile")* on topic *[Best selling products statistic does not work prop](/forum/36-reports-statistics/871974-best-selling-products-statistic-does-not-work-prop#174188 "-- HikaShop version -- : 2.3.3  Hi i noticed something wrong on the best selling products statistic. I have the total amount of some products too big. I have not sold all those products! Do you have notice of the same issue with other users? If not, could you explain better how does that type of statistic works? For example when the amount is update? If i try to make an order just for a test i don't see the amount update.")*

Hi,
i'm sorry but i don't have that file, as you can see on the screenshot attached here.

If it can to help you, the product where i had the test is that: [ www.lacasettabio.it/negozio-online/prodo...libro-vendita-online](http://www.lacasettabio.it/negozio-online/prodotto/il-meraviglioso-mondo-dei-peperoncini-piccanti-libro-vendita-online)

---

my site with Hikashop
[ www.lacasettabio.it](http://www.lacasettabio.it)

- [ ![Senza-titolo-1&#95;2014-10-03.jpg](/forum/attachment/19935) ](/forum/attachment/19935 "...2014-10-03.jpg") [ ](/forum/attachment/19935?download=1 "...2014-10-03.jpg")

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM2LXJlcG9ydHMtc3RhdGlzdGljcy84NzE5NzQtYmVzdC1zZWxsaW5nLXByb2R1Y3RzLXN0YXRpc3RpYy1kb2VzLW5vdC13b3JrLXByb3A/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation.

- **[Xavier](/forum/user/4105-xavier "View Xavier's Profile")**
- [![Xavier's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar4105.png)](/forum/user/4105-xavier "View Xavier's Profile")
- [ Offline](/forum/user/4105-xavier)

Less More

- Posts: 13201
- Thank you received: 2322
-
-
-
- [](http://www.kidiweb.fr)
-

12 years 1 month ago [\#174201](#174201) by [Xavier](/forum/user/4105-xavier "View Xavier's Profile")  Replied by *[Xavier](/forum/user/4105-xavier "View Xavier's Profile")* on topic *[Best selling products statistic does not work prop](/forum/36-reports-statistics/871974-best-selling-products-statistic-does-not-work-prop#174201 "-- HikaShop version -- : 2.3.3  Hi i noticed something wrong on the best selling products statistic. I have the total amount of some products too big. I have not sold all those products! Do you have notice of the same issue with other users? If not, could you explain better how does that type of statistic works? For example when the amount is update? If i try to make an order just for a test i don't see the amount update.")*

Hi,

Jérome was talking about the file "administrator/components/com_hikashop/classes/widget.php"

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM2LXJlcG9ydHMtc3RhdGlzdGljcy84NzE5NzQtYmVzdC1zZWxsaW5nLXByb2R1Y3RzLXN0YXRpc3RpYy1kb2VzLW5vdC13b3JrLXByb3A/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation.

- **[lacasetta](/forum/user/5505-lacasetta "View lacasetta's Profile")**
- [![lacasetta's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar5505.jpg)](/forum/user/5505-lacasetta "View lacasetta's Profile") Topic Author
- [ Offline](/forum/user/5505-lacasetta)

Less More

- Posts: 719
- Thank you received: 3
-
-
-
- [](http://www.lacasettabio.it)
-

12 years 1 month ago [\#174315](#174315) by [lacasetta](/forum/user/5505-lacasetta "View lacasetta's Profile")  Replied by *[lacasetta](/forum/user/5505-lacasetta "View lacasetta's Profile")* on topic *[Best selling products statistic does not work prop](/forum/36-reports-statistics/871974-best-selling-products-statistic-does-not-work-prop#174315 "-- HikaShop version -- : 2.3.3  Hi i noticed something wrong on the best selling products statistic. I have the total amount of some products too big. I have not sold all those products! Do you have notice of the same issue with other users? If not, could you explain better how does that type of statistic works? For example when the amount is update? If i try to make an order just for a test i don't see the amount update.")*

ok, now, yes, I found it.
But I find the file already modified. Namely in the version hikashop_business_v2.3.3_2014-09-29_07-13-52 the change was made

---

my site with Hikashop
[ www.lacasettabio.it](http://www.lacasettabio.it)

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM2LXJlcG9ydHMtc3RhdGlzdGljcy84NzE5NzQtYmVzdC1zZWxsaW5nLXByb2R1Y3RzLXN0YXRpc3RpYy1kb2VzLW5vdC13b3JrLXByb3A/dG1wbD1tYXJrZG93bg==) 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: 86555
- Thank you received: 14304
-
-

12 years 1 month ago [\#174414](#174414) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile")  Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Best selling products statistic does not work prop](/forum/36-reports-statistics/871974-best-selling-products-statistic-does-not-work-prop#174414 "-- HikaShop version -- : 2.3.3  Hi i noticed something wrong on the best selling products statistic. I have the total amount of some products too big. I have not sold all those products! Do you have notice of the same issue with other users? If not, could you explain better how does that type of statistic works? For example when the amount is update? If i try to make an order just for a test i don't see the amount update.")*

Ok. Then please replace the file administrator/components/com_hikashop/classes/widget.php with the one in this archive and see if that helps.

*This attachment is hidden for guests.
Please log in or register to see it.*

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM2LXJlcG9ydHMtc3RhdGlzdGljcy84NzE5NzQtYmVzdC1zZWxsaW5nLXByb2R1Y3RzLXN0YXRpc3RpYy1kb2VzLW5vdC13b3JrLXByb3A/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation.

- **[lacasetta](/forum/user/5505-lacasetta "View lacasetta's Profile")**
- [![lacasetta's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar5505.jpg)](/forum/user/5505-lacasetta "View lacasetta's Profile") Topic Author
- [ Offline](/forum/user/5505-lacasetta)

Less More

- Posts: 719
- Thank you received: 3
-
-
-
- [](http://www.lacasettabio.it)
-

12 years 1 month ago [\#174441](#174441) by [lacasetta](/forum/user/5505-lacasetta "View lacasetta's Profile")  Replied by *[lacasetta](/forum/user/5505-lacasetta "View lacasetta's Profile")* on topic *[Best selling products statistic does not work prop](/forum/36-reports-statistics/871974-best-selling-products-statistic-does-not-work-prop#174441 "-- HikaShop version -- : 2.3.3  Hi i noticed something wrong on the best selling products statistic. I have the total amount of some products too big. I have not sold all those products! Do you have notice of the same issue with other users? If not, could you explain better how does that type of statistic works? For example when the amount is update? If i try to make an order just for a test i don't see the amount update.")*

Hi,
I'm sorry, the result does not change
![:(](/media/kunena/emoticons/22.png ":(")

---

my site with Hikashop
[ www.lacasettabio.it](http://www.lacasettabio.it)

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM2LXJlcG9ydHMtc3RhdGlzdGljcy84NzE5NzQtYmVzdC1zZWxsaW5nLXByb2R1Y3RzLXN0YXRpc3RpYy1kb2VzLW5vdC13b3JrLXByb3A/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation.

- **[lacasetta](/forum/user/5505-lacasetta "View lacasetta's Profile")**
- [![lacasetta's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar5505.jpg)](/forum/user/5505-lacasetta "View lacasetta's Profile") Topic Author
- [ Offline](/forum/user/5505-lacasetta)

Less More

- Posts: 719
- Thank you received: 3
-
-
-
- [](http://www.lacasettabio.it)
-

12 years 1 month ago -  12 years 1 month ago [\#174443](#174443) by [lacasetta](/forum/user/5505-lacasetta "View lacasetta's Profile")  Replied by *[lacasetta](/forum/user/5505-lacasetta "View lacasetta's Profile")* on topic *[Best selling products statistic does not work prop](/forum/36-reports-statistics/871974-best-selling-products-statistic-does-not-work-prop#174443 "-- HikaShop version -- : 2.3.3  Hi i noticed something wrong on the best selling products statistic. I have the total amount of some products too big. I have not sold all those products! Do you have notice of the same issue with other users? If not, could you explain better how does that type of statistic works? For example when the amount is update? If i try to make an order just for a test i don't see the amount update.")*

Hi,
i tried to create an identical new gadget.
Now when i have the tests
on the old one i have the issue
on the new one seems to work.
![;)](/media/kunena/emoticons/24.png ";)")

---

my site with Hikashop
[ www.lacasettabio.it](http://www.lacasettabio.it)

Last edit: 12 years 1 month ago by [lacasetta](/forum/user/5505-lacasetta "View lacasetta's Profile").

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM2LXJlcG9ydHMtc3RhdGlzdGljcy84NzE5NzQtYmVzdC1zZWxsaW5nLXByb2R1Y3RzLXN0YXRpc3RpYy1kb2VzLW5vdC13b3JrLXByb3A/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation.

- **[lacasetta](/forum/user/5505-lacasetta "View lacasetta's Profile")**
- [![lacasetta's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar5505.jpg)](/forum/user/5505-lacasetta "View lacasetta's Profile") Topic Author
- [ Offline](/forum/user/5505-lacasetta)

Less More

- Posts: 719
- Thank you received: 3
-
-
-
- [](http://www.lacasettabio.it)
-

12 years 1 month ago [\#174444](#174444) by [lacasetta](/forum/user/5505-lacasetta "View lacasetta's Profile")  Replied by *[lacasetta](/forum/user/5505-lacasetta "View lacasetta's Profile")* on topic *[Best selling products statistic does not work prop](/forum/36-reports-statistics/871974-best-selling-products-statistic-does-not-work-prop#174444 "-- HikaShop version -- : 2.3.3  Hi i noticed something wrong on the best selling products statistic. I have the total amount of some products too big. I have not sold all those products! Do you have notice of the same issue with other users? If not, could you explain better how does that type of statistic works? For example when the amount is update? If i try to make an order just for a test i don't see the amount update.")*

Could you explain what is "Data type" &gt; Created or &gt; Last Modified
on the Display box, please?
Thanks

---

my site with Hikashop
[ www.lacasettabio.it](http://www.lacasettabio.it)

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM2LXJlcG9ydHMtc3RhdGlzdGljcy84NzE5NzQtYmVzdC1zZWxsaW5nLXByb2R1Y3RzLXN0YXRpc3RpYy1kb2VzLW5vdC13b3JrLXByb3A/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation.

- **[Jerome](/forum/user/80-jerome "View Jerome's Profile")**
- [![Jerome's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar80.png)](/forum/user/80-jerome "View Jerome's Profile")
- [ Offline](/forum/user/80-jerome)
- HikaShop core developer

Less More

- Posts: 26400
- Thank you received: 4080
-
- [](http://obsi.dev)
-

12 years 1 month ago [\#174523](#174523) by [Jerome](/forum/user/80-jerome "View Jerome's Profile")  Replied by *[Jerome](/forum/user/80-jerome "View Jerome's Profile")* on topic *[Best selling products statistic does not work prop](/forum/36-reports-statistics/871974-best-selling-products-statistic-does-not-work-prop#174523 "-- HikaShop version -- : 2.3.3  Hi i noticed something wrong on the best selling products statistic. I have the total amount of some products too big. I have not sold all those products! Do you have notice of the same issue with other users? If not, could you explain better how does that type of statistic works? For example when the amount is update? If i try to make an order just for a test i don't see the amount update.")*

Hi,

See : [ www.hikashop.com/support/documentation/i...hop-report-form.html](http://www.hikashop.com/support/documentation/integrated-documentation/20-hikashop/tutorials/133-hikashop-report-form.html)

Regards,

---

Jerome - Obsidev.com
HikaMarket &amp; HikaSerial developer / HikaShop core dev team.

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM2LXJlcG9ydHMtc3RhdGlzdGljcy84NzE5NzQtYmVzdC1zZWxsaW5nLXByb2R1Y3RzLXN0YXRpc3RpYy1kb2VzLW5vdC13b3JrLXByb3A/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation.

- **[lacasetta](/forum/user/5505-lacasetta "View lacasetta's Profile")**
- [![lacasetta's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar5505.jpg)](/forum/user/5505-lacasetta "View lacasetta's Profile") Topic Author
- [ Offline](/forum/user/5505-lacasetta)

Less More

- Posts: 719
- Thank you received: 3
-
-
-
- [](http://www.lacasettabio.it)
-

12 years 1 month ago [\#174586](#174586) by [lacasetta](/forum/user/5505-lacasetta "View lacasetta's Profile")  Replied by *[lacasetta](/forum/user/5505-lacasetta "View lacasetta's Profile")* on topic *[Best selling products statistic does not work prop](/forum/36-reports-statistics/871974-best-selling-products-statistic-does-not-work-prop#174586 "-- HikaShop version -- : 2.3.3  Hi i noticed something wrong on the best selling products statistic. I have the total amount of some products too big. I have not sold all those products! Do you have notice of the same issue with other users? If not, could you explain better how does that type of statistic works? For example when the amount is update? If i try to make an order just for a test i don't see the amount update.")*

Hi,
i red the tutorial...
but the instrution are
Date Type: Choose here the date type used to generate the report. :blink:

I'd like to know what is the difference between:
&gt; Created
&gt; Last Modified
Thanks

---

my site with Hikashop
[ www.lacasettabio.it](http://www.lacasettabio.it)

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM2LXJlcG9ydHMtc3RhdGlzdGljcy84NzE5NzQtYmVzdC1zZWxsaW5nLXByb2R1Y3RzLXN0YXRpc3RpYy1kb2VzLW5vdC13b3JrLXByb3A/dG1wbD1tYXJrZG93bg==) 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 1 month ago -  12 years 1 month ago [\#175560](#175560) 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 *[Best selling products statistic does not work prop](/forum/36-reports-statistics/871974-best-selling-products-statistic-does-not-work-prop#175560 "-- HikaShop version -- : 2.3.3  Hi i noticed something wrong on the best selling products statistic. I have the total amount of some products too big. I have not sold all those products! Do you have notice of the same issue with other users? If not, could you explain better how does that type of statistic works? For example when the amount is update? If i try to make an order just for a test i don't see the amount update.")*

Hello,
Sorry for the late reply, the Date Type option will enable you to choose the date which will be used to display your orders :
- Created : will display your orders on the Order creation date
- Last modified : will display your orders on the Order last modified date (the last time you modified your order).

Last edit: 12 years 1 month ago by [Mohamed Thelji](/forum/user/6861-mohamed-thelji "View Mohamed Thelji's Profile").

The following user(s) said Thank You: [lacasetta](/forum/user/5505-lacasetta "View lacasetta's Profile")

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM2LXJlcG9ydHMtc3RhdGlzdGljcy84NzE5NzQtYmVzdC1zZWxsaW5nLXByb2R1Y3RzLXN0YXRpc3RpYy1kb2VzLW5vdC13b3JrLXByb3A/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation.

Board Categories HikaShop Install &amp; Update Product &amp; Category Display Content Creation Sales and Orders Orders management Reports &amp; Statistics Customers Checkout Payment Methods Shipping Methods Import &amp; Export (CSV, XLS…) Specific Features Affilation Taxes Wishlist Vote Carousel &amp; Slider Mass Actions Filters &amp; Search Discount &amp; 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.111 seconds

[Powered by](/forum/credits) [Kunena Forum](https://www.kunena.org)
