在woocommerce上创建可变产品的SQL查询

INSERT INTO wp_posts (post_title, post_content, post_excerpt, post_status, post_type)
VALUES ('可变产品名称', '可变产品描述', '', 'publish', 'product');

SET @product_id = LAST_INSERT_ID();

INSERT INTO wp_postmeta (post_id, meta_key, meta_value)
VALUES (@product_id, '_visibility', 'visible'),
       (@product_id, '_stock_status', 'instock'),
       (@product_id, 'total_sales', '0'),
       (@product_id, '_downloadable', 'no'),
       (@product_id, '_virtual', 'no'),
       (@product_id, '_regular_price', '19.99'),
       (@product_id, '_sale_price', ''),
       (@product_id, '_purchase_note', ''),
       (@product_id, '_featured', 'no'),
       (@product_id, '_weight', ''),
       (@product_id, '_length', ''),
       (@product_id, '_width', ''),
       (@product_id, '_height', ''),
       (@product_id, '_sku', ''),
       (@product_id, '_product_attributes', 'a:1:{s:4:"size";a:6:{s:4:"name";s:4:"Size";s:5:"value";s:0:"";s:8:"position";s:1:"0";s:10:"is_visible";i:1;s:12:"is_variation";i:1;s:11:"is_taxonomy";i:0;}}'),
       (@product_id, '_sale_price_dates_from', ''),
       (@product_id, '_sale_price_dates_to', ''),
       (@product_id, '_price', '19.99'),
       (@product_id, '_sold_individually', ''),
       (@product_id, '_manage_stock', 'no'),
       (@product_id, '_backorders', 'no'),
       (@product_id, '_stock', ''),
       (@product_id, '_upsell_ids', ''),
       (@product_id, '_crosssell_ids', ''),
       (@product_id, '_product_version', '3.0.0'),
       (@product_id, '_thumbnail_id', ''),
       (@product_id, '_product_image_gallery', ''),
       (@product_id, '_download_limit', '-1'),
       (@product_id, '_download_expiry', '-1'),
       (@product_id, '_download_type', 'standard'),
       (@product_id, '_purchase_note', ''),
       (@product_id, '_product_attributes', 'a:1:{s:4:"size";a:6:{s:4:"name";s:4:"Size";s:5:"value";s:0:"";s:8:"position";s:1:"0";s:10:"is_visible";i:1;s:12:"is_variation";i:1;s:11:"is_taxonomy";i:0;}}');

INSERT INTO wp_terms (name, slug, term_group)
VALUES ('Size', 'size', '0');

SET @term_id = LAST_INSERT_ID();

INSERT INTO wp_term_taxonomy (term_id, taxonomy, description, parent, count)
VALUES (@term_id, 'pa_size', '', '0', '1');

INSERT INTO wp_term_relationships (object_id, term_taxonomy_id, term_order)
VALUES (@product_id, @term_id, '0');