Tuesday, April 19, 2022

Decrease product price by 10% using SQL command in Woocommernce from Phpmyadmin

 Query-1:

UPDATE

   wp_wc_product_meta_lookup

SET

    min_price =(min_price - min_price * .13)

WHERE 1;

Query-2;

 UPDATE

   wp_wc_product_meta_lookup

SET

    max_price =(max_price - max_price * .13)

WHERE 1;

No comments:

Post a Comment

How to select all blank cells in a range to keep unlocked in excel.

  Select Only the Blank Cells: Press Ctrl + G (or F5 ) to open the Go To dialog box. Click the Special... button at the bottom left. Sele...