Differentiate "Sold Out" versus "Out Of Stock"
DEFINITIONS:
Sold Out - an item with 0 quantity that we will NOT be re-ordering and should be disabled (products_status = 0) so it is not found in searches, etc.
Out Of Stock - an item with 0 quantity that we WILL re-order and can stay enabled so it will show up in searches and display as "Out of stock".
QUESTION:
Is there currently a way that I could mark an item as a "Sold Out" item or an "Out Of Stock" item?
Am thinking that the product_type could be used here, but is that over-kill, as we do not need to change anything in the display layout, product info, etc. between the two types?
OR, should I just add a custom field to the products table with a simple 1/0 value?
APPLICATION:
We sell items in our physical store and online, so we run a daily script to update the quantity from our in-store sales tool. Am writing a SQL query to disable any "Sold Out" items that are now 0 quantity while leaving "Out Of Stock" items alone.
Thoughts?
Thanks!
My Sewing Room
#148, 8228 Macleod Tr SE, Calgary, AB T2H 2B8
mysewingroom.ca
Bookmarks