Page 1 of 2 12 LastLast
Results 1 to 10 of 11
  1. #1

    Default Adding a new "Order Status"

    From the Admin go to - Customers - Orders then choosing the "Edit" option, I need to add in a new "Order Status" in the dropdown menu. By default I have 4 options including Pending 1, Processing 2, Delivered 3 and Update 4.
    I wanted to have "Shipped" included in that menu and would mind setting it as 3 and "Delivered" as 4 and Update as 5.

    One other thing, I am having problems with the "Flyout Menu" on the catalog. The Flyout boxes are overlapping, I know there is a value in the stylesheet that controls this but can't remember what it is.

    Any help is appreciated, Thanks!

  2. #2
    Join Date
    Sep 2003
    Location
    Ohio
    Posts
    69,402
    Plugin Contributions
    6

    Default Re: Adding a new "Order Status"

    I would set it by go to the Localization ... Orders Status ... and changing Delivered (orders_status 3) to Shipped ...

    Then Add a new one, Delivered (orders_status 5) and leave Updated at 4 as this is coded for Downloads ...

    Then, go to the Configuration ... Attribute Settings ... and change the setting for Downloads highest from 4 to 5 in the:
    Downloads Controller Order Status Value <= upper value
    Downloads Controller Order Status Value - Default <= 4

    Downloads are available for checkout based on the orders status. Orders with orders status less than this value will be available for download. The orders status is set for an order by the Payment Modules. Set the upper range for this range.
    This allows, should you use Downloads, that the Download is available from orders_status >= 2 (Processing) to <= 5 (new Delivered) ...
    Linda McGrath
    If you have to think ... you haven't been zenned ...

    Did YOU buy the Zen Cart Team a cup of coffee and a donut today? Just click here to support the Zen Cart Team!!

    Are you using the latest? Perhaps you've a problem that's fixed in the latest version: [Upgrade today: v1.5.5]
    Officially PayPal-Certified! Just click here

    Try our Zen Cart Recommended Services - Hosting, Payment and more ...
    Signup for our Announcements Forums to stay up to date on important changes and updates!

  3. #3
    Join Date
    Mar 2010
    Posts
    32
    Plugin Contributions
    0

    Default Re: Adding a new "Order Status"

    Hi there

    This thread is pretty old... but maybe someone can still help.

    I want to insert a new order status. This is pretty easy as described above.

    But to make it complicated, I want the new order status to be between the first and the second of my existing order status:

    Old situation:

    status_a [1]
    status_b [2]

    New target situation:

    status_a [1]
    status_c [2]
    status_b [3]

    => So how could I insert the new status BETWEEN two existing status? There is no such option in admin, is there?

    I have seen that the table orders_status has attributes orders_status_id, language_id and orders_status_name.
    I could now brutally change the orders_status_id by hand... but I think this would probably then set the status of all my existing order to a new incorrect status, would it not?

    Thanks for any advice!

  4. #4
    Join Date
    Sep 2003
    Location
    Ohio
    Posts
    69,402
    Plugin Contributions
    6

    Default Re: Adding a new "Order Status"

    Payment Modules are using the orders_status_id ...

    Several tables are using the orders_status_id ...
    orders
    orders_status_history

    Then, there are the settings on the Attribute Settings for Download, if you are using them, to set the range for orders_status_id that are allowed Downloads and the Update orders_status_id for updating Orders with Downloads to allow an extension of settings on Downloads ...

    Taking this in steps might help ...

    To alter a Live site, you would want to first determine the Old orders_status_id

    Example:
    Pending orders_status_id 1
    Processing orders_status_id 2
    Delivered orders_status_id 3
    Updated orders_status_id 4

    Next, what are you using in your Payment Modules?

    Once you know the current state of everything ... you can work out what the new state would be ...

    Knowing what you want to use the "New orders_status_id" for, would make it easier to work this out ...

    What is the purpose or meaning of the "New orders_status_id" that you want to add?
    Linda McGrath
    If you have to think ... you haven't been zenned ...

    Did YOU buy the Zen Cart Team a cup of coffee and a donut today? Just click here to support the Zen Cart Team!!

    Are you using the latest? Perhaps you've a problem that's fixed in the latest version: [Upgrade today: v1.5.5]
    Officially PayPal-Certified! Just click here

    Try our Zen Cart Recommended Services - Hosting, Payment and more ...
    Signup for our Announcements Forums to stay up to date on important changes and updates!

  5. #5
    Join Date
    Mar 2010
    Posts
    32
    Plugin Contributions
    0

    Default Re: Adding a new "Order Status"

    The new order status would be something in the sense of the following:

    "Payment received, article packaged and ready to be sent but not yet sent"

    So the order would be the following:

    Pending orders_status_id 1
    Processing orders_status_id 2
    Packaged orders_status_id 3
    Delivered orders_status_id 4
    Updated orders_status_id 5

    Business reason: I bring my packages at 12 am to the post office. If I receive a new order 30min later, I just package it and want to know the client that his order is immediately processed (i.e. packaged and ready to be sent), but status 'delivered' would be wrong because I want with the delivery until next 12 am.

    I hope you get the idea....

  6. #6
    Join Date
    Sep 2003
    Location
    Ohio
    Posts
    69,402
    Plugin Contributions
    6

    Default Re: Adding a new "Order Status"

    In theory ... this should work for you ...

    Backup your database ...

    Did you backup your database?

    Create a New Orders Status in the Localization ... Order Status ... for:
    Packaged

    ... this should become orders_status_id 6 ...


    Go to the Configuration ... Attributes Settings and change the:
    High Value <= 5
    Updated = 5


    In the Tools ... Install SQL Packages ...

    Run the following SQL commands:

    Code:
    UPDATE orders_status SET orders_status_id = 5 WHERE orders_status_id = 4;
    UPDATE orders SET orders_status = 5 WHERE orders_status = 4;
    UPDATE orders_status_history SET orders_status_id = 5 WHERE orders_status_id = 4;
    
    
    UPDATE orders_status SET orders_status_id = 4 WHERE orders_status_id = 3;
    UPDATE orders SET orders_status = 4 WHERE orders_status = 3;
    UPDATE orders_status_history SET orders_status_id = 4 WHERE orders_status_id = 3;
    
    
    UPDATE orders_status SET orders_status_id = 3 WHERE orders_status_id = 6;
    The result in all of this is all Old and Future Orders will use:
    Pending orders_status_id 1
    Processing orders_status_id 2
    Packaged orders_status_id 3
    Delivered orders_status_id 4
    Updated orders_status_id 5

    Next, go to your Modules ... Payment ... and adjust all Payment Modules to use the proper Orders Status based on your changes ...
    Linda McGrath
    If you have to think ... you haven't been zenned ...

    Did YOU buy the Zen Cart Team a cup of coffee and a donut today? Just click here to support the Zen Cart Team!!

    Are you using the latest? Perhaps you've a problem that's fixed in the latest version: [Upgrade today: v1.5.5]
    Officially PayPal-Certified! Just click here

    Try our Zen Cart Recommended Services - Hosting, Payment and more ...
    Signup for our Announcements Forums to stay up to date on important changes and updates!

  7. #7
    Join Date
    Nov 2009
    Location
    Sydney Australia
    Posts
    84
    Plugin Contributions
    0

    Default Re: Adding a new "Order Status"

    Hi Linda,

    I'm always happy to see a forum post from you, as they are usually spot on.

    First YES I did make a database back-up.

    What I am trying to do is somewhat similar. I just want to create an order status of Layby, that means we've accepted partial payment, but are not ready to ship (lay-away in the USA).

    In any event, when I ran the sequel statement bit, I got:

    1062 Duplicate entry '5-1' for key 'PRIMARY'
    in:
    [UPDATE zen_orders_status SET orders_status_id = 5 WHERE orders_status_id = 4;]
    If you were entering information, press the BACK button in your browser and re-check the information you had entered to be sure you left no blank fields.

    Not sure what that first item meant - is 1062 an order number? An error code number? Not sure where to go from here.

    By the way, I couldn't quite get my head around the "orders_status_id = 6" because my new "lay-by" is only "5" - as I think was this shop's "Packaged."

    Brain is fuzzy today, can you help un-fuzzy it?
    Sean M - Sydney, Australia

  8. #8
    Join Date
    Sep 2003
    Location
    Ohio
    Posts
    69,402
    Plugin Contributions
    6

    Default Re: Adding a new "Order Status"

    Why are you running a SQL for this?

    Quote Originally Posted by smcelligott View Post
    In any event, when I ran the sequel statement bit, I got:

    1062 Duplicate entry '5-1' for key 'PRIMARY'
    in:
    [UPDATE zen_orders_status SET orders_status_id = 5 WHERE orders_status_id = 4;]
    Go to your Zen Cart Admin and in the Localization ... Orders Status ... and Add/edit the Order Status(es) that you need ...
    Linda McGrath
    If you have to think ... you haven't been zenned ...

    Did YOU buy the Zen Cart Team a cup of coffee and a donut today? Just click here to support the Zen Cart Team!!

    Are you using the latest? Perhaps you've a problem that's fixed in the latest version: [Upgrade today: v1.5.5]
    Officially PayPal-Certified! Just click here

    Try our Zen Cart Recommended Services - Hosting, Payment and more ...
    Signup for our Announcements Forums to stay up to date on important changes and updates!

  9. #9
    Join Date
    Nov 2009
    Location
    Sydney Australia
    Posts
    84
    Plugin Contributions
    0

    Default Re: Adding a new "Order Status"

    did I misunderstand your last post? wanted to add a new #3 layby status that is less than "delivered."
    Sean M - Sydney, Australia

  10. #10
    Join Date
    Sep 2003
    Location
    Ohio
    Posts
    69,402
    Plugin Contributions
    6

    Default Re: Adding a new "Order Status"

    Go to the Localization ... Order Statuses ...

    What do you have right now and what are their values?
    Linda McGrath
    If you have to think ... you haven't been zenned ...

    Did YOU buy the Zen Cart Team a cup of coffee and a donut today? Just click here to support the Zen Cart Team!!

    Are you using the latest? Perhaps you've a problem that's fixed in the latest version: [Upgrade today: v1.5.5]
    Officially PayPal-Certified! Just click here

    Try our Zen Cart Recommended Services - Hosting, Payment and more ...
    Signup for our Announcements Forums to stay up to date on important changes and updates!

 

 
Page 1 of 2 12 LastLast

Similar Threads

  1. v150 Gigantic Flag pic in "Order Status" / Cannot re-order or edit "order status" text
    By lindagal2 in forum Managing Customers and Orders
    Replies: 6
    Last Post: 25 Aug 2016, 06:16 PM
  2. Changing "Default Order Status" from "Delivered" to "Shipped"
    By CookieMonster in forum Customization from the Admin
    Replies: 1
    Last Post: 25 Nov 2014, 12:22 AM
  3. v139h Adding one more "status of order" in the admin panel
    By devyani in forum Managing Customers and Orders
    Replies: 4
    Last Post: 28 May 2013, 10:23 AM
  4. v150 Change verbage from "delivered" to "shipped" on order status
    By nonprofit in forum Customization from the Admin
    Replies: 3
    Last Post: 6 Dec 2012, 12:03 PM
  5. Replies: 1
    Last Post: 20 Jun 2011, 03:58 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
disjunctive-egg
Zen-Cart, Internet Selling Services, Klamath Falls, OR