ProductCart Shopping Cart Software Forums : Programmatically setting items "Not for sale"

ProductCart Shopping Cart Software Forums : Programmatically setting items "Not for sale" https://forum.productcart.com/ Copyright (c) 2006-2013 Web Wiz Forums - All Rights Reserved. Mon, 13 Apr 2026 08:28:09 +0000 Wed, 16 Jun 2010 12:07:20 +0000 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 12.04 360 https://forum.productcart.com/RSS_post_feed.asp?TID=3788 <![CDATA[ProductCart Shopping Cart Software Forums]]> https://forum.productcart.com/forum_images/pc_logo_50.png https://forum.productcart.com/ <![CDATA[Programmatically setting items "Not for sale" : We run several ProductCart stores...]]> https://forum.productcart.com/programmatically-setting-items-not-for-sale_topic3788_post14726.html#14726 Author: BrianRoden
Subject: 3788
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?

]]> Wed, 16 Jun 2010 12:07:20 +0000 https://forum.productcart.com/programmatically-setting-items-not-for-sale_topic3788_post14726.html#14726