Contributions

Well I needed to be able to find the cost of my stock as well..... what I paid for it so this is V3 with a mjor change. You need to install stockview as before but also some more run a small sql query to alter the product table to add Products_cost. After that there are manual changes to the admin categories.php program to enable it to read, write and display the product cost and this lets you input it. There is a change to the adminincludeslanguagesxxxx file - I show the english version.

As always back up your installation and database before you start!!!

Updated to V1.0b. 3 to :

Not add items that are out of stock to the total.

highlight rows of items marked as out of stock.

Clean up new row code so that it is generated before the row rather than after and is driven by PHP rather than straight HTML.

Sorry - it will need modding to work with OSC 2.3

I have done this as My accountant wanted to know what my stock holding was - frightening!!

An edited version of the file stockview.php so that it works correctly with oscommerce 2.3.1.

Also just one alteration to the original installation instructions regarding edits to the reports.php file:

array(
'code' => FILENAME_STATS_STOCK_VIEW,
'title' => BOX_REPORTS_STOCKVIEW,
'link' => tep_href_link(FILENAME_STATS_STOCK_VIEW)
),

FULL PACKAGE

Well that was nice but I decided to integrate stockview with the admin site. I have done that here. Installation is simple. Modify 3 files and upload stockview.php to the admin folder.

Updated to extract product price and total the product value. Also provides a total stock value (all without tax).

NB this should be installed in your admin folder - not the catalog folder as originally advised.

CONTAINS:
- FULL PACKAGE of this 2 Contributions
- ENGLISH language file for Stockview
- POLISH language file for Stockview

Lukasz Brandt

Just added stocks to the admin section.

I modified the script to include a column that tells the quantity in stock in addition to the product status.

Very simple installation:
Directions: Upload the stockview.php file into your catalog directory. Then goto www.yoursite.com/catalog/stockview.php
www.yoursite.com/stockview.php (if you use a root directory)
to view current product status and quantities.

I can be reached at cdf12345 A T tmail.com

osCommerce Stock Viewer v1.0

I am hoping this will plant the seeds for a more comprehensive Stock Snapshot contribution.

I run an online bookstore and need a module that could take a snapshot of my stock as it is at the moment neatly listed on a page in tables so I could easily copy and paste it into Excel.

Thus was produced Stock View v1.00. There is much possibility for enhancements and further development and standardisation of this module into something worthwhile but for the time being it's barebones and does the job.

A live version of the module can be seen at :

http://www.vedicbooks.net/stockview.php

Installation
------------

Simply upload the file stockview.php into your catalog folder and then visit :

http://www.yoursite.com/catalog/stockview.php or if your site is in the root then http://yoursite.com/stockview.php

Enjoy and send feedback via http://www.vedicbooks.net contact page.

NB:

This module has been designed so you can copy and paste into Excel and then work with the data as per your requirements. Try it, it works well!