- Posts: 44
- Thank you received: 0
Order value, average showing in negative
6 years 3 months ago #321067
by Harrier
Order value, average showing in negative was created by Harrier
Please Log in or Create an account to join the conversation.
6 years 3 months ago #321071
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 Order value, average showing in negative
Hello,
Can you please confirm your HikaMarket configuration regarding the "market mode" setting ?
www.hikashop.com/support/documentation/1...ml#config_market_tax
Regards,
Can you please confirm your HikaMarket configuration regarding the "market mode" setting ?
www.hikashop.com/support/documentation/1...ml#config_market_tax
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.
6 years 3 months ago #321190
by Harrier
Replied by Harrier on topic Order value, average showing in negative
Please Log in or Create an account to join the conversation.
6 years 3 months ago #321198
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 Order value, average showing in negative
Hello,
Thank you for the confirmation.
Unfortunately, I cannot reproduce your issue in my test website.
The query made for the statistics should handle the display of the price correctly ; when you are in "vendor paid directly", the vendor order price is negative (so we can know that the vendor has been paid directly) and in such case, the value will be the order total minus the omission.
I would require more details about your fee configuration and probably more details about the order seen by the vendor.
If you still have a negative value, it should mean that there order total is inferior than the omission.
Regards,
Thank you for the confirmation.
Unfortunately, I cannot reproduce your issue in my test website.
The query made for the statistics should handle the display of the price correctly ; when you are in "vendor paid directly", the vendor order price is negative (so we can know that the vendor has been paid directly) and in such case, the value will be the order total minus the omission.
Code:
AVG( CASE WHEN hk_order.order_vendor_price >= 0 THEN hk_order.order_vendor_price ELSE (hk_order.order_full_price + hk_order.order_vendor_price) END )
If you still have a negative value, it should mean that there order total is inferior than the omission.
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.
6 years 3 months ago #321287
by Harrier
Replied by Harrier on topic Order value, average showing in negative
Thanks. I don't see any negative value now.
Please Log in or Create an account to join the conversation.
6 years 2 months ago #321292
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 Order value, average showing in negative
Hello,
Let us know if the problem comes again.
Regards,
Let us know if the problem comes again.
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.
6 years 2 months ago #321303
by Harrier
Replied by Harrier on topic Order value, average showing in negative
Hi Jerome,
Our vendors are paid directly exactly the amount paid by the customer on the portal. There is no fees, commission, etc to be deducted. It happens offline. The final cart value paid by the customer should reflect as it is on vendor page including the tax breakup, coupons, etc.
Thanks
Our vendors are paid directly exactly the amount paid by the customer on the portal. There is no fees, commission, etc to be deducted. It happens offline. The final cart value paid by the customer should reflect as it is on vendor page including the tax breakup, coupons, etc.
Thanks
Please Log in or Create an account to join the conversation.
6 years 2 months ago #321360
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 Order value, average showing in negative
Hello,
I'm sorry but I don't understand what you're talking about.
Do you still have the issue ?
Regards,
I'm sorry but I don't understand what you're talking about.
Do you still have the issue ?
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.
Moderators: Obsidev
Time to create page: 0.272 seconds