X-Cart forums - View Single Post - Custom Sales Reports by Product (item total and by qty)

jeremye · #48 02-14-2006, 05:29 PM

Hey, regarding your SKU question, that should be easy enough.

Modify the main SQL query to something like :

Code:

SQL QUERY...... WHERE productcode LIKE '38-%'

That will specify all products that start with "38-" (the % is wildcard).

I'm not sure the range query will always work, but you could try:

Code:

SQL QUERY...... WHERE productcode >= '38-9000' AND productcode <= '38-9999'

Hope that helps.