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

jeremye · #10 04-23-2004, 07:28 AM

Quote:

Originally Posted by abeight

Thanks Jeremy. I gave it a try, but it didn't work for me. See here: http://www.biz-plates.com/store/report.php (version 3.5.0)

Hmm, odd. Take out lines 2 through 5 (the comments section). Looks like it doesn't like the \ character at the end of line 2.

The only SQL fields that it needs are the following:

Code:

xcart_products.product,
xcart_order_details.productid
xcart_order_details.price
xcart_order_details.amount
xcart_order_details.amount

Try that and let me know.