ZenCart first needs a category and it gets a cat unique ID

Products are indexed in the "products to catergories" table

Products are in the product table with a couple of indexes back to the above

There are more tables depending upon the type of product

Writing a "simple" sql will not get info into all required tables