Table Widget Bug: Sales value incorrect

  • Posts: 55
  • Thank you received: 2
  • Hikaserial Subscription
9 years 2 weeks ago #247063

-- HikaShop version -- : 2.6.4

The table widget top line says "Sales this month"
The figure shows the value of the orders BEFORE coupons have been applied, not the ACTUAL value of the sale.

Please Log in or Create an account to join the conversation.

  • Posts: 84233
  • Thank you received: 13675
  • MODERATOR
9 years 2 weeks ago #247075

Hi,

It depends how you configured the report via the menu Orders>Reports. I've checked on my end and I do have the total including coupons:
take.ms/xjWEp
So something must be different in the settings of your report.

Please Log in or Create an account to join the conversation.

  • Posts: 55
  • Thank you received: 2
  • Hikaserial Subscription
9 years 2 weeks ago #247105

So...

1) I was using the default report settings - which yours appear not to be.
2) If I change the "Include Shipping" setting to YES, it takes off the coupons... Does that seem right to you?

Perhaps you could add another setting called "Include Bananas" that could multiply any sale made on a Tuesday by the current temperature in Greenland ;)

Please Log in or Create an account to join the conversation.

  • Posts: 84233
  • Thank you received: 13675
  • MODERATOR
9 years 2 weeks ago #247134

Hi,

When you don't include the shipping, the system calculates the amount out of the product prices and quantity.
So yes, it doesn't take into account coupons in that case. It's useful for people wanting to know the amount of money sold out of the products regardless of shipping fees, coupons, etc.
I don't think that a "include bananas" option would help, but a "include coupons" might be more useful. Please understand that many people use the reporting system in order to do all kind of statistics and one option that might not seem useful to what you're doing might be used by someone else for their needs.

Please Log in or Create an account to join the conversation.

  • Posts: 55
  • Thank you received: 2
  • Hikaserial Subscription
9 years 2 weeks ago #247219

Thanks Nicolas,

I do understand that what I want isn't necessarily what other people want - I'll counter your comment with "please understand that how you label and document a feature is critically important to the usability of your software - you know what it's supposed to do as you wrote it, but we (the users) don't have the luxury of that knowledge".

Separating the various elements of a sale would be very useful (each with their own options). I noticed that even with the include shipping option selected, we have some test data where the total sales value amounts to 0.02 pence (the products, after coupons, were 1p each) but the sales widget reports 0.05 pence total. Perhaps you could publish the formula used in the help documentation and then we could understand what's being added up/taxes applied in what order etc.

Obviously, for a test, it's not that important, but I don't want real data to be over stated by 150%. If this is a rounding error, then it'll only amount to pence - I'd just like to understand it better.

Please Log in or Create an account to join the conversation.

  • Posts: 84233
  • Thank you received: 13675
  • MODERATOR
9 years 1 week ago #247224

Hi,

No worries. We welcome feedbacks and are open to improving the naming and/or the documentation when needed.

Regarding the formula used for the calculations for the reports, there is actually not one formula but many combinations of formulas based on how you configure the report.

For example if you have the include tax setting turned off or the include shipping setting turned off, the system will base his calculations on the price and quantity of the products in the hikashop_order_product table (the table storing the links between orders and products). But if both settings are turned on, the system will base his calculations on the total of the orders in the hikashop_order table where the orders themselves are stored.

The disrepency you found is probably because the total that you see for your orders on your orders listing is the rounded total.
The real total in the database has 5 decimals for better precision.
But when the report system sums the order totals, it actually sum them before rounding.

Last edit: 9 years 2 weeks ago by nicolas.

Please Log in or Create an account to join the conversation.

Time to create page: 0.061 seconds
Powered by Kunena Forum