Profit Markup/Margin Calculator

[wtashby]

Farrukh,

I've done everything you said, uploaded the files you sent me, ran the sql's you sent, and it still won't work. Somewhere, somehow, the markup and fee are not connecting with the cost to create the new price. I cannot read or program php, so, I'm at your mercy here. Don't give up on me yet, cause if I'm having this trouble, others will too.

Remember, I'm running on my local server, phpMyAdmin 2.7.0, with the latest version of Zen.

PS: Your PM box is full, and cannot receive any more PM's.

[Farrukh]

Farrukh,

I've done everything you said, uploaded the files you sent me, ran the sql's you sent, and it still won't work. Somewhere, somehow, the markup and fee are not connecting with the cost to create the new price. I cannot read or program php, so, I'm at your mercy here. Don't give up on me yet, cause if I'm having this trouble, others will too.

Remember, I'm running on my local server, phpMyAdmin 2.7.0, with the latest version of Zen.

PS: Your PM box is full, and cannot receive any more PM's.

wtashby, I just installed a FRESH copy of Zencart 1.3.0.1 to only test out this mod.

I went through the installation file i sent you . All worked fine.

I dont know why it isnt working for you. The Values are shown up on the Admin side and they are being added to the Database.

Check the ScreenShots of the Admin section and the Database Query reflecting the change.

Admin Section:






Database Query :






I need some more Testers .

It seems as if no one is interested

[wtashby]

Maybe there is something I'm missing? Are there any mods that would conflict with this one? I have your other mod, the Profit_Markup_Calculator_v1[1].12

Could that be a conflict?

Maybe there is something about the cost field I'm missing. I actually only have Cost for 2 products. I manually entered those, but, I would think that the mod would work no matter if you had all product costs entered, or, just one.

If no one else seems interested, well, hee hee, I guess you are stuck with me

[plowe1]

i would be interested to still see the report tool for the original markup mod.....

[Farrukh]

i would be interested to still see the report tool for the original markup mod.....

Alright, ill finish that one as well.

[plowe1]

i am recieving two problems,

the first, is that the link in admin > reports is not displaying correctly, its showing as BOX_REPORTS_PRODUCTS_MARGIN, and when its cicked, it goes to :

http://www.yoursite.com/FILENAME_STA...CTS_MARGIN.php

secondly, i get this error on the report screen...

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.

what files need modifying??

i guess something to to with a define for the first one, and incorrect table refferences in second ???

[simon-m]

i would be interested to still see the report tool for the original markup mod.....

and me

simon

[ladysaat]

I am setting up another cart on a test site for another store. What can I test for you? I too am not a coder/php goddess so I can only install, run, and report for you... Would that be enough? Or are you needing someone who can find the errors and code fixes then report back to you?

[Holgate]

Not sure if anyone already suggested this, but the recent screenshot doesn't show it so I thought I'd comment... Would it be possible to add a column total for Total Cost and Total Profit on the report sheet?

Original




Recommended

[Farrukh]

I have setup the profit report PER PRODUCT. Its not the total of all products.