Sometimes you add new WooCommerce products on your staging site and just want to add those new products to the live site without affecting other data like orders and transactions. Therefore you need to make sure to copy only the relevant tables which contain the WooCommerce products data.
Products are located mainly in 2 tables:
wp_poststable with a post_type
wp_postmetatable with the corresponding
post_idby product (the product ID).
Product types, categories, subcategories, tags, attributes and all other custom taxonomies for particular products are located in the tables below:
wp_woocommerce_attribute_taxonomies(for product attributes only)
Product types are handled by custom taxonomy
product_type with the following default terms:
Since Woocommerce 3+ a new custom taxonomy named
- The product visibility with the terms
- The feature products with the term
- The stock status with the term
- The rating system with terms from
Particular feature: Each product attribute is a custom taxonomy.
So if you do not like to copy, nor overwrite any WooCommerce data on the live site exclude all tables prefixed with woo_ and also the tables