Orders Missing and numbers in report page are incorrect

Hi,

the page url: /store-manager/orderslist/


In the vendors store manager page, we are having some orders not showing in the vendors account page.
Also in the reports, the values of Gross revenue and total orders are less than actual.

How to debug the issue ?

We found below query, this query fetches all the orders, but some of the orders aren’t showing in the front end. Is this the correct query used for store managers page ?

SELECT *, GROUP_CONCAT( ID ) as commission_ids, GROUP_CONCAT(item_id) order_item_ids, GROUP_CONCAT(product_id) product_id, SUM( commission.quantity ) AS order_item_count, COALESCE( SUM( commission.item_total ), 0 ) AS item_total, COALESCE( SUM( commission.item_sub_total ), 0 ) AS item_sub_total, COALESCE( SUM( commission.shipping ), 0 ) AS shipping, COALESCE( SUM( commission.tax ), 0 ) AS tax, COALESCE( SUM( commission.shipping_tax_amount ), 0 ) AS shipping_tax_amount, COALESCE( SUM( commission.total_commission ), 0 ) AS total_commission, COALESCE( SUM( commission.discount_amount ), 0 ) AS discount_amount, COALESCE( SUM( commission.refunded_amount ), 0 ) AS refunded_amount, GROUP_CONCAT(is_refunded) is_refundeds, GROUP_CONCAT(refund_status) refund_statuses FROM wp_wcfm_marketplace_orders AS commission WHERE 1=1 AND vendor_id = 20462 AND is_trashed = 0 GROUP BY commission.order_id ORDER BY order_id DESC LIMIT 500 OFFSET 0;

• This topic was modified 2 years, 2 months ago by DinoExplains.