I have thousands of WooCommerce products that need to be inserted into the database. 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
How to assign the products to a particular taxonomy. In which table do they go?
Don't need the code just guidelines regarding tables.