Export WooCommerce Products & Customers for Shopify Import

woo_customers.sql

SELECT 
	`wp_users`.`user_email` AS `Email`,
	`T1`.`meta_value` AS `First Name`,
	`T2`.`meta_value` AS `Last Name`,
	`T3`.`meta_value` AS `Total Spent`,
	`T4`.`meta_value` AS `Total Orders`,
	`T5`.`meta_value` AS `Country Code`,
	`T6`.`meta_value` AS `City`,
	`T7`.`meta_value` AS `Address1`,
	`T8`.`meta_value` AS `Address2`,
	`T9`.`meta_value` AS `Zip`,
	`T0`.`meta_value` AS `Company`
FROM  `wp_users` 
	LEFT JOIN  `wp_usermeta` as `T1` ON  `ID` =  `T1`.`user_id` 
	LEFT JOIN  `wp_usermeta` as `T2` ON  `ID` =  `T2`.`user_id` 
	LEFT JOIN  `wp_usermeta` as `T3` ON  `ID` =  `T3`.`user_id` 
	LEFT JOIN  `wp_usermeta` as `T4` ON  `ID` =  `T4`.`user_id` 
	LEFT JOIN  `wp_usermeta` as `T5` ON  `ID` =  `T5`.`user_id` 
	LEFT JOIN  `wp_usermeta` as `T6` ON  `ID` =  `T6`.`user_id` 
	LEFT JOIN  `wp_usermeta` as `T7` ON  `ID` =  `T7`.`user_id` 
	LEFT JOIN  `wp_usermeta` as `T8` ON  `ID` =  `T8`.`user_id` 
	LEFT JOIN  `wp_usermeta` as `T9` ON  `ID` =  `T9`.`user_id` 
	LEFT JOIN  `wp_usermeta` as `T0` ON  `ID` =  `T0`.`user_id` 
WHERE
	`T1`.`meta_key` = 'first_name' AND
	`T2`.`meta_key` = 'last_name' AND
	`T3`.`meta_key` = '_money_spent' AND
	`T4`.`meta_key` = '_order_count' AND
	`T5`.`meta_key` = 'shipping_country' AND
	`T6`.`meta_key` = 'shipping_city' AND
	`T7`.`meta_key` = 'shipping_address_1' AND
	`T8`.`meta_key` = 'shipping_address_2' AND
	`T9`.`meta_key` = 'shipping_postcode' AND
	`T0`.`meta_key` = 'shipping_company' 

woo_products.sql

SELECT post_name AS 'Handle',
       post_title AS 'Title',
       post_content AS 'Body',
       'splendette' AS 'Vendor',
       (SELECT `name` FROM wp_terms WHERE term_id = (
          SELECT term_id FROM wp_term_taxonomy WHERE taxonomy = 'product_cat' AND term_taxonomy_id IN (
              SELECT term_taxonomy_id FROM wp_term_relationships WHERE object_id = ID)
          )
       ) AS 'Type',
       'TRUE' AS 'Published',
       `T0`.`meta_value` AS 'Variant SKU',
       `T2`.`meta_value` AS 'Variant Grams',
       'shopify' AS 'Variant Inventory Tracker',
       'manual' AS 'Variant Fulfillment Service',
       round(`T4`.`meta_value`) AS 'Variant Inventory Qty',
       'deny' AS 'Variant Inventory Policy',
       `T1`.`meta_value` AS 'Variant Price',
       'TRUE' AS 'Variant Requires Shipping',
       'TRUE' AS 'Variant Taxable',
       (SELECT guid FROM wp_posts WHERE ID = `T3`.`meta_value`) AS 'Image Src',
       'FALSE' AS 'Gift Card',
       'kg' AS 'Variant Weight Unit'
FROM wp_posts
       LEFT JOIN `wp_postmeta` AS `T0` ON `ID` = `T0`.`post_id`
       LEFT JOIN `wp_postmeta` AS `T1` ON `ID` = `T1`.`post_id`
       LEFT JOIN `wp_postmeta` AS `T2` ON `ID` = `T2`.`post_id`
       LEFT JOIN `wp_postmeta` AS `T3` ON `ID` = `T3`.`post_id`
       LEFT JOIN `wp_postmeta` AS `T4` ON `ID` = `T4`.`post_id`
WHERE post_type = 'product'
       AND post_status = 'publish'
       AND `T0`.`meta_key` = '_sku'
       AND `T1`.`meta_key` = '_regular_price'
       AND `T2`.`meta_key` = '_weight'
       AND `T3`.`meta_key` = '_thumbnail_id'
       AND `T4`.`meta_key` = '_stock'