Mass Inputs

Hi there ??

Upon checking on the internet I couldn’t find a SQL query to import all products. However, it sounds like the Product CSV Import Suite plugin might do the job for you. Here is a direct link to this plugin:

https://woocommerce.com/products/product-csv-import-suite/

For the SQL query, I can also recommend to visit the WooCommerce Facebook group or the #developers channel of the WooCommerce Community Slack. We’re lucky to have a great community of open-source developers for WooCommerce, and many of our developers hang out there, as well.

Cheers ??

that’s not it at all. I just don’t know what table to use since none of them are labeled wc_tags. And nowhere online refers to the tags.

basically this is the information I need

mysqli_query INSERT INTO this_table VALUES(V1,V2)

That’s what I am wanting

So far the only thing close is the attributes are in the wp_term_taxonomy but no other information is available for mysql

Hi @boionfire81,

You are correct. There isn’t a distinct table for WooCommere tags, attributes, and categories. WooCommerce makes use of the taxonomy system in WordPress to handle these.

These tables will be important to work with if you want to add these directly to the database.

That said, you may find it easier to import these via CSV and let WordPress create these and set up the relationships for you.

This post can explain in more detail how this works inside of WordPress.

https://code.tutsplus.com/tutorials/understanding-and-working-with-taxonomies-and-terms-in-wordpress–cms-21051

I hope that gets you pointed in the right direction.

100% thanks