Profit Markup/Margin Calculator

[simon-m]

and me

simon

is it poss Farrukh (have pm you)

simon

[simon-m]

Farrukh

The Profit Margin Calculator:
Products Cost:
Markup Percent : %
Gross Margin $:
Gross Margin %: %

is not showing up/working when you select Product Type:

Product Music
Document - General
Document - Product
Product - Free Shipping (I need)

Only when you select the Product Type:
Product General (I need)


simon

[simon-m]

Also Farrukh

Which Field's in Table products in the D/B would I/We need to export so i can up date all the cost's in excel and then inport them as EP can not do this yet??

is it just:

products_cost


or

products_cost, products_margin_gross_dollar, products_margin_gross_percent


working on that I/We only need to get the cost done in bulk, then global markup can mark it up.

simon

[plowe1]

I am recieving this error, when using the report...


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.

[simon-m]

I am recieving this error, when using the report...


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.

see

http://www.zen-cart.com/forum/showthread.php?t=37567

simon

[simon-m]

I am recieving this error, when using the report...


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.

Hi plowe1


have you got it fixed plowe1?

or did you get a Internal Server Error

simon

[plowe1]

partially fixed, but two links on the report page are still not working.

[simon-m]

We were just getting internal server errors. I am only now able to look at things late evening.

Simon

[wickedklown]

i have got it working, i believe, although its nothing like the screenshots iv seen.

the first thing i had to do was change the filename link in the admin/stats_products_profit.php file to refect the actual filename. From there i removed all the "o"s from the p_products_cost vars on that same file. and then it worked but there is still something wrong i believe... im waiting form some help myslef. ill post a screeen shot in a min.

[sanji]

I also had the following problem in the category.php file :

Warning: Missing argument 2 for display_price() in /home/www/a392c92774b2609c389bb3ca36fb6261/users/ilot20/web/admin/includes/classes/currencies.php on line 70

As said before, it is corrected on this message : http://www.zen-cart.com/forum/showpo...3&postcount=89

by changing, in admin/includes/functions/functions_price.php the following line:

    $show_normal_price = $currencies->display_price($display_cost_price);

to

    $show_normal_price = $currencies->display_price($display_cost_price, zen_get_tax_rate($product_check->fields['products_tax_class_id']));

Thanks a lot,

sanji