INSERT INTO 8k3sW1_postmeta (post_id, meta_key, meta_value) SELECT ID, '_manage_stock', 'yes' FROM 8k3sW1_posts WHERE post_type='product' AND ID NOT IN (SELECT post_id FROM 8k3sW1_postmeta WHERE meta_key = '_manage_stock');
INSERT INTO 8k3sW1_postmeta (post_id, meta_key, meta_value) SELECT ID, '_stock', '' FROM 8k3sW1_posts WHERE post_type='product' AND ID NOT IN (SELECT post_id FROM 8k3sW1_postmeta WHERE meta_key = '_stock');
INSERT INTO 8k3sW1_postmeta (post_id, meta_key, meta_value) SELECT ID, '_price', '' FROM 8k3sW1_posts WHERE post_type='product' AND ID NOT IN (SELECT post_id FROM 8k3sW1_postmeta WHERE meta_key = '_price');
INSERT INTO 8k3sW1_postmeta (post_id, meta_key, meta_value) SELECT ID, 'wholesale_customer_wholesale_price', '' FROM 8k3sW1_posts WHERE post_type='product' AND ID NOT IN (SELECT post_id FROM 8k3sW1_postmeta WHERE meta_key = 'wholesale_customer_wholesale_price');
INSERT INTO 8k3sW1_postmeta (post_id, meta_key, meta_value) SELECT ID, 'wholesale_customer_17_wholesale_price', '' FROM 8k3sW1_posts WHERE post_type='product' AND ID NOT IN (SELECT post_id FROM 8k3sW1_postmeta WHERE meta_key = 'wholesale_customer_17_wholesale_price');
INSERT INTO 8k3sW1_postmeta (post_id, meta_key, meta_value) SELECT ID, 'wholesale_customer_0_wholesale_price', '' FROM 8k3sW1_posts WHERE post_type='product' AND ID NOT IN (SELECT post_id FROM 8k3sW1_postmeta WHERE meta_key = 'wholesale_customer_0_wholesale_price');
INSERT INTO 8k3sW1_postmeta (post_id, meta_key, meta_value) SELECT ID, '_initial_wholesale_price', '' FROM 8k3sW1_posts WHERE post_type='product' AND ID NOT IN (SELECT post_id FROM 8k3sW1_postmeta WHERE meta_key = '_initial_wholesale_price');
INSERT INTO 8k3sW1_postmeta (post_id, meta_key, meta_value) SELECT ID, 'sync_with_erp', 'N' FROM 8k3sW1_posts WHERE post_type='product' AND ID NOT IN (SELECT post_id FROM 8k3sW1_postmeta WHERE meta_key = 'sync_with_erp');
INSERT INTO 8k3sW1_postmeta (post_id, meta_key, meta_value) SELECT ID, '_manage_stock', 'yes' FROM 8k3sW1_posts WHERE post_type='product_variation' AND post_parent > 0 AND ID NOT IN (SELECT post_id FROM 8k3sW1_postmeta WHERE meta_key = '_manage_stock');
INSERT INTO 8k3sW1_postmeta (post_id, meta_key, meta_value) SELECT ID, '_stock', '' FROM 8k3sW1_posts WHERE post_type='product_variation' AND post_parent > 0 AND ID NOT IN (SELECT post_id FROM 8k3sW1_postmeta WHERE meta_key = '_stock');
INSERT INTO 8k3sW1_postmeta (post_id, meta_key, meta_value) SELECT ID, '_price', '' FROM 8k3sW1_posts WHERE post_type='product_variation' AND post_parent > 0 AND ID NOT IN (SELECT post_id FROM 8k3sW1_postmeta WHERE meta_key = '_price');
INSERT INTO 8k3sW1_postmeta (post_id, meta_key, meta_value) SELECT ID, '_regular_price', '' FROM 8k3sW1_posts WHERE post_type='product_variation' AND post_parent > 0 AND ID NOT IN (SELECT post_id FROM 8k3sW1_postmeta WHERE meta_key = '_regular_price');
INSERT INTO 8k3sW1_postmeta (post_id, meta_key, meta_value) SELECT ID, '_sale_price', '' FROM 8k3sW1_posts WHERE post_type='product_variation' AND post_parent > 0 AND ID NOT IN (SELECT post_id FROM 8k3sW1_postmeta WHERE meta_key = '_sale_price');
INSERT INTO 8k3sW1_postmeta (post_id, meta_key, meta_value) SELECT ID, 'wholesale_customer_wholesale_price', '' FROM 8k3sW1_posts WHERE post_type='product_variation' AND post_parent > 0 AND ID NOT IN (SELECT post_id FROM 8k3sW1_postmeta WHERE meta_key = 'wholesale_customer_wholesale_price');
INSERT INTO 8k3sW1_postmeta (post_id, meta_key, meta_value) SELECT ID, 'wholesale_customer_17_wholesale_price', '' FROM 8k3sW1_posts WHERE post_type='product_variation' AND post_parent > 0 AND ID NOT IN (SELECT post_id FROM 8k3sW1_postmeta WHERE meta_key = 'wholesale_customer_17_wholesale_price');
INSERT INTO 8k3sW1_postmeta (post_id, meta_key, meta_value) SELECT ID, 'wholesale_customer_0_wholesale_price', '' FROM 8k3sW1_posts WHERE post_type='product_variation' AND post_parent > 0 AND ID NOT IN (SELECT post_id FROM 8k3sW1_postmeta WHERE meta_key = 'wholesale_customer_0_wholesale_price');
INSERT INTO 8k3sW1_postmeta (post_id, meta_key, meta_value) SELECT DISTINCT post_parent, '_initial_wholesale_price', '' FROM 8k3sW1_posts WHERE post_parent > 0 AND post_parent NOT IN (SELECT DISTINCT post_id FROM 8k3sW1_postmeta WHERE meta_key = '_initial_wholesale_price');
INSERT INTO 8k3sW1_postmeta (post_id, meta_key, meta_value) SELECT ID, 'sync_with_erp', 'N' FROM 8k3sW1_posts WHERE post_type='product_variation' AND post_parent > 0 AND ID NOT IN (SELECT post_id FROM 8k3sW1_postmeta WHERE meta_key = 'sync_with_erp');
UPDATE 8k3sW1_postmeta SET meta_value='119.9' WHERE post_id=106944 AND meta_key='_price';
UPDATE 8k3sW1_postmeta SET meta_value='48' WHERE post_id=106944 AND (meta_key='wholesale_customer_wholesale_price' OR meta_key='wholesale_customer_17_wholesale_price' OR meta_key='wholesale_customer_0_wholesale_price');
UPDATE 8k3sW1_postmeta SET meta_value='119.9' WHERE post_id=106943 AND meta_key='_price';
UPDATE 8k3sW1_postmeta SET meta_value='119.9' WHERE post_id=106944 AND meta_key='_regular_price';
UPDATE 8k3sW1_postmeta SET meta_value='' WHERE post_id=106944 AND meta_key='_sale_price';
UPDATE 8k3sW1_postmeta SET meta_value='0' WHERE post_id=106944 AND meta_key='_stock';
UPDATE 8k3sW1_postmeta SET meta_value='outofstock' WHERE post_id=106944 AND meta_key='_stock_status';
UPDATE 8k3sW1_postmeta SET meta_value='N' WHERE post_id=106944 AND meta_key='sync_with_erp';
UPDATE 8k3sW1_postmeta SET meta_value='no' WHERE post_ID=106943 AND meta_key='_manage_stock';
UPDATE 8k3sW1_postmeta SET meta_value='0' WHERE post_ID=106943 AND meta_key='_stock';
UPDATE 8k3sW1_postmeta SET meta_value='outofstock' WHERE post_ID=106943 AND meta_key='_stock_status';
UPDATE 8k3sW1_posts SET post_modified='2025-12-27 11:41:56', post_modified_gmt='2025-12-27 09:41:56' WHERE ID=106943;
UPDATE 8k3sW1_posts SET post_modified='2025-12-27 11:41:56', post_modified_gmt='2025-12-27 09:41:56' WHERE ID=106944;
UPDATE 8k3sW1_postmeta SET meta_value='119.9' WHERE post_id=106945 AND meta_key='_price';
UPDATE 8k3sW1_postmeta SET meta_value='48' WHERE post_id=106945 AND (meta_key='wholesale_customer_wholesale_price' OR meta_key='wholesale_customer_17_wholesale_price' OR meta_key='wholesale_customer_0_wholesale_price');
UPDATE 8k3sW1_postmeta SET meta_value='119.9' WHERE post_id=106943 AND meta_key='_price';
UPDATE 8k3sW1_postmeta SET meta_value='119.9' WHERE post_id=106945 AND meta_key='_regular_price';
UPDATE 8k3sW1_postmeta SET meta_value='' WHERE post_id=106945 AND meta_key='_sale_price';
UPDATE 8k3sW1_postmeta SET meta_value='0' WHERE post_id=106945 AND meta_key='_stock';
UPDATE 8k3sW1_postmeta SET meta_value='outofstock' WHERE post_id=106945 AND meta_key='_stock_status';
UPDATE 8k3sW1_postmeta SET meta_value='N' WHERE post_id=106945 AND meta_key='sync_with_erp';
UPDATE 8k3sW1_postmeta SET meta_value='no' WHERE post_ID=106943 AND meta_key='_manage_stock';
UPDATE 8k3sW1_postmeta SET meta_value='0' WHERE post_ID=106943 AND meta_key='_stock';
UPDATE 8k3sW1_postmeta SET meta_value='outofstock' WHERE post_ID=106943 AND meta_key='_stock_status';
UPDATE 8k3sW1_posts SET post_modified='2025-12-27 11:41:56', post_modified_gmt='2025-12-27 09:41:56' WHERE ID=106943;
UPDATE 8k3sW1_posts SET post_modified='2025-12-27 11:41:56', post_modified_gmt='2025-12-27 09:41:56' WHERE ID=106945;
UPDATE 8k3sW1_postmeta SET meta_value='119.9' WHERE post_id=106946 AND meta_key='_price';
UPDATE 8k3sW1_postmeta SET meta_value='48' WHERE post_id=106946 AND (meta_key='wholesale_customer_wholesale_price' OR meta_key='wholesale_customer_17_wholesale_price' OR meta_key='wholesale_customer_0_wholesale_price');
UPDATE 8k3sW1_postmeta SET meta_value='119.9' WHERE post_id=106943 AND meta_key='_price';
UPDATE 8k3sW1_postmeta SET meta_value='119.9' WHERE post_id=106946 AND meta_key='_regular_price';
UPDATE 8k3sW1_postmeta SET meta_value='' WHERE post_id=106946 AND meta_key='_sale_price';
UPDATE 8k3sW1_postmeta SET meta_value='0' WHERE post_id=106946 AND meta_key='_stock';
UPDATE 8k3sW1_postmeta SET meta_value='outofstock' WHERE post_id=106946 AND meta_key='_stock_status';
UPDATE 8k3sW1_postmeta SET meta_value='N' WHERE post_id=106946 AND meta_key='sync_with_erp';
UPDATE 8k3sW1_postmeta SET meta_value='no' WHERE post_ID=106943 AND meta_key='_manage_stock';
UPDATE 8k3sW1_postmeta SET meta_value='0' WHERE post_ID=106943 AND meta_key='_stock';
UPDATE 8k3sW1_postmeta SET meta_value='outofstock' WHERE post_ID=106943 AND meta_key='_stock_status';
UPDATE 8k3sW1_posts SET post_modified='2025-12-27 11:41:56', post_modified_gmt='2025-12-27 09:41:56' WHERE ID=106943;
UPDATE 8k3sW1_posts SET post_modified='2025-12-27 11:41:56', post_modified_gmt='2025-12-27 09:41:56' WHERE ID=106946;
UPDATE 8k3sW1_postmeta SET meta_value='119.9' WHERE post_id=106947 AND meta_key='_price';
UPDATE 8k3sW1_postmeta SET meta_value='48' WHERE post_id=106947 AND (meta_key='wholesale_customer_wholesale_price' OR meta_key='wholesale_customer_17_wholesale_price' OR meta_key='wholesale_customer_0_wholesale_price');
UPDATE 8k3sW1_postmeta SET meta_value='119.9' WHERE post_id=106943 AND meta_key='_price';
UPDATE 8k3sW1_postmeta SET meta_value='119.9' WHERE post_id=106947 AND meta_key='_regular_price';
UPDATE 8k3sW1_postmeta SET meta_value='' WHERE post_id=106947 AND meta_key='_sale_price';
UPDATE 8k3sW1_postmeta SET meta_value='0' WHERE post_id=106947 AND meta_key='_stock';
UPDATE 8k3sW1_postmeta SET meta_value='outofstock' WHERE post_id=106947 AND meta_key='_stock_status';
UPDATE 8k3sW1_postmeta SET meta_value='N' WHERE post_id=106947 AND meta_key='sync_with_erp';
UPDATE 8k3sW1_postmeta SET meta_value='no' WHERE post_ID=106943 AND meta_key='_manage_stock';
UPDATE 8k3sW1_postmeta SET meta_value='0' WHERE post_ID=106943 AND meta_key='_stock';
UPDATE 8k3sW1_postmeta SET meta_value='outofstock' WHERE post_ID=106943 AND meta_key='_stock_status';
UPDATE 8k3sW1_posts SET post_modified='2025-12-27 11:41:56', post_modified_gmt='2025-12-27 09:41:56' WHERE ID=106943;
UPDATE 8k3sW1_posts SET post_modified='2025-12-27 11:41:56', post_modified_gmt='2025-12-27 09:41:56' WHERE ID=106947;
UPDATE 8k3sW1_postmeta SET meta_value='154.9' WHERE post_id=107518 AND meta_key='_price';
UPDATE 8k3sW1_postmeta SET meta_value='57.4' WHERE post_id=107518 AND (meta_key='wholesale_customer_wholesale_price' OR meta_key='wholesale_customer_17_wholesale_price' OR meta_key='wholesale_customer_0_wholesale_price');
UPDATE 8k3sW1_postmeta SET meta_value='154.9' WHERE post_id=107517 AND meta_key='_price';
UPDATE 8k3sW1_postmeta SET meta_value='154.9' WHERE post_id=107518 AND meta_key='_regular_price';
UPDATE 8k3sW1_postmeta SET meta_value='' WHERE post_id=107518 AND meta_key='_sale_price';
UPDATE 8k3sW1_postmeta SET meta_value='0' WHERE post_id=107518 AND meta_key='_stock';
UPDATE 8k3sW1_postmeta SET meta_value='outofstock' WHERE post_id=107518 AND meta_key='_stock_status';
UPDATE 8k3sW1_postmeta SET meta_value='N' WHERE post_id=107518 AND meta_key='sync_with_erp';
UPDATE 8k3sW1_postmeta SET meta_value='no' WHERE post_ID=107517 AND meta_key='_manage_stock';
UPDATE 8k3sW1_postmeta SET meta_value='0' WHERE post_ID=107517 AND meta_key='_stock';
UPDATE 8k3sW1_postmeta SET meta_value='outofstock' WHERE post_ID=107517 AND meta_key='_stock_status';
UPDATE 8k3sW1_posts SET post_modified='2025-12-27 11:41:56', post_modified_gmt='2025-12-27 09:41:56' WHERE ID=107517;
UPDATE 8k3sW1_posts SET post_modified='2025-12-27 11:41:56', post_modified_gmt='2025-12-27 09:41:56' WHERE ID=107518;
UPDATE 8k3sW1_postmeta SET meta_value='154.9' WHERE post_id=107519 AND meta_key='_price';
UPDATE 8k3sW1_postmeta SET meta_value='57.4' WHERE post_id=107519 AND (meta_key='wholesale_customer_wholesale_price' OR meta_key='wholesale_customer_17_wholesale_price' OR meta_key='wholesale_customer_0_wholesale_price');
UPDATE 8k3sW1_postmeta SET meta_value='154.9' WHERE post_id=107517 AND meta_key='_price';
UPDATE 8k3sW1_postmeta SET meta_value='154.9' WHERE post_id=107519 AND meta_key='_regular_price';
UPDATE 8k3sW1_postmeta SET meta_value='' WHERE post_id=107519 AND meta_key='_sale_price';
UPDATE 8k3sW1_postmeta SET meta_value='0' WHERE post_id=107519 AND meta_key='_stock';
UPDATE 8k3sW1_postmeta SET meta_value='outofstock' WHERE post_id=107519 AND meta_key='_stock_status';
UPDATE 8k3sW1_postmeta SET meta_value='N' WHERE post_id=107519 AND meta_key='sync_with_erp';
UPDATE 8k3sW1_postmeta SET meta_value='no' WHERE post_ID=107517 AND meta_key='_manage_stock';
UPDATE 8k3sW1_postmeta SET meta_value='0' WHERE post_ID=107517 AND meta_key='_stock';
UPDATE 8k3sW1_postmeta SET meta_value='outofstock' WHERE post_ID=107517 AND meta_key='_stock_status';
UPDATE 8k3sW1_posts SET post_modified='2025-12-27 11:41:56', post_modified_gmt='2025-12-27 09:41:56' WHERE ID=107517;
UPDATE 8k3sW1_posts SET post_modified='2025-12-27 11:41:56', post_modified_gmt='2025-12-27 09:41:56' WHERE ID=107519;
UPDATE 8k3sW1_postmeta SET meta_value='154.9' WHERE post_id=107520 AND meta_key='_price';
UPDATE 8k3sW1_postmeta SET meta_value='57.4' WHERE post_id=107520 AND (meta_key='wholesale_customer_wholesale_price' OR meta_key='wholesale_customer_17_wholesale_price' OR meta_key='wholesale_customer_0_wholesale_price');
UPDATE 8k3sW1_postmeta SET meta_value='154.9' WHERE post_id=107517 AND meta_key='_price';
UPDATE 8k3sW1_postmeta SET meta_value='154.9' WHERE post_id=107520 AND meta_key='_regular_price';
UPDATE 8k3sW1_postmeta SET meta_value='' WHERE post_id=107520 AND meta_key='_sale_price';
UPDATE 8k3sW1_postmeta SET meta_value='0' WHERE post_id=107520 AND meta_key='_stock';
UPDATE 8k3sW1_postmeta SET meta_value='outofstock' WHERE post_id=107520 AND meta_key='_stock_status';
UPDATE 8k3sW1_postmeta SET meta_value='N' WHERE post_id=107520 AND meta_key='sync_with_erp';
UPDATE 8k3sW1_postmeta SET meta_value='no' WHERE post_ID=107517 AND meta_key='_manage_stock';
UPDATE 8k3sW1_postmeta SET meta_value='0' WHERE post_ID=107517 AND meta_key='_stock';
UPDATE 8k3sW1_postmeta SET meta_value='outofstock' WHERE post_ID=107517 AND meta_key='_stock_status';
UPDATE 8k3sW1_posts SET post_modified='2025-12-27 11:41:56', post_modified_gmt='2025-12-27 09:41:56' WHERE ID=107517;
UPDATE 8k3sW1_posts SET post_modified='2025-12-27 11:41:56', post_modified_gmt='2025-12-27 09:41:56' WHERE ID=107520;
UPDATE 8k3sW1_postmeta SET meta_value='174.9' WHERE post_id=107522 AND meta_key='_price';
UPDATE 8k3sW1_postmeta SET meta_value='64.8' WHERE post_id=107522 AND (meta_key='wholesale_customer_wholesale_price' OR meta_key='wholesale_customer_17_wholesale_price' OR meta_key='wholesale_customer_0_wholesale_price');
UPDATE 8k3sW1_postmeta SET meta_value='174.9' WHERE post_id=107521 AND meta_key='_price';
UPDATE 8k3sW1_postmeta SET meta_value='174.9' WHERE post_id=107522 AND meta_key='_regular_price';
UPDATE 8k3sW1_postmeta SET meta_value='' WHERE post_id=107522 AND meta_key='_sale_price';
UPDATE 8k3sW1_postmeta SET meta_value='0' WHERE post_id=107522 AND meta_key='_stock';
UPDATE 8k3sW1_postmeta SET meta_value='outofstock' WHERE post_id=107522 AND meta_key='_stock_status';
UPDATE 8k3sW1_postmeta SET meta_value='N' WHERE post_id=107522 AND meta_key='sync_with_erp';
UPDATE 8k3sW1_postmeta SET meta_value='no' WHERE post_ID=107521 AND meta_key='_manage_stock';
UPDATE 8k3sW1_postmeta SET meta_value='0' WHERE post_ID=107521 AND meta_key='_stock';
UPDATE 8k3sW1_postmeta SET meta_value='outofstock' WHERE post_ID=107521 AND meta_key='_stock_status';
UPDATE 8k3sW1_posts SET post_modified='2025-12-27 11:41:56', post_modified_gmt='2025-12-27 09:41:56' WHERE ID=107521;
UPDATE 8k3sW1_posts SET post_modified='2025-12-27 11:41:56', post_modified_gmt='2025-12-27 09:41:56' WHERE ID=107522;
UPDATE 8k3sW1_postmeta SET meta_value='174.9' WHERE post_id=107523 AND meta_key='_price';
UPDATE 8k3sW1_postmeta SET meta_value='64.8' WHERE post_id=107523 AND (meta_key='wholesale_customer_wholesale_price' OR meta_key='wholesale_customer_17_wholesale_price' OR meta_key='wholesale_customer_0_wholesale_price');
UPDATE 8k3sW1_postmeta SET meta_value='174.9' WHERE post_id=107521 AND meta_key='_price';
UPDATE 8k3sW1_postmeta SET meta_value='174.9' WHERE post_id=107523 AND meta_key='_regular_price';
UPDATE 8k3sW1_postmeta SET meta_value='' WHERE post_id=107523 AND meta_key='_sale_price';
UPDATE 8k3sW1_postmeta SET meta_value='0' WHERE post_id=107523 AND meta_key='_stock';
UPDATE 8k3sW1_postmeta SET meta_value='outofstock' WHERE post_id=107523 AND meta_key='_stock_status';
UPDATE 8k3sW1_postmeta SET meta_value='N' WHERE post_id=107523 AND meta_key='sync_with_erp';
UPDATE 8k3sW1_postmeta SET meta_value='no' WHERE post_ID=107521 AND meta_key='_manage_stock';
UPDATE 8k3sW1_postmeta SET meta_value='0' WHERE post_ID=107521 AND meta_key='_stock';
UPDATE 8k3sW1_postmeta SET meta_value='outofstock' WHERE post_ID=107521 AND meta_key='_stock_status';
UPDATE 8k3sW1_posts SET post_modified='2025-12-27 11:41:56', post_modified_gmt='2025-12-27 09:41:56' WHERE ID=107521;
UPDATE 8k3sW1_posts SET post_modified='2025-12-27 11:41:56', post_modified_gmt='2025-12-27 09:41:56' WHERE ID=107523;
UPDATE 8k3sW1_postmeta SET meta_value='174.9' WHERE post_id=107524 AND meta_key='_price';
UPDATE 8k3sW1_postmeta SET meta_value='64.8' WHERE post_id=107524 AND (meta_key='wholesale_customer_wholesale_price' OR meta_key='wholesale_customer_17_wholesale_price' OR meta_key='wholesale_customer_0_wholesale_price');
UPDATE 8k3sW1_postmeta SET meta_value='174.9' WHERE post_id=107521 AND meta_key='_price';
UPDATE 8k3sW1_postmeta SET meta_value='174.9' WHERE post_id=107524 AND meta_key='_regular_price';
UPDATE 8k3sW1_postmeta SET meta_value='' WHERE post_id=107524 AND meta_key='_sale_price';
UPDATE 8k3sW1_postmeta SET meta_value='0' WHERE post_id=107524 AND meta_key='_stock';
UPDATE 8k3sW1_postmeta SET meta_value='outofstock' WHERE post_id=107524 AND meta_key='_stock_status';
UPDATE 8k3sW1_postmeta SET meta_value='N' WHERE post_id=107524 AND meta_key='sync_with_erp';
UPDATE 8k3sW1_postmeta SET meta_value='no' WHERE post_ID=107521 AND meta_key='_manage_stock';
UPDATE 8k3sW1_postmeta SET meta_value='0' WHERE post_ID=107521 AND meta_key='_stock';
UPDATE 8k3sW1_postmeta SET meta_value='outofstock' WHERE post_ID=107521 AND meta_key='_stock_status';
UPDATE 8k3sW1_posts SET post_modified='2025-12-27 11:41:56', post_modified_gmt='2025-12-27 09:41:56' WHERE ID=107521;
UPDATE 8k3sW1_posts SET post_modified='2025-12-27 11:41:56', post_modified_gmt='2025-12-27 09:41:56' WHERE ID=107524;
UPDATE 8k3sW1_postmeta SET meta_value='174.9' WHERE post_id=107525 AND meta_key='_price';
UPDATE 8k3sW1_postmeta SET meta_value='64.8' WHERE post_id=107525 AND (meta_key='wholesale_customer_wholesale_price' OR meta_key='wholesale_customer_17_wholesale_price' OR meta_key='wholesale_customer_0_wholesale_price');
UPDATE 8k3sW1_postmeta SET meta_value='174.9' WHERE post_id=107521 AND meta_key='_price';
UPDATE 8k3sW1_postmeta SET meta_value='174.9' WHERE post_id=107525 AND meta_key='_regular_price';
UPDATE 8k3sW1_postmeta SET meta_value='' WHERE post_id=107525 AND meta_key='_sale_price';
UPDATE 8k3sW1_postmeta SET meta_value='0' WHERE post_id=107525 AND meta_key='_stock';
UPDATE 8k3sW1_postmeta SET meta_value='outofstock' WHERE post_id=107525 AND meta_key='_stock_status';
UPDATE 8k3sW1_postmeta SET meta_value='N' WHERE post_id=107525 AND meta_key='sync_with_erp';
UPDATE 8k3sW1_postmeta SET meta_value='no' WHERE post_ID=107521 AND meta_key='_manage_stock';
UPDATE 8k3sW1_postmeta SET meta_value='0' WHERE post_ID=107521 AND meta_key='_stock';
UPDATE 8k3sW1_postmeta SET meta_value='outofstock' WHERE post_ID=107521 AND meta_key='_stock_status';
UPDATE 8k3sW1_posts SET post_modified='2025-12-27 11:41:56', post_modified_gmt='2025-12-27 09:41:56' WHERE ID=107521;
UPDATE 8k3sW1_posts SET post_modified='2025-12-27 11:41:56', post_modified_gmt='2025-12-27 09:41:56' WHERE ID=107525;
UPDATE 8k3sW1_postmeta SET meta_value='174.9' WHERE post_id=107526 AND meta_key='_price';
UPDATE 8k3sW1_postmeta SET meta_value='64.8' WHERE post_id=107526 AND (meta_key='wholesale_customer_wholesale_price' OR meta_key='wholesale_customer_17_wholesale_price' OR meta_key='wholesale_customer_0_wholesale_price');
UPDATE 8k3sW1_postmeta SET meta_value='174.9' WHERE post_id=107521 AND meta_key='_price';
UPDATE 8k3sW1_postmeta SET meta_value='174.9' WHERE post_id=107526 AND meta_key='_regular_price';
UPDATE 8k3sW1_postmeta SET meta_value='' WHERE post_id=107526 AND meta_key='_sale_price';
UPDATE 8k3sW1_postmeta SET meta_value='0' WHERE post_id=107526 AND meta_key='_stock';
UPDATE 8k3sW1_postmeta SET meta_value='outofstock' WHERE post_id=107526 AND meta_key='_stock_status';
UPDATE 8k3sW1_postmeta SET meta_value='N' WHERE post_id=107526 AND meta_key='sync_with_erp';
UPDATE 8k3sW1_postmeta SET meta_value='no' WHERE post_ID=107521 AND meta_key='_manage_stock';
UPDATE 8k3sW1_postmeta SET meta_value='0' WHERE post_ID=107521 AND meta_key='_stock';
UPDATE 8k3sW1_postmeta SET meta_value='outofstock' WHERE post_ID=107521 AND meta_key='_stock_status';
UPDATE 8k3sW1_posts SET post_modified='2025-12-27 11:41:56', post_modified_gmt='2025-12-27 09:41:56' WHERE ID=107521;
UPDATE 8k3sW1_posts SET post_modified='2025-12-27 11:41:56', post_modified_gmt='2025-12-27 09:41:56' WHERE ID=107526;
UPDATE 8k3sW1_postmeta SET meta_value='174.9' WHERE post_id=107527 AND meta_key='_price';
UPDATE 8k3sW1_postmeta SET meta_value='64.8' WHERE post_id=107527 AND (meta_key='wholesale_customer_wholesale_price' OR meta_key='wholesale_customer_17_wholesale_price' OR meta_key='wholesale_customer_0_wholesale_price');
UPDATE 8k3sW1_postmeta SET meta_value='174.9' WHERE post_id=107521 AND meta_key='_price';
UPDATE 8k3sW1_postmeta SET meta_value='174.9' WHERE post_id=107527 AND meta_key='_regular_price';
UPDATE 8k3sW1_postmeta SET meta_value='' WHERE post_id=107527 AND meta_key='_sale_price';
UPDATE 8k3sW1_postmeta SET meta_value='0' WHERE post_id=107527 AND meta_key='_stock';
UPDATE 8k3sW1_postmeta SET meta_value='outofstock' WHERE post_id=107527 AND meta_key='_stock_status';
UPDATE 8k3sW1_postmeta SET meta_value='N' WHERE post_id=107527 AND meta_key='sync_with_erp';
UPDATE 8k3sW1_postmeta SET meta_value='no' WHERE post_ID=107521 AND meta_key='_manage_stock';
UPDATE 8k3sW1_postmeta SET meta_value='0' WHERE post_ID=107521 AND meta_key='_stock';
UPDATE 8k3sW1_postmeta SET meta_value='outofstock' WHERE post_ID=107521 AND meta_key='_stock_status';
UPDATE 8k3sW1_posts SET post_modified='2025-12-27 11:41:56', post_modified_gmt='2025-12-27 09:41:56' WHERE ID=107521;
UPDATE 8k3sW1_posts SET post_modified='2025-12-27 11:41:56', post_modified_gmt='2025-12-27 09:41:56' WHERE ID=107527;
UPDATE 8k3sW1_postmeta D INNER JOIN 8k3sW1_postmeta S ON S.post_id=103891 SET D.meta_value=S.meta_value WHERE S.meta_key='_price' AND D.meta_key='_price' AND D.post_id=104441;
UPDATE 8k3sW1_postmeta D INNER JOIN 8k3sW1_postmeta S ON S.post_id=103891 SET D.meta_value=S.meta_value WHERE S.meta_key='_regular_price' AND D.meta_key='_regular_price' AND D.post_id=104441;
UPDATE 8k3sW1_postmeta D INNER JOIN 8k3sW1_postmeta S ON S.post_id=103891 SET D.meta_value=S.meta_value WHERE S.meta_key='_sale_price' AND D.meta_key='_sale_price' AND D.post_id=104441;
UPDATE 8k3sW1_postmeta D INNER JOIN 8k3sW1_postmeta S ON S.post_id=103891 SET D.meta_value=S.meta_value WHERE S.meta_key='_stock' AND D.meta_key='_stock' AND D.post_id=104441;
UPDATE 8k3sW1_postmeta D INNER JOIN 8k3sW1_postmeta S ON S.post_id=103891 SET D.meta_value=S.meta_value WHERE S.meta_key='_stock_status' AND D.meta_key='_stock_status' AND D.post_id=104441;
UPDATE 8k3sW1_postmeta D INNER JOIN 8k3sW1_postmeta S ON S.post_id=103891 SET D.meta_value=S.meta_value WHERE S.meta_key='sync_with_erp' AND D.meta_key='sync_with_erp' AND D.post_id=104441;
UPDATE 8k3sW1_postmeta D INNER JOIN 8k3sW1_postmeta S ON S.post_id=103891 SET D.meta_value=S.meta_value WHERE S.meta_key='sync_months_lowest_price' AND D.meta_key='sync_months_lowest_price' AND D.post_id=104441;
UPDATE 8k3sW1_postmeta D INNER JOIN 8k3sW1_postmeta S ON S.post_id=103892 SET D.meta_value=S.meta_value WHERE S.meta_key='_price' AND D.meta_key='_price' AND D.post_id=104442;
UPDATE 8k3sW1_postmeta D INNER JOIN 8k3sW1_postmeta S ON S.post_id=103892 SET D.meta_value=S.meta_value WHERE S.meta_key='_regular_price' AND D.meta_key='_regular_price' AND D.post_id=104442;
UPDATE 8k3sW1_postmeta D INNER JOIN 8k3sW1_postmeta S ON S.post_id=103892 SET D.meta_value=S.meta_value WHERE S.meta_key='_sale_price' AND D.meta_key='_sale_price' AND D.post_id=104442;
UPDATE 8k3sW1_postmeta D INNER JOIN 8k3sW1_postmeta S ON S.post_id=103892 SET D.meta_value=S.meta_value WHERE S.meta_key='_stock' AND D.meta_key='_stock' AND D.post_id=104442;
UPDATE 8k3sW1_postmeta D INNER JOIN 8k3sW1_postmeta S ON S.post_id=103892 SET D.meta_value=S.meta_value WHERE S.meta_key='_stock_status' AND D.meta_key='_stock_status' AND D.post_id=104442;
UPDATE 8k3sW1_postmeta D INNER JOIN 8k3sW1_postmeta S ON S.post_id=103892 SET D.meta_value=S.meta_value WHERE S.meta_key='sync_with_erp' AND D.meta_key='sync_with_erp' AND D.post_id=104442;
UPDATE 8k3sW1_postmeta D INNER JOIN 8k3sW1_postmeta S ON S.post_id=103892 SET D.meta_value=S.meta_value WHERE S.meta_key='sync_months_lowest_price' AND D.meta_key='sync_months_lowest_price' AND D.post_id=104442;
UPDATE 8k3sW1_postmeta D INNER JOIN 8k3sW1_postmeta S ON S.post_id=103893 SET D.meta_value=S.meta_value WHERE S.meta_key='_price' AND D.meta_key='_price' AND D.post_id=104443;
UPDATE 8k3sW1_postmeta D INNER JOIN 8k3sW1_postmeta S ON S.post_id=103893 SET D.meta_value=S.meta_value WHERE S.meta_key='_regular_price' AND D.meta_key='_regular_price' AND D.post_id=104443;
UPDATE 8k3sW1_postmeta D INNER JOIN 8k3sW1_postmeta S ON S.post_id=103893 SET D.meta_value=S.meta_value WHERE S.meta_key='_sale_price' AND D.meta_key='_sale_price' AND D.post_id=104443;
UPDATE 8k3sW1_postmeta D INNER JOIN 8k3sW1_postmeta S ON S.post_id=103893 SET D.meta_value=S.meta_value WHERE S.meta_key='_stock' AND D.meta_key='_stock' AND D.post_id=104443;
UPDATE 8k3sW1_postmeta D INNER JOIN 8k3sW1_postmeta S ON S.post_id=103893 SET D.meta_value=S.meta_value WHERE S.meta_key='_stock_status' AND D.meta_key='_stock_status' AND D.post_id=104443;
UPDATE 8k3sW1_postmeta D INNER JOIN 8k3sW1_postmeta S ON S.post_id=103893 SET D.meta_value=S.meta_value WHERE S.meta_key='sync_with_erp' AND D.meta_key='sync_with_erp' AND D.post_id=104443;
UPDATE 8k3sW1_postmeta D INNER JOIN 8k3sW1_postmeta S ON S.post_id=103893 SET D.meta_value=S.meta_value WHERE S.meta_key='sync_months_lowest_price' AND D.meta_key='sync_months_lowest_price' AND D.post_id=104443;
