Do I use Content Type creator to create new modules?
edit

After a quick google search I found this. Might be useful
-http://drupal.org/project/merci- (couldn't add more links)



I'm sure there is already a module you can download that does something similar to what you'd like to do, but if not then you should probably start like this.

Install the ctools and views module

Things that can be done without code (Drupal creates the tables in the database for you)


Create content type
Add necessary fields to it (sku, description, amount remaining)
Create some nodes of your content type with sample data in order to build/test your module as you go
Create a view to display nodes of your new content type


Now for the code


Get the node id of the product you are trying to alter
Load the node - http://api.drupal.org/api/drupal/modules%21node%21node.module/function/node_load/7
Your code that adds and subtracts inventory should updated the amount remaining field (you can use db_query or EntityFieldQuery for this) http://api.drupal.org/api/drupal/includes%21entity.inc/class/EntityFieldQuery/7 http://api.drupal.org/api/drupal/includes%21database%21database.inc/function/db_query/7


You also mentioned übercart, are you currently using it? If so you can just add fields to that content type and track those with your module and not have to deal with creating content types and views, because ubercart does all of that for you.