I'm using Filemaker 9's new SQL connection feature to connect directly to my Drupal database and was hoping to have a little handholding on the Drupal end. Basically we have about 40,000+ products (ecommerce shippable products) to upload to our drupal site, which I plan to do via node_import. Once they're there, I want to be able to mark the records Sold from the Filemaker end (i.e., when something sells in the store rather than on the site). Which tables, and specifically which fields do I need to change to have it remain in the MySQL database but show as sold? I don't need it to show as part of a transaction or anything like that, I just don't want it listed for sale any longer. I know each product is stretched across multiple tables, and I've been warned about modifying the DB directly, but it seems like this shouldn't be too dangerous. Any help would be appreciated.
By bookguy on
