I have thousands of products that need to be inserted into woo commerce. For some reasons I can't use the csv import plugin or any other 3rd party solution and this has to be done manually through php code into database.

Here is what my question is:

To what table do the product categories go ? I guess the products have to be added to wp_posts and then the description/price etc is added to the wp_postmeta.

How to assign the products to a particular category. I mean in which table do they go?

Don't need the code just guidelines regarding tables.

Ahmar