Volusion script asp hide products with 0 inventory sql?

Cancelled Posted Oct 18, 2011 Paid on delivery
Cancelled Paid on delivery

We use to have a code that hid the parent product if child products have 0 inventory. the script is attached. however, this srcipt no longer works since we moved to a different server and account. I doubt that nothing else needs to change, only the DB and login info, which we do not know how to acquire.

We use volusion, and it is inconvenient to have to go and hide or delete products that have 0 inventory. Volusion system does not hide when out of stock Parent products that have child products (such as options, size or color) so we must go in and delete them manually, or else customer will be able to view the product, but not select a size, here is an example of a product that is out of stock, and needs to be hidden.

ASP

Project ID: #1253829

About the project

Remote project Active Oct 18, 2011