Using ProductCart - Instock Inventory

Print Page | Close Window

Instock Inventory

Printed From: ProductCart E-Commerce Solutions
Category: ProductCart
Forum Name: Using ProductCart
Forum Description: Running your store with ProductCart
URL: https://forum.productcart.com/forum_posts.asp?TID=4615
Printed Date: 06-March-2025 at 4:48am
Software Version: Web Wiz Forums 12.04 - http://www.webwizforums.com

Topic: Instock Inventory

Posted By: antonio5413
Subject: Instock Inventory
Date 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

Replies:

Posted By: whizzinpc
Date 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.

Posted By: antonio5413
Date 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.

Posted By: Hamish
Date 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 http://wiki.earlyimpact.com/developers/editcode" rel="nofollow - WIKI Guidelines for Editing ProductCart's ASP Source Code