Printable Invatory in Admin?

[wmorris]

Is there a mod that you can able print the invatory products in the Admin area?

[Dunk]

Have you tried this mod?

http://www.zen-cart.com/index.php?ma...roducts_id=276

We had it installed at one point but never really used it. From what I recall it was quite good though.

[wmorris]

This is for the main store not in the admin area......


this will not work for me. I want to print the inventory in the Admin area only.

[dbltoe]

Maybe we're missing something. What's different between the store inventory and the admin inventory?

That mod will configure to give many different printouts.

[wmorris]

will it also print the manufacturer on the list too?

[wmorris]

Nevermind I did a printout test that it printed out what I want. Thank you very much.

[dbltoe]

Now I see that this mod creates a sidebox for the customer to print out a price list. Wouldn't want them to get too much info.

You could just run a query to a spreadsheet.
The only tricky part would be getting the product description with the ID as they are in two separate tables and the manufacturer with the manufacturer's ID for the same reason.

But

SELECT
products_description.products_name as 'Product',
products.products_quantity as 'Qty on Hand',
products.products_model as 'Model',
manufacturers.manufacturers_name as 'Manufacturer'
FROM
products ,
products_description ,
manufacturers
WHERE
products.products_id in (products_description.products_id) OR
products.manufacturers_id in (manufacturers.manufacturers_id)

will get you pretty close.
This is assuming you don't have a table prefix
Adding WHERE and GROUP BY could clean things up for the display you need.