How to mass change backorder status in Woocommerce?
Save hours if not days of work – by changing all products at once!
You can manually set backorders in WordPress woocommerce manually but what happens if you need to change hundreds or thousands of products in bulk on your commerce website?
TAKE A BACKUP OF YOUR DATABASE – MOST IMPORTANT!
LOGIN TO PHP MY ADMIN and run this command:
UPDATE wp_postmeta SET meta_value = ‘yes’ WHERE meta_key = ‘_manage_stock’;
This will enable MANAGE STOCK OPTION
You can choose to allow a message on the product page front end, that the item is available for backorder with current stock level.
Example: 5 in stock (can be backordered)
By running this SQL command
UPDATE wp_postmeta SET meta_value = ‘notify’ WHERE meta_key = ‘_backorders’;
Or allow backorders but not show message on front end.
UPDATE wp_postmeta SET meta_value = ‘yes’ WHERE meta_key = ‘_backorders’;
Again please TAKE A BACKUP OF YOUR DATABASE before running any database commands.
Please note this will also add a notice of ‘on backorder‘ to the customer invoice that they get emailed.
We do hope this helps to save hours or if not days of work!