web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Microsoft Dynamics CRM (Archived)

Reactivating retired products

(1) ShareShare
ReportReport
Posted on by

As our investigation into products continues, along with the inability to re-parent a product, another action which is apparently impossible (at least according to the second part of this blog article but not the diagram at the top of the article), is reactivating a retired product.

We have attempted to use an on-demand workflow to change the status to Active, Draft and Under Revision but are greeted with an error message saying that a retired product cannot be changed.

In my opinion, a software package should never, ever be able to prevent an administrator from changing the status of a record. My assumption is that the implementation of the retire function is such that allowing a change of status sufficiently breaks the system in a catastrophic way and is therefore, simply wrong.

This post is partially a vent and partially a warning to others:

Never, ever, ever retire a product unless you are so damn sure that you will never under any conceivable circumstance want to re-activate it. For gods sake if you really do retire a product, change the product ID before you do because unless you disable de-duplication, you will never, ever, ever be able to use the product ID again. And yes Microsoft, sometimes product IDs, rightly or wrongly, are re-used.

Please, someone - I really hope we are wrong and that products can be un-retired.

*This post is locked for comments

I have the same question (0)
  • Suggested answer
    ScottDurow Profile Picture
    21 on at
    RE: Reactivating retired products

    Hi,

    Unfortunately, for products that have dynamic product properties, you will receive the message ""You can't set a retired property to an active state." if you try and re-activate after retiring. If the product is not part of a product family with no product properties you can 'Activate' again after retiring.

    The work around is to clone the product and give a different product number - or as you say always change the product ID before retiring.

    Again - sorry for the answer that you didn't want!

    You can post your suggestions to connect.microsoft.com

  • Community Member Profile Picture
    on at
    RE: Reactivating retired products

    Thank-you for replying Scott!

    Microsoft have informed us that this is a bug and that we should be able to reactivate a retired product. Apparently they are working on a fix... we shall see!

  • Community Member Profile Picture
    on at
    RE: Reactivating retired products

    Hey emj -- Have they updated you on whether or not this was fixed in the new update rollup? I cannot seem to delete a Product Bundle or even "un-retire" it in order to modify the associations with other entities.

  • Suggested answer
    Sina Khodaparast Profile Picture
    25 on at
    RE: Reactivating retired products

    Dynamics CRM Application till now has no way to revert the status of a Product Family or a Product (that has a parent) from Retired to Active/Draft.

    Unfortunately at on operational environment, a product family was set to retired by mistake and it was cascaded to all the subordinated products. Since there is no embedded way at the Application,the last solution is to update it at the DB.

    You can change the status of the product by placing an update query on the database. Here is the query.

    update Product set StateCode = 2, StatusCode = 0

    where (StateCode = 1 AND StatusCode = 2)

    Hint:  Retired  StateCode=1 , StatusCode =2

             Draft     StateCode=2 , StatusCode =0

  • Community Member Profile Picture
    on at
    RE: Reactivating retired products

    Thank You, It Worked!

  • FrankF-WorldStrides Profile Picture
    80 on at
    RE: Reactivating retired products

    Is there any way to update the statecode and statuscode on an online installation?

  • Community Member Profile Picture
    on at
    RE: Reactivating retired products

    Anyone facing this issue should log help desk tickets.  It is only by constant user "feedback" that this inane limitation will be removed.

  • Community Member Profile Picture
    on at
    RE: Reactivating retired products

    14 months on and the "bug" still persists!

  • ChristopherFernando Profile Picture
    95 on at
    RE: Reactivating retired products

    Can confirm... its still an issue in V8.2 and V9.  

    I found this in Ideas.dynamics.com, please upvote!

    ideas.dynamics.com/.../1917081

  • ChristopherFernando Profile Picture
    95 on at
    RE: Reactivating retired products

    Also upvote idea.dynamics.com! ideas.dynamics.com/.../1917081

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Leaderboard > 🔒一 Microsoft Dynamics CRM (Archived)

#1
Wayne Walton Profile Picture

Wayne Walton 2

#2
Good.Panos Profile Picture

Good.Panos 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans