Results 1 to 4 of 4
  1. #1
    Join Date
    Jun 2005
    Location
    Portland, OR
    Posts
    189
    Plugin Contributions
    0

    Default Change all orders from status 'x', to status 'y'.

    I can't remember why I did this, but I created an additional order status "Shipped" (ID5). Is there a sql query I could run to change all of these to Shipped (ID3)?

    Thanks in advance....

  2. #2
    Join Date
    Jan 2010
    Location
    Australia
    Posts
    239
    Plugin Contributions
    1

    Default Re: Change all orders from status 'x', to status 'y'.

    you can simply run UPDATE orders SET orders_status = '3'

    * Please bear in mind few steps
    1. this will change every order in your shop to shipped.
    2. this will not show on order history as that is a seperate table.

  3. #3
    Join Date
    Jun 2005
    Location
    Portland, OR
    Posts
    189
    Plugin Contributions
    0

    Default Re: Change all orders from status 'x', to status 'y'.

    thanks for the help, but that's not quite what i want to do.

    there's no easy way to simply change ID5 to ID3 with a sql query?


    Quote Originally Posted by gaurav10feb View Post
    you can simply run UPDATE orders SET orders_status = '3'

    * Please bear in mind few steps
    1. this will change every order in your shop to shipped.
    2. this will not show on order history as that is a seperate table.

  4. #4
    Join Date
    Feb 2006
    Location
    Tampa Bay, Florida
    Posts
    9,622
    Plugin Contributions
    123

    Default Re: Change all orders from status 'x', to status 'y'.

    Make a db backup, then:

    UPDATE orders SET orders_status = '3' WHERE orders_status = '5';
    UPDATE orders_status_history SET orders_status = '3' WHERE orders_status = '5';

    If the number of orders with status 5 is small, though, you might just do this by hand so you could make a status update note about the change you're making. To determine the number of orders in this state, do

    SELECT COUNT(*) FROM orders WHERE orders_status = '5';
    That Software Guy. My Store: Zen Cart Modifications
    Available for hire - See my ad in Services
    Plugin Moderator, Documentation Curator, Chief Cook and Bottle-Washer.
    Do you benefit from Zen Cart? Then please support the project.

 

 

Similar Threads

  1. v154 Change Email Subject of Status Update Messages To Show Assigned Status
    By ShopVille in forum Managing Customers and Orders
    Replies: 12
    Last Post: 27 Oct 2015, 02:43 PM
  2. Replies: 0
    Last Post: 16 Mar 2015, 09:46 AM
  3. Change All Product Status
    By Kenichi in forum General Questions
    Replies: 3
    Last Post: 23 Dec 2012, 08:18 AM
  4. Change orders Status choices...
    By warstormer in forum Managing Customers and Orders
    Replies: 15
    Last Post: 19 Feb 2011, 05:28 PM
  5. how to change status of multiple orders?
    By urungus in forum General Questions
    Replies: 1
    Last Post: 3 Oct 2007, 02:52 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