Individual Products Profit and Cost Report v1.0

[Farrukh]

hi

I have released Products Profit and Cost Report.

Here is the ScreenShot.





*************
Download Here:
*************

Products Profit and Cost Report v1.0






*************

[heronent]

I downloaded your contribution and it appears to be missing several files... especially the stats_products_margin.php file (plus the files that put the Profits Report on the Report Toolbar). Tom

[Farrukh]

I downloaded your contribution and it appears to be missing several files... especially the stats_products_margin.php file (plus the files that put the Profits Report on the Report Toolbar). Tom

I accidently left the Reports Box file.

But the installation instruction has all the detail in order to install the contrib. Just follow the readme.txt

Also, i have renamed the stats_products_margin.php tp stats_products_profit.php

[Ivan02]

Hi Farrukh,

you forgot the sql-file or is it just an update?

ciao

[heronent]

Hi again...yeah, I see what you're talking about in the install file...I saw it right after I posted my first reply. I've renamed the stats_products_profit to stats_products_margin and that parts working. However, there seem to be some database calls for tables I don't have. Is this an update to a previous contribution? Or, as was asked before, is there a MySQL update that I'm not seeing?

T

[simon-m]

Hi Farrukh

I am getting this when you look under Admin -> Reports



1054 Unknown column 'op.products_cost' in 'field list'
in:
[select SUM(op.products_quantity) as products_ordered, op.products_name, p.products_margin_gross_dollar, p.products_price,op.products_cost, op.products_id, SUM(op.products_cost * op.products_quantity) AS total_cost, (SUM(op.products_price) - SUM(op.products_cost)) AS total_profit FROM orders_products op LEFT JOIN products p ON (p.products_id = op.products_id ) GROUP BY p.products_id ORDER BY products_ordered DESC, products_name limit 0, 20]
If you were entering information, press the BACK button in your browser and re-check the information you had entered to be sure you left no blank fields.

can you help

simon

[simon-m]

Hi again...yeah, I see what you're talking about in the install file...I saw it right after I posted my first reply. I've renamed the stats_products_profit to stats_products_margin and that parts working. However, there seem to be some database calls for tables I don't have. Is this an update to a previous contribution? Or, as was asked before, is there a MySQL update that I'm not seeing?

T

Hi

this works as part of the following cont's

http://www.zen-cart.com/forum/showthread.php?t=36336 ( Profit Markup/Margin Calculator)

and

http://www.zen-cart.com/forum/showthread.php?t=36878 ( Global Price Markup and Handling Fee Mod)

all should work on ZC 1.3