- Posts: 101
- Thank you received: 9
Sales this month - Bug?
12 years 9 months ago #137735
by Plotec
Sales this month - Bug? was created 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.
-- 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.
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.
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.
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
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.
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?
Plotec.. have you found a way?
Please Log in or Create an account to join the conversation.
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.
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.
12 years 8 months ago #138296
by nicolas
Replied by nicolas on topic Sales this month - Bug?
You can change the line:
to:
in the file administrator/components/com_hikashop/classes/widget.php so that the shipping price is removed from the calculations.
Code:
$pie = 'SUM(a.order_full_price) AS total,a.order_currency_id AS currency_id';
Code:
$pie = 'SUM(a.order_full_price-a.order_shipping_price) AS total,a.order_currency_id AS currency_id';
Please Log in or Create an account to join the conversation.
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.
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.
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.
12 years 8 months ago #141305
by Jerome
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.
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,
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.
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.
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.
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
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