Products Listing
for osCommerce Online Merchant v2.2
I wanted to be able to print a list of all products in my catalog along with prices in order to cross reference them with newly released price lists, to see which products prices needed updating.
I have kept it simple. Located the option under reports, titled 'Products List'. It will open in a new window and list all products online in order of their ID number, but displays Product Name, Quantity & Price information. Just click on print in your browser window.
Legend: 
Download

Report
This is a full package with some changes:
- Pulldown list with categories, when you choose a category you will only see products from that category..
- A search function to show products with low stock. Useful to update your stock.
You can search for products with stock :
All
0-10
10-20
20-30
30 +
- A new column that automatic show price inc. tax based on the price ex. tax.
Spanish translation.
Agregar el archivo en includeslanguagesespanol
Add file to includeslanguagesespanol
This works a little better now and being a newbie it's really easy to install.
The contrib produces a list in a new window featuring the date, ID, Model, Product Name, Price and Quantity.
I find it really useful to check stock and allow the client to change prices without diving in and out of the catalog.
Uploaded full contrib, thanks to everyone who made this simple yet really useful contib, all I did was add the Product ID column.
This will be a much better starting point for most people -- no need for 5 levels of tables inside of tables.
A very small tweak - just added manufacturers column - made only 'active' or ID=1 products listed & changed sort order to manufacturer then model no. Of course the sort orders can be changed at your whim by just tweaking the code.
I find that most of my clients (and myself) found the list easier to navigate when the manufacturer was listed first as it helped narrow down the search a bit faster than just wading down a list of part no.s
All thanks to the original authors.
quantity column added into report...
only replace the new stats_products.php file with the old one...
take care...
1.2 by Steel Shadow
--12/17/04 Changes:
-cleaned up table making it look nicer
-combined 1.1c's model number with Kenneth's contrib to make it smaller and only use
one language so products are not shown twice
-fixed some install instructions
I moded the originaly adminstats_products.php for all of you that only want to see the products name in alphabetical order and the price.
This is just the file adminstats_products.php
overwrite existing one if you have installed the original contribution.
Maybe someone knows how to make it display all products that also have attributes with + price or - price.
Added Model number to the list
Fixed a couple of install errors for ms 2.2, cleaned up instructions
I am not a PHP programer but i got it to work whith osCommerce 2.2 Milestone 2
This is perfect to keep a simple invetory list
I wanted to be able to print a list of all products in my catalog along with prices in order to cross reference them
with newly released price lists, to see which products prices needed updating.
I updated this to list alphabetically, and included the date at the top. Option is located under reports, titled 'Products List'. It will open in a new window and list all
products online in alphabetical order and displays Product Name, Quantity & Price information. Just click on print in your
browser window.
I'm sure that many other variations on this theme could produce useful reports, but I'll leave that for others to contemplate.
I wanted to be able to print a list of all products in my catalog along with prices in order to cross reference them with newly released price lists, to see which products prices needed updating.
I have kept it simple. Located the option under reports, titled 'Products List'. It will open in a new window and list all products online in order of their ID number, but displays Product Name, Quantity & Price information. Just click on print in your browser window. (I got that idea from PrintOrders) :)
If anyone wants to make it more versatile and functional, please do, as it stands, it fulfils my needs.