This may be a SQL or nothing question, but have to ask. Is there a standard way to automate the updating of quantity on hand?
If the answer is no, I am fine with writing a query to do it through mysql, but what table is this in? I checked around and found price – but not quantity. Hmmm.
Thanks in advance!