Impossible to fulfill seller orders automatically if products are shipable

In my use case, sellers deliver orders to a central location for pick up from the buyers. When the seller drops the order off at the pick up point a site admin moved the order through to the ready for pick up state, which notifies the buyer. When the buyer collect's the order the site admin moves the order to the completed state.

We wanted this to be the point that the reports on the sellers reports page updated to show the new sale data with no action required from the seller. When the order moves to complete state a row is inserted into mp_seller_order_statuses however it's status is always set to 'not complete' which prevents it from appearing in the seller reports.

All of our seller's products are shippable because we have different flat rates for getting the orders to the pick up point given various conditions.

It seems like a serious limitation that the order is set to 'not complete' based on a hard coded 'SELECT shippable FROM {uc_products} ...' query.

Attached is patch that removes this query as a temporary work around. I should note that we are working from an older revision - 38a827e3fdca9fd85973e249e0de37eb0b532d44 - and that this may have changed since then.

Corey.