order the products in a content module

in Products/Categories, each category is ordered correctly under the "Order" field.
in Products/Products, under each category and subcategory the products are ordered correctly.

The content modules can successfully apply the "ordering field" to work for product_id or product_name but not the "ordering" field which is the one that is needed. The products seem to be in a random order.

Here are my settings:

First image: the order of the categories. "Cribs" is first.
Second image: the order of the products inside "Cribs", it is a full crib, a compact crib, and a mattress. The mattress is a new item that was added.
Third image: the content module set to order by productid.
Fourth image: the display of the content module, which successfully orders the products by productid, but mattress needs to be displayed after compact crib, so change to order by ordering.
Fifth image: the content module set to order by ordering.
Sixth image: the display of the content module, which seems random.

thank you, that makes complete sense!