What stored proc do I call to:
  1) add a product into the Product table
  2) Link that product to a Category
  3) Link that product to a Product Template
  4) Create an SKU
  5) Link the SKU to a Product

Thanks,
Rilwan

There are a lot of stored procedures called, especially if you want to include meta data, i would advise using the object model to accomplish adding new products and categories, but here is a list of basic procedures:

ProductInsert (inserts product and associates it with a product template)

CategorizationInsert (associates product with category )

SkuInsert (inserts sku to and links it to the product)