Sales report osc 2.3.1

[cretbogdan]

I have installed this contribution http://addons.oscommerce.com/info/7728 .

It is working with the mention that it does not add in the sales report the products without manufacturer .

I have some products at which i have not selected a manufacturer and those products are not added to the sales report .

If it possible to modify something and add to the sales report products without manufacturer too? Or i need to set a manufacturer at each product ?

[peteravu]

I have installed this contribution http://addons.oscommerce.com/info/7728 .

It is working with the mention that it does not add in the sales report the products without manufacturer .

I have some products at which i have not selected a manufacturer and those products are not added to the sales report .

If it possible to modify something and add to the sales report products without manufacturer too? Or i need to set a manufacturer at each product ?

Did you find a fix for the problem? I have same problem, I don't have any manufacturers, and the report come with

Thursday 24 October, 2013 0.00 $ 0.00 $
Friday 25 October, 2013 0.00 $ 0.00 $
Saturday 26 October, 2013 0.00 $ 0.00 $
Sunday 27 October, 2013 0.00 $ 0.00 $
Monday 28 October, 2013 0.00 $ 0.00 $
Tuesday 29 October, 2013 0.00 $ 0.00 $

[peteravu]

Did you find a fix for the problem? I have same problem, I don't have any manufacturers, and the report come with

Thursday 24 October, 2013 0.00 $ 0.00 $
Friday 25 October, 2013 0.00 $ 0.00 $
Saturday 26 October, 2013 0.00 $ 0.00 $
Sunday 27 October, 2013 0.00 $ 0.00 $
Monday 28 October, 2013 0.00 $ 0.00 $
Tuesday 29 October, 2013 0.00 $ 0.00 $

how to get the report working, without any manufacturers, as I don't have any manufacturers on any of the products?

[peteravu]

I think I got it to work but now have 2 new problems.

1. The attributes only count 1 per order like if 5 red it count only 1 in the report not 5.

2. The sort order are i think after orders_products_attributes_id and not attribute name or id

 

this is what i made of changes for the to make it work without manufacturers

$this->queryItemCnt = "SELECT op.products_id as pid, op.orders_products_id, op.products_name as pname,
 sum(op.products_quantity) as pquant, sum(op.final_price * op.products_quantity) as psum, op.products_tax as ptax " .
 " FROM " . TABLE_ORDERS . " o, " . TABLE_ORDERS_PRODUCTS . " op, " . TABLE_MANUFACTURERS . " m, " . TABLE_PRODUCTS . " p " .
 " WHERE o.orders_id = op.orders_id" .
 " AND op.products_id = p.products_id " .
 " AND p.manufacturers_id = m.manufacturers_id" .
 $filterString;

 

to

 

 $this->queryItemCnt = "SELECT op.products_id as pid, op.orders_products_id, op.products_name as pname,
 sum(op.products_quantity) as pquant, sum(op.final_price * op.products_quantity) as psum, op.products_tax as ptax " .
 " FROM " . TABLE_ORDERS . " o, " . TABLE_ORDERS_PRODUCTS . " op, " . TABLE_PRODUCTS . " p " .
 " WHERE o.orders_id = op.orders_id" .
 " AND op.products_id = p.products_id " .
 $filterString;