Stock status not saving
-
Stock status is not saving when using the wordpress dashboard unless Enable stock management is checked. This is NOT logical. If this is unchecked NOTHING should be checking stock for products or variations. Disabled should mean DISABLED! At the very least if I set stock for a variation as instock it should save.
However I have 600 products and 15000 variations!!!!!!!!!!!!! I have to manage this with the csv.
In my csv 1 product and variations works and the others don’t. The csv looks exactly the same….however when I upload the csv it doesn’t save the “In stock?” field. And these seem to not work no matter if I have Enable stock management checked.
-
Because WooCommerce is too lazy to actually test their software before publishing….here is a potential solution.
1. In phpMyAdmin and search for %stock% in postmeta and export as sql with the update function.
2. (Optional) save full backup of sql with insert function
3. Open sql in text editor, search and replace the following strings.'_stock',`meta_value` = '0' '_stock',`meta_value` = NULL '_manage_stock',`meta_value` = 'yes' '_manage_stock',`meta_value` = 'no' '_stock_status',`meta_value` = 'outofstock' '_stock_status',`meta_value` = 'instock'4. Save and import back in to phpMyAdmin
I haven’t fully tested this but at first glance it seems to have worked. I’ll post again if I run in to troubles.
Admins: You need a different character than ` for code because it makes it really hard to post sql code samples.
- The topic ‘Stock status not saving’ is closed to new replies.
