Sales this month - Bug?

  • Posts: 101
  • Thank you received: 9
10 years 10 months ago #137735

-- url of the page with the problem -- : mywebsite.com/mypage
-- HikaShop version -- : x.x.x
-- Joomla version -- : x.x
-- PHP version -- : x.x.x
-- Browser(s) name and version -- : XXXXX x.x.x
-- Error-message(debug-mod must be tuned on) -- : Error_message

Hi,

I noticed that the amount in Sales per month decreases each few days. Is this a bug or a feature what i'm not aware of? The amount is approximately 250,- € lower than it should be if we take all sales in December. Another thing is, how can we take only the procuct prices? At the moment the product prices plus shipping is shown but shipping doesn't matter at all because the shipping costs are paid to the shipping service.

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

  • Posts: 82863
  • Thank you received: 13372
  • MODERATOR
10 years 10 months ago #137762

Hi,

Can you provide a screenshot of the options of your report and the version of Hikashop you're using ?

There is no option to not take into account the shipping if you're data is orders/sales. You would have to have your report based on the products.

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

  • Posts: 101
  • Thank you received: 9
10 years 10 months ago #137785

I used the default settings of the statistics, I changed nothing. I use HS 2.2.3 from 8.12.2013.
In the Statistic of "Sales per month" I want to see the turnover in a month and the shipping costs are totally irrelevant for that. With (different) shipping costs included, this value is useless for a quick information about the monthly turnover.

The same for the last entry in the screenshot. "Quantity of customers per month". For 2 weeks, this value was at 22, now it's 17 and the month is not over yet. How can the quantity of customers decrease, if normally the value must increase with every sell by a new customer?

EDIT
Is the default value "This month" really the month from 1 to 30 (31) or is it the "last 30 days"? It looks to the "last 30 days".

EDIT2
Push

Attachments:
Last edit: 10 years 10 months ago by Plotec.

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

  • Posts: 25
  • Thank you received: 0
10 years 10 months ago #138073

I've been wondering the same... IS shipping added to the sales figures..? and how do we get rid of them.. I have no interest in the shipping charges since they're not an actual income..

Plotec.. have you found a way?

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

  • Posts: 101
  • Thank you received: 9
10 years 10 months ago #138106

No, not yet

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

  • Posts: 101
  • Thank you received: 9
10 years 10 months ago #138293

Is my problem to complicated or why nobody answers the question?

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

  • Posts: 82863
  • Thank you received: 13372
  • MODERATOR
10 years 10 months ago #138296

You can change the line:

$pie = 'SUM(a.order_full_price) AS total,a.order_currency_id AS currency_id';
to:
$pie = 'SUM(a.order_full_price-a.order_shipping_price) AS total,a.order_currency_id AS currency_id';
in the file administrator/components/com_hikashop/classes/widget.php so that the shipping price is removed from the calculations.

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

  • Posts: 101
  • Thank you received: 9
10 years 10 months ago #138362

Ok, thanks for answering but this is just one part of my question. It seems that, if you choose "this month" in the settings, not the month from 1st-31th is displayed, instead it displays the last 30 days.

We didn't sell something til now in January, so the sales per month should be empty, but it shows an amount from December.

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

  • Posts: 101
  • Thank you received: 9
10 years 10 months ago #140002

What about my problem? Do you use all sales from 1 to 31 of a month or do you use the last 30 days in your statistcs? If you use the sales from the 1 to the 31 of a month, then there is a bug in the code. If you use the last 30 days, the title of the statistics is wrong because it doesn't show all sales of the month.

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

  • Posts: 26158
  • Thank you received: 4028
  • MODERATOR
10 years 9 months ago #141305

Hi,

The report show the past month, not the current month.
It can be misunderstood, the appellation is probably not the best one, you're right.
But the title is not fully wrong because a month is a period of time, composed of 28, 29, 30 or 31 days.
A past month is the period of time from the same day of the previous month up to now.

We implement the statistics in a different way for HikaMarket and I think that some improvement will be re-integrated into HikaShop, specially for the distinction between "current month", "past month" and "previous month".

Regards,

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

Also helping the HikaShop support team when having some time or couldn't sleep.
By the way, do not send me private message, use the "contact us" form instead.

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

  • Posts: 101
  • Thank you received: 9
10 years 9 months ago #141897

Ok, that's reaslly misunderstanding. For me, a month - no matter if current or last month - is from the 1 til the 28,29,30,or 31 of the same month. A statistic for the last month has to show all sales between 1 and (31) of the last month.

If you define a month as a period of time, it's a flowing timeframe where the day 31 or 32, measured from the current day, will gone from the period. But I want e.g. all sales in January...and that's all sales from the 1 to 31.

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

  • Posts: 2334
  • Thank you received: 403
10 years 9 months ago #142262

Hi there,

Indeed your issue was coming from a misunderstanding and since you are not the only one complaining about that, we added few options to the reports and you will be able to choose between "last 30 days" and "this month" in the next version (coming soon). This should be easier for everybody :)

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

Time to create page: 0.086 seconds
Powered by Kunena Forum