Zen Cart Logo
Forums / General Questions / Printable Invatory in Admin?

Printable Invatory in Admin?

Views: 779

Results 1 to 7 of 7
10 May 2011, 3:01 PM
#1
wmorris avatar

wmorris

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?

10 May 2011, 4:36 PM
#3
wmorris avatar

wmorris

Totally Zenned

Join Date:
Aug 2007
Location:
Amarillo, Tx
Posts:
1,675
Plugin Contributions:
0

Re: Printable Invatory in Admin?

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.

10 May 2011, 5:43 PM
#4
dbltoe avatar

dbltoe

Totally Zenned

Join Date:
Jan 2004
Location:
N of San Antonio TX
Posts:
9,765
Plugin Contributions:
9

Re: Printable Invatory in Admin?

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.

10 May 2011, 5:45 PM
#5
wmorris avatar

wmorris

Totally Zenned

Join Date:
Aug 2007
Location:
Amarillo, Tx
Posts:
1,675
Plugin Contributions:
0

Re: Printable Invatory in Admin?

will it also print the manufacturer on the list too?

10 May 2011, 6:02 PM
#6
wmorris avatar

wmorris

Totally Zenned

Join Date:
Aug 2007
Location:
Amarillo, Tx
Posts:
1,675
Plugin Contributions:
0

Re: Printable Invatory in Admin?

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

10 May 2011, 6:51 PM
#7
dbltoe avatar

dbltoe

Totally Zenned

Join Date:
Jan 2004
Location:
N of San Antonio TX
Posts:
9,765
Plugin Contributions:
9

Re: Printable Invatory in Admin?

: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.