Order Status Types and Numeric Values

[alphabet]

Where can we find the values (cardinality) for the STATUS column in the s01_Orders table?

Miva Docs mention 8 different types: Pending, Processing, Shipped, Partially Shipped, Cancelled, Backordered, RMA Issued and Returned.

I can deduce from the status column distinct values:

0- Pending
100 - Processing
200 - Shipped
201 - Partially Shipped
300 - Cancelled
400 - Backordered
500 - RMA Issued
600 - Returned

Is this correct?

[wsmith]

Re: Order Status Types and Numeric Values

alphabet,

I ran the list past development and this list looks complete.

0- Pending
100 - Processing
200 - Shipped
201 - Partially Shipped
300 - Cancelled
400 - Backordered
500 - RMA Issued
600 - Returned

Wayne

[alphabet]

Re: Order Status Types and Numeric Values

Thank you Wayne.

Here's a code snippet to share on the ORDH page:

<div class="column-3">
<mvt:if expr="l.settings:order:order_status EQ '0'">Pending
<mvt:elseif expr="l.settings:order:order_status EQ '100'">Processing
<mvt:elseif expr="l.settings:order:order_status EQ '200'">Shipped
<mvt:elseif expr="l.settings:order:order_status EQ '201'">Partially Shipped
<mvt:elseif expr="l.settings:order:order_status EQ '300'">Canceled
<mvt:elseif expr="l.settings:order:order_status EQ '400'">Backordered
<mvt:elseif expr="l.settings:order:order_status EQ '500'">RMA Issued
<mvt:elseif expr="l.settings:order:order_status EQ '600'">Returned
<mvt:else>&mvt:order:order_status;
</mvt:if></div>

[alphabet]

Re: Order Status Types and Numeric Values

Another token that will work is:

&mvt:order:formatted_status;

[swiftmv]

Hello,

Where, in Order Processing, does one promote the order to the status: "processing"?

thanks
Michael

[Rick Wilson]

When you create a shipment, it moves all the products in that shipment from Pending to Processing (if you're doing it via the GUI).

[swiftmv]

Hi Rick

I have clients who want to not have "pending" for very long. They consider that, once they have seen and acknowledge the order, they are then "processing" it. In their case they have many drop-shippers, so are not in complete control of the moment the order is shipped. Moreover they have customers who see "pending" for quite a while and they get worried thinking that nothing is happening with their order when, in fact, they are processing it.

How do you suggest we try and overcome this conundrum and client need? I've tried going under the hood to find where I would change the actual word "Pending" to "Processing" but I'm at a loss with that!

cheers,
Michael

[Rick Wilson]

Michael,

It doesn't work that way (today). You'd have to do one of a couple things. Create a shipment via the GUI (like I said above), use the Shipment Export/Import Module that's built in, can create the shipments in batch for you that way or do some custom module to auto-create the shipments in the cases you want.

[swiftmv]

Thanks Rick. I'll talk to you and Brennan further about it this week.

cheers, Michael