Community Add-Ons
Add file to this packageStocktaking Cost
for osCommerce Online Merchant v2.2
As I needed to know the value of my stock, I created this contrib with the help of two other Oscommerce users (thanks to phocea and djebaz).
It is an ongoing process. It is difficult as my level in php and mysql is rather low. I will open a thread in the forum.
Features (so far):
- Multilanguages
- Item name
- Quantity per item
- Purchase price per item
- Total Purchase Price per item
- Retail price per item
- Total Retail Price per item
- Number of item per category
- Total Purchase price per category
- Total Retail Price per category
- Quantity of item in stock
- Total Stock Cost
- Total Stock Retail Price
- Excluding categories (by id) if needed
- Link to view item in a separate window
- Take in account specials
Download 
Report
1054 - Unknown column 'p.products_cost' in 'field list'
admin/categories.php
-----------------------------
Search/Busque
------------------------------------
add this line: 'products_cost_price' => tep_db_prepare_input($HTTP_POST_VARS['products_price_cost']),
-------------------------------
replace / mude para
---------------------------------
search this line 'products_price' => tep_db_prepare_input($HTTP_POST_VARS['products_price']),
add this line: 'products_price_cost' => tep_db_prepare_input($HTTP_POST_VARS['products_price_cost']),
------------------------
Search/Busque
------------------------------------
p.products_price add p.products_cost,
-------------------------------
replace / mude para
---------------------------------
p.products_price add p.products_price_cost,
------------------------
Search/Busque
------------------------------------
$currencies->format($pInfo->products_price) . '<br>' . TEXT_PRODUCTS_INVENTORY_COST . ' ' .
-------------------------------
replace / mude para
---------------------------------
$currencies->format($pInfo->products_price) . '<br>' . TEXT_PRODUCTS_PRICE_COST . ' ' .
Thank´s , Obrigado
Suporte Oscommerce no Brasil
http://www.osconline.info