i buy this product in codecanyon few years ago but i don’t use . At this time, i try to use this product for my family company, i hope it works.

Thanks you. @Mian Saleem , this topic can close

Mian Saleem I got this data

Hello,

Yes. I will update the file this week.

Thank you

OK so we can use the update version to enable this feature? correct?

Yes, update will fix the issue. Thanks

Mian Saleem Hello support,

it’s been awhile. and now I already updated to V3.4.51, but category report still see nothing.

see my screenshot.

Hello,

The update was released. It might not be due to parent_id 😦

Let me know the site link with owner account and server details to check.

Thank you

Mian Saleem Oh to do that, you need to access my hosting.

and in my hosting there are many sites.

could we work remotely? or can anyone do a skype or online?

thank you

Hello,

Please try to run the following query after selecting your database in phpmyadmin and let me know the result.

SELECT
	sma_categories.id AS cid,
	sma_categories.code,
	sma_categories.name,
	SUM(COALESCE(PCosts.purchasedQty, 0)) AS PurchasedQty,
	SUM(COALESCE(PSales.soldQty, 0)) AS SoldQty,
	SUM(COALESCE(PCosts.totalPurchase, 0)) AS TotalPurchase,
	SUM(COALESCE(PSales.totalSale, 0)) AS TotalSales,
	(SUM(COALESCE(PSales.totalSale, 0)) - SUM(COALESCE(PCosts.totalPurchase, 0))) AS Profit
FROM
	`sma_categories`
	LEFT JOIN (
		SELECT
			sp.category_id AS category,
			SUM(si.quantity) soldQty,
			SUM(si.subtotal) totalSale
		FROM
			sma_products sp
			LEFT JOIN sma_sale_items si ON sp.id = si.product_id
			LEFT JOIN sma_sales s ON s.id = si.sale_id
		GROUP BY
			sp.category_id) PSales ON `sma_categories`.`id` = `PSales`.`category`
	LEFT JOIN (
		SELECT
			pp.category_id AS category,
			SUM(pi.quantity) purchasedQty,
			SUM(pi.subtotal) totalPurchase
		FROM
			sma_products pp
			LEFT JOIN sma_purchase_items pi ON pp.id = pi.product_id
			LEFT JOIN sma_purchases p ON p.id = pi.purchase_id
		GROUP BY
			pp.category_id) PCosts ON `sma_categories`.`id` = `PCosts`.`category`
WHERE (parent_id IS NULL OR `parent_id` = 0)
GROUP BY
	`sma_categories`.`id`,
	`sma_categories`.`code`,
	`sma_categories`.`name`,
	`PSales`.`SoldQty`,
	`PSales`.`totalSale`,
	`PCosts`.`purchasedQty`,
	`PCosts`.`totalPurchase`
ORDER BY
	`sma_categories`.`code` ASC
LIMIT 10

Mian Saleem I run your query and I got the result,

I attached.