Post by onyxweb » Wed Sep 05, 2012 6:39 pm

Hi,

When I set this Report to All Statuses, it displays a number of products that do not appear on any order actually received & paid for.

Any idea why/how we can prevent this?

Thanks,

Bass

New member

Posts

Joined
Fri Mar 19, 2010 6:30 am

Post by Avvici » Thu Sep 06, 2012 5:02 am

But, that would not be accurate. Perhaps it is showing missing orders? The missing orders are not showing because they are in fact missing :) Perhaps I am reading you wrong?

User avatar
Expert Member

Posts

Joined
Tue Apr 05, 2011 12:09 pm
Location - Asheville, NC

Post by onyxweb » Fri Sep 07, 2012 4:26 pm

Hi,

Sorry, not to be clearer!

The Product> Purchased Report for a given date range is showing products that were NOT actually purchased. (It does also show the products that were purchased.)

Could it be that it is displaying products that were once in a basket that went on to be purchased, but were in fact removed before checking out?

If this was the case, how do we fis it?

Thanks,

Bass

New member

Posts

Joined
Fri Mar 19, 2010 6:30 am

Post by JNeuhoff » Mon Dec 10, 2012 11:31 pm

onyxweb wrote:Hi,

Sorry, not to be clearer!

The Product> Purchased Report for a given date range is showing products that were NOT actually purchased. (It does also show the products that were purchased.)

Could it be that it is displaying products that were once in a basket that went on to be purchased, but were in fact removed before checking out?

If this was the case, how do we fis it?

Thanks,

Bass
The Products Purchased report is indeed very buggy, here is a suggested bugfix (as a VQmod script):

Code: Select all

<modification>
	<id>Opencart file modifications: Bugfix for Report Products Purchased</id>
	<version>1.5.4.x</version>
	<vqmver>2.2.1</vqmver>
	<author>JNeuhoff</author>
	<file name="admin/model/report/product.php">
		<operation>
			<search position="replace"><![CDATA[GROUP BY op.model]]></search>
			<add><![CDATA[GROUP BY op.name]]></add>
		</operation>
		<operation>
			<search position="replace"><![CDATA[COUNT(DISTINCT op.model)]]></search>
			<add><![CDATA[COUNT(DISTINCT op.name)]]></add>
		</operation>
		<operation>
			<search position="replace"><![CDATA[(op.total + op.total * op.tax / 100)]]></search>
			<add><![CDATA[(op.total + op.tax)]]></add>
		</operation>
	</file>
</modification>


Override Engine * Integrated VQMod * Unused Images Manager * Instant Option Price Calculator * Number Option * Google Rich Snippets * Google Tag Manager * Export/Import Tool * SpamBot Buster * Survey Plus


User avatar
Expert Member

Posts

Joined
Wed Dec 05, 2007 3:38 am

Who is online

Users browsing this forum: Bing [Bot] and 39 guests