Instock Inventory |
Post Reply |
Author | |
antonio5413
Newbie Joined: 27-April-2011 Status: Offline Points: 0 |
Post Options
Thanks(0)
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
Newbie Joined: 17-January-2006 Location: California Status: Offline Points: 20 |
Post Options
Thanks(0)
|
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
Newbie Joined: 27-April-2011 Status: Offline Points: 0 |
Post Options
Thanks(0)
|
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
Admin Group Joined: 12-October-2006 Location: United Kingdom Status: Offline Points: 56 |
Post Options
Thanks(0)
|
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. |
|
Post Reply | |
Tweet
|
Forum Jump | Forum Permissions You cannot post new topics in this forum You cannot reply to topics in this forum You cannot delete your posts in this forum You cannot edit your posts in this forum You cannot create polls in this forum You cannot vote in polls in this forum |