Community Add-Ons

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

Description
History

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

FULL PACKAGE with Discount coupon addons

________________________________________

Marge net et brute définie pour les utilisateurs de discount coupon (si vous utilisez un autre module il suffit de remplacer la class "ot_discount_coupon" dans le fichier margin_report2 et de le remplacer par votre class

date ok

Pack complet

DON'T USE PREVIOUS VERSION FROM ME PREFER THIS ONE

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!

Community Add-Ons

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

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