Announcement

Collapse
No announcement yet.

Order Status Types and Numeric Values

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

    Order Status Types and Numeric Values

    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?
    http://www.alphabetsigns.com/

    #2
    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
    Wayne Smith

    Comment


      #3
      Re: Order Status Types and Numeric Values

      Thank you Wayne.

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

      Code:
      <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>
      http://www.alphabetsigns.com/

      Comment


        #4
        Re: Order Status Types and Numeric Values

        Another token that will work is:

        &mvt:order:formatted_status;
        http://www.alphabetsigns.com/

        Comment


          #5
          Hello,

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

          thanks
          Michael

          Comment


            #6
            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).
            Thanks,

            Rick Wilson
            CEO
            Miva, Inc.
            [email protected]
            https://www.miva.com

            Comment


              #7
              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

              Comment


                #8
                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.
                Thanks,

                Rick Wilson
                CEO
                Miva, Inc.
                [email protected]
                https://www.miva.com

                Comment


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

                  cheers, Michael

                  Comment

                  Working...
                  X