ProductCart E-Commerce Solutions Homepage
Forum Home Forum Home > ProductCart > Using ProductCart
  New Posts New Posts RSS Feed - Programmatically setting items "Not for sale"
  FAQ FAQ  Forum Search   Events   Register Register  Login Login

Programmatically setting items "Not for sale"

 Post Reply Post Reply
Author
Message
BrianRoden View Drop Down
Groupie
Groupie


Joined: 07-September-2007
Status: Offline
Points: 0
Post Options Post Options   Thanks (0) Thanks(0)   Quote BrianRoden Quote  Post ReplyReply Direct Link To This Post 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?
Back to Top
 Post Reply Post Reply
  Share Topic   

Forum Jump Forum Permissions View Drop Down

Forum Software by Web Wiz Forums® version 12.04
Copyright ©2001-2021 Web Wiz Ltd.

This page was generated in 0.031 seconds.