talkingimage

Chat gpt is suggest this

Add a Custom Discount % Field + Auto-Calculate (Advanced – Recommended for You)

Since you manage DB + WooCommerce directly, this is better long-term. Step 1 — Create a Custom Product Field

Add a custom meta field:

_discount_percentage

You can:

• Add via ACF
• Or add directly in database
• Or via code

Step 2 — Auto Calculate Sale Price from Regular Price

Add this in your functions.php:

add_action(‘save_post_product’, ‘auto_calculate_sale_price_from_discount’, 20, 3);
function auto_calculate_sale_price_from_discount($post_id, $post, $update) {

if (defined(‘DOING_AUTOSAVE’) && DOING_AUTOSAVE) return;

$regular_price = get_post_meta($post_id, ‘_regular_price’, true);
$discount = get_post_meta($post_id, ‘_discount_percentage’, true);

if ($regular_price && $discount) {

$sale_price = $regular_price – ($regular_price * ($discount / 100));

update_post_meta($post_id, ‘_sale_price’, $sale_price);
update_post_meta($post_id, ‘_price’, $sale_price);
}
} What This Does

If:

Regular Price = 100
Discount % = 20

It auto sets:

Sale Price = 80

Now inside Bulky:

• Add _discount_percentage column
• Enter 10, 15, 20 etc.
• Save
• Sale price auto updates

This gives you Excel-style control.

Please reply as soon as possible. We are waiting to purchase the plugin once this issue is resolved.