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 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

Hi Farrukh

got over adove as "op.products_cost" to p.products_cost
in file Admin -> stats_products_profit.php

then get this

Internal Server Error
The server encountered an internal error or misconfiguration and was unable to complete your request.

Please contact the server administrator, webmaster AT kitchenjunction DOT metcalfandmetcalf DOT co DOT uk and inform them of the time the error occurred, and anything you might have done that may have caused the error.

More information about this error may be available in the server error log.

Additionally, a 500 Internal Server Error error was encountered while trying to use an ErrorDocument to handle the request.

when i click

* Product Profit Report
or
* Product Report

Ido get this showing under Admin -> Reports


ID# Products Purchased Total Cost ($) Total Profit ($)
7205 Baumatic 125mm dia. Vent Kit. 3 metre flexible ducting 1 25.20 10.56
1098 Baumatic BT2100 60cm Slot-In Cooker 1 0.00 251.04
1128 Baumatic Chimney Cooker Hood, 60cm 1 0.00 110.11
691 Blanco Alta Chrome Tap High Pressure Only 1 0.00 108.72
984 BLANCO BE/MGF/CAN60 Filters Replacement aluminium metal grease f 1 0.00 0.00
695 Blanco Dual 5050, Single Lever Monobloc Mixer Tap 1 0.00 96.62
723 Blanco Strand 6075 Cruciform Monobloc Tap, Quarter Turn 1 0.00 118.08
Displaying 1 to 7 (of 7 products) Page 1 of 1


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

[Farrukh]

This contribution requires you to have Profit Markup Calculator (http://www.zen-cart.com/forum/showthread.php?t=36336)

installed prior to installing the Cost Report.

[wickedklown]

This contribution requires you to have Profit Markup Calculator (http://www.zen-cart.com/forum/showthread.php?t=36336)

installed prior to installing the Cost Report.

I have your other contrib installed, and i just installed this report, however im running into the same issues as the others are. but if i change the file from profit to margin i get a server error. But if i leave it as profit it shows me 2 links with the error below it..

Now i see the post where dude changes op.????? to p.?????? when i look at that file i see that alot of them have an "o" infront of the p, is this correct, or should i remove all them?

also when i hover over the links it shows them going to the stat_products_margin.php file which is actualy called profit? does this need to be changed somewhere?

any help wouldbe great.
Thanks
Wicked