Totally Zenned
- Join Date:
- Aug 2007
- Location:
- Amarillo, Tx
- Posts:
- 1,675
- Plugin Contributions:
- 0
Printable Invatory in Admin?
Is there a mod that you can able print the invatory products in the Admin area?
Views: 779
Totally Zenned
Is there a mod that you can able print the invatory products in the Admin area?
Zen Follower
Have you tried this mod?
http://www.zen-cart.com/index.php?main_page=product_contrib_info&products_id=276
We had it installed at one point but never really used it. From what I recall it was quite good though.
Totally Zenned
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.
Totally Zenned
Maybe we're missing something. What's different between the store inventory and the admin inventory?:huh:
That mod will configure to give many different printouts.
Totally Zenned
will it also print the manufacturer on the list too?
Totally Zenned
Nevermind I did a printout test that it printed out what I want. Thank you very much.
Totally Zenned
:blush:
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.
Fields marked required must be completed.
Tell staff why this post should be reviewed.