VP-ASP :: Shopping Cart Software

Shopping Cart Software Solutions for anywhere in the World

US/Canada(Toll Free): +1 888 587 2278
Europe/UK: +44 (020) 7193 9408
Australia/New Zealand: +61 3 9016 4497

VP-ASP Shopping Cart Customer Forum

Home | Profile | Register | Active Topics | Members | Search | FAQ
Username:
Password:
Save Password
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-ASP 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-ASP 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-ASP 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-ASP 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