[Picflick]

Hi,
We have a data discrepancy issue needing assistance please.
One of our Vendors (Liam) shared that they have a huge commission amount for withdrawal showing on their dashboard – https://prnt.sc/uumJ6QGwkWkn
Upon investigating on the MultivendorX >> Analytics tab, we see that the data is showing he’s made 66 sales! (https://prnt.sc/t6II3q93I0Mo). This is definitely incorrect as we have never processed a sale for this vendor. See WooCommerce >> Orders tab: https://prnt.sc/4JPxlbZGhAQ_.
How can we go about resolving this please? I’d appreciate your guidance/advice where to start debugging.
Thanks,
PicFlick

[Sangita Support Squad]

Hi there,
I’m sorry to hear you’re experiencing a data discrepancy. Could you please confirm if this issue started after upgrading to the latest version on your end?

[Picflick]

Hi
Thanks for responding. No, this is a pre-existing issue for a while.

[Sangita Support Squad]

Hi there, Thank you for getting back to us. We kindly request you to update to the latest version and check if the issue still persists on your end.
We look forward to hearing from you once you’ve tested it with the updated version.

[Picflick]

Hi,
Thanks. I understand your suggestion, however there is a more core concern here that is being deflected…
This is a historical data inconsistency rather than a functional issue. The underlying commission or transaction records are out of sync with the actual order data. Version upgrades typically address code and logic, not retroactively correct corrupted or inconsistent records already persisted in the database.
More than happy to run the update after you assist identifying and correcting the underlying data issue please.
Thanks.

[NerdySupportExpert Moumita]

Hi @Picflick,

Thank you for your detailed explanation—we completely understand your concern here.

You are absolutely right that upgrading to 5.0.0 will not automatically correct any existing historical data inconsistencies. Since this issue seems to be pre-existing, debugging it directly on the older version can be quite complex due to the legacy data structure and how records were maintained.

That said, if you choose to migrate to MultiVendorX 5.0.0, the system will handle migration of:

All vendors → converted into stores
Their associated commission data

During migration, commission is recalculated based on order status:

Orders with Completed / Processing status → treated as commission paid
Any commissions not marked as paid in version 4.2.42 → reflected in the store wallet balance

Additionally, MultiVendorX 5.0.0 provides a Custom Gateway option, which allows you to manually adjust store balances if needed. This can be helpful in cases like yours where certain vendors are showing inflated or incorrect amounts. You can refer to this here:
https://prnt.sc/CLiHPJGj00ws

Given the nature of the issue, a structured migration followed by adjustment may be a more reliable approach than trying to reconcile inconsistent legacy data directly.

Please let us know how you’d like to proceed—we’re happy to guide you through the migration and correction process.

[Author]

Posts