Your Cart

Shopping Cart Items: 0   Sub-Total : $0.00    View Cart    Checkout
Welcome, Guest ( Customer Panel | Login )


Home | Profile | Register | Active Topics | Members | Search | FAQ


Forgot your Password?
 All Forums
 VPCart Forum
 General help me questions
 Stock Inventory		  New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

willy99
VP-CART New User

Italy
108 Posts
Posted - March 19 2009 :  13:28:12  Show Profile  Reply with Quote
Hello,

I'd like to know if is possible to know the stock quantity for every items I input in Vpasp.

Is it possible ?

Thanks

carfin
VP-CART Expert

United Kingdom
948 Posts
Posted - March 19 2009 :  17:04:44  Show Profile  Reply with Quote
If you just want a list of all your products and the quantity in stock you can go to your Admin panel -> Edit products and click on the advanced search option. In the Query field type in the following:

SELECT productid,cname,cstock FROM products ORDER BY cname ASC

Regards,

Carrol
www.deanston-electrical.co.uk
Edited by - carfin on March 19 2009 17:05:55
Go to Top of Page

willy99
VP-CART New User

Italy
108 Posts
Posted - March 20 2009 :  17:39:59  Show Profile  Reply with Quote
Thank you carfin,

I try but it doesn't work. But now I know and try to create a new query.
Go to Top of Page

carfin
VP-CART Expert

United Kingdom
948 Posts
Posted - March 23 2009 :  12:09:52  Show Profile  Reply with Quote
My apologies, the sql query should read:

SELECT catalogid, cname, cstock FROM products ORDER BY cname ASC

Regards,

Carrol
www.deanston-electrical.co.uk
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
Snitz Forums 2000
0 Item(s)
$0.00
  • Your Cart Is Empty