Set Incremental SKU-s to your WooCommerce products

When you have products with no SKU and you would like to set Incremental SKU numbers for them directly in the website – then this snippet will help you.

$base_sku = 100;
$args = array(
'post_type' => 'product',
'post_status' => 'publish',
'meta_query' => array(
'key' => '_sku',
'compare' => 'NOT EXISTS'
$query = new WP_Query($args);
while ($query->have_posts()) {
$product_id = get_the_ID();
$sku = $base_sku++;
update_post_meta($product_id, '_sku', "SK_".$sku);
die("DONE. You can remove this code from your website!");

That’s it. Now just run yourwebsitecom/?set_sku=1 once and done!

The code will create SK_100, SK_101, … SKU-s for your website.

If you want to create SKU-s for variation as well, we can improve our code and get this snippet below:

Continue reading “Set Incremental SKU-s to your WooCommerce products”

Rename existing WordPress Attachments files, titles

Rename wp media object

If you change your website name, or you have to change some strings in existing imagedata of your website, we need to do the following steps:

Step 1: Fetch all attachments

Step 2: Rename all corresponding uploaded files

Step 3: update attachment data so that new files would be recognized by WP

Step 4: Update title, description data as well.

Here is a snippet which implements all 4 steps above.

Continue reading “Rename existing WordPress Attachments files, titles”

How quickly get started with Open-AI DALL-E using PHP

Official documentation of Open AI gives 3 type of examples – NodeJS SDK, Python SDK and raw CURL.

I know there are several 3rd party PHP SDK-s in Github. But i also know most of excited testers would like to get started directly, without installing SDK and reading docs.

So, let’s implement raw CURL directly into PHP code and make DALL-E working in 1 minute.

You must get your API token here:

Once you have a key, just use this PHP snippet for DALL-E image generation:

Continue reading “How quickly get started with Open-AI DALL-E using PHP”

How to use Google DNS in Ubuntu/Debian permanently

Few weeks ago in one of the servers we faces strange issue: The website couldn’t send emails using remote SMTP.

First i thought it was related to SMTP port, credentials etc. – but everything was OK there. So then i tries to ping and got surprised. It wasn’t worked. Simple ping didn’t work.

So it was obviously corrupted DNS issue.

First i tried the easier way, which is recommended by, adding Google DNS IP addresses to resolv.conf file

sudo vi /etc/resolv.conf

But it didn’t help.

So i decided to go into deeper and solving it using netplan.

Continue reading “How to use Google DNS in Ubuntu/Debian permanently”

How to create downloadable PDF link that works in all mobile browsers – Chrome, Safari etc.

In some mobile browsers PDF links might not work properly.
Instead of downloading, its tab just disappears immediately after opening. And we get no downloaded PDF.

Auto-close, auto-disappear – whatever you call that – but the problem exists.

So for WordPress websites, here is how to skip this pdf-download block for mobile browsers.

We will use pseudo-page link in order to bypass that block.

I mean, instead of direct links to PDF, we will use pseudo-pdf link which doesn’t look like PDF, but actually returns PDF header and body.

Let’s say that we have a PDF ile in “wp-content/uploads/2022.pdf”.

Continue reading “How to create downloadable PDF link that works in all mobile browsers – Chrome, Safari etc.”

Creating dynamic partial content in Cached WordPress Pages using Rest API

Assume that we are using Fully cached static pages by any cache plugin. But we need to server some fresh content inside some block of the page.

To understand it easier let’s consider that we have fully cached homepage where there is a block about the number of your customers.

Something like this

Continue reading “Creating dynamic partial content in Cached WordPress Pages using Rest API”

How to modify the output of any WordPress shortcode

Assume we have some plugin called AAA and it has built-in shortcode aaa_content and its usage is like this:

[AAA_content title=”Recent news” id=”23″]

Now we want to change its output HTML.

In WordPress, the output of any 3rd party function can be changed only if it has apply_filters() filtered output. Unfortunately not all functions and shortcodes have such filter in output. So it is almost impossible to modify its output without editing the plugin’s source file.

And as we know, editing the plugin file is always bad idea. The changes will be erased just in the next update.

So we have some different approach for such cases.

For example, here is one idea, which is subject of this blog post.

Creating parent shortcode which handles the output of the original shortcode.

So let’s declare and build that alternative shortcode.

Continue reading “How to modify the output of any WordPress shortcode”