Defining the same price to all WooCommerce Products

Question

All of my products on my site are $1 and during an import I did using WooCommerce import it didn't save all the _regular_price & _sale_price values, so there is no way for the user to buy that product.

Is there a mysql query that can go through and apply a value to all of the nulls to the $1 value?

Answer 1

Looks like you are not familiar with WordPress Bulk Edit.

Change the Screen Options to show all the products you have (if there are too many this can be slow, and is better to do it following some 100/200 product per page).

Select all the products, select Edit in the Bulk Edit dropdown and Apply.

Now you can change a batch of product details.

^{^ click to enlarge ^}