Skip to main content

Sales this month - Bug?

More
12 years 9 months ago #137735 by Plotec
-- 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.

More
12 years 9 months ago #137762 by nicolas
Replied by nicolas on topic Sales this month - Bug?
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.

More
12 years 9 months ago - 12 years 8 months ago #137785 by Plotec
Replied by Plotec on topic Sales this month - Bug?
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
Last edit: 12 years 8 months ago by Plotec.

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

More
12 years 8 months ago #138073 by Symbiot
Replied by Symbiot on topic Sales this month - Bug?
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.

More
12 years 8 months ago #138106 by Plotec
Replied by Plotec on topic Sales this month - Bug?
No, not yet

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

More
12 years 8 months ago #138293 by Plotec
Replied by Plotec on topic Sales this month - Bug?
Is my problem to complicated or why nobody answers the question?

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

More
12 years 8 months ago #138296 by nicolas
Replied by nicolas on topic Sales this month - Bug?
You can change the line:
Code:
$pie = 'SUM(a.order_full_price) AS total,a.order_currency_id AS currency_id';
to:
Code:
$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.

More
12 years 8 months ago #138362 by Plotec
Replied by Plotec on topic Sales this month - Bug?
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.

More
12 years 8 months ago #140002 by Plotec
Replied by Plotec on topic Sales this month - Bug?
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.

More
12 years 8 months ago #141305 by Jerome
Replied by Jerome on topic Sales this month - Bug?
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.

More
12 years 7 months ago #141897 by Plotec
Replied by Plotec on topic Sales this month - Bug?
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.

More
12 years 7 months ago #142262 by Eliot
Replied by Eliot on topic Sales this month - Bug?
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.225 seconds
Powered by Kunena Forum