Community Add-Ons

Margin Report v1.00
for osCommerce Online Merchant v2.2

This is a module that will allow you to see a full report on the margin of all of your products. You now enter the cost of the good (in the admin) when you are entering or editing products.

From there this report allows you to sort out your products, in the report, by Product name, cost, price, specials price, margin dollars, and margin percentage.

Hope you like it.
-Chris

Legend:

Download

Report

Expand All / Collapse All

Updated version:

I made the order number clickable to link to the order details directly.

If you're upgrading, you should be OK with replacing files, but as always backup and compare.

Full package.

After installing 2.56a, I came across an error in Order.php when a customer viewed their order information from the My Account page. As this contribution was the only one I had installed that editted /catalog/includes/classes/order.php I had a close look at the intall instructions and found the problem.

/catalog/includes/classes/order.php
Find:
$orders_products_query = tep_db_query("select orders_products_id, products_id, products_name, products_model, products_price, products_tax, products_quantity, final_price from " . TABLE_ORDERS_PRODUCTS . " where orders_id = '" . (int)$order_id . "'");
while ($orders_products = tep_db_fetch_array($orders_products_query)) {
$this->products[$index] = array('qty' => $orders_products['products_quantity'],
'id' => $orders_products['products_id'],
'name' => $orders_products['products_name'],
'model' => $orders_products['products_model'],
'tax' => $orders_products['products_tax'],
'price' => $orders_products['products_price'],
'final_price' => $orders_products['final_price']);

Replace With:
$orders_products_query = tep_db_query("select orders_products_id, products_id, products_name, products_model, products_price, products_tax, products_quantity, final_price from " . TABLE_ORDERS_PRODUCTS . " where orders_id = '" . (int)$order_id . "'");
while ($orders_products = tep_db_fetch_array($orders_products_query)) {
$this->products[$index] = array('qty' => $orders_products['products_quantity'],
'id' => $orders_products['products_id'],
'name' => $orders_products['products_name'],
'model' => $orders_products['products_model'],
'tax' => $orders_products['products_tax'],
'price' => $orders_products['products_price'],
'cost' => $orders_products['products_cost'],
'final_price' => $orders_products['final_price'],

The last line of the replacement:
'final_price' => $orders_products['final_price'],

Should actually be:
'final_price' => $orders_products['final_price']);

The attached file is the install instructions with this change.

Thanks for the extra updates everyone. In this file there was no code for the extra report popups in 2.56b. The code:

$options = array();
$options[] = array('id' => 'all', 'text' => TEXT_SELECT_REPORT);
$options[] = array('id' => 'daily', 'text' => TEXT_SELECT_REPORT_DAILY);
$options[] = array('id' => 'weekly', 'text' => TEXT_SELECT_REPORT_WEEKLY);
$options[] = array('id' => 'monthly', 'text' => TEXT_SELECT_REPORT_MONTHLY);
$options[] = array('id' => 'quarterly', 'text' =>
TEXT_SELECT_REPORT_QUARTERLY);
$options[] = array('id' => 'semiannually', 'text' => TEXT_SELECT_REPORT_SEMIANNUALLY);
$options[] = array('id' => 'annually', 'text' => TEXT_SELECT_REPORT_ANNUALLY);
echo tep_draw_pull_down_menu('report_id', $options, (isset($_GET['report_id']) ? $_GET['report_id'] : '1'), 'onchange="this.form.submit()"');
echo '</form></td>' . "n";
}

Should look like this:

$options = array();
$options[] = array('id' => 'all', 'text' => TEXT_SELECT_REPORT);
$options[] = array('id' => 'daily', 'text' => TEXT_SELECT_REPORT_DAILY);
$options[] = array('id' => 'yesterday', 'text' => TEXT_SELECT_REPORT_YESTERDAY);
$options[] = array('id' => 'weekly', 'text' => TEXT_SELECT_REPORT_WEEKLY);
$options[] = array('id' => 'lastweek', 'text' => TEXT_SELECT_REPORT_LASTWEEK);
$options[] = array('id' => 'monthly', 'text' => TEXT_SELECT_REPORT_MONTHLY);
$options[] = array('id' => 'lastmonth', 'text' => TEXT_SELECT_REPORT_LASTMONTH);
$options[] = array('id' => 'quarterly', 'text' =>
TEXT_SELECT_REPORT_QUARTERLY);
$options[] = array('id' => 'semiannually', 'text' => TEXT_SELECT_REPORT_SEMIANNUALLY);
$options[] = array('id' => 'annually', 'text' => TEXT_SELECT_REPORT_ANNUALLY);
echo tep_draw_pull_down_menu('report_id', $options, (isset($_GET['report_id']) ? $_GET['report_id'] : '1'), 'onchange="this.form.submit()"');
echo '</form></td>' . "n";
}

Hope this helps some one :) Enjoy!

our success? individual commitment to a group effort

Community Add-Ons

Margin Report v1.00for osCommerce Online Merchant v2.2

Margin Report v1.00
for osCommerce Online Merchant v2.2