mysql - Update WooCommerce stock status with SQL query if stock value is greater than 0

I'm attempting to update a large product catalogue using a SQL query via phpMyAdmin if:the _stock_status = onbackor

I'm attempting to update a large product catalogue using a SQL query via phpMyAdmin if:

  1. the _stock_status = onbackorder
  2. the _stock > 0

Queries attempted:

Update wp_postmeta 
Set meta_value = 'instock' 
Where meta_key = '_stock' 
And meta_value > 0

Update wp_postmeta 
Set meta_value = 'instock' 
Where meta_value = 'onbackorder' 
And meta_key = '_stock_status'
And meta_value > 0
And meta_key = "_stock"

Update wp_postmeta 
Set meta_value = 'instock' 
Where meta_value = 'onbackorder' 
And '_stock' > 0

None of the above have worked.
The last query reduces all stock quantities to 0 but the stock status remains on "backorder"

发布者:admin,转转请注明出处:http://www.yc00.com/questions/1744796733a4594248.html

相关推荐

发表回复

评论列表(0条)

  • 暂无评论

联系我们

400-800-8888

在线咨询: QQ交谈

邮件:admin@example.com

工作时间:周一至周五,9:30-18:30,节假日休息

关注微信