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?

STEP 1:

TAKE A BACKUP OF YOUR DATABASE – MOST IMPORTANT!

STEP 2:

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

STEP 3:

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!

Contact a Bristol Web Design expert in Woocomerce if you need any help.