Individual Products Profit and Cost Report v1.0

[wickedklown]

sorry for the double post but i would like to post an image of what i have, and show that there are only 279 products, when i have 3119 products.... 260 of which are deactivated if that means anything....

[wickedklown]

and i know this is a tripple post, but its in reguards to my last post..

I noticed a bit closer at your screenshot of this release, and its showing the same info that my current setup is showing, but im wondering if you plan to add all the fields that you had in a previous screenshot of the report. Showing the sale total and sale price along with the product cost and totals..... this would be great.

if you have a donation account setup, id be more than happy to donate to your hard and wonderfull work on the contrib.

i hope to hear from you soon
Wicked

[simon-m]

Hi Wicked

did you get the 2 reportes working or not?

i am only geting the same report showing from the 2


simon

[wickedklown]

Hi Wicked

did you get the 2 reportes working or not?

i am only geting the same report showing from the 2


simon

same thing... same report showing for both...im still tring to find out whats wrong, and see if i can fix it..... without the author here tho. it makes it hard

[simon-m]

Hi

can we say that the report that is showing is the Product Profit Report?

and the Product Report is the one we all need?

without the author and the nonexistence stats_Product_Report.php.

so we need to workout what we need it to show

poss a less than <??% to show in back and a >??% to show in red

simon

[wickedklown]

i believe your correct... are you sure that there is suppose to be another stats_product_report.php file that we are missing? or does it do all this through the one file?

im seeing in the stats_products_profit.php file (located in admin/) both links are going to that same file? should they be, and all functions are located in the file, or are we really missing another file?

[wickedklown]

what do you have in your stats_products_profit.php file under /admin/?

this is what i have

<?php
if (isset($_GET['page']) && ($_GET['page'] > 1)) $rows = $_GET['page'] * MAX_DISPLAY_SEARCH_RESULTS_REPORTS - MAX_DISPLAY_SEARCH_RESULTS_REPORTS;
// The new query uses real order info from the orders_products table, and is theoretically more accurate.
// To use this newer query, remove the "1" from the following line ($products_query_raw1 becomes $products_query_raw )
$products_query_raw1 = "select
SUM(op.products_quantity) as products_ordered, op.products_name, p.products_margin_gross_dollar,
p.products_price,p.products_cost, op.products_id,
SUM(p.products_cost * op.products_quantity) AS total_cost,
(SUM(op.products_price) - SUM(p.products_cost)) AS total_profit
FROM ".TABLE_ORDERS_PRODUCTS." op
LEFT JOIN " . TABLE_PRODUCTS . " p
ON (p.products_id = op.products_id )
GROUP BY p.products_id
ORDER BY products_ordered DESC, products_name";
--------------------------------------------------------
--------------------------------------------------------
Do you have the same thing? or did you remove more of the "o"s from that list?

[simon-m]

it would be better if it was in one .php as it would be less work for others to set up?

but

I was looking at the Product Stock Report in admin and this could be used as a 2nd .php with the addon the is needed, should only need to be moved and remaned BUT THE AUTHOR OF IT WOULD STILL BE GIVEN THERE CREDIT.

[simon-m]

what do you have in your stats_products_profit.php file under /admin/?

this is what i have

<?php
if (isset($_GET['page']) && ($_GET['page'] > 1)) $rows = $_GET['page'] * MAX_DISPLAY_SEARCH_RESULTS_REPORTS - MAX_DISPLAY_SEARCH_RESULTS_REPORTS;
// The new query uses real order info from the orders_products table, and is theoretically more accurate.
// To use this newer query, remove the "1" from the following line ($products_query_raw1 becomes $products_query_raw )
$products_query_raw1 = "select
SUM(op.products_quantity) as products_ordered, op.products_name, p.products_margin_gross_dollar,
p.products_price,p.products_cost, op.products_id,
SUM(p.products_cost * op.products_quantity) AS total_cost,
(SUM(op.products_price) - SUM(p.products_cost)) AS total_profit
FROM ".TABLE_ORDERS_PRODUCTS." op
LEFT JOIN " . TABLE_PRODUCTS . " p
ON (p.products_id = op.products_id )
GROUP BY p.products_id
ORDER BY products_ordered DESC, products_name";
--------------------------------------------------------
--------------------------------------------------------
Do you have the same thing? or did you remove more of the "o"s from that list?

yes i removed the "o" from the op.products_cost as the cost is in the products table and not in the order table

[Farrukh]

Hi

I have been very busy so thats why I wasnt available for support.

As soon as I get some free time, i'll look into the problems you guys are facing