Page 1 of 2 12 LastLast
Results 1 to 10 of 20
  1. #1
    Join Date
    Feb 2006
    Posts
    130
    Plugin Contributions
    0

    Default delete unwanted Orders Status categories?

    I have searched for literally months for a way to do this and came up with nothing.

    I have several Orders Status categories that I want to delete. I do not want to RENAME them I want them GONE.
    By Categories I am referring to the status selection such as:
    New
    Shipped
    Etc.

    There are no orders currently assigned to the status entries i want to delete
    There are orders that were once assigned to said categories but they were changed to some other status.

    When I try to delete one of them I get the error message:

    Error: This order status is currently used in the order status history.

    What do I need to do so that I can delete these unwanted categories? My Orders Status list has too many entries and I want to totally redo it.

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

    Default Re: How to delete unwanted Orders Status categories

    You need to check the tables:
    orders - check orders_status
    orders_status_history - check orders_status_id

    to ensure the orders status is not in use ... otherwise they cannot be deleted ...
    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
    Feb 2006
    Posts
    130
    Plugin Contributions
    0

    Default Re: How to delete unwanted Orders Status categories

    I have no clue what you are talking about.....

    I don't know how to check a table or to see if something is in use.

    I do know that the orders status categories I want to delete do not have any orders showing in that category in the admin.

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

    Default Re: How to delete unwanted Orders Status categories

    If you go to phpMyAdmin and look at your database tables for:

    orders - check field orders_status
    orders_status_history - check field orders_status_id

    for the Order Status value that you are trying to delete, this may help you find what orders are still using the Order Status(es) that you want to remove ...
    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
    Jan 2004
    Posts
    66,364
    Blog Entries
    7
    Plugin Contributions
    274

    Default Re: How to delete unwanted Orders Status categories

    Quote Originally Posted by LRS View Post
    There are no orders currently assigned to the status entries i want to delete
    There are orders that were once assigned to said categories but they were changed to some other status.

    When I try to delete one of them I get the error message:

    Error: This order status is currently used in the order status history.
    Quote Originally Posted by LRS View Post
    I do know that the orders status categories I want to delete do not have any orders showing in that category in the admin.
    Yes, but remember those orders that WERE using those "old" statuses? If you look at the order now, you'll see that the "old" status WAS used on that order. And because it's part of the history of the order, that's why it's telling you its "currently used in the order status history".

    Where did all these old "extra" order statuses come from anyway? Zen Cart (v1.1 thru 1.5) only has 4 out-of-the-box.
    .

    Zen Cart - putting the dream of business ownership within reach of anyone!
    Donate to: DrByte directly or to the Zen Cart team as a whole

    Remember: Any code suggestions you see here are merely suggestions. You assume full responsibility for your use of any such suggestions, including any impact ANY alterations you make to your site may have on your PCI compliance.
    Furthermore, any advice you see here about PCI matters is merely an opinion, and should not be relied upon as "official". Official PCI information should be obtained from the PCI Security Council directly or from one of their authorized Assessors.

  6. #6
    Join Date
    Dec 2013
    Location
    Southampton, UK
    Posts
    51
    Plugin Contributions
    0

    Default Re: How to delete unwanted Orders Status categories

    If the order status has been used in the past but is not in use now and is now empty is there a way to delete it?

  7. #7
    Join Date
    Jul 2005
    Location
    Upstate NY
    Posts
    22,010
    Plugin Contributions
    25

    Default Re: How to delete unwanted Orders Status categories

    If an order status has been used in the past, it is still part of the order status history and cannot be deleted. You would have to do some advanced database manipulation to remove it from the history (thus falsifying your history, if it matters for PCI compliance).

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

    Default Re: How to delete unwanted Orders Status categories

    Originally, you had Order Statuses of:
    1 Pending
    2 Processing
    3 Delivered
    4 Update

    What are your Order Statuses now (as in what do you want them to be)?
    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
    Jul 2005
    Location
    Upstate NY
    Posts
    22,010
    Plugin Contributions
    25

    Default Re: How to delete unwanted Orders Status categories

    This thread (from Similar Threads at the bottom of the page) may point to the answer you are looking for:
    http://www.zen-cart.com/showthread.p...rom-orders-php

    Ajeh's advice:
    You would need to browse the table:
    orders_status_history

    and do a search for the:
    orders_id...
    In that table will be a field named something like orders_status_id. You should be able to change all instances of an id that you want to eliminate to an id that you still want to exist (and is not misleading in its meaning).

    Do a database backup before you try anything like this, so you can restore it if you make a mistake.

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

    Default Re: How to delete unwanted Orders Status categories

    Do keep in mind that before changing the labels/names of the order statuses that you want to plan this out to fix the table names and ids carefully so as not to make a mess of previous orders ...
    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. How to delete a status from orders.php?
    By samar777 in forum General Questions
    Replies: 5
    Last Post: 30 Sep 2010, 08:09 PM
  2. Replies: 0
    Last Post: 20 Jan 2010, 09:50 PM
  3. Delete Unwanted Ads
    By irulecards in forum General Questions
    Replies: 1
    Last Post: 4 Jul 2009, 02:08 PM
  4. HELP! too much stuff... how to delete the unwanted things?
    By heerosferret in forum Templates, Stylesheets, Page Layout
    Replies: 2
    Last Post: 7 Nov 2007, 01:32 AM
  5. Orders- Update status of order, delete order or print order paperwork.
    By dandownunder in forum Managing Customers and Orders
    Replies: 6
    Last Post: 8 Aug 2006, 09:11 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