tuongpgjz

-- Run this SQL commands from PhpMyAdmin or similar ways
-- change the wp_ to your tables prefix to make it works
-- Script from SalesGen.io 

DELETE FROM wp_term_taxonomy WHERE taxonomy = 'product_cat' AND count = 0;
DELETE t FROM wp_terms t LEFT JOIN wp_term_taxonomy tt ON tt.term_id = t.term_id WHERE tt.term_id IS NULL;

tuongpgjz

-- Run this SQL commands from PhpMyAdmin or similar ways
-- change the wp_ to your tables prefix to make it works
-- Script from SalesGen.io 

UPDATE wp_term_taxonomy tt SET count = (SELECT COUNT(object_id) FROM wp_term_relationships WHERE term_taxonomy_id = tt.term_taxonomy_id) WHERE taxonomy = 'product_cat';

tuongpgjz

-- SalesGen.io

-- Change 'category name' by your category name

-- Reduce current price 5
update `wp_postmeta` SET meta_value = meta_value - 5 WHERE meta_key IN ('_regular_price', '_price') AND meta_value <> '' AND post_id IN (SELECT object_id from wp_term_relationships WHERE term_taxonomy_id IN(SELECT term_taxonomy_id FROM `wp_term_taxonomy` WHERE taxonomy = 'product_cat' AND term_id IN (SELECT term_id FROM `wp_terms` WHERE name = 'category name')));


-- Increase current price 5
update `wp_postmeta` SET meta_value = meta_value + 5 WHERE meta_key IN ('_regular_price', '_price') AND meta_value <> '' AND post_id IN (SELECT object_id from wp_term_relationships WHERE term_taxonomy_id IN(SELECT term_taxonomy_id FROM `wp_term_taxonomy` WHERE taxonomy = 'product_cat' AND term_id IN (SELECT term_id FROM `wp_terms` WHERE name = 'category name')))

tuongpgjz

-- replace category_name by your category name

DELETE FROM wp_posts WHERE ID IN (SELECT object_id from wp_term_relationships WHERE term_taxonomy_id IN(SELECT term_taxonomy_id FROM `wp_term_taxonomy` WHERE taxonomy = 'product_cat' AND term_id IN (SELECT term_id FROM `wp_terms` WHERE name like '%category_name%')))

tuongpgjz

-- Delete product variants
DELETE FROM wp_posts WHERE post_type = 'product_variation' AND post_parent IN (DELETE FROM wp_posts WHERE post_type = 'product' AND post_status = 'trash');

-- Delete main product
DELETE FROM wp_posts WHERE post_type = 'product' AND post_status = 'trash';

-- clean metapost
DELETE pm
FROM wp_postmeta pm

tuongpgjz

<?php
// SalesGen.io
// WooCommerce plugins, woocommerce upsell, woocommerce buy more save more

/*** Follow Steps ***/

// 1 Put the code below into the functions.php of your theme

add_filter('woocommerce_get_price_html', 'salesgen_hide_variation_price', 99, 2);
function salesgen_hide_variation_price( $v_price, $v_product ) {

tuongpgjz

div[id^=zoid-paypal-buttons]:nth-child(3),
div[id^=zoid-paypal-buttons]:nth-child(1) {
    display: none!important;
}

tuongpgjz

/*
Anthony from SalesGen.io
Demo page https://demo.salesgen.io/product/ninja-design/

Copy this script into your functions.php file theme
*/

add_action('wp_footer', function(){
/* Code By SalesGen.io */
?>

tuongpgjz

<?php
//SalesGen.io

//remove reviews and additional_information tab
add_filter( 'woocommerce_product_tabs', 'salesgen_remove_product_tabs', 98 );

function salesgen_remove_product_tabs( $tabs ) {
	if(is_product()){
		unset( $tabs['additional_information'] );   // Remove the additional information tab
		unset( $tabs['reviews'] );   // Remove the additional information tab

tuongpgjz

ALTER TABLE wp_postmeta ADD key(post_id, meta_key(100), meta_value(191));
ALTER TABLE wp_postmeta ADD key(meta_key(100), meta_value(191));

-- change wp_postmeta to your table with prefix