Currently, there is only options for Order by to be by Published date, Modified date, etc.
There is no option to order the query by the WooCommerce’s Menu Order field, where from the backend under Sorting, users can adjust the product orders by drag and drop.
I tried to use dynamic custom field option under the Order by and it does not work to order the query based on the built-in WooCommerce Menu Order field.