Instock Inventory

Message Topic Search Topic Options Post Reply Create New Topic Printable Version Translate Topic

Hey all, 
Can someone please tell me how I can query instock items.  I want to be able to pull a report of all the items we have instock and the stock amount.

Unless Im being blind which is usually the case I cant seem to be able to see any where to do this.

Many thanks

Author	Message Topic Search Topic Options Post Reply Create New Topic Printable Version Translate Topic
antonio5413 Members Profile Send Private Message Find Members Posts Add to Buddy List Newbie Joined: 27-April-2011 Status: Offline Points: 0	Post Options Post Reply Quote antonio5413 Report Post Thanks(0) Quote Reply Topic: Instock Inventory Posted: 13-July-2011 at 7:52pm
	Hey all, Can someone please tell me how I can query instock items. I want to be able to pull a report of all the items we have instock and the stock amount. Unless Im being blind which is usually the case I cant seem to be able to see any where to do this. Many thanks

whizzinpc Members Profile Send Private Message Find Members Posts Add to Buddy List Newbie Joined: 17-January-2006 Location: California Status: Offline Points: 20	Post Options Post Reply Quote whizzinpc Report Post Thanks(0) Quote Reply Posted: 14-July-2011 at 6:35pm
	You can do a custom data export to include the following: Product SKU, Stock, Active and Not for sale fields then use excel to sort.

antonio5413 Members Profile Send Private Message Find Members Posts Add to Buddy List Newbie Joined: 27-April-2011 Status: Offline Points: 0	Post Options Post Reply Quote antonio5413 Report Post Thanks(0) Quote Reply Posted: 16-July-2011 at 10:37pm
	Hi Whizzinpc, Many thanks for that. One would think that as I can write a very simple script in sql query that something as advanced as PC would have a click here for instock items report. Not export this sort that filter the other. Still I guess I expect to much from the cart. Heaven forbid some fundamental things should be included. Edited by antonio5413 - 16-July-2011 at 10:37pm

Hamish Members Profile Send Private Message Find Members Posts Add to Buddy List Admin Group Joined: 12-October-2006 Location: United Kingdom Status: Offline Points: 56	Post Options Post Reply Quote Hamish Report Post Thanks(0) Quote Reply Posted: 17-July-2011 at 5:31am
	Hi Antonio, What's not simple about the answer from Whizzinpc? Being able to export the stock level data gives you complete flexibility to sort/filter etc the data within Excel, which most people are familiar with. Also, as each item reaches it's re-order level the store manager can be alerted if this is desired.
	Editing ProductCart Code? See WIKI Guidelines for Editing ProductCart's ASP Source Code