Блог веб разработчика

22.10.202222.10.2022

Show list out of stock products

<?php
include( 'wp-load.php' );
// Setup your custom query
$args = [
    'post_type' => ['product'/*, 'post', 'page'*/],
    'posts_per_page' => -1,
    'post_status' => 'publish'
];
$loop = new WP_Query( $args );

while ( $loop->have_posts() ) : $loop->the_post();
	global $post;	
	$product = wc_get_product( $post->ID );		
	if($product->get_stock_status() == 'outofstock'){
		echo 'Out of stock simple product ID: '.$post->ID.' link: '.get_permalink( $product->ID ).' Title: '.$product->get_title().'<br>';
	}
	 if ($product->get_type() == "variable" && $post->post_name != 'bra') {		
        $variations = $product->get_available_variations();
		foreach($variations as $variation){
			 $variation_id = $variation['variation_id'];
			 $variation_obj = new WC_Product_variation($variation_id);			 
			 if($product->get_stock_status() == 'outofstock'){
				echo 'Out of stock variation product ID: '.$variation_id .' link: '.get_permalink( $product->ID ).' Title: '.$variation_obj->get_title().'<br>';
			}
		}
    }	
	 
endwhile; wp_reset_query(); // Remember to reset 
echo 'stock update done';
?>

<?php

include( 'wp-load.php' );

// Setup your custom query

$args = [

'post_type' => ['product'/*, 'post', 'page'*/],

'posts_per_page' => -1,

'post_status' => 'publish'

];

$loop = new WP_Query( $args );

while ( $loop->have_posts() ) : $loop->the_post();

global $post;

$product = wc_get_product( $post->ID );

if($product->get_stock_status() == 'outofstock'){

echo 'Out of stock simple product ID: '.$post->ID.' link: '.get_permalink( $product->ID ).' Title: '.$product->get_title().' ';

}

if ($product->get_type() == "variable" && $post->post_name != 'bra') {

$variations = $product->get_available_variations();

foreach($variations as $variation){

$variation_id = $variation['variation_id'];

$variation_obj = new WC_Product_variation($variation_id);

if($product->get_stock_status() == 'outofstock'){

echo 'Out of stock variation product ID: '.$variation_id .' link: '.get_permalink( $product->ID ).' Title: '.$variation_obj->get_title().' ';

}

endwhile; wp_reset_query(); // Remember to reset

echo 'stock update done';

22.10.2022

Убрать количество товара, оставив instock

Данный код уберет численные значения товара на складе, оставив просто instock

<?php
include( 'wp-load.php' );
// Setup your custom query
$args = [
    'post_type' => ['product'/*, 'post', 'page'*/],
    'posts_per_page' => -1,
    'post_status' => 'publish'
];
$loop = new WP_Query( $args );

while ( $loop->have_posts() ) : $loop->the_post();
	global $post;	
	$product = wc_get_product( $post->ID );		
	if($product->get_stock_quantity()>0 && $product->get_manage_stock() == 'yes' && $post->post_name != 'bra'){
		echo 'Update stock for simple product ID: '.$post->ID.' slug: '.$post->post_name.' Title: '.$product->get_title().' Old quantity: '.$product->get_stock_quantity().'<br>';
		// Using WC setters
        $product->set_manage_stock(false);
        $product->set_stock_quantity(0);
        $product->set_stock_status('instock');
        
        // Save Product
        $product->save();
	}
	 if ($product->get_type() == "variable" && $post->post_name != 'bra') {		
        $variations = $product->get_available_variations();
		foreach($variations as $variation){
			 $variation_id = $variation['variation_id'];
			 $variation_obj = new WC_Product_variation($variation_id);			 
			 if($variation_obj->get_stock_quantity()>0 && $variation_obj->get_manage_stock() == 'yes'){
				echo 'Update stock for variation product ID: '.$variation_id .' slug: '.$post->post_name.' Title: '.$variation_obj->get_title().' Old quantity: '.$variation_obj->get_stock_quantity().'<br>';
				// Using WC setters
				$variation_obj->set_manage_stock(false);
				$variation_obj->set_stock_quantity(0);
				$variation_obj->set_stock_status('instock');

				// Save Product
				$variation_obj->save();
			}
		}
    }	
	 
endwhile; wp_reset_query(); // Remember to reset 
echo 'stock update done';
?>

<?php

include( 'wp-load.php' );

// Setup your custom query

$args = [

'post_type' => ['product'/*, 'post', 'page'*/],

'posts_per_page' => -1,

'post_status' => 'publish'

];

$loop = new WP_Query( $args );

while ( $loop->have_posts() ) : $loop->the_post();

global $post;

$product = wc_get_product( $post->ID );

if($product->get_stock_quantity()>0 && $product->get_manage_stock() == 'yes' && $post->post_name != 'bra'){

echo 'Update stock for simple product ID: '.$post->ID.' slug: '.$post->post_name.' Title: '.$product->get_title().' Old quantity: '.$product->get_stock_quantity().' ';

// Using WC setters

$product->set_manage_stock(false);

$product->set_stock_quantity(0);

$product->set_stock_status('instock');

// Save Product

$product->save();

}

if ($product->get_type() == "variable" && $post->post_name != 'bra') {

$variations = $product->get_available_variations();

foreach($variations as $variation){

$variation_id = $variation['variation_id'];

$variation_obj = new WC_Product_variation($variation_id);

if($variation_obj->get_stock_quantity()>0 && $variation_obj->get_manage_stock() == 'yes'){

echo 'Update stock for variation product ID: '.$variation_id .' slug: '.$post->post_name.' Title: '.$variation_obj->get_title().' Old quantity: '.$variation_obj->get_stock_quantity().' ';

// Using WC setters

$variation_obj->set_manage_stock(false);

$variation_obj->set_stock_quantity(0);

$variation_obj->set_stock_status('instock');

// Save Product

$variation_obj->save();

}

endwhile; wp_reset_query(); // Remember to reset

echo 'stock update done';

Создается отдельный php файл, к которому напрямую идет обращение из адресной строки браузера.

15.10.202215.10.2022

Получить количество товара в корзине

WC()->cart->get_cart_contents_count() – it allows to get a number of cart items including their quantity counts. For example, if you have 10 snowboards and 1 avocado toast in the cart, this method will return 11! You can see it yourself if you open this method in WooCommerce source code. It just gets the whole cart array from WC()->cart->get_cart() and then for each item it gets its quantity parameter.
count( WC()->cart->get_cart() ) – this implementation actually returns the number of unique products in the cart, one per product.

14.10.2022

Устранение неполадок в работе ISPmanager

timeweb.com/ru/help/pages/viewpage.action?pageId=27459605

29.08.202229.08.2022

Woocommerce вывести ниже цену

Если для простых товаров нужно опустить цену ниже рейтинга в summary:

add_action('woocommerce_single_product_summary', 'move_single_product_price', 1);
function move_single_product_price() {
    remove_action('woocommerce_single_product_summary', 'woocommerce_template_single_price', 10);
    add_action('woocommerce_single_product_summary', 'woocommerce_template_single_price', 29);
}

add_action('woocommerce_single_product_summary', 'move_single_product_price', 1);

function move_single_product_price() {

remove_action('woocommerce_single_product_summary', 'woocommerce_template_single_price', 10);

add_action('woocommerce_single_product_summary', 'woocommerce_template_single_price', 29);

}

27.08.2022

Woocommerce вывести цену выше вариаций

remove_action( ‘woocommerce_single_variation’, ‘woocommerce_single_variation’, 10);
add_action( ‘woocommerce_before_variations_form’, ‘woocommerce_single_variation’, 20);

11.08.202211.08.2022

SQL SET WHERE

UPDATE `wp_comments` SET `comment_type` = 'review' WHERE `comment_type` = 'comment' AND `comment_approved` = 1

1	UPDATE `wp_comments` SET `comment_type` = 'review' WHERE `comment_type` = 'comment' AND `comment_approved` = 1

неплохой сайт со всеми операторами SQL https://www.w3schools.com/sql/sql_update.asp
Изменить тип комментария для товаров:

UPDATE ic 
SET ic.comment_type = 'review' 
FROM in_comments AS ic
INNER JOIN in_posts AS ip 
       ON ic.comment_post_ID = ip.ID 
WHERE ic.comment_type = 'comment' AND ip.post_type = 'product'

UPDATE ic

SET ic.comment_type = 'review'

FROM in_comments AS ic

INNER JOIN in_posts AS ip

ON ic.comment_post_ID = ip.ID

WHERE ic.comment_type = 'comment' AND ip.post_type = 'product'

16.06.2022

Woocommerce Catalogue visibility

$wc_product->get_catalog_visibility()

1	$wc_product->get_catalog_visibility()

С помощью этого кода можно проверить, выбрано ли скрывать товар в каталоге и поиске

18.05.2022

Сравнить поля в xml файлах

$i=0;
$array_id_old_feed = [];
$array_id_new_feed = [];
$xml = simplexml_load_file('VBHy6J9p0cSJyNpgzftWAyeemploypsg.xml');

$p_cnt = count($xml->channel->item);
echo 'Count for item old feed: '.$p_cnt.'<br/>';
foreach ($xml->channel->item as $value){
    $i++;
	//echo $i.' '.$value->id . '<br/>';
	array_push($array_id_old_feed ,strval($value->id));	
} 

$xml = simplexml_load_file('E-Commerce_Product_List.xml');
$p_cnt = count($xml->channel->item);
echo 'Count for item new feed: '.$p_cnt.'<br/>';
$i=0;
foreach ($xml->channel->item as $value){
	$i++;
  //  echo $i.' '.$value->id . '<br/>';
	array_push($array_id_new_feed ,strval($value->id));	
}
$i=0;
echo '<br/>Search differnce id between old and new<br/>';
foreach($array_id_old_feed as $array_id_old_feed_item){
	//var_dump(in_array($array_id_old_feed_item, $array_id_new_feed));
	if(!in_array($array_id_old_feed_item, $array_id_new_feed)){
		$i++;
		echo '<br/>'.$i.' '.$array_id_old_feed_item;		
	}
}
echo '<br/>'.$i.' differences finded between old and new<br/>';
echo '<br/>Search differnce id between new and old<br/>';
$i=0;
foreach($array_id_new_feed as $array_id_new_feed_item){
	//var_dump(!in_array($array_id_new_feed_item, $array_id_old_feed));
	if(!in_array($array_id_new_feed_item, $array_id_old_feed)){
		$i++;
		echo '<br/>'.$i.' '.$array_id_new_feed_item;		
	}
}
echo '<br/>'.$i.' differences finded between new and old<br/>';

$i=0;

$array_id_old_feed = [];

$array_id_new_feed = [];

$xml = simplexml_load_file('VBHy6J9p0cSJyNpgzftWAyeemploypsg.xml');

$p_cnt = count($xml->channel->item);

echo 'Count for item old feed: '.$p_cnt.' ';

foreach ($xml->channel->item as $value){

$i++;

//echo $i.' '.$value->id . ' ';

array_push($array_id_old_feed ,strval($value->id));

}

$xml = simplexml_load_file('E-Commerce_Product_List.xml');

$p_cnt = count($xml->channel->item);

echo 'Count for item new feed: '.$p_cnt.' ';

$i=0;

foreach ($xml->channel->item as $value){

$i++;

// echo $i.' '.$value->id . ' ';

array_push($array_id_new_feed ,strval($value->id));

}

$i=0;

echo ' Search differnce id between old and new ';

foreach($array_id_old_feed as $array_id_old_feed_item){

//var_dump(in_array($array_id_old_feed_item, $array_id_new_feed));

if(!in_array($array_id_old_feed_item, $array_id_new_feed)){

$i++;

echo ' '.$i.' '.$array_id_old_feed_item;

}

echo ' '.$i.' differences finded between old and new ';

echo ' Search differnce id between new and old ';

$i=0;

foreach($array_id_new_feed as $array_id_new_feed_item){

//var_dump(!in_array($array_id_new_feed_item, $array_id_old_feed));

if(!in_array($array_id_new_feed_item, $array_id_old_feed)){

$i++;

echo ' '.$i.' '.$array_id_new_feed_item;

}

echo ' '.$i.' differences finded between new and old ';

11.05.2022

nginx изменить conf

Чтобы изменить файл конфигурации сервера:
— Нужно зайти на сервер под суперпользователем
— Затем выполнить sudo su и стать root пользователем
— Выполнить команду vi /etc/nginx/site/site.conf
— Внизу будет зеленым сообщение, что данный файл уже используется нажать edit anymore
— Нажать Shift + ‘i’ для активации режима вставки
— Команда Shift + ‘;’ активирует снизу строку для ввода команды
— Сделать необходимые изменения и сохранить :wq (:q! — выйти без сохранения)
— Затем нужно проверить корректность конфигурации nginx -t
— Перезапускаем nginx коммандой service nginx reload