Using ProductCart - Programmatically setting items "Not for sale"

Print Page | Close Window

Programmatically setting items "Not for sale"

Printed From: ProductCart E-Commerce Solutions
Category: ProductCart
Forum Name: Using ProductCart
Forum Description: Running your store with ProductCart
URL: https://forum.productcart.com/forum_posts.asp?TID=3788
Printed Date: 18-October-2024 at 7:29am
Software Version: Web Wiz Forums 12.04 - http://www.webwizforums.com

Topic: Programmatically setting items "Not for sale"

Posted By: BrianRoden
Subject: Programmatically setting items "Not for sale"
Date 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?