Home Forums Theme Support Dokan Seller Dashboard Earnings different from Logs

This topic is: not resolved

Tagged: 

This topic contains 56 replies, has 4 voices, and was last updated by  Nayem 3 years, 11 months ago.

Viewing 15 posts - 16 through 30 (of 57 total)
  • Author
    Posts
  • #52726

    Simon
    Member
    Post count: 99

    Hi, any update?

    #52839

    towhid
    Participant
    Post count: 4505

    Hello Simon,

    I was not available yesterday. I will look this issue today. Please allow me some times.

    Thanks

    #53041

    Simon
    Member
    Post count: 99

    I understand that you have a number of accounts to work with but this problem is now over 2 weeks old (It started on another thread). Most of my sellers have stopped using the site at this point and this is costing me a lot of money. While I appreciate this problem may not be easy to solve, I really do need an update as to what the problem might be as I cannot keep telling my sellers that you are simply asking for more time. This plugin has cost me a lot of money on top of hosting fees and I do expect that it should work most of the time. I understand that sometimes things can go wrong but I cannot really expect my customers and sellers to be as patient as I am. Please, if you can, give me at least a hint of what you think the problem might be and how long you think it might take to resolve. For me, I suspect it's a problem with the database file.

    #53141

    towhid
    Participant
    Post count: 4505

    Hello Simon,

    Actually all the calculation are alright in the dashboard right now. Total sales are reading €309 and total earning is €152.56. This €152.56 earning is actually deduction of the Tax + Shipping.

    If a product price is $10. Shipping is $2 and Tax is $2. At the checkout, you will get total 10+2+2 = $14.

    When the seller receives commission he will get commission over the product price, not the total sales in checkout cleared. But the seller will read $14 in the total sales section in the dashboard.

    Please open this page plugins/dokan-plugin/includes/order-functions.php`

    and find this function function dokan_sync_insert_order( $order_id )

    In this function describes how the net amount is calculating.

    Hope you understand.

    Thank 🙂

    #53226

    Simon
    Member
    Post count: 99

    Hi and thank you for this. However, I had set my account to not have tax or shipping costs. How did it happen that these costs were taken?

    #53230

    Simon
    Member
    Post count: 99

    I also just checked the logs of each order and no tax or shipping was included in any sale so I don't know where the $2 and $2 are coming from?

    It should be very simple: The total sales should equal the Order_Total field and the commission should equal the Net_Amount field.

    I really hope you can help resolve this.

    #53234

    Simon
    Member
    Post count: 99

    I've also just logged into the user's account and the figures are different again!

    Here are the figures for total sales (S) and commission (C) according to the different ways to try and see data:

    On the user's dashboard: (S) 409.50 (C) 222.91
    Upon Exporting all her orders to csv: (S) 380.50 (excluding cancelled orders) (C) not displayed in this file
    From the logs of the MySQL files: (S) 359.75 (C) 251.78

    None of these figures have any correlation and it's impossible for me to see which ones are correct. This is just one seller's experience but all of my sellers are in a similar situation. This problem is costing me a significant income and I am getting very worried that this may not be resolved. Surely one of the above scenarios is correct and it can be correlated across all logs.

    Also, just for the record. All products are downloadable products. Therefore shipping should definitely not applied.

    #53237

    Simon
    Member
    Post count: 99

    The seller has sent me on her records and things are even more strange. There are several examples where the logs give one figure and her records are different. When I have checked the order number, her figure is correct.

    For example: look at Order 16179. If you look at the log from the MySQL database, it shows €6 but it should be €13.50
    Another example: Order 15685 appears in the MySQL log but this was a cancelled order.

    All examples that mismatched turned out to be correct from her records.

    I guess we have a number of questions:

    1. How come her figures do not match the ones on her dashboard?
    2. How come the MySQL log for the orders not match anything?
    3. How can we get everything matching up?

    We must be close to an answer?

    #53331

    towhid
    Participant
    Post count: 4505

    Hello Simon,

    I need the database for inspect the issue. Can you please send me database to me.

    Thanks

    #53400

    Simon
    Member
    Post count: 99
    This reply has been marked as private.
    #53440

    towhid
    Participant
    Post count: 4505

    Hello Simon,

    In Order 16179 customer use discount coupon and Order 15685 is saved as cancelled order. please check yourself in the database which you have sent to me.

    Thanks

    #53458

    Simon
    Member
    Post count: 99

    I'm aware of all that but the figures still don't add up at all in the Dashboard. If people used coupons, it should be reflected in the Dashboard figures. Her commission figure should be 70% of her total sales figure. There are no charges for tax or shipping. If coupons are not taken from total sales, it should be reflected somewhere in the Dashboard so sellers can see an accurate total sales figure.

    We still don't have the answer as to why none of the figures have any correlation.

    #53462

    Simon
    Member
    Post count: 99

    I've been looking through the seller's own records and the database is missing the following orders:

    15853
    15948
    16918
    17173
    17486
    17506

    They are nowhere to be seen in the log file I sent to you.

    #53466

    Simon
    Member
    Post count: 99

    Also, if you look at another example when things don't make sense:

    Order 16395 is marked as €6 but this is a sub order of 16391 and the seller's total should be zero. This happens on this order too: 16488 where the log states a sale of 3.75 but the seller's part of that order is a value of zero.

    #53469

    Simon
    Member
    Post count: 99

    Just checked order 16179 and you are correct that the customer used a coupon. However, the total cost of the product without the coupon would be €27.00 and the paid amount was €13.50 (which is correct) but the log shows €6.

    I don't think we are any closer to resolving the mystery and we are now entering the third week of troubleshooting.

Viewing 15 posts - 16 through 30 (of 57 total)

The topic ‘Seller Dashboard Earnings different from Logs’ is closed to new replies.