I have it configured so that if an item sells out via the site it will be set to inactive. Is there anything we can do to achieve this? I figure it would be as simple as running a script that checks stock level, then executes an SQL query that changes it to inactive if it has a 0 quantity, and to active if it has over 0 quantity. Unfortunately I am not comfortable coding a php script due to security issues. I could not find any scripts that do this, and am also concerned as to the load it would put on the server (we use 1and1 web hosting currently, but have been considering moving).
Does anyone know of any existing contributions that would help me with this?
EDIT: Thought I should add that we have about 900 products in the cart currently, most of which are in stock. If we get this working correctly we will most likely add the other 1800 or so out of stock products that we may or may not get in.
Edited by jonesy827, 09 July 2011 - 08:50 PM.