Page 2 of 2 FirstFirst 12
Results 11 to 12 of 12
  1. #11
    Join Date
    Jun 2004
    Posts
    113
    Plugin Contributions
    0

    Default Re: Set all Processing orders to Delivered? Or delete all orders?

    Thanks again DrByte. :^)

    I've reviewed the changes in the related tables and they seem apropos. Order history looks good in the admin and user UI's too, reflecting the changes.

  2. #12
    Join Date
    Aug 2007
    Posts
    95
    Plugin Contributions
    0

    Default Re: Set all Processing orders to Delivered? Or delete all orders?

    Quote Originally Posted by Brian1234 View Post
    OK, thanks! Would you take a look and see if this looks appropriate for zen-cart?

    INSERT INTO orders_status_history (orders_id, orders_status_id, date_added, customer_notified, comments)
    VALUES ($id, 5, '2010-03-03 23:00:00', 0, 'order status was changed to History by Brian')

    There, $id represents the number of each actual order I have changed the status of. The rest of the fields would be static values exactly as shown where 5 is my custom History status, then that datetime, notification value and comment.

    I'm not touching orders_status_history_id in the statement because it's an auto_increment and I think it will handle itself. I'm seeing some indexes (PRIMARY and idx_orders_id_status_id_zen) but am unsure if I have to do anything with those.

    hi i have a customer wanting to do this as well, they process there orders everyday and have hundreds to do so need a quick way of doing this.

    if they have finished sorting all there orderds for that day and they then just login to there admin go to tools> install SQL patches then copy and past the following??

    INSERT INTO orders_status_history (orders_id, orders_status_id, date_added, customer_notified, comments)
    VALUES ($id, 5, '2010-03-03 23:00:00', 0, 'order status was changed to History by Brian')


    or will it need editing?? looking at it it looks like there is a date and time in there does this need changing to the current time and date?? also what needs to go in place of "'order status was changed to History by Brian" what is that bit for??

    please can someone help thanks

 

 
Page 2 of 2 FirstFirst 12

Similar Threads

  1. v150 Remove ALL customers and ALL orders before a certain date and reset counter history.
    By hawkwynd in forum Managing Customers and Orders
    Replies: 4
    Last Post: 10 Dec 2013, 03:22 AM
  2. Delete all orders
    By bonheddwr in forum General Questions
    Replies: 2
    Last Post: 30 May 2013, 10:15 AM
  3. Reset store: Delete all orders, customers, etc.
    By flix in forum Managing Customers and Orders
    Replies: 16
    Last Post: 31 Oct 2012, 08:04 PM
  4. HELP - Starting today all paypal orders creates 2 orders
    By keylesslocks in forum General Questions
    Replies: 1
    Last Post: 28 Jan 2009, 12:59 AM
  5. How can I add on a set price to all international orders??
    By Snype in forum Built-in Shipping and Payment Modules
    Replies: 3
    Last Post: 4 Sep 2008, 11:47 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