Programmatically setting items "Not for sale"

Message Topic Search Topic Options Post Reply Create New Topic Printable Version Translate Topic

   We run several ProductCart stores for different product lines. But some products are sold in more than one online storefront, as well as through our regular wholesale distribution.

We use our in-house SQL server with SQL replication to the web SQL Server to do some nightly updates regarding item status (so discontinued items get taken off the sites without human intervention, inventory levels are updated to reflect what our warehouse management system actually shows, etc.).

We have set reorder levels in the ProductCart item data, but as extra protection against something being ordered by a customer that we may not have in stock to fulfill, we would like to set items to "Not for Sale" (but leave the image and description visible in the store) whenever the on-hand qty drops below the reorder level that has been set. And when the inventory level rises above the reorder level, we want to turn the "Not for sale" flag back off. Which field in the products table do I need to update to accomplish this?

Author	Message Topic Search Topic Options Post Reply Create New Topic Printable Version Translate Topic
BrianRoden Members Profile Send Private Message Find Members Posts Add to Buddy List Groupie Joined: 07-September-2007 Status: Offline Points: 0	Post Options Post Reply Quote BrianRoden Report Post Thanks(0) Quote Reply Topic: Programmatically setting items "Not for sale" Posted: 16-June-2010 at 12:07pm
	We run several ProductCart stores for different product lines. But some products are sold in more than one online storefront, as well as through our regular wholesale distribution. We use our in-house SQL server with SQL replication to the web SQL Server to do some nightly updates regarding item status (so discontinued items get taken off the sites without human intervention, inventory levels are updated to reflect what our warehouse management system actually shows, etc.). We have set reorder levels in the ProductCart item data, but as extra protection against something being ordered by a customer that we may not have in stock to fulfill, we would like to set items to "Not for Sale" (but leave the image and description visible in the store) whenever the on-hand qty drops below the reorder level that has been set. And when the inventory level rises above the reorder level, we want to turn the "Not for sale" flag back off. Which field in the products table do I need to update to accomplish this?