WordPress Development Stack Exchange is a question and answer site for WordPress developers and administrators. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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?

share|improve this question
up vote 4 down vote accepted

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 ^

share|improve this answer
Awesome! And I was trying to do it through the database lol. – Stephen Dec 7 '12 at 0:52
I didn't know that until now. Thanks a lot. – kaiser Mar 11 '13 at 21:44

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

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