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?

1 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).

woocommerce products screen options

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

Now you can change a batch of product details.

woocommerce products bulk edit
^ click to enlarge ^

  • Awesome! And I was trying to do it through the database lol.
    – Stephen
    Dec 7, 2012 at 0:52
  • I didn't know that until now. Thanks a lot.
    – kaiser
    Mar 11, 2013 at 21:44

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.